Configuration Settings:
Host name = (use the server IP address)
Database name = (cpanelUsername_databaseName)
Database username = (cpanelUsername_databaseUsername)
Database password = (whatever you picked)
MySQL Connection Port = 3306
TCP or UDP, either is fine.
Enable Your Computer as an Access Host
By default, all IPs are blocked and must be added to an access list in order to access the server. So, before connecting to MySQL from another computer, the connecting computer must be enabled as an Access Host.
Allow Remote access in cPanel
(Shared, Reseller. VPS, Linux Dedicated):
- Click the Remote MySQL icon, under Databases.
- Type in the connecting IP address, and click the Add Host button.
- All done, try connecting remotely.
How can I find out my computers IP address?
Simple, just go to http://www.whatismyip.com/
Notes regarding dynamic IPs.
Having a dynamic IP address means that the connecting IP address can change periodically, depending on the Internet Service Provider (ISP). You must update the connecting IP in Remote MySQL every time it changes.
Before you can connect:
After whitelisting your local IP, you should be able to make the proper remote MySQL connection. Be sure that the username you use matches the username created in the My SQL database section of cPanel. The most common problem in connecting is due to the use of an incorrect username and password.
I enabled remote access, now what?
You will need a third party application to access MySQL remotely. Some are free and some cost money. For a list of applications, you may want to visit our page on:
