MAMP MySQL Server Won’t Start

This was a common problem with past versions of MAMP and it continues to happen for some users in version 4.x. Fortunately, the fix is easy. The problem is that when exiting MAMP the MySQL processes continue to run and are not stopped.

Mamp

Steps to Fix

  1. Quit MAMP. You may have to force quit when this happens as it does not shut down correctly.
  2. Open Terminal and from the command prompt run:
    ps -ef | grep mysql

    This will show you any mysql processes that are still running. Note there are two processes running in this example (not including the grep process). The process id’s are 38585 and 39048. Note these id’s will be different on your system!

    ps -ef | grep mysql

  3. Next, from within terminal, kill the two processes.
    sudo kill -9 38585 39048

    To verify they no longer exist, we’ll grep for mysql again

    ps -ef | grep mysql


    ps -ef | grep mysql

  4. Now launch MAMP again and it should start normally, including MySQL Server.MAMP

2 thoughts on “MAMP MySQL Server Won’t Start”

  1. Hi Tyler, thanks for posting. Unfortunately, I’m not able to get MAMP 4 to launch MySQL and I’ve verified there are no other mysql processes running.

    I did an install of MAMP 4 over an older MAMP 1.9.4 which had migrated from an older computer over to my new iMac with Sierra. During installation a window popped up to notify me that my wp databases had been copied to the folder mysql56 and it would be necessary to convert them when MySQL launched.

    Unhappily, MySQL has not launched. I’ve changed the ports to 80 and 3306. I’ve switched the webserver document root to the folder where I keep my websites. It’s not working. I tried switching back to the default document root. Still no go.

    Contacted MAMP support, copied the error log and they suggested I rename the ib_logfile0 and ib_logfile1. But what should I name them? Do you have any idea?

    MAMP 1.9.4 is still working beautifully on my old iMac. 🙁

    1. I’ve never tried to upgrade major releases over the top of another MAMP version. I always just dump my databases and save any server config info then install the new version and import the DBs back in. Doesn’t take long and seems like a cleaner solution. With version 4 though, I have upgraded the latest point releases without any issues. Can you install v4 as a standalone and not upgrade your 1.9.4?

Leave a Reply

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