MySQL wont start after restart.
Posted: 08. March 2012 17:32
There was a topic below that had similar symptoms that was resolved, but it was marked as solved so I figured I'd start a new topic. I start MySQL for the first time, change the root password, and restart the service. After this restart, MySQL does not stay on anymore.
My log file contains:
Judging from the previous topic, I assume that I need to remove the '--skip-locking' option from mysqld.exe. However, I'm not sure how to do that. Can anyone help me with the process, google is not yielding any results.
My log file contains:
- Code: Select all
120308 9:16:56 [Note] Plugin 'FEDERATED' is disabled.
120308 9:16:56 InnoDB: The InnoDB memory heap is disabled
120308 9:16:56 InnoDB: Mutexes and rw_locks use Windows interlocked functions
120308 9:16:56 InnoDB: Compressed tables use zlib 1.2.3
120308 9:16:56 InnoDB: Initializing buffer pool, size = 16.0M
120308 9:16:56 InnoDB: Completed initialization of buffer pool
120308 9:16:56 InnoDB: highest supported file format is Barracuda.
120308 9:16:57 InnoDB: Waiting for the background threads to start
120308 9:16:58 InnoDB: 1.1.8 started; log sequence number 1595675
120308 9:16:58 [ERROR] C:\xampp\mysql\bin\mysqld.exe: unknown option '--skip-locking'
120308 9:16:58 [ERROR] Aborting
Judging from the previous topic, I assume that I need to remove the '--skip-locking' option from mysqld.exe. However, I'm not sure how to do that. Can anyone help me with the process, google is not yielding any results.