Client does not support authentication protocol requested by server; consider upgrading MySQL client ,这是怎么回事呢？

[lgr0727]

我的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');




mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd')
-> WHERE Host = 'some_host' AND User = 'some_user';
mysql> FLUSH PRIVILEGES;


这是怎样回事呢？

[mouzhi]

use mysql;
update user set password=old_password("newpasswod") where user="username";
flush privileges;