Review your favorite Linux distribution.
Go Back > Forums > Linux Forums > Linux - Software
User Name
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.


  Search this Thread
Old 10-25-2010, 12:30 PM   #1
Registered: Oct 2005
Posts: 43

Rep: Reputation: 0
Mysql help needed: Can't find file: './mysql/host.frm' (errno: 13)

Hello, I've been "messing around" with my database today until I got to the point that it wouldn't start and get the well deserved message below in the mysqld.log.

101025 17:23:14 [ERROR] /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
101025 17:23:14 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
I run the latest mysql-server version on fedora 12.

Any help?
Old 10-25-2010, 02:46 PM   #2
LQ Newbie
Registered: Sep 2010
Location: Greece
Distribution: Fedora, Ubuntu, Slackware, Arch, Sabayon
Posts: 10

Rep: Reputation: 0
locate host.frm

and then start mysqld --data-dir the path the frm is located..
Hopefully it'll work
Old 10-26-2010, 05:19 AM   #3
Registered: Oct 2005
Posts: 43

Original Poster
Rep: Reputation: 0
Ok little update here:

This is the mysqld.log every time I try to restart the process:

101026 09:53:28 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
101026  9:53:28 [Note] Plugin 'ndbcluster' is disabled.
/usr/libexec/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
101026  9:53:28 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
101026  9:53:29  InnoDB: Started; log sequence number 0 44233
101026  9:53:29 [Note] Recovering after a crash using mysql-bin
101026  9:53:29 [Note] Starting crash recovery...
101026  9:53:29 [Note] Crash recovery finished.
101026  9:53:29 [ERROR] /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
101026  9:53:29 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
101026 09:53:29 mysqld_safe mysqld from pid file /var/run/mysqld/ ended
My question is: why is it trying to start the mysql_safe??

I'm using the standard: service mysqld start command

Beside this I can confirm that the host.frm is located in the default directory: /var/lib/mysql/mysql
Old 10-26-2010, 06:43 AM   #4
Registered: Oct 2005
Posts: 43

Original Poster
Rep: Reputation: 0
Deleting the /var/lib/mysql/mysql directory and restarting the process solved the problem.
I did have to re-set the administrator password manually though


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
mysql host.frm xushi Slackware 6 05-19-2005 09:54 AM
can't find host.frm with MySQL wheelie_2000 Linux - Software 3 05-06-2004 06:44 PM
Setting up mysql without user.frm?!?! silversky Slackware 1 02-04-2004 04:01 PM
Invisible mysql .frm file p_nanda2002 Linux - Software 0 07-23-2003 03:16 AM > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 09:45 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