cPanel’s Remote MySQL page lets you enable database access from locations, such as your home or another website. For security reasons we don’t allow remote connections on our shared hosting, premium and reseller hosting packages. However, we can enable the feature on our VPS and dedicated hosting plans.

How to connect remotely

The Remote MySQL page has two sections:

  • You can whitelist an IP address or domain under the Add Access Host header.
  • You can manage existing whitelisted IP addresses or domains in the Manage Access Hosts section.

Adding an IP address or domain

To access your database(s) from your home or office you first need to know your IPv4 address. You can check your IP address via findip.co.

In the below example I added the IP address 84.18.210.139. I also added a comment, which is purely for my own reference (you can leave the field blank).

Adding an IP address that will be allowed to access my database(s).
Image: whitelisting an IP address that should be allowed to connect to my database.


Note: You can connect from another website by entering the site’s domain name instead of an IP address.


Managing the whitelist

The Manage Access Hosts section lists existing whitelisted IP addresses and domains. By default, only the IP address of the server is whitelisted. In the below image you also see the office IP address we whitelisted.

The list with hosts that are allowed to connect to our database(s).
Image: the office IP address is now allowed to connect to our databases.

If you need to revoke access for an IP address or domain name, simply click on the Delete link.

Connecting to the database

After whitelisting your IP address or domain you can connect to the database straight away. You can use a graphical tool such as MySQL workbench, or you can connect directly from the command line.