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@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
-- Wes Barris E-Mail: Wes.Barris@xxxxxxxx
