[solved] MySQL server not Starting

Standard

MAMP headache on Mac

If you can’t figure out why the MySQL Server won’t turn on if you’re using MAMP to do local development work, here are two ways to go about it.


 

What worked for me

  1. Quit MAMP.

2. In the Finder, go to and delete the log files (in my case ib_logfile0 and ib_logfile1).

Applications/MAMP/db/mysql56

3. Restart MAMP.


So I tried the below fix and kept getting

No matching processes were found


What others used that didn’t work for me

Quit MAMP.

  1. Open Terminal (either open Spotlight (Cmd+Space) and type “terminal” or you can find Terminal in the /Applications/Utilities/folder)
  2. Then type this (will allow you to kill the mysqld process with security privileges of another users such as root)
ps aux | grep mysql 
lsof -i 
sudo killall -9 mysqld

4. Restart MAMP


Happy Developer!!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s