How to access MySQL databases from Remote or external location

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.

Comments are closed.

Basic Helpful Tutorials (41)
Cpanel (13)
Domain name (39)
Email (53)
FTP (9)
General FAQ (60)
Home Page (14)
Mysql (7)
Our Reseller Program Tutorials (4)
Pre Sales (25)
Reseller Hosting (5)
Script installations (7)
SSL (22)
TBR (8)
Video Tutorials (7)
Website Builders (28)
Windows Hosting (14)

WP Cumulus Flash tag cloud by Roy Tanck requires Flash Player 9 or better.

Sibername.com is an
ICANN Accredited Registrar

ICANN Certified Registrar
Sibername.com is an Authority (CIRA)
certified .CA Domain Name Registrar
Sibername.com is an Authority (CIRA) certified .CA Domain Name Registrar
Click for the BBB Business Review of this Internet Services in Ottawa ON


HACKER SAFE certified sites prevent over 99.9% of hacker crime.
  • Facebook
  • Twitter