How to access MySQL databases from Remote or external location
You can allow access to MySQL databases from an external location by adding its domain name or IP address to the list of hosts that are allowed to access your databases remotely. Additionally, if you would like to manage your database using an application for remote database management, the IP address from which the connection is established should be added to the list of allowed hosts.
In order to add allowed hosts you should access the tool via cPanel
Please login to Cpanel
Now click on Remote MySQL
Now you can put your IP or the server IP from where you want to connect to database.
If you dont know your IP then go to http://sibername.com/ip.php and use it there.
Click on the Add host button.
A confirmation message will inform that the host is successfully added. Next time you access Remote MySQL the newly added host will be listed under Access Hosts.
If still not able to access it then let us know your IP so we can check it for you.