How to Connect to the MySQL Database Remotely

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.

To learn more about adding a connection string to your Perl or PHP code using these configuration settings, please see the following article:

Enable Your Computer as an Access Host

By default, all IPs are blocked and must be added to an access list in order to access the server. So, before connecting to MySQL from another computer, the connecting computer must be enabled as an Access Host.

If you do not know your IP address, find it by going to http://www.whatismyip.com/ 

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.

Many of our servers block port 3306 inbound. If you are getting a "Connection Refused" error when trying to connect, please create a ticketrequesting that we open port 3306 for your IP to be able to connect to MySQL remotely.

When Using cPanel X3 Theme

  1. Log into cPanel.
  2. Under Databases, click the Remote MySQL icon.
  3. In the Host field, type in the connecting IP address.
  4. Click Add Host.

You should now be able to connect remotely to your database.

When Using cPanel X Theme

  1. Log into cPanel.
  2. Under Databases, click the MySQL Databases icon.
  3. Scroll all the way to the bottom and type in the connecting IP address in the Host field.
  4. Click Add Host.

You should now be able to connect remotely to your database.

Plesk

If you have Windows hosting, you will need to whitelist your IP. Please follow the instructions in the following articles:

Accessing Your Databases

After whitelisting the, you should be able to make the proper remote MySQL connection. Be sure that the username you use matches the username created in the My SQL database section of cPanel. The most common problem in connecting is due to the use of an incorrect username and password.

For more examples of common MySQL errors, please see the related article:

Removing an Access Host

To remove a host from accessing databases on your server:

  1. In Remote MySQL, click the X icon next to the IP address of the user you wish to remove.
  2. If you are sure you wish to remove the IP address as an access host, click Remove Access Host.
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How to install a script using Fantastico

Fantastico is a great addition to cPanel, which allows users to install the great open source...

What happened to the search engine submitter that was in cpanel?

It was removed by cPanel because all search engine submitters are obsolete. The search engines...

public_ftp folder

The public_ftp folder is used for storing files which are available with anonymous FTP. You...

How to Whitelist Your IP in cPanel for Remote MySQL Access

This tutorial will show you how to whitelist your IP to allow remote MySQL connections for...

cPAddons

CPaddons are no longer available. You will need to use Fantastico De Luxe or QuickInstall for all...