MAMP : Mysql won't turn on

Question

My mamp mysql server won't turn on. I tried executing /Applications/MAMP/bin/startMysql.sh but that gave me this error :

101110 05:50:31 mysqld_safe Logging to '/Applications/MAMP/logs/mysql_error_log.err'.

101110 05:50:32 mysqld_safe Starting mysqld daemon with databases from /Applications/MAMP/db/mysql

101110 05:50:32 mysqld_safe mysqld from pid file /Applications/MAMP/tmp/mysql/mysql.pid ended

/Applications/MAMP/logs/mysql_error_log.err :

InnoDB: http://dev.mysql.com/doc/refman/5.1/en/operating-system-error-codes.html

InnoDB: Could not open or create data files.

InnoDB: If you tried to add new data files, and it failed here,

InnoDB: you should now edit innodb_data_file_path in my.cnf back

InnoDB: to what it was, and remove the new ibdata files InnoDB created

InnoDB: in this failed attempt. InnoDB only wrote those files full of

InnoDB: zeros, but did not yet use them in any way. But be careful: do not

InnoDB: remove old data files which contain your precious data!

101110 5:53:08 [ERROR] Plugin 'InnoDB' init function returned error.

101110 5:53:08 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

101110 5:53:08 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use

101110 5:53:08 [ERROR] Do you already have another mysqld server running on port: 3306 ?

101110 5:53:08 [ERROR] Aborting

101110 5:53:08 [Warning] Forcing shutdown of 2 plugins

101110 5:53:08 [Note] /Applications/MAMP/Library/libexec/mysqld: Shutdown complete

101110 05:53:08 mysqld_safe mysqld from pid file /Applications/MAMP/tmp/mysql/mysql.pid ended

Answer 1

This command worked for me.

     ps aux | grep mysql 
     lsof -i 
     killall -9 mysqld

if needed

    sudo killall -9 mysqld

Ref: http://www.witheringtree.com/2010/05/how-to-resolve-mysql-not-starting-in-mamp/

Answer 2

With a new/clean install of MAMP 4.1.1, I had the same problem.

When running: /Applications/MAMP/bin/startMysql.sh

MySql reported:

mysqld_safe error: log-error set to '/Applications/MAMP/logs/mysql_error_log.err', however file don't exists. Create writable for user 'mysql'..

So, I ran touch /Applications/MAMP/logs/mysql_error_log.err and tried again with startMysql.sh. It worked (but it wasn't quite "by itself")!

Answer 3

Jmeyer, on occasion MAMP will do strange things like refuse to restart. When this happens, go to the MAMP application and click "preferences" and then just click "Ok."

For some reason this forces a restart of the MAMP server.

Not sure if that's what you were looking for, but a helpful tip nonetheless.