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:
Optionally, if you changed the root password, you should use
2. after connection, use the following statement
That’s it! Now all new and old clients will work.
Andrei
http://www.webxpert.ro