Shulou(Shulou.com)06/01 Report--

MYSQL (solution): Client does not support authentication (transfer) [@ more@] Client does not support authentication protocol problem occurs when connecting to the above version of mysql4.1 shell > mysqlClient does not support authentication protocol requestedby server; consider upgrading MySQL client is officially called MySQL 4.1 and up uses an authentication protocol based on a password hashing algorithm that is incompatible with that used by older clients. . If you encounter the above problems after upgrading mysql to version 4.1 or later, please make sure that your mysql client is version 4.1 or later. (if you have a problem under WINDOWS, just skip below to see the solution, because MYSQL is installed in WINDOWS by client and server.) Please use one of the following two methods: mysql > SET PASSWORD FOR- > 'some_user'@'some_host' = OLD_PASSWORD (' newpwd') Second: mysql > UPDATE mysql.user SET Password = OLD_PASSWORD ('newpwd')-> WHERE Host =' some_host' AND User = 'some_user';mysql > FLUSH PRIVILEGES;. Please modify the above part according to your actual situation. After doing so, the connection will be normal @

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.