当前位置： 首页 > database > 正文

mysql OLD_PASSWORD’s problem

Aug252008
作者：2hei   发布：2008-08-25 21:36   分类：database   阅读：3,124 views   mysql OLD_PASSWORD’s problem已关闭评论  

In my mysql slave and master’s
i meet a problem:
[MysqlDb.connectDB]java.sql.SQLException: Client does not support authentication protocol requested by server; consider upgrading MySQL client

this is a problem of mysql update version 4.1 and more!

to sovle it , we can do this

1st:
mysql> SET PASSWORD FOR
    -> ‘some_user’@’some_host’ = OLD_PASSWORD(‘newpwd’);
2nd:
mysql> UPDATE mysql.user SET Password = OLD_PASSWORD(‘newpwd’)
    -> WHERE Host = ‘some_host’ AND User = ‘some_user’;
mysql> FLUSH PRIVILEGES;

本文固定链接: http://2hei.net/mysql_old_passwords_problem.html | 二黑的站点

该日志由 2hei 于2008年08月25日发表在 database 分类下，
原创文章转载请注明: mysql OLD_PASSWORD’s problem | 二黑的站点
关键字:
【上一篇】
【下一篇】

您可能还会对这些文章感兴趣！

报歉!评论已关闭.