MySQL mysqld 工作但 wampmysqld 没有启动
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/17770846/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
mysqld working but wampmysqld not starting up
提问by user961627
Following up from here: Wampserver icon not going green fully, mysql services not starting up?
从这里开始：Wampserver 图标没有完全变绿，mysql 服务没有启动？
I can see that mysqldis working now. But wampmysqldis still not working as a service!
我可以看到mysqld现在正在工作。但wampmysqld仍然不能作为服务工作！
d:\wamp\bin\mysql\mysql5.5.8\bin>mysqld.exe --console
130721 12:10:45 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions
InnoDB: Compressed tables use zlib 1.2.3
130721 12:10:45 InnoDB: Initializing buffer pool, size = 128.0M
130721 12:10:45 InnoDB: Completed initialization of buffer pool
130721 12:10:45 InnoDB: highest supported file format is Barracuda.
130721 12:10:45 InnoDB: 1.1.4 started; log sequence number 1595675
130721 12:10:45 [Note] Event Scheduler: Loaded 0 events
130721 12:10:45 [Note] mysqld.exe: ready for connections.
Version: '5.5.8' socket: '' port: 3306 MySQL Community Server (GPL)
I've deleted all files in the mysql /data/folder and when I ran mysqld, a new ibdata1 file was created. So handling InnoDB files seems fine. But wampmysqld still gives Error 1067.
我已经删除了 mysql/data/文件夹中的所有文件，当我运行时mysqld，创建了一个新的 ibdata1 文件。所以处理 InnoDB 文件似乎没问题。但是 wampmysqld 仍然给出Error 1067.
These are the last lines on the mysql error log generated by wampserver:
这些是 wampserver 生成的 mysql 错误日志的最后几行：
130720 10:28:45 [Note] Event Scheduler: Purging the queue. 0 events
130720 10:28:46 InnoDB: Starting shutdown...
130720 10:28:52 InnoDB: Shutdown completed; log sequence number 29711976
130720 10:28:52 [Note] wampmysqld: Shutdown complete
This means it closed down yesterday morning around half past ten, and it's just not starting up after that!
这意味着它昨天早上十点半左右关闭了，之后就没有启动了！
回答by Misha Bolgarskiy
Actually it shouldn't work. Apparently you have hard-copied some database files into "data" folder. Just let you know, the mysql doesn't like such things and will never ever start. Just imagine for security reasons that somebody added files to your server. Probably you have added those files while the server was already started and no issues were expected.
其实应该行不通。显然，您已将一些数据库文件硬复制到“数据”文件夹中。只是让你知道，mysql 不喜欢这样的东西，永远不会启动。想象一下，出于安全原因，有人向您的服务器添加了文件。可能您已经在服务器启动时添加了这些文件，并且预计不会出现任何问题。
Two things you could do:
你可以做两件事：
- Remove the index file mysql-bin.index on Linux( i do not know the corresponding file for Windows).
- You should simply remove the added files from 'data' folder and it will then turn to green.
- 删除Linux上的索引文件mysql-bin.index（我不知道Windows对应的文件）。
- 您应该简单地从“数据”文件夹中删除添加的文件，然后它会变成绿色。
Rule: Try to add databases by csv import options, but never add them manually as folders.
规则：尝试通过 csv 导入选项添加数据库，但切勿将它们手动添加为文件夹。
回答by Shital
I had same problem, and solution was:
我有同样的问题，解决方案是：
go to services,(type command services.msc in run) find mysql service which is installed outside of wamp right click on it and stop. then again in services panel go to wampmysqld64-> right click-> start
转到服务，（在运行中键入命令 services.msc）找到安装在 wamp 外部的 mysql 服务，右键单击它并停止。然后再次在服务面板中转到 wampmysqld64-> 右键单击-> 启动
if you need only wamp's mysql version then you can turn other mysql service off.
如果您只需要 wamp 的 mysql 版本，那么您可以关闭其他 mysql 服务。
it fixed my problem. Hope this helps!
它解决了我的问题。希望这可以帮助！
回答by user961627
This is what worked for me: http://jinengbali.wordpress.com/2010/04/20/mysql-server-stop-working-in-wampserver-error-wampmysqld-shutdown-complete/
这对我有用：http: //jinengbali.wordpress.com/2010/04/20/mysql-server-stop-working-in-wampserver-error-wampmysqld-shutdown-complete/
I installed an "addon" and then from the wampserver icon selected > MySQL > Version and selected one of the newly installed version. The icon finally went green!
我安装了一个“插件”，然后从 wampserver 图标中选择 > MySQL > 版本并选择了一个新安装的版本。图标终于变绿了！
回答by user2894800
reinstall the entire wampserver again in your computer the wampmysqld file will be allocated back by system .as simple as that.
在您的计算机中再次重新安装整个 wampserver wampmysqld 文件将由系统分配回来。就这么简单。
回答by Ditrix 36
I got a similar problem go to mysql and open up the log file should find the cause of the error .
我遇到了类似的问题，转到mysql并打开日志文件应该可以找到错误原因。
1.In my case the log file was absent so I created a new one.
1.就我而言，日志文件不存在，所以我创建了一个新文件。
2.In another case you could have a read error on your log file so could result to an error in this case just locate and delete the problematic file my path for the file "C:\wamp\logs" once it is done try openning the sql log from wamp panel.
2.在另一种情况下，您的日志文件可能会出现读取错误，因此在这种情况下可能会导致错误，只需找到并删除有问题的文件我的文件“C:\wamp\logs”路径完成后尝试打开来自 wamp 面板的 sql 日志。
3.If you tried all of the above methods and had no result try to look in the log file the cause of your possible error and google it.
3.如果您尝试了上述所有方法但都没有结果，请尝试在日志文件中查看可能出现错误的原因并使用谷歌搜索。
回答by Priyanka Arora
I got the same error. How I resolved it was that the port no. assigned to wampmysql was 3306 which was used by another service, so right clicking on wamp icon->tools->use a port other than 3306(under port used by mysql)->change port no. say 3310->press enter. And icon turned green and started working. Hope it helps.
我得到了同样的错误。我如何解决它是端口号。分配给wampmysql的是3306，它被另一个服务使用，所以右键单击wamp图标->工具->使用3306以外的端口（在mysql使用的端口下）->更改端口号。说 3310-> 按 Enter。图标变成绿色并开始工作。希望能帮助到你。
