MySQL Server on Windows · 1105 days ago
Everytime I install MySQL on a Windows machine I get the same error messge in php when trying to access the database.
This is with MySQL 4.1 and PHP 4.3.
The error is something like this:
mysql Client does not support authentication protocol requested by server; consider upgrading MySQL client
The solution is very simple but I always have trouble finding it online.
So here it is:
SET PASSWORD FOR
-> 'user_name'@'localhost' = OLD_PASSWORD('pass_word');
I did read somwhere that you may need to use a different password before setting with OLD_PASSWORD.
SET PASSWORD FOR
-> 'user_name'@'localhost' = OLD_PASSWORD('tmp_pasword');
then
SET PASSWORD FOR
-> 'user_name'@'localhost' = OLD_PASSWORD('real_password');
but I haven’t experienced this problem yet.