Apache Friends Support Forum

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.

1st question:
You have updated XAMPP (or MySQL) without the upgrade package?

I've used the basic XAMPP installation.

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?

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.