mysqld 工作但 wampmysqld 没有启动
从这里开始: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!
相关文章