8 messages in com.mysql.lists.win32Re: jayme : Running different version...
FromSent OnAttachments
Daniel da Veiga25 Nov 2004 11:34 
Jayme Jeffman Filho25 Nov 2004 12:14 
John Paul Ashenfelter26 Nov 2004 09:17 
Tom Molesworth29 Nov 2004 05:43 
Jayme Jeffman Filho29 Nov 2004 06:12 
jjef...@cpovo.net29 Nov 2004 07:43 
Tom Molesworth29 Nov 2004 08:11 
Jon Stephens29 Nov 2004 15:39 
Subject:Re: jayme : Running different versions of MySQL
From:Jon Stephens (jo@mysql.com)
Date:11/29/2004 03:39:03 PM
List:com.mysql.lists.win32

------------------------------

Date: Mon, 29 Nov 2004 12:13:21 -0200 To: <win@lists.mysql.com> From: "Jayme Jeffman Filho" <jjef@cpovo.net> Subject: Re: jayme : Running different versions of MySQL Message-ID: <000101c4d617$344893a0$13471e0a@gseew2k>

Now I have two instances of MySQL running on the same computer, but I still can't connect to MySQL 4.1.7 using PHP 4.3.9. The mysqli functions are not present. Should I use a PHP 5.x version ?

TIA.

Jayme.

mysqli is available only in PHP 5 (it would be nice if the PHP Manual made this plain).

You can connect to MySQL 4.1+ using the mysql extension (in either PHP 4 or PHP 5), but if you do this, you'll also need to do one of:

(a) set passwords for users of the 4.1.7 server using the OLD_PASSWORD() function

or

(b) configure the 4.1.7 server with old-passwords in the my.cnf (or possibly my.ini on win32) file

See http://dev.mysql.com/doc/mysql/en/Password_hashing.html and http://dev.mysql.com/doc/mysql/en/Application_password_use.html for more info.

Note that ext/mysql only knows the old password hashing (as used before MySQL 4.1), whereas ext/mysqli can use the old and new methods for password hashing, and will "know" automatically which is being used by the server it's trying to connect to.

-- Jon Stephens, Technical Writer MySQL AB www.mysql.com Office: +61 (7) 3388 2228 Are you MySQL certified? www.mysql.com/certification