After upgrade Mysql password not working

kumkumsharma

Administrator
Staff member
We are getting error “Error establishing a database connection” after up gradation to MySQL 5.6.5 or newer version; the reason is new hashing method. Mysql older version used a hashing method to store password but newer version does not support hash method.

You have to delete your current user and then create new one, it’s because after recreating user Mysql used new hash method to save password. You can follow below steps :
  • Login to cpanel.
  • Click on Mysql databases under “Database” section.
  • Now under ”Current User” remove your user and then create it.
  • You have to click on “Add a New User”, you have to enter details which you have delete previously.
  • Enter your user password and then click on “Create a User “ button.
 
Top