Re: Can't start mysql on FC3

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [Current Fedora Users]     [Fedora Desktop]     [Fedora SELinux]     [Yosemite News]     [Yosemite Photos]     [KDE Users]     [Fedora Tools]     [Fedora Docs]

  Powered by Linux