This article describes a problem that occurs after a server is upgraded to MySQL 5.6.5 or later, and how to resolve it.
When you try to access a database on a server running MySQL 5.6.5 or later the login fails, even though you are using the correct username and password.
For example, if you are running WordPress on your site, you see the following error message:
Error establishing a database connection
Other web applications may display similar messages about database connection errors.
This problem occurs because MySQL 5.6.5 and later versions use a new hashing method for user passwords. These newer MySQL versions do not support the hash method that was used in older versions of MySQL to store passwords, so logins fail.
To resolve this problem, you must delete and recreate the database user. When you do this, MySQL uses the new hash method to store the password, and the database user can log in again.
To do this, follow these steps:
Subscribe to receive weekly cutting edge tips, strategies, and news you need to grow your web business.
No charge. Unsubscribe anytime.
Did you find this article helpful? Then you'll love our support. Experience the A2 Hosting difference today and get a pre-secured, pre-optimized website. Check out our web hosting plans today.
We use cookies to personalize the website for you and to analyze the use of our website. You consent to this by clicking on "I consent" or by continuing your use of this website. Further information about cookies can be found in our Privacy Policy.