問題描述
從這里開始:Wampserver 圖標(biāo)沒有完全變綠,mysql 服務(wù)沒有啟動(dòng)?
我可以看到 mysqld
現(xiàn)在正在工作.但是 wampmysqld
仍然不能作為服務(wù)運(yùn)行!
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)
我已經(jīng)刪除了 mysql /data/
文件夾中的所有文件,當(dāng)我運(yùn)行 mysqld
時(shí),創(chuàng)建了一個(gè)新的 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 錯(cuò)誤日志的最后幾行:
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
這意味著它昨天早上十點(diǎn)半左右關(guān)閉了,之后就沒有啟動(dòng)了!
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:
轉(zhuǎn)到服務(wù),(在運(yùn)行中鍵入命令 services.msc)找到安裝在 wamp 之外的 mysql 服務(wù),右鍵單擊它并停止.然后再次在服務(wù)面板中轉(zhuǎn)到 wampmysqld64-> 右鍵單擊??-> 啟動(dòng)
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版本那么你可以關(guān)閉其他mysql服務(wù).
if you need only wamp's mysql version then you can turn other mysql service off.
它解決了我的問題.希望這會(huì)有所幫助!
it fixed my problem. Hope this helps!
這篇關(guān)于mysqld 工作但 wampmysqld 沒有啟動(dòng)的文章就介紹到這了,希望我們推薦的答案對大家有所幫助,也希望大家多多支持html5模板網(wǎng)!