blocks|key|336913|text|对我来说起作用的是删除mysql目录中的所有文件(但不是目录)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|336914|编辑#2根据下面的答案，你只需要删除日志文件:+ib_logfile0，ib_logfile1|336915|所以退出MAMP，然后在终端中：|336916|rm+/Applications/MAMP/db/mysql/ib_logfile*+#(or+wherever+your+MAMP+is+installed)|code-block|syntax|javascript|336917|编辑！：一些人提到，你可能想先备份这些文件，以防出现问题，所以可能只需要使用mv：|336918|mv+/Applications/MAMP/db/mysql/*++/tmp/.|336919|如果这不起作用，则返回并杀死所有进程：sudo+killall+-9+mysqld|offset|length|style|CODE|336920|这也在这里复制：mysql+server+won't+start+MAMP|336921|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/23455841/mysql-server-wont-start-mamp/28654878#28654878^0|0|0|0|0|0|0|J|M|0|8|T|0|0^^$0|@$1|2|3|4|5|6|7|14|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|15|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|16|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|17|8|@]|9|@]|A|$I|J]]|$1|K|3|L|5|6|7|18|8|@]|9|@]|A|$]]|$1|M|3|N|5|H|7|19|8|@]|9|@]|A|$I|J]]|$1|O|3|P|5|6|7|1A|8|@$Q|1B|R|1C|S|T]]|9|@]|A|$]]|$1|U|3|V|5|6|7|1D|8|@]|9|@$Q|1E|R|1F|1|1G]]|A|$]]|$1|W|3|-4|5|6|7|1H|8|@]|9|@]|A|$]]]|X|$Y|$5|Z|10|11|A|$12|13]]]]

What worked for me was removing all files (but not directories) in the mysql dir.

Edit #2 As per answers below, you only need to delete the log files: [ib_logfile0, ib_logfile1]

So quit MAMP and then in the terminal:

<pre><code>rm /Applications/MAMP/db/mysql/ib_logfile* #(or wherever your MAMP is installed)
</code></pre>

Edit!: A few people have mentioned that you may want to back up these files first in case anything goes wrong, so maybe just use mv instead:

<pre><code>mv /Applications/MAMP/db/mysql/* /tmp/.
</code></pre>

If this doesn't work go back and kill all processes:
<code>sudo killall -9 mysqld</code>

This is also duplicated here:
<a href="https://stackoverflow.com/questions/23455841/mysql-server-wont-start-mamp/28654878#28654878">mysql server won&#39;t start MAMP</a>

blocks|key|119513|text|好的，所以我尝试了我在so和其他论坛上找到的所有建议，但都没有对我起作用。对我有效的唯一解决方案是安装MAMP+3版本，因为我使用MAMP+for+wordpress+projects版本3工作得很好。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|119514|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Ok, so I tried EVERY suggestion i found here on SO and other forums I nothing worked for me. The only solution, that worked for me was to install MAMP 3 version, since I use MAMP for wordpress projects version 3 works just fine.

blocks|key|336981|text|最简单的解决方案是:退出MAMP并从MAMP/db/mysql目录ib_logfile0、ib_logfile1中删除日志文件，然后重新启动MAMP。如需更多信息，请访问http://juanfra.me/2013/01/mysql-not-starting-mamp-fix/|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|336982|entityMap|0|LINK|mutability|MUTABLE|url|http://juanfra.me/2013/01/mysql-not-starting-mamp-fix/^0|2D|1I|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

The easiest solution: quit MAMP and remove the log files from MAMP/db/mysql directory [ib_logfile0, ib_logfile1] and restart MAMP. 
For more visit <a href="http://juanfra.me/2013/01/mysql-not-starting-mamp-fix/" rel="noreferrer">http://juanfra.me/2013/01/mysql-not-starting-mamp-fix/</a>

blocks|key|119551|text|rm+/Applications/MAMP/db/mysql56/*|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|119552|运行正常，但是在phpmyadmin中显示“没有找到数据库”，尽管有数据库，因此我的drupal因此给了我错误。|unstyled|119553|我所需要做的就是从/Applications/MAMP/db/mysql56/中删除两个文件ib_logfile0和ib_logfile1，这对我来说很有效。|offset|length|style|CODE|119554|entityMap^0|0|0|9|U|1A|B|1M|B|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|P|8|@]|9|@]|A|$]]|$1|G|3|H|5|F|7|Q|8|@$I|R|J|S|K|L]|$I|T|J|U|K|L]|$I|V|J|W|K|L]]|9|@]|A|$]]|$1|M|3|-4|5|F|7|X|8|@]|9|@]|A|$]]]|N|$]]

<pre><code>rm /Applications/MAMP/db/mysql56/*
</code></pre>

Works fine, but then it shows "No database found" in phpmyadmin although there are databases, so my drupal gave me errors because of this.

All I need to do is simply remove two files <code>ib_logfile0</code> and <code>ib_logfile1</code> from <code>/Applications/MAMP/db/mysql56/</code> and that did the trick for me.

blocks|key|119577|text|对我起作用的是：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|119578|我有一个名为"mysqld“的进程在运行，即使在MAMP退出时也是如此。我强制退出了进程，重新启动了MAMP，它再次工作。|119579|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

What worked for me was:

I had a process called "mysqld" running even when MAMP had been quit. I force quit the process, restarted MAMP and it worked again.

blocks|key|337050|text|从MAMP/db/mysql56文件夹中删除文件ib_logfileN+(N是编号)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|337051|然后重新启动MAMP。|337052|应该行得通！|337053|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

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

Then restart MAMP.

Should Work!

blocks|key|119659|text|我已经尝试了上面所有的MAMP+4.2版本的解决方案，但它们都没有在El+Capitan+OS中对我起作用，所以唯一起作用的是用Clean+My+Mac卸载MAMP，然后安装旧的3.5.2版本，这个版本立即就起作用了。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|119660|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I've tried all the solutions above with version 4.2 of MAMP and none of them worked to me in El Capitan OS, so the only thing that worked was uninstalled MAMP with Clean My Mac and then install the older 3.5.2 version, that one worked right away.

blocks|key|119684|text|如果是MAMP+PRO，您需要在此处删除ib_logfiles：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|119685|rm+-rf+/Library/Application\+Support/appsolute/MAMP\+PRO/db/mysql56/ib_logfile*|code-block|syntax|javascript|119686|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

In case of MAMP PRO you need to remove ib_logfiles here:

<pre><code>rm -rf /Library/Application\ Support/appsolute/MAMP\ PRO/db/mysql56/ib_logfile*
</code></pre>

blocks|key|119705|text|我不得不做一系列的事情。首先，我必须更改mysql目录的权限。应用程序/MAMP/db/mysql56/mysql+see+Stackoverflow+here|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|119706|如果不起作用，请将my.cnf文件添加到applications/MAMP/conf文件夹中，其中包含以下内容|119707|[mysqld]
innodb_force_recovery+=+1|code-block|syntax|javascript|119708|见Adel+'Sean‘Helal。回答|119709|这就是最终为我工作的方法。|119710|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/6443428/cant-find-file-ci-users-frm-errno-13^0|1M|M|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@$A|X|B|Y|1|Z]]|C|$]]|$1|D|3|E|5|6|7|10|8|@]|9|@]|C|$]]|$1|F|3|G|5|H|7|11|8|@]|9|@]|C|$I|J]]|$1|K|3|L|5|6|7|12|8|@]|9|@]|C|$]]|$1|M|3|N|5|6|7|13|8|@]|9|@]|C|$]]|$1|O|3|-4|5|6|7|14|8|@]|9|@]|C|$]]]|P|$Q|$5|R|S|T|C|$U|V]]]]

I had to do a combination of things. First I had to change the permissions on my mysql directory. applications/MAMP/db/mysql56/mysql <a href="https://stackoverflow.com/questions/6443428/cant-find-file-ci-users-frm-errno-13">see Stackoverflow here</a> 

If that doesn't work add in a my.cnf file to applications/MAMP/conf folder with the following

<pre><code>[mysqld]
innodb_force_recovery = 1
</code></pre>

see Adel 'Sean' Helal . answer

This is what ended up working for me.

blocks|key|337143|text|只需在终端中键入以下命令：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|337144|rm+/Applications/MAMP/db/mysql56/ib_logfile*+|code-block|syntax|javascript|337145|然后重新启动MAMP。|337146|它的效果非常好。|337147|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|P|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

Just type below command in terminal:

<pre><code>rm /Applications/MAMP/db/mysql56/ib_logfile* 
</code></pre>

and then restart the MAMP.

It works back perfectly.

blocks|key|119762|text|我在不同的答案中看到，我们必须在Applications/MAMP/db/mysql56/中删除ib_logfile0和ib_logfile1|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|119763|如果您使用的是MAMP+PRO4，这些文件在/Library/Application+Support/appsolute/MAMP+PRO/db/mysql56/中|119764|删除这些文件对我来说是有效的(+serveur在系统崩溃后不会启动)。|119765|entityMap^0|G|T|1C|B|1O|B|0|M|1N|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@$9|M|A|N|B|C]|$9|O|A|P|B|C]|$9|Q|A|R|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|S|8|@$9|T|A|U|B|C]]|D|@]|E|$]]|$1|H|3|I|5|6|7|V|8|@]|D|@]|E|$]]|$1|J|3|-4|5|6|7|W|8|@]|D|@]|E|$]]]|K|$]]

I’ve seen on different answers that we have to remove <code>ib_logfile0</code> and <code>ib_logfile1</code> in <code>Applications/MAMP/db/mysql56/</code>

If you use MAMP PRO 4, these files are in <code>/Library/Application Support/appsolute/MAMP PRO/db/mysql56/</code>

Removing theses fils works for me (the serveur doesn’t start after a system crash).

blocks|key|119795|text|对我来说，是my.cnf中的innodb_additional_mem_pool_size行导致了这个问题|type|unstyled|depth|inlineStyleRanges|entityRanges|data|119796|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

For me the line innodb_additional_mem_pool_size in my.cnf was causing it

blocks|key|337301|text|找到真正原因的最好方法是在MAMP+>+logs+>+mysql_error_log.err中检查MAMP错误日志|type|unstyled|depth|inlineStyleRanges|entityRanges|data|337302|我发现错误“您是否已经有另一台mysql服务器在端口:+3306上运行?”--这实际上是我的MAMP+MYSQL无法启动的原因。|337303|端口3306已经“忙”了，所以我把它改成了8306，这解决了我的问题。|337304|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

Best way to find the real cause is to check the MAMP error log in MAMP > logs > mysql_error_log.err

I found the ERROR "Do you already have another mysql server running on port: 3306 ?" - which was actually the cause for my MAMP MYSQL not starting.

Port 3306 was already "busy", so I have changed it to 8306 and that solved my issue.

blocks|key|337366|text|我只是在终端中运行了这个命令：sudo+killall+-9+mysqld，然后我强制退出了MAMP。重新打开Mamp，一切工作正常。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|337367|有时，只需关闭并重新启动您的计算机就可以达到目的。|337368|entityMap^0|F|M|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|M|8|@]|D|@]|E|$]]|$1|H|3|-4|5|6|7|N|8|@]|D|@]|E|$]]]|I|$]]

I just ran this in terminal: <code>sudo killall -9 mysqld</code> and then I force quit MAMP.
Reopen Mamp and everything works perfectly.

Sometimes, just turning off and restarting your computer does the trick.

blocks|key|337391|text|上面的答案对我都不起作用(我在MacOS上升级到了最新的5.7+)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|337392|在深入研究错误日志(/Applications/MAMP/logs/mysql_error_log.err)一段时间后，我发现有一个导致终止的错误[ERROR]+unknown+variable+'thread_concurrency=8']。|offset|length|style|CODE|337393|基于一篇关于upgrades的文章，我从my.cnf中删除了该指令，并重新启动了MAMP。之后所有工作正常(提示升级数据库等)|337394|entityMap|0|LINK|mutability|MUTABLE|url|https://ahelpme.com/software/mysql/upgrade-mysql-5-6-to-5-7-what-problems-to-expect-with-old-my-cnf-configuration-file/^0|0|A|17|21|1C|0|K|6|6|8|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@$D|T|E|U|F|G]|$D|V|E|W|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|X|8|@$D|Y|E|Z|F|G]]|9|@$D|10|E|11|1|12]]|A|$]]|$1|J|3|-4|5|6|7|13|8|@]|9|@]|A|$]]]|K|$L|$5|M|N|O|A|$P|Q]]]]

None of the above answers worked for me (I did MAMP upgrade to latest 5.7 on MacOS).
After a while of digging through the error log (<code>/Applications/MAMP/logs/mysql_error_log.err</code>) i found out that there's an error <code>[ERROR] unknown variable 'thread_concurrency=8']</code> that causes termination.
Based on a post about <a href="https://ahelpme.com/software/mysql/upgrade-mysql-5-6-to-5-7-what-problems-to-expect-with-old-my-cnf-configuration-file/" rel="nofollow noreferrer">upgrades</a> i removed the directive from <code>my.cnf</code> and restarted MAMP. All worked well afterwards (was prompted to upgrade DBs, etc.)

blocks|key|337428|text|我的mac系统和我的mamp不能正常启动。只要重新启动我的系统，然后再次启动mamp，它就可以正常工作了|type|unstyled|depth|inlineStyleRanges|entityRanges|data|337429|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I have mac system and my mamp does not start properly.
Just restart my system and then start mamp again then it's working properly

My MAMP mysql server won't start. All of the suggestions I've seen on the web say to check for other mysqld processes running and kill them if they exist, and that it should fix the problem, but it has not for me. 

Here's the error log:

<pre><code>130415 13:42:12 mysqld_safe Starting mysqld daemon with databases from /Library/Application Support/appsolute/MAMP PRO/db/mysql
130415 13:42:12 [Warning] Setting lower_case_table_names=2 because file system for /Library/Application Support/appsolute/MAMP PRO/db/mysql/ is case insensitive
130415 13:42:12 [Note] Plugin 'FEDERATED' is disabled.
130415 13:42:12 InnoDB: The InnoDB memory heap is disabled
130415 13:42:12 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130415 13:42:12 InnoDB: Compressed tables use zlib 1.2.3
130415 13:42:12 InnoDB: Initializing buffer pool, size = 128.0M
130415 13:42:12 InnoDB: Completed initialization of buffer pool
130415 13:42:12 InnoDB: highest supported file format is Barracuda.
130415 13:42:13 InnoDB: Waiting for the background threads to start
130415 13:42:14 InnoDB: 1.1.8 started; log sequence number 1707549
130415 13:42:14 [Note] Event Scheduler: Loaded 0 events
130415 13:42:14 [Note] /Applications/MAMP/Library/bin/mysqld: ready for connections.
Version: '5.5.25' socket: '/Applications/MAMP/tmp/mysql/mysql.sock' port: 0 Source distribution
</code></pre>

It looks like the connection is open to me, but MAMP stil errors out with this message: "MySQL wasn't able to start. Please check log for more information."

Any suggestions?

MAMP mysql server won't start. No mysql processes are running

日志文件

数据库

服务器

MySQL

MacOS

我的MAMP mysql服务器无法启动。我在网上看到的所有建议都是检查正在运行的其他mysqld进程，如果它们存在，就杀死它们，它应该解决这个问题，但对我来说却没有。以下是错误日志：130415 13:42:12 mysqld_safe Starting mysqld daemon with databases fro...

问MAMP mysql服务器无法启动。没有正在运行的mysql进程
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问MAMP mysql服务器无法启动。没有正在运行的mysql进程EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问MAMP mysql服务器无法启动。没有正在运行的mysql进程
EN