mysql
4.1 错误：Client does not support authentication protocol requested
by server; consider upgrading MySQL client
解决：mysql> SET PASSWORD FOR
-> 'some_user'@'some_host' = OLD_PASSWORD('newpwd');
Alternatively, use UPDATE and FLUSH PRIVILEGES:
mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd')
-> WHERE Host = 'some_host' AND User = 'some_user';
mysql> FLUSH PRIVILEGES;
如果还不行就：
use mysql;
update user set password=old_password("newpasswod") where user="username";
flush privileges;
例子：
by server; consider upgrading MySQL client
解决：mysql> SET PASSWORD FOR
-> 'some_user'@'some_host' = OLD_PASSWORD('newpwd');
Alternatively, use UPDATE and FLUSH PRIVILEGES:
mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd')
-> WHERE Host = 'some_host' AND User = 'some_user';
mysql> FLUSH PRIVILEGES;
如果还不行就：
use mysql;
update user set password=old_password("newpasswod") where user="username";
flush privileges;
例子：
SET PASSWORD FOR 用户名@localhost = OLD_PASSWORD('密码');
本文转自守住每一天51CTO博客，原文链接：http://blog.51cto.com/liuyu/129614，如需转载请自行联系原作者
