mysql 1251错误

技术分享 Story 69浏览 0评论
摘要

mysql 1251错误

#1251 - Client does not support authentication protocol requested by server;
2007-07-25 17:14
[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:\mysql\bin>mysql -uroot -p123 (用户root,密码123)
2、输入命令:
mysql>set password for 'root'@'localhost'=old_password('123'); (注意冒号不能少)
3、退入MYSQL命令行:
mysql>\q

搞定!!!

转载请注明:成长的对话 » mysql 1251错误