PHP-MySQL Conn Problem in Win XP

[aparnesh]

Hi

When I am trying to connect to mySQL from PHP, I am getting the error "Client does not support authentication protocol requested by server; consider upgrading mySQL client" . I am using PHP 4, mySQL 4.1 and Win XP Pro. The error is occuring both for Apache & IIS. I am using the same configurations (including php.ini & httpd.conf) in a Win 98 machine, where it is working perfectly. The php.net site advised recompling with -mysqli option, but since I am in Windows I can't do that.

How can I make this work ?
Thanks

[Troy]

Unfortunately, I don't have the experience or time to troubleshoot your exact problem, but I can offer you my WAMP Tutorial which sets up Apache2, PHP5, and MySQL4.1 on Windows XP Home and Pro. It is here:
http://www.daniweb.com/techtalkforums/thread26579.html

[darklordsatan]

This simply happens because of the way php is trying to connect to the mysql server... it has to do with the mysql module in php. Whats weird is that with the exact same configuration, you have it working on win98 (provided the mysql server version is THE SAME that in the xp box).
Likely, there are many solutions... Since im a little tired, Im gonna leave you this:
1. Check the mysql manual (docs folder somewhere in your mysql installation path), as it deals with some possible solutions (that have to do with the way new mysql servers deal with passwords).
2. Google for it, maybe do a search with the error message "Client does not support authentication protocol requested by server; consider upgrading mySQL client", and some good answers might arise. IIRC, one of them is to change the mysql.dll or whatever module for another version or something like that.

Cheers

[aparnesh]

Tried your solution, but the old problem persists. Could this be because of php 5 (in ur example) and php4 (that I am installing) ?