Posted on 2006-03-02 10:45
橘子 閱讀(553)
評(píng)論(0) 編輯 收藏 所屬分類:
數(shù)據(jù)庫開發(fā)
Mysql4安裝Client does not support authentication protocol requested問題的解決
今天升級(jí)了一下Mysql數(shù)據(jù)庫，結(jié)果出現(xiàn)了以下錯(cuò)誤：
Client does not support authentication protocol requested by server; consider upgrading MySQL client
升級(jí)到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>
查詢了一下，在官方網(wǎng)站發(fā)現(xiàn)了解決方法:
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;
使用第二種方法，解決了該問題。