ThinkPHP Archives - 俺的BLOG

现象：

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

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

解决方法：

SET old_passwords =0;
UPDATE mysql.user SET password =PASSWORD('testpass') WHERE user='testuser' limit 1;
SELECT LENGTH(Password) FROM mysql.user WHERE user='testuser';
FLUSH PRIVILEGES;

SET old_passwords =0;

UPDATE mysql.user SET password =PASSWORD('testpass') WHERE user='testuser' limit 1;

SELECT LENGTH(Password) FROM mysql.user WHERE user='testuser';

FLUSH PRIVILEGES;

原文连接：http://hi.baidu.com/cheng7610/item/16abb4ec51f6d6f02a09a4c1

分类存档：ThinkPHP

php免费开源的手册软件程序

ThinkPHP-无法连接数据库