Robert A. Rawlinson wrote:
I got the messages like you sent on a previous e-mail. This looked like everything was ok with no error messages.
rcmysql start
I got an indication of start which looked ok
rcmysql status
This gave me the unused message. Then I looked in the log for today and found the time I ran it. it again showed the error: Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm ' (errno: 13) I also tryed the ls -l /var/lib/mysql that someone suggested and it returned: drwxr--xr-x 4 mysql daemon 296 2005-02-16 14:42 . drwxr--xr-x 32 root root 896 2005-02-16 04:19 .. However the host.frm file is not there. ... It just seems that files are missing and do not get created if mysql_install_db is supposed to create them.
Hi Bob, Here's what I see at my end for ownership & permissions: under /var/lib drwxr-xr-x 4 mysql mysql 312 2005-02-16 12:10 mysql/ under /var/lib/mysql drwx------ 2 mysql mysql 624 2005-01-23 20:53 mysql -rw-rw---- 1 mysql mysql 161 2005-02-16 12:10 mysqld.log -rw-r--r-- 1 root root 211 2005-01-24 11:15 mysqld.log-20050124.gz -rw-r--r-- 1 root root 235 2005-01-25 11:15 mysqld.log-20050125.gz -rw-r--r-- 1 root root 463 2005-02-16 04:15 mysqld.log-20050216.gz -rw-rw---- 1 mysql mysql 6 2005-02-16 12:10 mysqld.pid srwxrwxrwx 1 mysql mysql 0 2005-02-16 12:10 mysql.sock drwx------ 2 mysql mysql 48 2005-01-22 15:24 test under /var/lib/mysql/mysql -rw-rw---- 1 mysql mysql 8778 2005-01-22 15:25 columns_priv.frm -rw-rw---- 1 mysql mysql 0 2005-01-22 15:25 columns_priv.MYD -rw-rw---- 1 mysql mysql 1024 2005-01-22 15:25 columns_priv.MYI -rw-rw---- 1 mysql mysql 9088 2005-01-22 15:24 db.frm -rw-rw---- 1 mysql mysql 306 2005-01-22 15:25 db.MYD -rw-rw---- 1 mysql mysql 3072 2005-01-22 15:25 db.MYI -rw-rw---- 1 mysql mysql 8641 2005-01-22 15:25 func.frm -rw-rw---- 1 mysql mysql 0 2005-01-22 15:25 func.MYD -rw-rw---- 1 mysql mysql 1024 2005-01-22 15:25 func.MYI -rw-rw---- 1 mysql mysql 9064 2005-01-22 15:25 host.frm -rw-rw---- 1 mysql mysql 0 2005-01-22 15:25 host.MYD -rw-rw---- 1 mysql mysql 1024 2005-01-22 15:25 host.MYI -rw-rw---- 1 mysql mysql 8877 2005-01-22 15:25 tables_priv.frm -rw-rw---- 1 mysql mysql 0 2005-01-22 15:25 tables_priv.MYD -rw-rw---- 1 mysql mysql 1024 2005-01-22 15:25 tables_priv.MYI -rw-rw---- 1 mysql mysql 9806 2005-01-22 15:25 user.frm -rw-rw---- 1 mysql mysql 8730 2005-01-23 20:53 user_info.frm -rw-rw---- 1 mysql mysql 0 2005-01-23 20:53 user_info.MYD -rw-rw---- 1 mysql mysql 1024 2005-01-23 20:53 user_info.MYI -rw-rw---- 1 mysql mysql 224 2005-02-15 16:45 user.MYD -rw-rw---- 1 mysql mysql 2048 2005-02-15 16:53 user.MYI Do you have the same files and directory structure? - Carl -- ____________________________________________________________________ C. E. Hartung Business Development & Support Services http://www.cehartung.com/ carlh@cehartung.com Dover Foxcroft, Maine, USA Public Key #0x68396713 Reg. Linux User #350527 http://counter.li.org/