|
|
Posted by Jerry Stuckle on 11/06/06 11:47
Anonymous wrote:
> 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!
Not at all. Unless he's trying to backup the MySQL users database on
one machine and restore it to the other, there should be no problems.
Other than cleaning up some syntax (i.e. JOINS) to make MySQL 5.x more
standards compliant, code written for MySQL 4.x should run on MySQL 5.x.
And code written on MySQL 5.x which doesn't use new features should
run fine on MySQL 4.x (other than the JOIN statements).
The password problem affects ONLY the MySQL users database. And in
general there's no reason to backup that database and restore it on
another machine unless moving an entire system.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|