"Consider upgrading MySQL client" .... how do I do this?
| From: | Vinoaj Vijeyakumaar | Date: | Wed, 03 Sep 2003 09:50:37 +0000 |
| Subject: | "Consider upgrading MySQL client" .... how do I do this? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-30294@lists.php.net to get a copy of this message | ||
Hi,
Just this morning I upgraded to MySQL 4.1.0 alpha and PHP 4.3.3. I'm also running Apache 2 on a WinXP machine. The main reason for the upgrade was so that I could make use of 4.1.0's sub-select feature rather than attempt learning JOINs. It is now 7 hours later, and I keep getting the following error when trying to connect to my database:
Warning: mysql_connect(): Client does not support authentication protocol requested by server. Consider upgrading MySQL client
Running phpinfo() shows Client API version 3.23.49 under mySQL.
Searching around the net all day, the closest explanation I could find was that PHP does not have a client API to interface with MySQL 4.1.x. The solution suggested was to use an ODBC driver to interface between PHP and MySQL but indicated that this may be slower.
My question, therefore, is - is there a way to upgrade the MySQL client in PHP 4.3.3? If not, what are the alternatives (apart from reverting back to MySQL 4.0.x of course).
Thanks in advance.
Vinny.