When I first installed MySQL 5.6.11 on Mountain Lion it worked fine for a week. The only issue was I couldn’t get the service to automatically start from boot.
Strangely a week later it started recursively crashing, the only way to stop it was a kill -9 on the mysqld process.
At first I thought this might be due to running the database with a Postgres installation running as well, something that gets setup when you install Daylite, the excellent CRM package. But this was not the cause.
The only way I found to fix it was uninstalling the 64 bit version and installing the 32 bit. I had read something earlier describing this issue.
I spent ages combing the web for a decent ERD tool for the Mac, and for some time resigned to using dbwrench, a java binary the provides decent but limited functionality and is free of charge.
The choice of tools for ERD work is much narrower than what’s available on Linux or the PC, where something like DBDesigner 4 is fantastic and can handle pretty much any job you throw at it.
Then finally I stumbled across SQLEditor and I have to say it’s excellent. It has a sharp and clean GUI with the attention to detail you’d expect from a first rate Mac app. However there is a price tag, $79, and after years of being able to depend on high quality apps that are available for free, I have to say paying such a price takes some getting used to. In this case I think it’s totally worth it and would recommend this tool for any Mac-based software developer.
NB: As phpMyAdmin has collapsed in recent versions, you might also be looking for a decent MySQL client, Sequel Pro is the clear leader.
To find out more about using MySQL in iPhone development see the full details over at the eval-art website.