Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can't find file: './mysql/host.frm' (errno: 13)

Status
Not open for further replies.

hisham

IS-IT--Management
Nov 6, 2000
194
I reinstalled Mysql in a linux box, when I tried mysqladmin –user mysql &
I get
mysqld ended
When I checked the localhost.localdomain.err, I found
/usr/local/mysql/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
021020 18:03:03 mysqld ended
But I searched for host.frm and I found it at: /usr/local/mysql/data/mysql/host.frm

All the permissions for these files are 777:
/usr/local/mysql/tmp
/usr/local/mysql/tmp/mysql.socket
/usr/local/mysql/data/mysql/host.frm

Now I can’t connect to Mysql server, and how can I connect to mysql server from a host in the same LAN?
Thanks in advance.


 
looks like you have your datadir set up to other dir than /usr/local/mysql/data

check your my.cnf file for the datadir variable, if there's nothing set, then add in the [mysqld] section:
>datadir=/usr/local/mysql/data
and restart mysql

and to your second question - change the rights of the user you want use to connect to mysql that he is able to connect from hosts in your lan and then connect to mysql with a client of your choice
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top