eygle.com   eygle.com
eygle.com eygle
eygle.com  
 

« 2004年十大风骨人物 | 文摘首页 | 美军地面部队:101空降师 »

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

今天升级了一下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;


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


历史上的今天...

By eygle on 2005-11-01 09:44 | Comments (0) | 学习资料 | 1141 |


CopyRight © 2004~2020 云和恩墨,成就未来!, All rights reserved.
数据恢复·紧急救援·性能优化 云和恩墨 24x7 热线电话:400-600-8755 业务咨询:010-59007017-7040 or 7037 业务合作: marketing@enmotech.com