MySQL Connection error resolution (Error 2049 (HY000): Connection using old (pre-4.1.1) authentication protocol ref used (client option ' Secure_a Uth ' enabled)

When a new version of MySQL is used, the old version of MySQL is connected, and it is possible to report:

ERROR 2049 (HY000): Connection using old (pre-4.1.1) authentication Protocol ref
Used (client option ' Secure_auth ' enabled) this error.

The reason for this is that the server-side password Management protocol is obsolete, using the old user password format storage, but the client upgrade followed by a new password format. The new version of MySQL will reject the connection if it encounters this inconsistency.

So in connection is: to set Secure_auth to False, that is, connect with--secure_auth=off, such as: Mysql-u User name-pip address-p port number--secure_auth=off can.

If you are using a MySQL workbench connection, such as

MySQL Connection error resolution (Error 2049 (HY000): Connection using old (pre-4.1.1) authentication protocol ref used (client option ' Secure_a Uth ' enabled)