Setup.php tell me to upgrade MySQl Client???

When running the Setup.php I receive the following error:

Cannot connect to mysql (Client does not support authentication protocol requested by server; consider upgrading MySQL client)

I am running Apache 2.2 on a Windows2003 server with PHP 4.4.4 and MySQL 5.0.27. And the site is Zend Optimized.

Help!

Dan

Not your MySQL rather your PHP version. MySQL changed its login alogorithm in 4.1 so the password hash is different for all versions >4.1. You have to use the OLD_PASSWORD() to authenticate. Something like this....

Code:

UPDATE mysql.user SET Password = OLD_PASSWORD('new_password')
WHERE User = 'user_name';
FLUSH PRIVILEGES;

You must be logged in as root or a poweruser who can manage users.