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

[Frédéric LEROY]

It took me a while, but i found out another way of doing it and keeping the new authentication scheme : recompile php with proper client libs.

So when configuring php, i used the --with-mysql=/usr to use another lib than the one provided with php (from version 5 of php you HAVE TO do this since no std lib is provided)

In order to get this working make sure you have the mysql-devel rpm or some kinda stuff installed... Basically you need Mysql header files. The path /usr might be different depending on how you inalled mysql.

So then you make your php and use that new sapi. (I use apache2 and needed as well the apache2-devel stuff to compile php).

And the new .so is the right version with everything in order... no need to go back to old password stuff !