Leopard Upgrade Breaks MySQL [READ: DON’T UPGRADE]
[UPDATE] I can’t get the below process to work, but found that a thread on Marc Linyanage forum where he appears to be in the process of creating his PHP package installer. Have patience! Solution is eminent. I’m experimenting with his builds.
[UPDATE] PHP isn’t compiled with GD library by default. Here are instructions on how to recompile it with the necessary libraries. Fuck.
[UPDATE] The most comprehensive solution to date is here.
I just put Leopard on my MacBook this morning and can’t get MySQL running. Leopard comes with Apache 2, so some directories have changed. To get PHP running, you’ll need to modify your config file thusly.
As far as MySQL goes, nothing I’ve found on the internet works. Still hunting … I’ll keep you posted here. In the mean time, DO NOT UPGRADE
Looks like it’s a no go. After a few crashes and configuration hacks, I couldn’t get anything working. I’m downgrading back to Tiger.
While I’m still freshly pissed off, I’m just going to come out and say it. I find Leopard fugly. I could make a prettier UI with my asshole.
Comment by Mark — October 27, 2007 @ 2:43 pm
Noooooooo … i was getting super amped to put in work computers! The screen sharing and back to my mac look so awesome. And spaces I bet I could put to work. Plz post an update if anything changes!
Comment by Robert — October 27, 2007 @ 5:30 pm
man thats a bummer, I know you were almost if not more excited for this than I was.
I ran out and bought it this morning, my install went ok, i LOVE the screen share (tested it on me and michelle’s computers today) . I already know this will come in handy around buk, especially for me and jeff. I can’t wait to use back to my mac.
The UI doesn’t bug me too bad, but I wouldn’t have been upset if it was a little bit more… well just more i guess. I don’t use PHP so I haven’t had this problem, but I would say that a pretty big problem for a new OS to have.
crossing my fingers for ya mark.
Comment by Greg — October 27, 2007 @ 8:28 pm
Yeah, screen sharing is going to be AWESOME for us. Both for trouble shooting and just having someone look at some code and maybe design. The colors seem to get affected and there is some aliasing, but it may be useful for checking out layout etc. What seems rad is you could illustrate what you’re looking at on the page with it. I’m curious to see how it goes over regular internet as opposed to LAN
Comment by Robert — October 28, 2007 @ 9:05 am
A good feature would be for Apple to actually provide the final release seeds to developers prior to releasing the OS. That way non-Apple software could actually have a chance to work before you upgrade. Deal breakers aren’t as bad if you know about them ahead of time, but this one took six hours of my life away.
There’s still no easy answer or official solution to the problem, just thousands of forum posts, blog entries, and comments that contradict each other.
Comment by Mark — October 29, 2007 @ 8:21 am
The issue you’re experiencing is probably due to the fact that php doesn’t know where the mysql socket file is. Try this in your php.ini (/etc/php.ini)
mysql.default_socket = /private/tmp/mysql.sock
Comment by Stan — October 29, 2007 @ 8:35 pm
That’s weird, Mark. MySQL is working fine for me on Leopard. I had to start it using the:
sudo /usr/local/mysql/support-files/mysql.server start
instead of using the usual, System Prefs pane. I’m also using MySQL 5.1.20 too. I wonder if that has something to do with it.
Comment by Levi — October 31, 2007 @ 8:31 am
Dude, FAIL.
I like that they’re putting more Quartz animation into their OS, and feel a little like the new UI is much improved over Tiger. Although, the transparent menubar can suck an egg.
Comment by Josh — October 31, 2007 @ 10:55 am
Check this out:
http://discussions.apple.com/thread.jspa?messageID=5777882
My MySQL 5.0.45 has continued to work from Tiger. PHP 5 broke, but I fixed that by using Apple’s version. All of my sites work fine in Leopard and I’m happy.
Leopard hasn’t broken anything I’ve got. Adobe CS3, Coda, VMWare 1.1RC, Office v.X - I’m really happy with Leopard.
That’s on a 4 week old Mac Book Pro 15inch 2.4GHz that had a clean Tiger install which I upgraded because I really didn’t have time to install everything again since I’d only done it 3 weeks before and moved all my MySQL and PHP over from an old PowerBook G4.
But my G5 didn’t like the upgrade to Leopard. So I’ve done a clean install on that on a 2nd Hard Drive inside the G5 and keep switching back to Tiger until I’ve moved everything across.
But there shouldn’t be a problem with MySQL and PHP working on Leopard. Maybe I was just lucky.
Check that Apple Discussion out, it might help. Hope it does, good luck.
Comment by Aled Brown — November 7, 2007 @ 9:13 am
[…] I’ve been running Leopard on my laptop for the past week (haven’t put it on my work comp yet) and there is a lot I like, but as usual, there are a number of irritants. One on that list I’ve been able to put to bed. The finder behaves unexpectedly when used with spaces. Or rather, it behaves like it should, but it just feels weird. To be able to manage the finder absolutely, in my case making it available in all spaces, you just need to know where to look for it. […]
Pingback by Team BKWLD » Managing the finder in spaces — November 10, 2007 @ 7:52 am
[…] I installed Leopard on my work comp last night. Because I was scarred of php/mysql config from Mark’s post I ended up using Mamp. Just learned of it this morning and installed it, but it’s working pretty nice. One useful thing is it makes it really easy to change your apache directory, so you could test sites out as the root of the webserver without any host file / vhost shenanigans. Also, you can quickly switch between php 4 and 5. I wish it installed as a system pref instead of an app, but still, pretty rad. […]
Pingback by Team BKWLD » Leopard + mysql 2 — November 14, 2007 @ 9:37 am
Just posted by solution: http://team.bkwld.com/?p=74
Comment by Robert — November 14, 2007 @ 9:38 am