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 is what did it for me, in terminal:

sudo chown -R mysql:mysql /usr/local/mysql

Answer 2

There are multiple ways to fix this - usually one works.

To start off, try quitting MAMP and then:

sudo killall -9 mysqld

If that fails, try going to Preferences > Ports and changing to MAMP default. Click ‘OK’. MySQL should then start. If your website doesn’t show up at localhost, try changing the ports back.

You can also stop MAMP, go to System Preferences > MySQL and turn off MySQL and then restart MAMP.

Hope this helps!

Answer 3

twob.net has a pretty good fix for it. Go Into terminal and type in

killall -9 mysqld 

Check it - http://twob.net/journal/fix-for-mamp-mysql/. Worked for me

Answer 4

other way that might fix the same problem :

-go in the folder MAMP/db/mysql/ – delete all files that IS NOT A FOLDER (files like ‘mysql-bin.XXXXXX’ / ‘mysql-bin.index’/ ‘ibdata1’ / ‘ib_logfileX’

don’t worry, this doesn’t erase any of your database, but make sure you don’t delete the folders. That’s where the data of your databases are stored.

Answer 5

Well I'm glad for you it fixed itself on its own ;)

From the look of your error file, it looks like you already had an instance of MySQL running... Not sure if this works on a mac, but you could try :

pidof mysqld

If this outputs something (one or several numbers), then MySQL is running. If the output is empty, then it is not.

Answer 6

What I have found is that at times more than one occurrence of mysql is running. What I do when MySQL will not start is I first quit MAMP, then I go into the Applications/utlities and open the Activity Monitor. From there I search for "my" which should bring up any mysql's that may be running. I then either quit or force quit mysql. At that point I'm able to open MAMP with a working MySQL server.

Hope that helps.