学习笔记

Study notes

数据库连接失败 mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication.

云逐梦13682016-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');  


再次运行连接数据库的代码,能够正常连接数据库了。


返回
顶部