Re: [PHP] Which PHP for MySQL 4.1

2004-11-11 Thread Chris
In my previous email OLDPASSWORD() should have been OLD_PASSWORD() Chris -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Which PHP for MySQL 4.1

2004-11-11 Thread Chris
The MySQL library for 4.1.x is mysqli_* ( http://www.php.net/mysqli ) , that's only works with PHP 5 as far as I know. The old MySQL library ( http://www.php.net/mysql ) Can be used with PHP 4 (any version), but it won't be able to connect to MySQL with a user using the new password system intr

Re: [PHP] Which PHP for MySQL 4.1

2004-11-11 Thread Jim Wharton
You will need to use the old_password() function in MySQL 4.1 and above. You can find out more at mysql.com Jim On Thu, 2004-11-11 at 15:58 -0500, Brent Baisley wrote: > I migrated to MySQL 4.1 about a month ago. I had some issues with PHP > (running 4.3.6) communicating with MySQL because 4.1

Re: [PHP] Which PHP for MySQL 4.1

2004-11-11 Thread Brent Baisley
I migrated to MySQL 4.1 about a month ago. I had some issues with PHP (running 4.3.6) communicating with MySQL because 4.1 implements a new form of communication. As I recall, I had to do something with the passwords in the grants table, but I forget what now. It's been working fine since. On

RE: [PHP] Which PHP for MySQL 4.1

2004-11-11 Thread Jay Blanchard
[snip] I would like to migrate my MySQL servers from 4.0 to 4.1. As I use PHP as well as Java with these servers I wonder what PHP 4 version would be compatible with MySQL 4.1. Has anyone used MySQL 4.1 with PHP yet? [/snip] PHP 4 is compatible with MySQL 4.1. My caution to you would be using A