MySQL 4 to 5 for PHP

Question

Level 1

0 points

MySQL 4 to 5 for PHP

I've just installed MySQL 5.0.27 on my Tiger server. As far as I can tell, it installed OK. MySQL 4.1.13 is still running on the server also (as was pre-installed). How do I link PHP to use the MySQL 5 instead of 4? Also, same question for MySQL Admin and through Terminal.

Thanks in advance.

G4, Mac OS X (10.4.8)

Posted on Nov 29, 2006 3:08 PM

Reply

Answer 1

Best reply

Dave Walcott

Level 3

765 points

Nov 30, 2006 9:30 AM in response to mindpalette

The stock Tiger server configuration expects to find the MySQL 'socket' at /var/mysql/mysql.sock. You can check this in /etc/my.cnf, and you can check where php will look for the MySQL socket in /etc/php.ini.

So, if your MySQL 5.x installer uses the same socket location (check the config file metnioned above), you should be all set.

Probably be a good idea to disable MySQL 4.x, by changing 'MYSQL=-YES-' to 'MYSQL=-NO-' in /etc/hostconfig. Note that this assumes that both MySQL 4 and 5 are running, which would indicate that the 5.x is using launchd, not SystemStarter to start at boot time, which is probably the case unless you really did a lot of tweaking.

I've just installed MySQL 5.0.27 on my Tiger server.
As far as I can tell, it installed OK. MySQL 4.1.13
is still running on the server also (as was
pre-installed). How do I link PHP to use the MySQL 5
instead of 4? Also, same question for MySQL Admin and
through Terminal.

Thanks in advance.

MacBook Pro Mac OS X (10.4.8)

Reply

Answer 2

mindpalette Author

Level 1

0 points

Nov 30, 2006 12:49 PM in response to Dave Walcott

Thanks Dave,

I guess my problem at this point is I don't know where the socket is for MySQL 5 to point everything to (apparently /var/mysql/mysql.sock is pointing to MySQL 4). Nothing in the /tmp folder.

I just used the standard installer from mysql.com for Max 5.0.27, Mac OS X 10.4 (PowerPC, 32-bit). I can see it installed MySQL 5 into /usr/local, but I don't know where the socket is...

Reply

Answer 3

Nov 30, 2006 1:43 PM in response to mindpalette

Check '/etc/my.cnf' for the MySQL socket location.

MacBook Pro Mac OS X (10.4.8)

Reply

Answer 4

mindpalette Author

Level 1

0 points

Nov 30, 2006 1:51 PM in response to Dave Walcott

The /etc/my.cnf file is pointing to /var/mysql/mysql.sock. When I use /var/mysql/mysql.sock in MySQL Administrator (or PHP), it's getting MySQL 4.1.13.

Reply

Answer 5

mindpalette Author

Level 1

0 points

Dec 5, 2006 4:33 PM in response to mindpalette

In case someone else is having the same issues, it turns out that MySQL 5 was running/connecting OK, but the MySQL Manager utility was launching MySQL 4 which was taking over from there. After a fresh restart without using MySQL Manager, everything connected fine to MySQL 5. Edited the hostconfig file per the suggestion above. Thanks!

Reply