How to configure remote MySQL access in cPanel

Last modified: Monday November 27th, 2023

In this article, you will know 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 directly to your databases.

Enabling direct remote access to your databases is a potential security risk. An alternative, more secure way to access your databases remotely is to tunnel MySQL connections over SSH. For information on how to set up an SSH tunnel for MySQL, see this article.

Adding host access

Please follow these steps to add remote host access for MySQL:

  1. Log in to cPanel.
  2. Click Remote MySQL in the DATABASES section of the cPanel home screen:                             How to configure remote MySQL access in cPanel remote mysql
  3. Type the domain name or IP address of the host that you want to add under Add Access Host, in the Host text box.
    • To find out 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 starting with 10.0.1, enter 10.0.1.%
  4. You can add an optional comment to describe the remote host in the Comment text box.
  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. For more information about how to use MySQL client applications, please see this article.

Removing host access

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

Please follow these steps to remove host access:

  1. Log in to cPanel.
  2. Click Remote MySQL in the DATABASES section of the cPanel home screen:                                          How to configure remote MySQL access in cPanel remote mysql
  3. Locate the host for which you want to remove access under Manage Access Hosts, and then click Delete.
  4. Click Remove Access Host, and cPanel removes the host.

Looking for an outstanding cPanel-based web hosting provider? Try our web hosting packages with cPanel

Was this article helpful?
Views: 650

10 Years Beehosting!
Celebrate with 70% OFF + FREE Site Transfer.

Beehosting.pro website uses cookies

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners who may combine it with other information that you’ve provided to them or that they’ve collected from your use of their services.

Menu