MySQL Old password error error:2049 (Cr_secure_auth)

The error prompts are as follows

error:2049 (Cr_secure_auth)

Message:connection using old (pre-4.1.1) authentication protocol refused (client option ' Secure_auth ' enabled)

Error: 2049 (Cr_secure_auth)
Message: Connection request denied using old password encryption (earlier than 4.1.1) (server turned on client ' secure_auth ' option to prohibit link for account with 16-bit password encryption).

workaround See::

The code is as follows	Copy Code
Mysql-u root-pxxxxxx mysql> use MySQL; Mysql> SELECT * from user where user= ' xxxx ';

Now, the password encryption is the 16-bit old password.

The code is as follows	Copy Code
0364fed5542b42b3

Re-modify the password

The code is as follows	Copy Code
mysql-> Update user set Password=password (' 123 ') where user= ' xxx '

Look again, the password is the new password.

The code is as follows	Copy Code
Mysql> SELECT * from user where user= ' xxxx '; *2a2e28094d7b28d4a11108714fe913b0d40512d6

Finally remember to refresh the authorization table

The code is as follows	Copy Code
mysql> flush Privileges;

The

is actually reset the password.