汤云飞

mysqlnd cannot connect 连接错误处理方法

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. 

使用phpadmin连接上远程数据库,执行以下sql即可:

SET SESSION old_passwords=FALSE;
 
SET PASSWORD = PASSWORD('yourpassword');

 

posted on 2015-05-04 09:51  汤云飞  阅读(213)  评论(0编辑  收藏  举报