How to connect to MySQL database?

Configuration Settings:

Host name = localhost (literally put localhost)
Database name = (cpanelUsername_databaseName)
Database username = (cpanelUsername_databaseUsername)
Database password = (whatever you picked)

WordPress Example: User name = joe1337 , Database name = wrdp1 , Database-user name = wp1 , Database-user password = eHTb7%Pxa9

// ** MySQL settings - You can get this info from your web host ** //
/** The name of the database for WordPress */
define('DB_NAME', 'joe1337_wrdp1');

/** MySQL database username */
define('DB_USER', 'joe1337_wp1');

/** MySQL database password */
define('DB_PASSWORD', 'eHTb7%Pxa9');

/** MySQL hostname */
define('DB_HOST', 'localhost');

Note: When you move databases to our servers, the database name and username may change. This change must be updated in your script code. (The database name and username is clearly displayed in cPanel, in the MySQL area.)

On shared servers, the database user name cannot be changed to something without the cPanel user name in it.

It is possible for someone to use their cPanel username and password to connect to the database. However, we NEVER recommend doing this because the first time you change or reset your cPanel password, then your databases will stop working.


How to connect to the MySQL server remotely

Note: If connecting from your home computer, you need a MySQL client like Navicat, phpMyAdmin, or Dreamweaver.

Configuration Settings:

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

  • 1 Users Found This Useful
Was this answer helpful?

Related Articles

Apache Error Logs

When you check the error logs, you can see many things. Some things you can ignore: File does...

Accessing Web Disk

Web disk (also known as Web Dav) is a drag-and-drop interface which allows you to access your...

Apache Handlers (running html as php)

Apache handlers allow you to control what Apache will do with certain file types. When Apache...

Backup File Types

So, you have a backup file, but you need to know what type of backup it is so you can know what...

Copy Entire Database or Rename Database

Is there a way for me to copy an entire database in cPanel from another server? You will need...