| You can allow external web servers to remotely access your MySQL databases by adding their IP addresses to the list of hosts that are able to access databases on your web site.
To add external host access:
1. Click the "MySQL Databases" button at your control panel.
2. Enter the IP address of the host that you wish to add in the Host field.
3. Click on the "Add Host" button.
4. Open a Client Care ticket via the Client Lounge to let us know the IP address of the remote server, so that we can have it added to our firewall.
Once we've added the IP address to the firewall, you should be able to connect to MySQL from the remote server using a MySQL username/login combination that you created via the 'MySQL Databases' section of your control panel. The name of the MySQL server is your hosted domain name.
Note: Only individual static IP addresses are allowed. Numerous IP addresses, dynamic IPs and IP ranges are not supported for remote MySQL access for security reasons. This feature is meant for connections from remote enterprise web servers, not desktop/laptop computers, unless it is a single development machine with a static IP address.
For mass consumer/business desktop applications that need to access and/or manipulate data stored in databases on the server, we recommend developing custom server-side scripts (your own APIs) and having your desktop apps interface with them, preferably through a secure HTTP connection. |
