Client does not support authentication protocol requested by server; consider upgrading MySQL client
2010-09-23 23:48:35 来源:WEB开发网核心提示:错误编号:1251问题分析:Client 不能支持 authentication protocol 的要求解决办法:方法1:mysql> SET PASSWORD FOR -> ' some_user '@' some_host ' = OLD_PASSWORD('
错误编号:1251
问题分析:
Client 不能支持 authentication protocol 的要求
解决办法:
方法1:mysql> SET PASSWORD FOR
-> ' some_user '@' some_host ' = OLD_PASSWORD(' newpwd ');
结合我们的实际情况,在 MySQL Command Line Client 下运行:
set password for root@localhost = old_password('123456');
方法2:
mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd')
-> WHERE Host = 'some_host' AND User = 'some_user';
mysql> FLUSH PRIVILEGES;
上面红色的部分请按自己实际情况修改。
[]
更多精彩
赞助商链接