Did you recently encounter “Error 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client” error?
This is a common issue for MySQL server 4.1 and higher. Starting 4.1 version, MySQL changed the authentication algorithm to a better password hashing one. All older clients are trying to connect using the old authentication algorithm and this is the source of the error.
However, MySQL offers the OLD_PASSWORD function for backward compatibility.

These are the steps:
1. start mysql from console:

cd c:program filesmysqlmysql server 4.1binmysql

Optionally, if you changed the root password, you should use

cd c:program filesmysqlmysql server 4.1binmysql -u root

2. after connection, use the following statement

SET PASSWORD FOR root@localhost = OLD_PASSWORD('old_password_here');

That’s it! Now all new and old clients will work.

Leave a Reply