Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Mysql server on MAMP won't start

Tags:

My Mysql server on MAMP won't start. This is the error:

161224 00:15:00 mysqld_safe Logging to '/Applications/MAMP/logs/mysql_error_log.err'. 161224 00:15:00 mysqld_safe Starting mysqld daemon with databases from /Applications/MAMP/db/mysql56 161224 00:15:01 mysqld_safe mysqld from pid file /Applications/MAMP/tmp/mysql/mysql.pid ended

I already tried the following commands:

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

But the server is still not working.

Help ?

like image 377
Inas Avatar asked Dec 24 '16 00:12

Inas


People also ask

Why is my MySQL not working?

normally means that there is no MySQL server running on the system or that you are using an incorrect Unix socket file name or TCP/IP port number when trying to connect to the server. You should also check that the TCP/IP port you are using has not been blocked by a firewall or port blocking service.


1 Answers

Remove the files ib_logfileN (N being the number) from the MAMP/db/mysql56 folder.

Then restart MAMP.

Should Work!!

Edit: If the above step doesn't work completely, please remove the ibdata<n> file as well, based on the comments.

like image 115
A R Avatar answered Oct 20 '22 13:10

A R