Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I logged into Xampp today and it wouldn't launch MySQL. It said there was an error and it shut down unexpectedly. Here are the errors from the error log. Hoping someone has seen this before, because I have little experience fixing this stuff.

2013-11-12 18:21:39 8324 [ERROR] Fatal error: Can't open and lock privilege tables: Incorrect key file for table 'user'; try to repair it
2013-11-12 18:27:36 5800 [Note] Plugin 'FEDERATED' is disabled.
2013-11-12 18:27:36 16ac InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2013-11-12 18:27:36 5800 [Note] InnoDB: The InnoDB memory heap is disabled
2013-11-12 18:27:36 5800 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2013-11-12 18:27:36 5800 [Note] InnoDB: Compressed tables use zlib 1.2.3
2013-11-12 18:27:36 5800 [Note] InnoDB: Not using CPU crc32 instructions
2013-11-12 18:27:36 5800 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2013-11-12 18:27:36 5800 [Note] InnoDB: Completed initialization of buffer pool
2013-11-12 18:27:36 5800 [Note] InnoDB: Highest supported file format is Barracuda.
2013-11-12 18:27:36 5800 [Note] InnoDB: The log sequence numbers 0 and 0 in ibdata files do not match the log sequence number 1957328 in the ib_logfiles!
2013-11-12 18:27:36 5800 [Note] InnoDB: Database was not shutdown normally!
2013-11-12 18:27:36 5800 [Note] InnoDB: Starting crash recovery.
2013-11-12 18:27:36 5800 [Note] InnoDB: Reading tablespace information from the .ibd files...
2013-11-12 18:27:36 5800 [Note] InnoDB: Restoring possible half-written data pages 
2013-11-12 18:27:36 5800 [Note] InnoDB: from the doublewrite buffer...
2013-11-12 18:27:37 5800 [Note] InnoDB: 128 rollback segment(s) are active.
2013-11-12 18:27:37 5800 [Note] InnoDB: Waiting for purge to start
2013-11-12 18:27:37 5800 [Note] InnoDB: 5.6.11 started; log sequence number 1957328
2013-11-12 18:27:37 5800 [Note] Server hostname (bind-address): '*'; port: 3306
2013-11-12 18:27:37 5800 [Note] IPv6 is available.
2013-11-12 18:27:37 5800 [Note]   - '::' resolves to '::';
2013-11-12 18:27:37 5800 [Note] Server socket created on IP: '::'.
2013-11-12 18:27:37 5800 [ERROR] Fatal error: Can't open and lock privilege tables: Incorrect key file for table 'user'; try to repair it
share|improve this question

2 Answers 2

A working solution was given by MasterCedie on the following site: http://www.apachefriends.org/f/viewtopic.php?p=218295&sid=aa76af1f088639c3661985b7b1d6d274

share|improve this answer
2  
Link only answers are usually frowned upon here - the link could be gone in the future. You should at least add the gist of the solution. –  a_horse_with_no_name Dec 6 '13 at 22:10

Go to Xampp/mysql/bin/my.ini

open it and add the following line:

innodb_force_recovery = 1

Atleast this was what solved it for me. I'd backup my .cnf file to be on the safe side. After adding the single line you should be able to start your mySQL service again.

P.S. I think anything greater than 0 works, since the log error simply states > 0.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.