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@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@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@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@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@xxxxxxxx ________________________________________________________________________ Total Quality Management - A Commitment to Excellence http://www.TQMcube.com
