The Remote MySQL feature is used when the user wants to connect to their database using third party software that does not run on the server. The user has to first allow the connection from within cPanel for the IP address they are connecting from. This feature primarily permits remote hosts or servers to access the MySQL databases on the users account. Often developers need to connect to their databases from remote locations. The remote MySQL feature allows the user to access client program running in the remote computers to access the hosted database in the sever. For configuring the remote MySQL feature on cPanel following are the pre-requisites:
In order to allow a remote server to access your databases observe the following steps:
An important point to be noted here is that, the user can either enter a fully qualified domain name (FDQN) or an IP address. The percentage sign (%) can be used as a wildcard. For example type all IP addresses beginning with 10.01 as 10.01%.
In order to deny a remote server access to the databases the following steps have to be observed:
This feature facilitates the user, by allowing to store MySQL databases on a remote server that runs MySQL. For busy servers or servers with large databases a separate server is essentially useful. This facilitates offloading MySQL related work to the Remote MySQL server hence making it a useful feature on cPanel.