How To Resolve MySQL Not Starting In MAMP

I use MAMP daily. I love MAMP. I recently discovered how truly awesome MAMP Pro is too. But that’s a story for another time. I recently upgraded from MAMP 1.8.4 to 1.9. When I got MAMP 1.9 installed I started the servers. Apache came up but MySQL didn’t want to. I tried shutting down both servers and starting it back up again, which didn’t work.

Thankfully, there is a pretty simple fix. To begin with, make sure MAMP is shut down. Next, open Terminal. To open Terminal either open Spotlight (Cmd+Space) and type “terminal” or you can find Terminal in the /Applications/Utilities/ folder.

Once you get Terminal opened, type the following:

ps aux | grep mysql 
lsof -i 
killall -9 mysqld

That’s it. Start up MAMP and MySQL will come back up just like normal. Another option would be to simply change the port number MySQL is using in MAMP. Restarting your computer may work too but I did’t try that.

[Edit May 5, 2012] Very, very late response to a couple of the comments. If this isn’t working for you, you may have to use sudo. In Terminal, type “sudo killall -9 mysqld” (without the quotes). This will allow you to kill the mysqld process with security privileges of another users (such as root).

66 Responses to How To Resolve MySQL Not Starting In MAMP

  1. Dean says:

    Thanks for the help.

  2. Paul Jinks says:

    Brought my MAMP v2.1.3 installation back from the dead. Thanks!

  3. ac grüns says:

    thx so much!!!….life saver

  4. Jorge says:

    awesome, thanks

  5. Thank you! Worked perfectly for me. I’m on MAMP 1.9.6 and Mac OS X 10.6.8. I am saving this!

  6. Adam says:

    So awesome when something just works, quickly and painlessly. Thanks a lot!

  7. bob m says:

    Thanks very much. That worked for me too.

  8. William M says:

    Thanks. That did the trick.

  9. Betty says:

    After spending the past week trying to trouble shoot my problem with the MySQL server not starting, I followed your instructions. It took a re-start to make it work. Thank you thank you thank you!

  10. Doug says:

    Simple fix… thanks!

  11. Ben says:

    Perfecto, thanks for sharing this with us!

  12. Fabio says:

    When i put the last command (killall -9 mysqld), even with the sudo, it returns “No matching processes were found”. How I fix it? Thanks!

  13. Alex Maltsev says:

    Thanks. That was Easy!

  14. Me says:

    The last option brought my mamp back to life

  15. Javier says:

    Hey man, thanks for this!

    Love the design too!

  16. Peaceedotcom says:

    Just finished installing joomla site on my localhost, cant remember what i did, and my localhost:888 could not show list of sites anymore. Just blank page. please help.

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>