mySQL suddenly stopped. Privilege tables error.

[gemdesign]

Hi everybody
I need some advice here. I've got a Fedora server running Xampp 1.4.9a which has been fine for a long time. Suddenly a couple of days ago mysql stopped and I can't get it to start again.

When I check the localhost.localdomain.err file I find this error:

Code: Select all

060815 06:18:09  mysqld started
060815  6:18:11 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist
060815  6:18:11 Aborting

060815  6:18:11 /opt/lampp/sbin/mysqld: Shutdown Complete

060815 06:18:11  mysqld ended


Any suggestions? Do you know what might have happend?
It would be great if you could answer in english, but I also understand some german - since I'm norwegian myself

Thanks.

[Wiedmann]

Someone have killed this table, db...

Are there some files left in the driectory for the database 'mysql'?

[gemdesign]

Thank you for replying quickly.

In /opt/lampp/var/mysql/mysql there are no files, but in /opt/lampp/var/mysql i see all my databases as directories containing files:

ie database "contacts" contain:
contacts.frm contacts.MYD contacts.MYI

There are also a bunch of files called localhost-bin.001 - 087 in there.

I also noticed that all these files are owned by nobody/nobody. Shouldn't they be owned by root or mysql?

[Wiedmann]

In /opt/lampp/var/mysql/mysql there are no files,

Then someone have killed this db

Simply restore this database (directory) from your backup.

And of course:
Change your passwords and have a look on your scripts (e.g. sql injections...)

[gemdesign]

Is this a database that mysql needs to run? Cause it is not a database that I have used on my website at all. I do not think I have a backup of it, just my website databases.

Is there some other way I can make mysql run?

Since I got all the files in the data directory I should be able to restore all my database tables that I need if I can get mysql running again.

[Wiedmann]

Is this a database that mysql needs to run?

Yes.

Is there some other way I can make mysql run?

Restore this special database

I do not think I have a backup of it, just my website databases.

The initial version you can get from the XAMPP archive.

[gemdesign]

Allright, thank you very much for your fast replys I'll give it a try an let you all know how it goes!

[gemdesign]

Hi again. I got it fixed. Downloaded the package from the archive and re-uploaded the files. Changed all passwords and ran "lampp security" to set new passwords for the mysql users.

Now I'll take a look at my scripts and upgrade some opensource systems, but I probably should upgrade xampp as well.

Would it be a difficult task to do that from 1.4.9a?