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

2,041次阅读
没有评论

[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


搞定!!!

正文完
 0
评论(没有评论)
验证码