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 ?