Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"

[Gheorghe Iuga]

I have been searching all over the internet for a solution to this problem.
What i have found and it seemed to work for me is this:

http://www.phplivesupport.com/documentation/viewarticle.php?aid=72
-------------------------------------------------------------------------------------------------------------------
mysql_connect(): Client does not support authentication protocol

SUMMARY

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client ...
Could not connect: Client does not support authentication protocol requested by server; consider upgrading MySQL client

INFORMATION

As of MySQL 4.1 there is a new authentication protocol. This authentication protocol is only supported by PHP 5 or higher.

So what you need to do is upgrade your PHP engine to PHP 5 or higher.

NOTE: We have found that PHP 5.0.2 (on Windows) comes with the 3.23.x client API. Try... PHP 5.0.3 for MySQL 4.1.x
-------------------------------------------------------------------------------------------------------------------

Please note that the PHP 5.0.3 Windows Installer comes with NO EXTENSIONS
Wich means that you'll either have to compile the binaries or to manualy install PHP from PHP 5.0.3 zip package.
Or, go down with MySQL to MySQL 4.0 wich seems to be unsing the old protocol.