How to fix: MySQL not starting on MAMP (Pro)

I recently had to install MAMP Pro, in order to do some separate work from my Laravel Homestead VM.

After a weird Mac crash, MAMP would no longer start the MySQL server. This was the data from the logs:

To fix this, go to MAMP, File > Edit Template > MySQL > [version] and add the line highlighted below.

# The MySQL server
[mysqld]
innodb_force_recovery = 1

The restart the server. After this you can comment out that line. Hopefully you will now be able to run the server again.

12 Comments

  1. Thank you, you’re a lifesaver.

    This is the second time this has happened to me (first time I had to reinstall and lose all my data), but this time I looked up the logs and found your post

  2. I tried /Library/Application Support/appsolute/MAMP PRO/db/mysql56 renaming the log files…did not work. THIS worked beautifully! Thank you!

  3. BLESS YOU! Been spinning my wheels on this all day!

  4. Thank you! No other solution has worked for me.

  5. Worked perfectly for me – thanks! I had previously tried to uncomment the same command further down the file – without success!

  6. thanks so much … you saved my day !

  7. Great, thanks to you I’am able to work again, great article. Take care

  8. There are no such thing as a stupid question right? ..how do I go to “File > Edit Template > MySQL > [version]” in MAMP ? I cant figure it out ..

  9. Thanks for this, worked perfect!

  10. Like others have said, thank you!

Leave a Reply

© 2018 Nacho Toledo

Theme by Anders NorénUp ↑