Home » Database » DB » Bug #2518

[2004-10-13 10:00 UTC] farcel at yahoo dot com

Description:
------------
My configuration is
PHP 4.3.9
MySql 4.1.5-gamma-nt
Pear::DB 1.6.8 (DB-1.6.8.tgz)
IIS on Win2K

I've upgraded MySql from 4.0.20-nt to 4.1.5-gamma-nt yesterday. And everything was working properly on 4.0.20-nt.

I read the comment lines in the files "pear\DB\mysql.php" and ""pear\DB\mysqli.php" :

"pear\DB\mysql.php" says "This is for MySQL versions 4.0 and below"
and
"pear\DB\mysqli.php" says "This is for MySQL versions 4.1 and above. Requires PHP 5"

I've got a question keeping these comments in mind :
"Isn't it possible to use Pear::DB with MySql 4.1 and PHP 4.x ?"

P.S: I also read the Bug #2473 (http://pear.php.net/bugs/bug.php?id=2473). The only difference is i'm using PHP 4.

Regards,
Faruk

Reproduce code:
---------------
$db = DB::connect("mysql://user:pass@localhost/test");
if (DB::isError($db)){
echo "error: ".$db->getMessage() . " " .
$db->getUserInfo();
}else{
echo "ok";
}

Expected result:
----------------
ok

Actual result:
--------------
Error: DB Error: connect failed [nativecode=Client does not support authentication protocol requested by server; consider upgrading MySQL client] ** mysql://user:pass@localhost/test

[2004-10-13 10:44 UTC] farcel at yahoo dot com

In an addition, I read the page "A.2.3 Client does not support authentication protocol" in MySql manual (http://dev.mysql.com/doc/mysql/en/Old_client.html).

I've installed Mysql 4.1.5-gamma-nt to another folder. I mean my new Mysql's "mysql" database is a fresh one. I didn't copy my old 4.0.20-nt's "mysql" database on top of the new one.

I wanted you to know i'm not experiencing the "Old Password" problem.

thanks,
faruk

[2004-10-13 13:39 UTC] farcel at yahoo dot com

thanks danielc