Mailinglist Archive: opensuse (2912 mails)

< Previous Next >
Re: [SLE] mySQL startup problem
  • From: "Carl E. Hartung" <suselinux@xxxxxxxxxxxxx>
  • Date: Wed, 16 Feb 2005 19:46:19 -0500
  • Message-id: <4213E95B.2060306@xxxxxxxxxxxxx>
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@xxxxxxxxxxxxx
Dover Foxcroft, Maine, USA Public Key #0x68396713
Reg. Linux User #350527 http://counter.li.org/

< Previous Next >