80后的细娃儿

#1251 - Client does not support authentication protocol requested by serve

[mysql]#1251 – Client does not support authentication ……
2007-01-01 09:10
#1251 – Client does not support authentication ……


安装完MYSQL 5.0.18后,配置好PHPMYADMIN 2.7.0,一切正常,就是到了最后登录的时候出现

错误
#1251 – Client does not support authentication protocol requested by server; consider upgrading MySQL client



解决办法:
1、进入命令行下,转到MYSQL目录的BIN目录下,进入MYSQL命令行模式:
   例:d:mysqlin>mysql -uroot -p123   (用户root,密码123)
2、输入命令:
   mysql>set password for 
'root'@'localhost'=old_password('123'
);   (注意冒号不能少)
3、退入MYSQL命令行:
   mysql>q


搞定!!!

点赞