LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
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!

Notices


Reply
  Search this Thread
Old 08-13-2013, 06:04 PM   #1
Gflames
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, 06:54 PM   #2
Ser Olmy
Senior Member
 
Registered: Jan 2012
Distribution: Slackware
Posts: 2,469

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, 06:57 PM   #3
Kustom42
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.

http://forums.mysql.com/read.php?34,164324
http://wiki.unixh4cks.com/index.php/...mat_%27host%27
 
  


Reply


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 09:41 AM
Couldn't start mysql services on Debian Lenny Tueleep86 Linux - Newbie 6 10-12-2010 03:25 AM
After moving mysql db to NFS[netapp] unable to start mysql server throws error naveenrajn Linux - General 3 09-13-2010 03:20 AM
Unable to start httpd services epollnac Linux - Newbie 1 06-14-2006 09:41 AM
Unable to start the named services anupverma Linux - Newbie 0 05-16-2004 07:22 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 04:15 AM.

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