IF YOU WANT TO CONNECT ” CONNECT TO THE MYSQL DATABASE LOCALLY “  MAKE USE OF THE FOLLOWING CONFIGURATION SETTINGS:

=================================

Host = localhost (really, put localhost)

Database name = (cpanelusername_databasename)

Database username = (cpanelusername_databaseusername)

Database password = (******)

=================================

TO CONNECT TO THE MYSQL SERVER REMOTELY CONFIGURATION SETTINGS:

=================================

Host = (use the server IP address)

Database name = (cpanelusername_databasename)

Database username = (cpanelusername_databaseuser)

Database password = (******)

MySQL Connection Port = 3306 TCP or UDP, either is fine.

=================================

NOTE : If connecting from your home computer, you need a MySQL client like  phpMyAdmin.
Also, inorder to be able to connect to MySQL DataBase from remote computer computer, you must enable your computer as an Access Host.

You can do so by simply following these instructions :)

If you are using cPanel with X3 Theme,

  1.  Login to cPanel and click the Remote MySQL icon, under Databases.
  2.  Type in the connecting IP address, and click the Add Host button.All done, try connecting remotely.

– or –

If you are using cPanel with X Theme :

  1. login to cPanel and click the MySQL Databases icon, under Databases.
  2. Scroll to the bottom and type in the connecting IP address where it says “Host (% wildcard is allowed):”, and click the Add Host button.

All done, try connecting remotely.