how to activate MYSQL?

Problems with the Windows version of XAMPP, questions, comments, and anything related.

how to activate MYSQL?

Postby Nico Boots » 11. July 2012 13:29

[EDIT by Altrea: moved from this post in the german only forum]

I have the same problem. Just installed the latest XAMPP version. from the control panel I can start Apache and Filezilla, but not MySql. I followed your suggestion to start xampp-control-3-beta.exe and to see in the error log what is going wrong. These are the last lines in the error report:

120711 14:17:48 [Note] Plugin 'FEDERATED' is disabled.
120711 14:17:48 InnoDB: The InnoDB memory heap is disabled
120711 14:17:48 InnoDB: Mutexes and rw_locks use Windows interlocked functions
120711 14:17:48 InnoDB: Compressed tables use zlib 1.2.3
120711 14:17:48 InnoDB: Initializing buffer pool, size = 16.0M
120711 14:17:48 InnoDB: Completed initialization of buffer pool
120711 14:17:48 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
120711 14:17:48 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
120711 14:17:48 InnoDB: Waiting for the background threads to start
120711 14:17:49 InnoDB: 1.1.8 started; log sequence number 1591515
120711 14:17:49 [ERROR] Fatal error: Can't open and lock privilege tables: Incorrect key file for table 'user'; try to repair it

Apparently it has something to do with the privilages. But I have no idea how to repair that. I am the only user on this recently bought laptop which runs under Windows 7 Home

Can you help me?
Nico Boots
Posts: 1
Joined: 11. July 2012 13:21
Operating System: Windows 7

Re: how to activate MYSQL?

Postby JonB » 11. July 2012 21:09

Is this a 'brand-new' unaltered XAMPP installation AND you have never had MySQL previously installed?

IF so - My guess is you have a corrupt install.

Stop any parts of XAMPP that are running

If you made Apache, MySQL or Filezilla services - remove them as services with the Control Panel. (uncheck the green checkbox) you will have to do it one at a time.

Did you use the installer version?

IF so - use the Windows Control Panel - to un-install the installer, then delete the xampp folder.

If you used a 7z or ZIP DL, just delete the XAMPP folder

Next, DL a fresh XAMPP distribution picking either the 7z or ZIP versions, and check the MDD5 checksums when done.

Expand the Archive and copy it to the install location (preferably the root of a drive)

Start XAMPP with either the Control Panel or xampp_start.exe.

Good Luck
User avatar
AF Moderator
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
Operating System: Windows XP/7 - Fedora 15 1.7.7

Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 59 guests