MAMP MySQL not starting

Occasionally, your MAMP MySQL server will just stop working and will not start again even you quit and open MAMP again.

Here are the 2 solutions that always worked for me.

 

/Applications/MAMP/logs/mysql_error_log.err

InnoDB: Unable to lock ./ibdata1, error: 35
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.

 

Solution #1

Steps:

  1. Quit MAMP
  2. Kill all mysqld process
    killall -9 mysqld

     

  3. Open MAMP

 

If the Solution #1 didn't work, try this

Solution #2

Steps:

  1. Quit MAMP
  2. Get all mysqld Process IDs (PIDs)
    ps -ef | grep mysql
    Sample Result:
      501 28623     1   0  1:09PM ??         0:00.09 /bin/sh /Applications/MAMP/Library/bin/mysqld_safe --port=8889 --socket=/Applications/MAMP/tmp/mysql/mysql.sock --pid-file=/Applications/MAMP/tmp/mysql/mysql.pid --log-error=/Applications/MAMP/logs/mysql_error_log
      501 29183 28623   0  1:09PM ??         0:01.80 /Applications/MAMP/Library/bin/mysqld --basedir=/Applications/MAMP/Library --datadir=/Applications/MAMP/db/mysql --plugin-dir=/Applications/MAMP/Library/lib/plugin --log-error=/Applications/MAMP/logs/mysql_error_log.err --pid-file=/Applications/MAMP/tmp/mysql/mysql.pid --socket=/Applications/MAMP/tmp/mysql/mysql.sock --port=8889

    The PID the 2nd column (28623, 29183)

  3. Kill all process by PID
    kill 28623
    kill 29183

     
  4. Open MAMP