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.

  • Another Ari

    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

    • Glad it helped :)

  • famousartguy

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

  • kari

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