数据库连接失败 mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication.
17162016-05-02 08:10:00返回列表
数据库连接失败 mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication.
想让另一台服务器上的代码连接一台万网服务器上的数据库,但是却一直连不上数据库,报出下面的错误:
mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication. Please use an administration tool to reset your password with the command SET PASSWORD = PASSWORD('your_existing_password'). This will store a new, and more secure, hash value in mysql.user. If this user is used in other scripts executed by PHP 5.2 or earlier you might need to remove the old-passwords flag from your my.cnf file
解决的办法,通过navicat for mysql连接数据库,在命令行执行下面的语句:
SET SESSION old_passwords = FALSE;
SET PASSWORD = PASSWORD('your existing password in plain text');
再次运行连接数据库的代码,能够正常连接数据库了。