What is Remote MySQL? Remote MySQL allows external web servers to access your MySQL databases by adding their domain name to the list of hosts that are able to access databases on your web site.
Notes: 'localhost' stands for the server that your site is currently on. Also make sure port 3306 is not behind a firewall. To test port 3306, run the following from the server itself via ssh:
`telnet 127.0.0.1 3306`
Also make sure you have added the IP of the machine you are connecting from to the remote IPs list in your cPanel interface, otherwise the connection will not work.
Getting Started
1. Enter a server's host name or IP address in the "Host (% wildcard is allowed)" text box.
2. Click on the "Add Host" button.
3. You will see the following statement:
"Added Host HOSTNAME to the access list."
4. Click on the "Go Back" link.
5. When the page loads, you will see a two-column table containing the following information:
Access Hosts - This entry will include the host name or IP address.
Remove - Click on the "x in a circle" icon to remove the "Access Hosts" from being allowed to access your MySQL database.