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. This post has two solutions. The first solution of killing running processes has worked for me pretty much all the time. The second solution is from one of the comments below.

  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 the command below.
    pgrep mysql
  3. Next, kill the MySQL processes by running the command below.
    pgrep mysql | xargs kill -9
  4. To verify they no longer exist, pgrep for mysql again and you should not have any processes returned.
    pgrep mysql
  5. Now Launch MAMP again and MySQL Server should start normally.

Alternative Solution

If the above solution does not work, this method should.

  1. Stop Mamp and kill the mysql processes as above.
  2. Rename the ib_logfileN (N is the log numbers) files to something else. Don’t delete these as you may need to return to them. The path to these files may be different on your system. On my system, I would do the following:
    mv /Library/Application\ Support/appsolute/MAMP\ PRO/db/mysql56/ib_logfile0 /Library/Application\ Support/appsolute/MAMP\ PRO/db/mysql56/ib_logfile_0
    
    mv /Library/Application\ Support/appsolute/MAMP\ PRO/db/mysql56/ib_logfile1 /Library/Application\ Support/appsolute/MAMP\ PRO/db/mysql56/ib_logfile_1
  3. Restart MAMP and MySQL should start correctly.
    (Thanks to Daniel Erkalo for this alternative fix!)

21 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 !!!

    2. Hi Daniel, I’m just new to mac. I’ve experienced the same error but don’t know how to rename the file or where it’s located. Can you please share the details? Thanks!

  3. I changed the file names but it didn’t work for me. My MAMP used to work fine but there was an outage and computer shutdown. Upon restart MAMP wasn’t running. MySQL won’t start.

  4. Hi, I don’t have ib_logfile0 in my mysql directory? My machine crashed while running MAMP Pro and on a restart, mysql won’t come up, I’ve tried the suggestions in the posts here, still nothing?
    My mysql install is in Applications/MAMP/db/mysql56/mysql which seems different to configurations I have been reading, trying to resolve this. Any advice?

  5. My MAMP was running just fine until my Macbook crashed on me. So I had to restart it by pushing the power button. But now the MYSQL server won’t start. I tried your solution above, however this did not resolve the problem. Any further assistance would be greatly appreciated.

  6. Hi Tyler
    Thanks, for the post with yours and Daniel’s insightful content and assistance from course instructor, I was able to get my databases up and running.

  7. Same problem, no solutions have worked sadly. Have renamed files, changed ports, reinstalled latest MAMP – nothing. Apache green light but MySql refuses to start.

  8. DO NOT DELETE ibdata1 or your WP installs etc will clear all the database tables!! I found the error of my ways, and luckily had backed up said file. Now reinstated and MySql is working. Thanks to tomdurkin.me. Also thanks to contributions here – it’s been a hell of a day!

Leave a Reply

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