MAMP上的MySQL服务器无法启动 [英] Mysql server on MAMP won't start

问题描述

我在MAMP上的Mysql服务器无法启动. 这是错误:

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

161224 00:15:00 mysqld_safe登录到'/Applications/MAMP/logs/mysql_error_log.err'. 161224 00:15:00 mysqld_safe使用/Applications/MAMP/db/mysql56中的数据库启动mysqld守护程序 161224 00:15:01 pid文件/Applications/MAMP/tmp/mysql/mysql.pid中的mysqld_safe mysqld已结束

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.

帮助?

推荐答案

从MAMP/db/mysql56文件夹中删除文件ib_logfileN( N 是数字).

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

然后重新启动MAMP.

Then restart MAMP.

应该工作！

如果上述步骤不能完全完成，请根据注释也删除ibdata<n>文件.

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

这篇关于MAMP上的MySQL服务器无法启动的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！