Client does not support authentication protocol

Solutions

Drivers

Others

Solution for Client does not support authentication protocol error

In MySQL server 4.1 some times we get "Client does not support authentication protocol..." error. This also happens frequently when we use older version of Apache Server with MySQL backend.

I faced this problem once and here is a solution i found working. It seems that, it happens because the latest versions of MySQL uses a new format for the password. It's better to update the client instead of applying these work around.

• To start MySQL server, use "mysqld.exe --old-passwords"
• Try connecting to the server and it should work now.

If above method fails, then try the following method.

• Run MySQL and login as root:
• MySQL -u root -p
• Then, paste the following command, editing as necessary, to change the password of the user to the old format.
• UPDATE MySQL.user SET password=OLD_PASSWORD('somepassword') WHERE user='someuser' AND host='somehost';
• After you have set the passwords to the old format, flush the tables. (flush privileges;)
• Then exit the MySQL client with "quit" and test again.