Mysql4安装Client does not support authentication protocol requested问题的解决

Mysql4安装Client does not support authentication protocol requested问题的解决

今天升级了一下Mysql数据库，结果出现了以下错误：

Client does not support authentication protocol requested by server; consider upgrading MySQL client

升级到4.1.7版:

[root@eygle gbook]# mysql -uroot -p -heygle

Enter password:

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 44 to server version: 4.1.7-max

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

查询了一下，在官方网站发现了解决方法:

http://dev.mysql.com/doc/mysql/en/Old_client.html

共有以下两种解决方法:

一:

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;

使用第二种方法，解决了该问题。