How to enable remote MySQL Connections in WHM/cPanel

Enable Remote MySQL Connections in cPanel


Please note that Top Speed shared customers are not permitted to use remote MySQL connections in order to ensure the security of the other customers on the same server. This guide is for Dedicated customers running Linux servers with cPanel.

Before using either of the following techniques, you will need to to open up port 3306 in your server’s firewall.

Enabling Remote MySQL in the WHM Interface

Log in to the server’s WHM interface and find the section in the left-side navigation bar labeled SQL Services. Click on the link marked Additional MySQL Access Hosts:

WHM Additional MySQL Access Hosts Link

On the following page, enter one or more hosts or IP addresses in the text box (1) and click the Save button (2). If you wish to activate these settings on all user accounts see (3).

Click for large version





Now that the remote connection has been activated in the WHM each domain account that wants to use the remote connection will need to activate it in their own cPanel interface.

Enabling Remote MySQL in the Domain cPanel Interface

Using the X3 cPanel theme:

Log in to the domain’s cPanel interface and find the section on the main page labeled Databases.

In the Databases section find the link/button labeled Remote MySQL and click on it.

cPanel interface Remote MySQL button

The following page will appear in your browser. Add a hostname or IP address that you want to grant remote MySQL access to (1) and then click the Save button (2).

If a host or IP address needs to be removed from this list you can click the red X next to the entry in the list.

Add Remote MySQL Host

Once you have made your changes/additions to the list you can return the main page of the cPanel interface, or log out if you have no other tasks to take care of.

  • 2 Users Found This Useful
Was this answer helpful?

Related Articles

How to Disable SSLv3 for Apache and Protect Your WHM/cPanel Server from POODLE

There’s a new POODLE in town, but unfortunately it’s not the kind of pooch you want around....

What TLDs are supported?

We support the use of all standard and new TLDs.