Managing MySQL databases remotely using 'Remote MySQL' in cPanel


Written by Dennis Nind

Last published at: February 8th, 2019

(cPanel >> Home >> Databases >> Remote MySQL)


Whilst this facility explains how to activate Remote MySQL from within cPanel, it is also required for you to contact us via a support ticket so that we can 'whitelist' the remote server / device to permit remote connections to port 3306


This feature allows remote hosts (servers) to access MySQL® databases on your account. This is useful, for example, if you wish to allow shopping cart or guestbook applications on other servers to access your databases.


Your hosting provider may add remote hosts to this list at the server level. If you see a hostname that you do not recognize or remove a hostname that reappears later, contact your hosting provider.

Allow a remote server to access your databases

To specify remote hosts that can access MySQL databases on your account, perform the following steps:

  1. Enter the host’s name or IP address in the Host text box.


    • You may enter a fully qualified domain name (FQDN) or an IP address.
    • You may use the percentage sign character (%) as a wildcard. For example, to allow access from all IP addresses that begin with 192.68.0, enter 192.68.0.%.
  2. Click Add Host.

Deny a remote server access to your databases

To deny database access to a remote host, perform the following steps:

  1. Click Delete next to the host’s name or IP address.
  2. Click Yes.