XAMPP mysql fails to start

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

XAMPP mysql fails to start

Postby random1 » 18. February 2009 02:45

My XAMPP installation has been working fine for some time now.

Today I get this message when mysql tries to start.

Code: Select all
Diese Eingabeforderung nicht waehrend des Running beenden
Please dont close Window while MySQL is running
MySQL is trying to start
Please wait  ...
MySQL is starting with mysql\bin\my.cnf (console)
090218 12:43:03 [Warning] Changed limits: max_open_files: 2048  max_connections:
 500  table_cache: 769
mysql\bin\mysqld: Table 'mysql.plugin' doesn't exist
090218 12:43:03 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgr
ade to create it.
090218 12:43:04  InnoDB: Started; log sequence number 0 6423732
090218 12:43:04 [ERROR] Fatal error: Can't open and lock privilege tables: Table
 'mysql.host' doesn't exist

MySQL konnte nicht gestartet werden
MySQL could not be started
Press any key to continue . . .


Any suggestions on what this is? I tried running 'mysql_upgrade.exe' but this does not fix it.
random1
 
Posts: 27
Joined: 17. December 2007 07:31

Re: XAMPP mysql fails to start

Postby Wiedmann » 18. February 2009 02:52

1st question:
You have updated XAMPP (or MySQL) without the upgrade package?
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Re: XAMPP mysql fails to start

Postby random1 » 18. February 2009 03:27

I've used the basic XAMPP installation.
random1
 
Posts: 27
Joined: 17. December 2007 07:31

Re: XAMPP mysql fails to start

Postby Wiedmann » 18. February 2009 03:55

090218 12:43:04 [ERROR] Fatal error: Can't open and lock privilege tables: Table
'mysql.host' doesn't exist

Well, someone have deleted this table... Best is to restore this from your last backup.

090218 12:43:03 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgr
ade to create it.

This can only happen, if you made an upgrade... (really sure, that you don't use files from an older XAMPP/MySQL installation?
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Re: XAMPP mysql fails to start

Postby random1 » 18. February 2009 11:22

Yeah I am sure that it was a clean install.

I've given up and uninstalled and reinstalled it for the beginning again.

Working again.
random1
 
Posts: 27
Joined: 17. December 2007 07:31


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 54 guests