mysqld 工作但 wampmysqld 没有启动 [英] mysqld working but wampmysqld not starting up

问题描述

从这里开始:Wampserver 图标没有完全变绿，mysql 服务没有启动?

我可以看到 mysqld 现在正在工作.但是 wampmysqld 仍然不能作为服务运行！

I can see that mysqld is working now. But wampmysqld is still not working as a service!

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)

我已经删除了 mysql /data/ 文件夹中的所有文件，当我运行 mysqld 时，创建了一个新的 ibdata1 文件.所以处理 InnoDB 文件似乎没问题.但是 wampmysqld 仍然给出 Error 1067.

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.

这些是 wampserver 生成的 mysql 错误日志的最后几行:

These are the last lines on the mysql error log generated by wampserver:

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!

推荐答案

我遇到了同样的问题，解决方案是:

I had same problem, and solution was:

转到服务，(在运行中键入命令 services.msc)找到安装在 wamp 之外的 mysql 服务，右键单击它并停止.然后再次在服务面板中转到 wampmysqld64-> 右键单击​​-> 启动

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

如果你只需要wamp的mysql版本那么你可以关闭其他mysql服务.

if you need only wamp's mysql version then you can turn other mysql service off.

它解决了我的问题.希望这会有所帮助！

it fixed my problem. Hope this helps!

这篇关于mysqld 工作但 wampmysqld 没有启动的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！