MYSQL 新版出現用戶端版本過低

 

　　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;