I upgraded to MYSQL 5.6 and now passwords are broke

[WebHostPro]

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]

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.

 

[cPanelMichael]

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.