問題描述
從這里開始: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 沒有啟動的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！