WampServer

Hello,

I am having grief in trying to get WAMP to start since I updated to 2.2.

Apache starts fine.
MYSQL does not.

I've made sure that the previous MYSQL service where removed.
I've tried looking for instances of my.ini and my.cnf that are out of the directory.
I've tried installing it in a different location.

Still nothing seems to want to make it work. It always comes back with the same error.
At wits end - and really don't know how to rectify this problem. Can someone help me?

Here's the dump from my.log.

120922 9:32:00 InnoDB: Waiting for the background threads to start
120922 9:32:01 InnoDB: 1.1.8 started; log sequence number 1595675
120922 9:32:01 [ERROR] wampmysqld: unknown option '--skip-locking'
120922 9:32:01 [ERROR] Aborting

120922 9:32:01 InnoDB: Starting shutdown...
120922 9:32:02 InnoDB: Shutdown completed; log sequence number 1595675
120922 9:32:02 [Note] wampmysqld: Shutdown complete

120922 9:32:59 [Note] Plugin 'FEDERATED' is disabled.
120922 9:32:59 InnoDB: The InnoDB memory heap is disabled
120922 9:32:59 InnoDB: Mutexes and rw_locks use Windows interlocked functions
120922 9:32:59 InnoDB: Compressed tables use zlib 1.2.3
120922 9:32:59 InnoDB: Initializing buffer pool, size = 128.0M
120922 9:32:59 InnoDB: Completed initialization of buffer pool
120922 9:32:59 InnoDB: highest supported file format is Barracuda.
120922 9:32:59 InnoDB: Waiting for the background threads to start
120922 9:33:00 InnoDB: 1.1.8 started; log sequence number 1595675
120922 9:33:00 [ERROR] wampmysqld: unknown option '--skip-locking'
120922 9:33:00 [ERROR] Aborting

120922 9:33:00 InnoDB: Starting shutdown...
120922 9:33:01 InnoDB: Shutdown completed; log sequence number 1595675
120922 9:33:01 [Note] wampmysqld: Shutdown complete

Are they new errors? If so , there is definitely a my.ini of my.cnf somewhere

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

If you have a look in the my.ini ..... wamp->mysql->my.ini there is no skip-locking parameter, UNLESS YOU ADDED IT.

So therefore you must have a my.ini or a my.cnf somewhere else on your system.

And possibly another installation of mysql. Both should be removed.

Steven - thanks for your zippy response. I haven't really touched any of the configs at all. I conducted an extensive search on my computer for those files. How to I launch this service manually - maybe I can force loading the my.ini that is shipped with the install to try and prove out that what your suggesting is the case.

I am going to do two other tests.

Try installing under a clean account on the same computer.
Try installing on my laptop.

I'll let you know what I find. Any other clues to help me debug this would be well appreciated. I love using WAMP and appreciate this great service.

OK - update. I removed WAMP from the same computer Windows 7, 1 year old i7 core machine, 12GB ram. Made sure all services where gone.

Logged in as ADMIN (different account).

Installed WAMP 2.2e-php5.4.3-httpd-2.4.2-mysql5.5.24

Same problem. Failing on this wampmysqld: unknown option '--skip-locking'


-------
Tried the same install on my laptop - Windows 7, new i7 Core machine.
Worked just fine.

--------

So - the problem lies on my desktop computer somewhere. I will search again for these files you suggested. Could they be anywhere else?


Alan

Can u get team viewer?

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

skip-locking was an option that was removed from mysql in V5. So its rather odd and I guess means there is a my.ini or my.cnf somewhere that is nothing to do with anything you have done.

Trouble is when some computer sellers build these system who knows where they get there base systems from.

If its any help this is the search order that mysql uses to find either my.ini or my.cnf

WINDIR\my.ini, WINDIR\my.cnf
C:\my.ini, C:\my.cnf
INSTALLDIR\my.ini, INSTALLDIR\my.cnf
defaults-extra-file. The file specified with --defaults-extra-file=path, if any

OK - I Fixed it. You were totally right. Inside my \windows\ folder was a my.ini. I relied too much on windows search to find those instances, but i guess windows search sucks if you don't tell to search everywhere.

Steven - much thanks for your help.

Alan

The search is good but you need to press ADVANCED and select , "search non indexed and system folders"

The little search box sucks , advanced search is decent


Glad You got it working

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]