shell> mysqlClient does not support authentication protocol requestedby server; consider upgrading MySQL client official line is that MySQL 4.1 and up uses an authentication protocol based on a password hashing algorithm that is incompatible with that used by older clients ..... (see. I don't quite understand, E text is too bad) If you upgrade mysql to 4.1 or later, 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 following solution) Because MySQL is installed together in Windows is Client and Server), use one of the following two methods one: mysql> set password for -> 'some_user' @ 'Some_host' = Old_Password ('newpwd'); 2: mysql> update mysql.user set password = Old_password ('newpwd') -> where host = 'some_host' and user = 'some_user'; mysql> flush privileges; on the red part, please modify it according to your actual situation ... After doing this, the connection will be normal. @! ====================================== ===== Or above the network abstracts, the following my mistakes. Third, if still prompts "Host DRF Not ALLOWED TO Connect To this MySQL Server", add the following statement mysql> grant select, update, insert, delete on *. * To drf@192.168.0.88 identified by "Your New Password "It is to add an account, you can do a lot, I haven't fully understood it, anyway, DRF is my username, IP is my machine, your new password is my password is OK.
