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.

  1. Quit MAMP. You may have to force quit when this happens as it does not shut down correctly.
  2. To show any MySQL processes currently running, open Terminal and from the command prompt run:
  3. pgrep mysql
    
  4. Next, kill the two MySQL processes by running the command below.
  5. pgrep mysql | xargs kill -9
  6. To verify they no longer exist, we’ll grep for mysql again and you should not see any processes returned.
  7. pgrep mysql
  8. Now launch MAMP again and MySQL Server start normally.

7 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?

  2. After trying everything recommended on the web.
    I went into MAMP preferences and rolled back my version of PHP. This seemed to work.

    1. Hi Tyler,
      I just had this problem in my MAMP installation – Thanks for your article, tried all the suggested solutions.

      In my case, the one that started the MYSQL Server again was the one Daniel Erkalo suggested. I renamed the files ib_logfile0 and ib_logfile1 as ib_logfile_0 and ib_logfile_1 and the problem was fixed.

      Thanks a lot to both of you !!!

Leave a Reply

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