LinuxQuestions.org
Did you know LQ has a Linux Hardware Compatibility List?
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
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.

Notices

Reply
 
Search this Thread
Old 10-25-2010, 11:30 AM   #1
rs232
Member
 
Registered: Oct 2005
Posts: 38

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.

Code:
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?
Regards
 
Old 10-25-2010, 01:46 PM   #2
Gmamakis
LQ Newbie
 
Registered: Sep 2010
Location: Greece
Distribution: Fedora, Ubuntu, Slackware, Arch, Sabayon
Posts: 10

Rep: Reputation: 0
try
updatedb
locate host.frm

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

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

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

Code:
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/mysqld.pid 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, 05:43 AM   #4
rs232
Member
 
Registered: Oct 2005
Posts: 38

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
 
  


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


All times are GMT -5. The time now is 07:30 AM.

Main Menu
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
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration