WordPress : Error establishing database connection

• FTP connect to your hosting account using your account FTP details, Or you can login to cPanel and access the File Manager.
• Open the wp-config.php file (located in the webroot folder, in cPanel it would be the public_html folder)
• Make sure your database name, username, password and hostname are correct (you can find instructions below depending on your hosting)
• Find the database string below in the wp-config.php file and replace the relevant credentials with the correct information.

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

/** Database username */
define( 'DB_USER', 'your-datbase-username' );

/** Database password */
define( 'DB_PASSWORD', 'your-database-password' );

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

/** Database charset to use in creating database tables. */
define( 'DB_CHARSET', 'utf8' );

/** The database collate type. Don't change this if in doubt. */
define( 'DB_COLLATE', '' );

• Re-upload the edited wp-config.php file

​

Cloud Hosting : Database credentials

1. Log into the Console
2. Click the domain you want to manage
3. Click Database and you will see your database under the Current Databases heading
4. Click View under Credentials
5. In the pop up you’ll find log in information and your hostname

​

cPanel Hosting : Database credentials

1. Log into the Console
2. Click the domain you want to manage
3. Click cPanel Hosting
4. Under hosting settings, click Log into cPanel interface
5. Under the Databases section click MySQL Databases
6. On this page you’ll find the database name
7. Scroll down to Current Users and your will find the database user which will connect to the database
8. In the Current Users section you can reset your database user password