Can someone tell me why I am getting this message:

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

System Setup:
Running Apache 2 with PHP 4.3.9 on Windows XP
and mySQL 4.1.7

PHP Code Used:
mysql_connect("localhost", "userid", "password") or
die(mysql_error());

Any help will be appreciated
Thanks

u may try Win2000 Pro/Server or Win2003 :)

Although I haven't heard of the error you're talking about, using a Microsoft server will not overcome it.

Check out the docs and mailing lists at http://www.mysql.com. I'm sure someone there has a clue of what's happening.

Regards,
Rich

--
[http://www.smilingsouls.net]
[http://pear.php.net/Mail_IMAP] A PHP/C-Client/PEAR solution for webmail

try to set register_globals to On and try it.

mysql on my system works alone but can not connect to php, i use php4 and mysql 4.1 on apache 1.33 all om win xp pro,please help me too.

Thanks, I did set up my password by using :
"set password for root@loacalhost=password('your_password');
log out "\q", and then log back with:
mysql -u root -p,
prompts for password! 'yourpassword'
and then I get the wellcome monitor screen.
then I make sure I place the same password in my PHP script, at hte
mysql_connect () function.
and I now get : Can't create database 'wiley'. Database exists.
My hole next week will be dvoted to this message NOW..

Ho yes, I tried to do that I remember; Then I decided that a better use of my time was to use an internet host.