- SOLVED - Same old Authentication problem - SOLVED -
Posted: Thu Jan 26, 2006 8:23 am
Hi,
I have installed mysql 4.1 on to my computer (windows xp pro). Again I have the following error when connecting through my php script,
Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in F:\Auditwebsite\checkuser.php on line 5
Problem connecting
Previously I used the following command within mysql to correc this;
mysql>SET PASSWORD FOR "something@localhost" = OLD_PASSWORD("something");
However this time I get the following error;
Error 1133 - Cant find any matching row in user table
Now I know this error usually means that it doesnt exist however I have checked my db within mysql admin and can see the user there fine.
I have also tried doing this on the root user which lets me in on the admin, however the same error comes up.
Please help!
I have installed mysql 4.1 on to my computer (windows xp pro). Again I have the following error when connecting through my php script,
Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in F:\Auditwebsite\checkuser.php on line 5
Problem connecting
Previously I used the following command within mysql to correc this;
mysql>SET PASSWORD FOR "something@localhost" = OLD_PASSWORD("something");
However this time I get the following error;
Error 1133 - Cant find any matching row in user table
Now I know this error usually means that it doesnt exist however I have checked my db within mysql admin and can see the user there fine.
I have also tried doing this on the root user which lets me in on the admin, however the same error comes up.
Please help!