How to access MySQL databases from Remote or external location

Date: December 29th, 2011 | Category: Mysql

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.

remotemysql

Click Here to Enlarge Screenshot

 

If you dont know your IP then go to http://sibername.com/ip.php and use it there.

remotemysql1

Click Here to Enlarge Screenshot

 

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.

Article published on Sibername Help Center - http://www.sibername.com/tutorials

Print this article!