Mysql_connect (): Connection using old (pre-4.1.1) authentication protocol Refused_mysql

Do a bit of MySQL upgrade, the development of MySQL upgrade to version 5.6, the result of connecting some of the lower version of the MySQL server reported the following exception:
Warning:mysql_connect (): Connection using old (pre-4.1.1) authentication protocol refused (client option ' Secure_auth ' en abled)

The exception is because the server-side password Management protocol is stale, using the old user password format store, but the client is upgraded with a new password format. When the mysql5.6 version encounters this inconsistency, it rejects the connection.

See the description of the "--secure-auth" option in the MySQL manual "Server Command Options" section: http://dev.mysql.com/doc/refman/5.6/en/ Server-options.html#option_mysqld_secure-auth

There are three ways to solve the problem:

1, server-side upgrade enable Secure_auth option;

2, the client connection off Secure_auth, that is, when connected with--secure_auth=off, such as: Mysql-p10.51.1.11-p3308-uroot--secure_auth=off

3, find the corresponding MySQL user password to the new encryption method, PASSWORD (' Your PASSWORD '), such as:

Copy Code code as follows:

SET PASSWORD for Root=password (' 123456 ');

For method Two, use in the program to do the appropriate MySQL configuration can, in PHP as an example, in php.ini set Secure_auth=off