In this article, we will explain how to resolve the problem that occurs after a server is upgraded to MySQL 5.6.5 or later.
To know the version of MySQL
If you want to know which version of MySQL is installed on your server, but are unsure, then follow these steps.
- Log into “cPanel Account”.
- On the right sidebar of the cPanel home page, click Server Information in the General Information.
- Under Server Information, you need to locate the MySQL Version row to determine the MySQL version installed on the server.
Problem
When you are trying to access a database on your server running MySQL 5.6.5 or later the login fails, after that, you are also using the correct username and password.
For Example: If you are running WordPress on your site, you may see the following error message: Error establishing a database connection
Sometimes other web applications may display similar messages about database connection errors.
Cause
This problem happens when MySQL 5.6.5 and later versions use a new hashing method for user passwords. The newer MySQL versions don’t support the hash method that was used in older versions of MySQL to store passwords, so logins fail.
Resolution
To solve this problem, you have to delete and need to recreate the database user. Once you do this, MySQL will use the new hash method to store the password and the database user can log in again.
Follow these steps to fix the issues MySQL passwords do not work after upgrade
- Login to “cPanel Account”.
- Search the “Database” section, and click on the “MySQL®Databases”
- Select the “Database” which you want to remove and click in the “Delete” Button.
- Now, click on “Delete User” to confirm the deletion, and then click on “Go Back”.
- Add New User, and type the username of the user you deleted in step 3.
- Type the user “Password”.
- Retype the user “Password”.
- Click on “Create User”.
In this manner, you can resolve the error “Error establishing a database connection”.
