consider upgrading MySQL client official line is that MySQL 4.1 and up uses an authentication protocol based on a password; Client does not support authentication protocol solution to the problem shell> mysql Client does not support authentication protocol requested by server version when connected over mysql4.1 Hashing Algorithm That IS Incompatible with That Used by Older Clients. ..... If you upgrade mysql to 4.1 or more version, you have encountered the above questions, please make sure your MySQL Client is 4.1 or higher. (there is a problem under Windows You will jump directly to the solution below, because MySQL is installed together in Windows is Client and Server) Please use one of the following two methods one: mysql> set password for -> 'some_user' @ 'Some_host' = OLD_Password ('newpwd'); two: mysql> update mysql.user set password = Old_password ('newpwd') -> where host = 'some_host' and user = 'some_user'; mysql> flush privilege
