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.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

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

Visit link for more details

I have find solution for this error in xampp

  1. on start MySQL service we have face some problem
  2. Solution for this Error Plugin 'FEDERATED' is disabled. Just open Task Manager and go in Details tab then find mysqld.exe file stop this task.
  3. Let's Re-try start MySQL Service and see it's working.
share|improve this answer

protected by Community Jan 31 at 5:30

Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site.

Would you like to answer one of these unanswered questions instead?

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