So if you’re like me, you do a lot of WordPress development locally and experience annoying issues. I use MAMP, personally, as do many others. One of these common headaches is the MySQL server not starting on MAMP for Mac; inexplicably stopping and whatever you try, it won’t start again. Here’s a fix that has worked all the time for me:
- Quit MAMP.
- In the Finder (or Terminal) go to Applications/MAMP/db/mysql56/ and delete the last log file (e.g. ib_logfile1). Sometimes you’ll have to also delete ib_logfile0
- Restart MAMP.
Boom. You should now be able to use your MySQL databases again.