环境: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; 就可以了. 
|