Re: Can't find hosts.frm -- permissions now okay?

[Csongor Fagyal]

Lefevre, Steven wrote:

I'm still getting the error 'Can't find hosts.frm' when I try to laund the
mysql daemon.


I've run the mysql_install_db script several times.

I've changed the user and group ownership for all the files in the
/usr/libexec/mysql directory, and also in /var/lib/mysql to 'mysql' (it was
'root').

(RPM installed it originally in /var/lib/mysql, I copied it to
/usr/libexec/mysql just in case that's where is was looking. That's where th
mysqld was, and the error said "can't find ./hosts.frm".)

Any ideas?

ls -la /var/lib/mysql/
total 120
drwxr-xr-x 4 mysql mysql 4096 Dec 12 15:03 .
drwxr-xr-x 13 root root 4096 Dec 6 10:07 ..
...
-rw-rw---- 1 mysql mysql 1024 Dec 6 11:10 func.MYI
-rw-rw---- 1 mysql mysql 8958 Dec 6 11:10 host.frm
-rw-rw---- 1 mysql mysql 0 Dec 6 11:10 host.MYD
...

ls -la /usr/libexec/mysql
total 116
drwxr-xr-x 3 root root 4096 Dec 11 15:30 .
drwxr-xr-x 7 root root 4096 Dec 11 15:28 ..
...
-rw-r----- 1 mysql mysql 1024 Dec 11 15:29 func.MYI
-rw-r----- 1 mysql mysql 8958 Dec 11 15:29 host.frm
-rw-r----- 1 mysql mysql 0 Dec 11 15:29 host.MYD
...

How come your mysql is looking for hosts.frm while you have host.frm? Is that a normal behaviour?

- Cs.


---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php