help needed

[sankalp sunder]

am just a beginner so this may sound foolish, but my query is --

when i try to connect to mysql server through php, it gives the following error :

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:\Program Files\KeyFocus\KFWS\htdocs\connect.php on line 3


what is the solution.
the version of mysql i hv is 4.1.10
and php version is 4.3.10

plz can someone help me

[khp]

This question is asked quite alot around here, there are multiple solutions. You can read more here http://www.codeguru.com/forum/showthread.php?t=318929
The easiest solution is probably to use the old_password method to set the passwords on the server, this forces the server to use the older authentication protocol which the client also uses.

[sankalp sunder]

thnx a ton buddy...i
the old_password method worked !!!!
thnx again...i guess i am gonna put up a lot more queries... but then again being a beginner entitles me that..(heheheheh)