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.

13 thoughts on “How to fix: MySQL not starting on MAMP (Pro)”

  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. Worked perfectly for me – thanks! I had previously tried to uncomment the same command further down the file – without success!

  4. 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 ..

Leave a Reply

Your email address will not be published. Required fields are marked *