By default, all IPs are blocked from connecting to your MySQL databases. In order to allow an IP connection, it must be added to the access list. To do so, log in to cPanel, under the heading Databases, click Remote MySQL.

Type in the connecting IP address, and click the Add Host button. Note that you can find your IP address from this page.

Configuration Settings:

Use the following configuration settings for connecting to your database

Host name = (use the server IP address)
Database name = (cpanelUsername_databaseName)
Database username = (cpanelUsername_databaseUsername)
Database password = (the password you entered for that database user)
MySQL Connection Port = 3306
TCP or UDP, either is fine.

Removing Access for a Remote Server to Access Your Database

To remove a host from accessing databases on your server:

1. Click the Delete button next to the IP address.
2. If you are sure you wish to prevent the server from accessing your databases, click Yes.

Dynamic IP Addresses

Having a dynamic IP address means that the connecting IP address can change periodically depending on the Internet Service Provider (ISP). You must update the connecting IP in Remote MySQL every time it changes.

Managing Your Databases

After whitelisting the IP to allow remote connection, you should be able to make the proper remote MySQL connection with the database's name and user found in the cPanel's MySQL Databases page. The most common problem in connecting is due to an incorrect username and/or password. Please make sure the username you use matches the username created in the "MySQL Database" section of your cPanel.

You will need a third party application to access MySQL remotely. Some are free and some cost money.

How helpful was this article to you?