How to Connect to the MySQL Database Remotely?

Log in to the domain’s cPanel interface and find the section on the main page labeled Databases.
 
In the Databases section find the link/button labeled Remote MySQL and click on it.
  


The following page will appear in your browser. Add a hostname or IP address that you want to grant remote MySQL access to (1) and then click the Save button (2).

If a host or IP address needs to be removed from this list you can click the red X next to the entry in the list.


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.

  • 99 Users Found This Useful
Was this answer helpful?

Related Articles

What Is a Wildcard Redirect?

Wildcard redirect is a specific redirect type that allows you to redirect all files within a...

How to Remove Old Backup Files from cPanel?

1. Log in to your cPanel account.2. Go to File Manager, 3. Click on Home (/home/username)...

How much Bandwidth Does your Site Really Need?

What is the bandwidth?Essentially, it’s just a term to quantify the rate of traffic and data...