I upgraded to MYSQL 5.6 and now passwords are broke

WebHostPro

• January 18, 2016 19:36

DBD::mysql::db do failed: Password hash should be a 16-digit hexadecimal number I upgrade to MySQL 5.6 since 5.5 stopped being supported last month. I noticed the password error message during the upgrade but I can't even change the mysql password. Every time I tried to change the password I get this error: DBD::mysql::db do failed: Password hash should be a 16-digit hexadecimal number I even tried to add a 16-digit hexadecimal number and it still gave the same error.

• 

  WebHostPro

  • January 19, 2016 13:32

  I see all you have to do is add a new MySQL user and connect it to the script. There is a way to upgrade the current password but it is a not needed if you just add a new user.

  0
• 

  cPanelMichael

  • January 19, 2016 15:30

  Hello :) You can run the following command to determine which users are using the old style MySQL passwords:
  mysql -e "select User,plugin from mysql.user where plugin = 'mysql_old_password';"
  The following document explains how to upgrade the passwords for these users: MySQL :: MySQL 5.6 Reference Manual :: 6.3.8.3 Migrating Away from Pre-4.1 Password Hashing and the mysql_old_password Plugin Thank you.

  0

Please sign in to leave a comment.