How to Configure Remote MySQL Access in CPanel

Web Hosting in Pakistan

This article describes 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 to your databases directly.


Adding Host Access

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

  1. In the Databases section of the cPanel home screen, click Remote MySQL.
  2. 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 https://www.whatismyip.com/
    • 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.%.

  3. 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. In the Databases section of the cPanel home screen, click Remote MySQL.
  2. Under Access Hosts, locate the host that you want to delete, and then click the red X icon.
  3. Click Remove Access Host to confirm the deletion.


Was this answer helpful?

 Print this Article

Also Read

Becoming Familiar with Databases in phpMyAdmin

We are going to assume that you are logged in to phpMyAdmin.The main screen is divided into two...

How to Use PHPMyAdmin to Copy a MySQL Database

This article describes how to copy a MySQL database using phpMyAdmin. Copying a MySQL Database...

How to Access phpMyAdmin in cPanel

This article describes the third-party SQL management tool phpMyAdmin. This web-based database...

How to Change MySQL Collation Settings using PHPMyAdmin

This article describes how to use phpMyAdmin to change the collation settings for MySQL databases...

How to Optimize and Repair MySQL Databases using PHPMyAdmin

This article describes how to optimize and repair MySQL databases using phpMyAdmin. Optimizing...

Web Hosting in Pakistan

Powered by WHMCompleteSolution