oldpassword mysql_mysql OLD_PASSWORD's problem | 2hei's site

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;