Solving development problems  |  About this blog

If you got this strange message on MySQL:

Client does not support authentication protocol requested by server; consider upgrading MySQL client

Then you will need to do the following:

1. Start DOS mysql script manager with command (I assume that you put MySQL/bin to the PATH enviroment variable):
   mysql -u [dbusername] -p, where dbusername is username for your database
2. Enter your current password and you will get mysql > prompt
3. Type:
   SET PASSWORD = OLD_PASSWORD(‘MyPassword’);
4. Type:
   FLUSH PRIVILEGES;

And thats it!