|
|
Posted by Anonymous on 11/06/06 05:27
Andy Hassall wrote:
>
> On Sun, 5 Nov 2006 17:06:59 -0500, "Paul" <lof@invalid.com> wrote:
>
> >Warning: mysql_connect() [function.mysql-connect]: Client does not support
> >authentication protocol requested by server; consider upgrading MySQL client
> >in D:\MyDocuments\web\client\login.php on line 3
>
> There's even a section in the MySQL manual, which is the first hit on Google
> for the error message you posted, for what to do:
>
> http://dev.mysql.com/doc/refman/5.0/en/old-client.html
>
> It offers several possibilities, the most advisable of which is to upgrade the
> MySQL client that your system is using.
The problem is: If he wants to stick with PHP 4.x, he can't. Even the
latest PHP 4.x version uses the old MySQL library for compatibility
reasons.
> Note that older versions of PHP came bundled with a MySQL 3.2.x client
> library, although that (probably) doesn't mean you're forced to use that
> specific version.
In theory you could recompile the latest PHP 4.x version with the latest
MySQL library but I would strongly advise against that. That would make
his scripts work on *his* machine, but nowhere else. As soon as he
uploads them to a provider, a customer he wrote the scripts for, etc.,
they would have the same troubles.
If upgrading to PHP 5 is not desirable, the only reasonable way to deal
with this problem is to use old passwords.
Bye!
Navigation:
[Reply to this message]
|