Can't start mysql on FC3

[Wes Barris]

David Cary Hart wrote:

> On Wed, 2005-02-02 at 12:04 +1000, Wes Barris wrote:
> 
>>Hi,
>>
>>I have installed Fedora Core 3.  I am unable to start the
>>mysql daemon.  This error is issued in /var/log/mysqld.log:
>>
>>050202 11:13:01  mysqld started
>>050202 11:13:01  /usr/libexec/mysqld: Can't find file: 
>>'./mysql/host.frm' (errno: 13)
>>050202 11:13:01  mysqld ended
>>
> 
> 
> Did you install from the RPM?

Yes.  I have also run up2date which installed the latest available
mysql rpms.


> host.frm is created the first time you start the daemon and is located
> in /var/lib/mysql/mysql.

Yes.  As my post shows, the file is there.  Yet, mysqld somehow
does not see it.  That is why I am posting this query.

> 
>>My /etc/my.cnf contains this:
>>
>>root at bioweb# less /etc/my.cnf
>>[mysqld]
>>skip-innodb
>>datadir=/var/lib/mysql
>>socket=/var/lib/mysql/mysql.sock
>>
>>[mysql.server]
>>user=mysql
>>basedir=/var/lib
>>
>>[safe_mysqld]
>>err-log=/var/log/mysqld.log
>>pid-file=/var/run/mysqld/mysqld.pid
>>
>>The permissions on the /var/lib/mysql directory are:
>>
>>root at bioweb# ls -ld /var/lib/mysql
>>drwxr-xr-x  4 mysql mysql 4096 Feb  2 11:13 /var/lib/mysql/
>>
>>
>>The contents of this directory is:
>>
>>root at bioweb# ls -la /var/lib/mysql
>>total 20576
>>drwxr-xr-x   4 mysql mysql     4096 Feb  2 11:13 ./
>>drwxr-xr-x  14 root  root      4096 Jan  6 10:05 ../
>>-rw-rw----   1 mysql mysql     2511 Feb  1 12:44 bioweb.sl.csiro.au.err
>>-rw-rw----   1 mysql mysql 10485760 Feb  1 12:44 ibdata1
>>-rw-rw----   1 mysql mysql  5242880 Feb  1 12:44 ib_logfile0
>>-rw-rw----   1 mysql mysql  5242880 Feb  1 12:43 ib_logfile1
>>drwx------   2 mysql mysql     4096 Dec 21 13:09 mysql/
>>srwxrwxrwx   1 mysql mysql        0 Feb  2 11:13 mysql.sock=
>>drwx------   2 mysql mysql     4096 Dec 21 13:09 test/
>>
>>The contents of the mysql/mysql directory is:
>>
>>root at bioweb# ls -la /var/lib/mysql/mysql
>>total 192
>>drwx------  2 mysql mysql 4096 Dec 21 13:09 ./
>>drwxr-xr-x  4 mysql mysql 4096 Feb  2 11:13 ../
>>-rw-------  1 mysql mysql 8778 Dec 21 13:09 columns_priv.frm
>>-rw-------  1 mysql mysql    0 Dec 21 13:09 columns_priv.MYD
>>-rw-------  1 mysql mysql 1024 Dec 21 13:09 columns_priv.MYI
>>-rw-------  1 mysql mysql 8982 Dec 21 13:09 db.frm
>>-rw-------  1 mysql mysql  302 Dec 21 13:09 db.MYD
>>-rw-------  1 mysql mysql 3072 Dec 21 13:09 db.MYI
>>-rw-------  1 mysql mysql 8641 Dec 21 13:09 func.frm
>>-rw-------  1 mysql mysql    0 Dec 21 13:09 func.MYD
>>-rw-------  1 mysql mysql 1024 Dec 21 13:09 func.MYI
>>-rw-------  1 mysql mysql 8958 Dec 21 13:09 host.frm
>>-rw-------  1 mysql mysql    0 Dec 21 13:09 host.MYD
>>-rw-------  1 mysql mysql 1024 Dec 21 13:09 host.MYI
>>-rw-------  1 mysql mysql 8877 Dec 21 13:09 tables_priv.frm
>>-rw-------  1 mysql mysql    0 Dec 21 13:09 tables_priv.MYD
>>-rw-------  1 mysql mysql 1024 Dec 21 13:09 tables_priv.MYI
>>-rw-------  1 mysql mysql 9148 Dec 21 13:09 user.frm
>>-rw-------  1 mysql mysql  428 Dec 21 13:09 user.MYD
>>-rw-------  1 mysql mysql 2048 Dec 21 13:09 user.MYI
>>
>>
>>As you can see, the './mysql/host.frm' exists and is readable
>>by mysql.  Why am I getting this error?
>>-- 
>>Wes Barris
>>E-Mail: Wes.Barris at csiro.au
> 
> 
> ________________________________________________________________________
> Total Quality Management - A Commitment to Excellence
> http://www.TQMcube.com
> 


-- 
Wes Barris
E-Mail: Wes.Barris at csiro.au