Geek asks and answers

MySQL service does not start after a new wampserver installation

I just installed wampserver on my machine and I can not start it, the icon remains orange. I am using Windows7 Home Premium (64-bit) and I installed wampserver 2.2E (64-bit). I had no problems installing. I checked port 80 and used Apache. So it looks like the apache service is running, but the MySQL service is not. I tried disabling the firewall, I checked if another MySQL service was working, and I tried to start wampmysqld manually in Services. When I tried to start wampmysqld in Services, an error occurred saying

Windows could not start the wampmysqld service on the local computer.
Error 1067: The process terminated unexpectedly.

And when I look at the MySQL log, it says:

140216 21:52:04 [Note] The 'FEDERATED' plugin is disabled.
140216 21:52:04 [Note] The 'InnoDB' plugin is disabled.
140216 21:52:04 [ERROR] wampmysqld: unknown parameter '-skip-locking'
140216 21:52:04 [ERROR] Cancel

140216 21:52:04 [Note] wampmysqld: Shutdown completeBlockquote

+3
source share
2 answers
  • Stop the MySQL service
  • Open the data folder
  • Remove both ib_logfile0andib_logfile1
  • Restart service
+10
source

Edit the file my.ini. Use the wampmanager menu to open the editor on my.ini

left click wampmanager -> MySQL -> my.ini

Change parameter

skip-locking

To

skip-external-locking

Its just an old parameter that they forgot to change when releasing this version of WAMP.

0
source

More articles:


All Articles