Ware Adams wrote:
On May 13, 2005, at 8:34 PM, Hassan Schroeder wrote:
Ong Khai Chin wrote:
Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in C: \Program Files\Apache Group\Apache2\htdocs\mysqltest.php on line 2
Could not connect: Client does not support authentication protocol requested by server; consider upgrading MySQL client what are the configuration i need to do for mysql in php??
You're apparently using a recent MySQL server with an old PHP build. So you should recompile PHP using the newer MySQL client libraries.
Most likely you're using MySQL 4.1 and a php compiled against MySQL 4.0. If you are using a my.cnf file you could also add:
[mysqld-4.1] old-passwords
to it, which for MySQL 4.1 will use the old password methodology and should allow your php to connect.
--Ware
This will certainly work, and it's easy, but it also means turning off the improved security of the new password hashing in mysql 4.1. The more secure course is to follow Hassan Schroeder's advice and build a new php using the mysql 4.1 client library.
As a side note, I find it disappointing that people are still distributing php packages built against the old client library.
Michael
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
