解决mysql Client does not support authentication 错误!
Nov122008
作者:u2 发布:2008-11-12 23:05 分类:database 解决mysql Client does not support authentication 错误!已关闭评论
今天遇到这样一个问题,mysql无法登陆,日志提示如下:
[Wed Nov 12 14:15:38 CST 2008][MysqlDb.connectDB]java.sql.SQLException: Client does not support authentication protocol requested by server; consider upgrading MySQL client
搜了一下,好多人遇到此问题,大致是mysql版本不通造成的,以下是解决办法:
mysql>UPDATE mysql.user SET Password = OLD_PASSWORD(‘yourpass’) WHERE Host = ‘localhost’ AND User = ‘username’;
mysql>FLUSH PRIVILEGES;
这里是mysql官方的解释!
http://dev.mysql.com/doc/refman/5.0/en/old-client.html
本文固定链接: https://www.2hei.net/2008/11/12/mysql_client_does_not_support/ | 2hei.net
最活跃的读者