MAMP-Windows上的MySQL Server无法启动 [英] MySQL Server on MAMP-Windows Will Not Start

问题描述

我在Windows 10上使用MAMP 4.1，无法启动MySQL服务器.当我卸载MAMP并重新安装它时，MySQL服务器启动，但是当我停止它时，它不会启动.我还进入了\ mamp \ db \ mysql \并删除了下面隐藏的四个日志文件.然后我关闭服务器，然后再打开，但只有Apache启动，而不是MySQL.

在名为MySQL80的服务中也运行着一个进程.当我尝试启动它时，我收到显示的错误消息.我尝试了许多删除它的方法，包括转到命令提示符并使用"sc mysql80"并转到"regedit". MySQL80没有显示在任何地方，因此我可以删除它.

此外，下面的资源监视器显示Apache在端口80上运行，但在端口3306上没有运行.是的，对于MySQL，我的MAMP首选项设置为端口3306.

运行MySQL时，我有2个"mysqld"监听进程:一个会话在IPv6端口3306上，另一个会话在IPv4端口3306上?

出什么问题了，我该如何解决?

并且，是否有(2)个"mysqld"会话都在端口3306上侦听，其中一个在IPv6上，另一个在IPv4上?

感谢社区.

MAMP控制面板

mysql80服务

列出了端口的资源窗口

MAMP日志文件

解决方案

我遇到了同样的问题.我联系了Mamp的支持人员，他们的回答是:它为我工作.希望这对您也有帮助.停止MAMP中的所有服务器.

以下假定您的MAMP安装目录为C:\MAMP\.

对于MAMP:

• 使用Windows资源管理器转到文件夹C:\MAMP\db\mysql\
• 首先备份所有以mysql-bin.*开头的文件，然后将其删除(包括mysql-bin.index文件.)
• 然后尝试重新启动所有MAMP服务器(等待MySQL打开).
• 此后，再次停止所有MAMP服务器.
• 您现在将尝试在MAMP(或MAMP PRO)中禁用二进制日志bin.
• 在您选择的文本编辑器中打开MySQL配置文件:C:\MAMP\conf\mysql\my.ini
• 查找以下文本:log-bin
• 通过在行首添加#字符来注释此行.

  #log-bin=mysql-bin
  

• 保存并重新启动服务器
• 之后，将mysql-bin.*文件放回原处.

I am using MAMP 4.1 on Windows 10 and cannot get MySQL server to start. When I uninstalled MAMP and re-installed it MySQL server starts up, but when I stop it, it will not start back up. I also went into the \mamp\db\mysql\ and deleted the four log files hilited below. Then I turned the server off, then back on, but only Apache starts up, not MySQL.

There is also a process running in services called MySQL80. When I try to start it I get the error message shown. I have tried many ways to delete it, including going to the command prompt and using "sc mysql80" and going to 'regedit'. MySQL80 does not show up anywhere so that I can delete it.

Also, the Resource Monitor below shows that Apache is running on port 80, but nothing on port 3306. And yes, my MAMP Preferences are set to port 3306 for MySQL.

When MySQL was running, I had 2 processes of 'mysqld' listening: one session on IPv6 Port 3306, and the other session on IPv4 Port 3306?

What's wrong and how do I fix it?

And, is there suppose to be (2) sessions of 'mysqld' both listening on port 3306 where one is on IPv6 and the other is on IPv4?

Thanks Community.

MAMP Control Panel

mysql80 Service

Resource Window with Ports Listed

MAMP Log Files

解决方案

I had the same problem. I contacted mamp support, and their answer was the following; it worked for me. Hope this helps you too. Stop all servers in MAMP.

The below assumes your MAMP installation directory is C:\MAMP\.

For MAMP:

• With Windows Explorer go to folder C:\MAMP\db\mysql\
• First backup all files that begin with mysql-bin.*, then delete them (including mysql-bin.index file.)
• Then try starting all MAMP servers again (wait for MySQL to turn light on).
• After that stop all MAMP servers again.
• You'll now try to disable binary log-bin in MAMP (or MAMP PRO)
• Open up MySQL configuration file in text editor of your choice: C:\MAMP\conf\mysql\my.ini
• Find following text: log-bin
• Comment this line by adding # character at start of line.

  #log-bin=mysql-bin
  

• Save and restart servers
• After that put the mysql-bin.* files back in their place.

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