Can't start mysql on FC3
David Cary Hart
Fedora at TQMcube.com
Wed Feb 2 02:12:27 UTC 2005
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?
host.frm is created the first time you start the daemon and is located
in /var/lib/mysql/mysql.
>
> 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
More information about the fedora-list
mailing list