What is the Remote MySQL?

Posted by Allura on 08 02 2018.

Remote MySQL: Connecting to the Hosted Database

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:

• Access to the users cPanel account.
• An IP address or a fully qualified domain name with which the user wants to extend access to his MySQL databases.

Configuring the Remote MySQL feature on cPanel

In order to allow a remote server to access your databases observe the following steps:

• Through the use of the login credentials access cPanel. Find the Remote MySQL feature located under the Databases section.
• In the second step enter the host’s name ( another website or server) or IP address in the Host text box. If the user is trying to access the database from their local computer that is running an application then they should use their public IP address that can be located here: http://whatismyipaddress.com/. Or the user can also mention a domain name like for example per say- twitter.com .
• Click on the Add Host button.
• The user will see a message stating that the host IP address was added to the access list.

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:

• On the cPanel home screen in the databases section, click on Remote MySQL.
• Locate the host to be deleted under the Access Hosts section and then click on the red X
• Confirm the deletion by clicking on the Remove Access Host.

cPanel’s Hosted Database

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.