php 4.4 not working with mysql 4.1

[Paul]

I recently installed php 4.4.4 using windows binaries on Windows XP Pro. I
also installed MySQL 4.1. I usually use Pear DB but I tried MDB2 and it
worked fine until a client uses a different version so I reverted back to
straigh PHP mysql function calls.

I use this code:
$link = mysql_connect('localhost', 'username', 'password');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';

And get this error:
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

Line 3 = $link = mysql_connect('localhost', 'username', 'password');

This is from the PHP.ini file:
;Windows Extensions
;Note that MySQL and ODBC support is now built in, so no dll is needed for
it.

Therefore I assumed I didn't have to do anything to get access especially
since MDB2 worked.

Any ideas of what to do?

[J.O. Aho]

Paul wrote:

I use this code:
$link = mysql_connect('localhost', 'username', 'password');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';

And get this error:
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

Line 3 = $link = mysql_connect('localhost', 'username', 'password');

try with mysqli_connect() instead of the mysql_connect()
see http://www.php.net/manual/en/functio...li-connect.php
and www.php.net/manual/en/ref.mysqli.php
//Aho

[Andy Hassall]

On Sun, 5 Nov 2006 17:06:59 -0500, "Paul" <lo*@invalid.comwrote:

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

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.

--
Andy Hassall :: an**@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool

[Andy Hassall]

On Sun, 05 Nov 2006 23:40:13 +0100, "J.O. Aho" <us**@example.netwrote:

>try with mysqli_connect() instead of the mysql_connect()
see http://www.php.net/manual/en/functio...li-connect.php
and www.php.net/manual/en/ref.mysqli.php

Has mysqli been backported to PHP 4, I though it required PHP 5?

If he's getting an error about having a pre-4.1 MySQL client then mysqli won't
run anyway, since it also requires a 4.1.3 or later MySQL client.

--
Andy Hassall :: an**@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool

[Anonymous]

Andy Hassall wrote:

>
On Sun, 5 Nov 2006 17:06:59 -0500, "Paul" <lo*@invalid.comwrote:

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!

[Jerry Stuckle]

Anonymous wrote:

Andy Hassall wrote:

>>On Sun, 5 Nov 2006 17:06:59 -0500, "Paul" <lo*@invalid.comwrote:

>>>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.
js*******@attglobal.net
==================

[Paul]

"Paul" <lo*@invalid.comwrote in message
news:_f*****************@bignews6.bellsouth.net...

>I recently installed php 4.4.4 using windows binaries on Windows XP Pro. I
also installed MySQL 4.1. I usually use Pear DB but I tried MDB2 and it
worked fine until a client uses a different version so I reverted back to
straigh PHP mysql function calls.

I use this code:
$link = mysql_connect('localhost', 'username', 'password');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';

And get this error:
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

Line 3 = $link = mysql_connect('localhost', 'username', 'password');

This is from the PHP.ini file:
;Windows Extensions
;Note that MySQL and ODBC support is now built in, so no dll is needed for
it.

Therefore I assumed I didn't have to do anything to get access especially
since MDB2 worked.

Any ideas of what to do?

I finally got it working. Several days ago I tried using "UPDATE
mysql.users SET password = OLD_PASSWORD...

And it did not make a difference. I verified the password was chanegd to
the old format.

Yestrday, I tried it again and it worked. Something else must have changed
in the interim. Anyway, I got it working.

Manyt hanks to everyone who replied to my plead for help!

[Anonymous]

Jerry Stuckle wrote:

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.

Which I did in the past. It's better to keep the data consistent so that
you can move the table without problems.

I stick with my recommendation: If upgrading to PHP 5.x is not possible
or wanted, it's best to use old passowrds.

Bye!