mySQL problem?

[Galaxay1]

Warning: mysql_connect() [function.mysql-connect]: Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:\Apache2\htdocs\dbconnect.php on line 3
Could not connect : Client does not support authentication protocol requested by server; consider upgrading MySQL client

It running on Windows Server 2003, using Apache 2.2.4 PHP 4 and mySQL 5..

[craigg.]

I never knew windows servers could handle MySQL. I thought MySQL and PHP were linux/unix based. I'm not sure.

[Galaxay1]

PHP Works fine for me and has for a bit, but i just tried to install mySQL latety, failing at it

[Eccentric]

is that the latest version of mysql? if so try downgrading to the version before?

[Galaxay1]

Please only reply if you have proper answer.

[Eccentric]

it was a question not ana answer

[Tomm]

You have a number of options:

- Upgrade the MySQL DLL for PHP
- Downgrade to MySQL 4
- Change all the passwords manually and enclose the password with OLD_PASSWORD.

And just to let you know MySQL, PHP and Apache run perfectly well on Windows. I run a Windows Server as well.

[Galaxay1]

How do i change the pass's manually? o.O

[Tomm]

How do i change the pass's manually? o.O

SET PASSWORD FOR 'user'@'host' = OLD_PASSWORD('newpwd');

Change user and host to the appropriate values.

Run that SQL while logged in as root.

[Galaxay1]

Yer ino but where?