Re: "Consider upgrading MySQL client" .... how do I do this?

[Shahmat Dahlan <shahmatd@sains.com.my>]

one way it to use old_password ()instead of password(), when creating 
new user name, or update the password for those existing user names with 
the old_password() function.

but then this will force you to use the old password() function, which 
doesn't really help much...


Vinoaj Vijeyakumaar wrote:

> 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.

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php