How do I setup remote access to my MySQL databases?

Databases: Remote (MySQL)

Overview

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.

NOTE: "localhost" stands for the server that your site is currently on.

Steps

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.