MySQL::ERROR Client does not support authentication protocol requested by server; consider upgrading MySQL client

将Linux下的MySQL5.0.37的data文件夹移到Windows平台下MySQL5.1.20后,Rails程序报如下错误：
Client does not support authentication protocol requested by server; consider upgrading MySQL client
这个错误以前在用MySQL从老版本转到MySQL4.1.10时候碰到过，不知到5.1.20还碰到这个问题，还是用原来的方法修改下数据中mysql那个库中的用户密码即可：
SET PASSWORD FOR user@localhost = OLD_PASSWORD('password');