mysql4.1 error:consider upgrading MySQL client [笔记]

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;


例子：

SET PASSWORD FOR 用户名@localhost = OLD_PASSWORD('密码');

本文转自守住每一天51CTO博客，原文链接：http://blog.51cto.com/liuyu/129614，如需转载请自行联系原作者