Visit Jeremy's Blog.
Go Back > Forums > Linux Forums > Linux - Newbie
User Name
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!


  Search this Thread
Old 08-13-2013, 05:04 PM   #1
LQ Newbie
Registered: Nov 2012
Location: Malawi
Posts: 25

Rep: Reputation: Disabled
unable to start mysql services

I lost power while accessing mysql services,after rebooting I can not restart the service.The error in the mysqld.log file; FATAL error;cant open and lock privilege tables:incorrect file format 'host'.
thanks for the help in advance
Old 08-13-2013, 05:54 PM   #2
Ser Olmy
Senior Member
Registered: Jan 2012
Distribution: Slackware
Posts: 2,669

Rep: Reputation: Disabled
This is not really a "newbie" question, and the thread would probably be more at home in the "Linux - Server" forum.

If you type the exact error message into Google, you'll find that the fix involves backing up your database files, clearing out the entire database directory and running mysql_install_db to regenerate the missing/corrupt system database. You can then copy your database files back.

You'll have to add back all user privileges manually, but they're gone now anyway.
Old 08-13-2013, 05:57 PM   #3
Senior Member
Registered: Mar 2012
Distribution: Red Hat
Posts: 1,604

Rep: Reputation: 415Reputation: 415Reputation: 415Reputation: 415Reputation: 415
Did you try a quick google search?

There are a few ways to fix this. You can do the mysql_install_db to reinstall the hosts or you can start mysqld with skip grant and try a repair on the table, which will more than likely delete all the users in it and you will just need to add them back in.,164324


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Changed my user password and now VMware tells me unable to start services... Swaggoner Linux - Newbie 2 08-02-2011 08:41 AM
Couldn't start mysql services on Debian Lenny Tueleep86 Linux - Newbie 6 10-12-2010 02:25 AM
After moving mysql db to NFS[netapp] unable to start mysql server throws error naveenrajn Linux - General 3 09-13-2010 02:20 AM
Unable to start httpd services epollnac Linux - Newbie 1 06-14-2006 08:41 AM
Unable to start the named services anupverma Linux - Newbie 0 05-16-2004 06:22 AM > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 01:38 PM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration