Remote Access To MySQL Database Server?
Host name = (use the server IP address)
Database name = (cpanelUsername_databaseName)
Database username = (cpanelUsername_databaseUsername)
Database password = (whatever you picked)
MySQL Connection Port = 3306
How to add yourself to the whitelist so that you can connect to MySQL remotely.Your done! You should now be able to connect successfully to port 3306 on your server.
- Log into your cPanel
- Click on the 'Remote MySQL' icon under the databases category
- Type the IP you are connecting from in the box. (You can get your IP by browsing to http://whatismyip.org)
- Click on 'Add Host'