Re: [PHP] Which PHP for MySQL 4.1
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
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 introduced in MySQL 4.1.3 . You can set a password for a MySQL user using the OLDPASSWORD() function, which would allow you to connect with the old library in PHP 4. Chris C.F. Scheidecker Antunes wrote: Hello, 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? I appreciate your thoughts. Thanks. -- 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
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 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 Nov 11, 2004, at 3:05 PM, C.F. Scheidecker Antunes wrote: > > > Hello, > > > > 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? > > > > I appreciate your thoughts. > > > > Thanks. > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > -- > Brent Baisley > Systems Architect > Landover Associates, Inc. > Search & Advisory Services for Advanced Technology Environments > p: 212.759.6400/800.759.0577 > -- 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
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 Nov 11, 2004, at 3:05 PM, C.F. Scheidecker Antunes wrote: Hello, 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? I appreciate your thoughts. Thanks. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Brent Baisley Systems Architect Landover Associates, Inc. Search & Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 -- 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
[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 Apache 2 as it has some quirks that haven't been worked out yet. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Which PHP for MySQL 4.1
Hello, 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? I appreciate your thoughts. Thanks. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
