Important: If connecting from your own home computer means remote MySql database connection, you will need a MySQL client like Navicat, phpMyAdmin, Workbench or Dreamweaver.

See our article on Managing Your Database with Applications for most suggested programs and much more details.

Configuration Settings:

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.

Utilizethe following configuration settings to plug in your database-

For adding vital string to your Perl or PHP code using these configuration settings, please see: MySQL Connection Strings-
Allowing an online Server to gain access to Your Database-

Before connecting to MySQL from another computer, the connecting computer have to be enabled being an Access Host.

Log into cPanel and then click the Remote MySQL icon, under Databases.
Type in the connecting IP address, and click on the Add Host button.
Note: You will find and add your IP address completely from this tool. Search Your IP is: 122.122.12.122 [Add]. Clicking the [Add] link will input your IP in the field box below.
Click Add, and you ought to easily be able to connect remotely on your database.
​

Removing Access to get a Remote Server gain access to Your Database:

To clear out a number from accessing databases on your own server:

Click on the X icon next to the IP address.
If you are sure you need to prevent the server from accessing your databases, click Yes.
Dynamic IP Addresses

Which has a dynamic IP address signifies that the connecting IP address can change periodically according to the Isp (ISP). You need to update the connecting IP in Remote MySQL every time it changes.

Managing Your Remote MySql Databases

After whitelisting the IP permitting remote connection, you ought to be capable of making the proper remote MySQL connection with the database's name and user found in the cPanel's MySQL Databases page. The commonest overuse injury in connecting is because of an incorrect username and/or password. Please ensure the username you make use of matches the username created in the "MySQL Database" section of your cPanel.