How to configure remote MySQL access in cPanel

This article describes how to use cPanel to allow external hosts to access your MySQL databases. When remote host access is enabled, you can use remote client applications to connect to your databases directly.

Adding host access

To add remote host access for MySQL, follow these steps:

1. Open a support ticket on the A2 Hosting Customer Portal at https://my.a2hosting.com. In the ticket, specify that you want to enable inbound access to MySQL port 3306 for your account.
2. You will receive confirmation from A2 Hosting support that MySQL access is configured for your account. Log in to cPanel.
   If you do not know how to log in to your cPanel account, please see this article.
3. Open the Remote MySQL tool:
   • If you are using the Jupiter theme, on the Tools page, in the Databases section, click Remote MySQL:

     

   • If you are using the Paper Lantern theme, in the DATABASES section of the cPanel home page, click Remote MySQL:
     

     

4. Under Add Access Host, in the Host text box, type the domain name or IP address of the host that you want to add. 
   

   To obtain your own IP address, use your web browser to visit http://ipfinder.us.
5. In the Comment text box, you can add an optional comment to describe the remote host.
6. Click Add Host.

Accessing your database remotely

After you enable host access, you can connect to your MySQL databases remotely by using a MySQL client application. For more information about how to use MySQL client applications, please see this article.

Removing host access

You can remove host access when you no longer want a host to be able to access your MySQL databases remotely.

To remove host access, follow these steps:

1. Log in to cPanel.
   If you do not know how to log in to your cPanel account, please see this article.
2. Open the Remote MySQL tool:
   • If you are using the Jupiter theme, on the Tools page, in the Databases section, click Remote MySQL:

     

   • If you are using the Paper Lantern theme, in the DATABASES section of the cPanel home page, click Remote MySQL:
     

     

3. Under Manage Access Hosts, locate the host for which you want to remove access, and then click Delete.
4. Click Remove Access Host. cPanel removes the host.