关于"Client does not support authentication protocol requested by server”错误

环境:WINDOWS/IIS/PHP/MYSQL

自由生活的一种方式,所以我也选者了PHP.

原因

当我把phpMyAdmin安装完以后进行测试时出现了配置文件错误的提示其中一句是

"Client does not support authentication protocol requested by server"

解决方法:

(原文地址http://dev.mysql.com/doc/mysql/en/Old_client.html)

CMD进入命令提示符窗口

cd c:\mysql

cd \bin

mysql

mysql>SET PASSWORD FOR

-> 'some_user'@'some_host' = OLD_PASSWORD('newpwd');

然后任意选着下面两种方法:

mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd')

-> WHERE Host = 'some_host' AND User = 'some_user';

mysql> FLUSH PRIVILEGES;

就可以了.