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 ** //
/** 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.
Please see our related article on How to Connect to MySQL Remotely.
IMPORTANT UPDATE ! Since the 11.25 update, we've noticed a bug where you add an IP to the MySQL remote access list, only to find that the corresponding MySQL user that is created does not have any privileges.
In order to get the correct privileges added, you must go back to your MySQL Databases section in cPanel and re-add the user to each database (reassign the privileges). No need to remove the user first; just select the user and the database from the drop-downs and click "Add".
We've notified cPanel about the issue.
cPanel is a popular web hosting control panel that helps you manage your hosting account and assists you in creating web sites, managing e-mail addresses, & installing applications to a server.
I am currently hosting two websites utilising Wordpress. They are both currently displaying the message "Error Establishing a Database Connection". This message appears and then a few minutes later the website can be viewed again. How can I fix this please? None of the files have been changed in any way although I did upgrade one of the sites to a newer version of Wordpress earlier today.
Thanks for your assistance,
Suzanne