Re: Change password the new hash

[James Mason]

Hey guys,

This just bit me after restoring a dump from an older MySQL version onto 5.6. The problem is with the User.plugin field indicating the account is using the old-style password hash.

Here are the steps I used to resolve it.

1. Log in as root (mysql -uroot)

2. Run the following statements:

UPDATE mysql.user SET Password = PASSWORD('cheese') WHERE User = 'test' AND Host = 'localhost';
UPDATE mysql.user SET plugin = 'mysql_native_password' WHERE User = 'test' AND Host = 'localhost';
flush privileges;