How to configure remote MySQL access in cPanel

Adding host access #

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

  1. Log in to cPanel.
  2. In the DATABASES section of the cPanel home screen, click Remote MySQL:cPanel - Databases - Remote MySQL icon
  3. 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.
    • You can use the % wildcard to specify a block of addresses. For example, to allow all IP addresses that begin with 10.0.1, type 10.0.1.%.
  4. In the Comment text box, you can add an optional comment to describe the remote host.
  5. 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.

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.
  2. In the DATABASES section of the cPanel home screen, click Remote MySQL:cPanel - Databases - Remote MySQL icon
  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.
error: