在连接Mysql的时候,报下面的错误及解决方法

1. Client does not support authentication protocol requested by server; consider upgrading MySQL client (Mysql::Error)

          一般情况下都可以解决。如果还出现这种错误，可以按照下面的方法来做：

 

1）MySQL->SET PASSWORD FOR 'some_user'@'some_host'=OLD_PASSWORD('new_password');

 

      MySQL->FLUSH PRIVILEGES;

 

2）MySQL->UPDATE MySQL.user SET Password=OLD_PASSWORD('new_password') WHERE Host='some_host' AND User='some_user';

 

     MySQL->FLUSH PRIVILEGES;