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. SiteGround MySQL hosting allows remote database access.
In order to add allowed hosts you should access the tool via cPanel -> Remote MySQL:
In the Host field you should enter the desired domain name or IP address:
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.
Important (only for accounts hosted on semi-dedicated servers): In order to complete the PCI compliance requirements the remote MySQL connection to the semi-dedicated servers' primary IP is blocked. Still, to establish a remote MySQL connection to a database hosted on a semi-dedicated server use the server's secondary IP (ns2.servername.biz). It will be listed in the corresponding page. Alternatively, it can be found in the Customer Area -> My Account section -> Manage.
(c) Copyright 2004-2013 SiteGround. All rights reserved