Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Freak MySql error with MAMP

Tags:

mysql

macos

mamp

  • I setup MAMP Pro. Before that i setup and deleted MAMP and XAMPP. I maniacally deleted all the files of the former two. Since then Apache is not running on Mamp default port 8888 and - MySql is just not running whatsoever.
  • One line says "check if mysqld process isnt already running" i checked that and it is not ! -Here is the error log.
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
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.
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.
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.
130305 19:49:08  InnoDB: Unable to open the first data file
InnoDB: Error in opening ./ibdata1
130305 19:49:08  InnoDB: Operating system error number 35 in a file operation.
InnoDB: Error number 35 means 'Resource temporarily unavailable'.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/operating-system-error-codes.html
130305 19:49:08 InnoDB: Could not open or create data files.
130305 19:49:08 InnoDB: If you tried to add new data files, and it failed here,
130305 19:49:08 InnoDB: you should now edit innodb_data_file_path in my.cnf back
130305 19:49:08 InnoDB: to what it was, and remove the new ibdata files InnoDB created
130305 19:49:08 InnoDB: in this failed attempt. InnoDB only wrote those files full of
130305 19:49:08 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
130305 19:49:08 InnoDB: remove old data files which contain your precious data!
130305 19:49:08 [ERROR] Plugin 'InnoDB' init function returned error.
130305 19:49:08 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
130305 19:49:08 [ERROR] Unknown/unsupported storage engine: InnoDB
130305 19:49:08 [ERROR] Aborting

130305 19:49:08 [Note] /Applications/MAMP/Library/bin/mysqld: Shutdown complete

130305 19:49:08 mysqld_safe mysqld from pid file /Applications/MAMP/tmp/mysql/mysql.pid ended
like image 835
Asis Avatar asked Mar 05 '13 14:03

Asis


3 Answers

Just search for "Activity Monitor" application on MAC and search for any task called mysql and end it. Then restart MAMP it will work. Hope it helps someone.

like image 120
user3431595 Avatar answered Oct 07 '22 00:10

user3431595


End any mysql or mysqld task (or other) in your Activity Monitor application.

like image 43
cdegourcy Avatar answered Oct 06 '22 23:10

cdegourcy


If you cannot kill them with Activity Monitor, in Terminal do
$ ps aux | grep mysqld
The 2nd column is the process id, and you can stop it with (if it is 1234)
$ kill 1234

like image 43
kris Avatar answered Oct 07 '22 01:10

kris