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

[seul-edu] MySql config Problem



Hello,

I am having trouble running mysql on rh70. 

I have done all the updates and I can't get mysql to start.  It gave me some
table errors, so I ran mysql_install_db -- the table errors went away, but it
still gives me the problem:

[root@sonam mysql]# safe_mysqld 
Starting mysqld daemon with databases from /var/lib/mysql
001029 07:17:24  mysqld ended

[root@sonam mysql]# more sonam.tasis.ch.err 
001029 07:17:24  mysqld started
001029  7:17:24  /usr/libexec/mysqld: Can't find file: './mysql/host.frm'
(errno: 13)
001029 07:17:24  mysqld ended

I have checked the host.frm file is indeed there.

[root@sonam bill]# cd /var/lib/mysql/mysql
[root@sonam mysql]# pwd
/var/lib/mysql/mysql
[root@sonam mysql]# ls -ls
total 104
 0 -rw-rw----    1 root     root            0 Oct 28 23:28 columns_priv.MYD
 4 -rw-rw----    1 root     root         1024 Oct 28 23:28 columns_priv.MYI
12 -rw-rw----    1 root     root         8778 Oct 28 23:28 columns_priv.frm
 4 -rw-rw----    1 root     root          302 Oct 28 23:28 db.MYD
 4 -rw-rw----    1 root     root         3072 Oct 28 23:28 db.MYI
12 -rw-rw----    1 root     root         8982 Oct 28 23:28 db.frm
 0 -rw-rw----    1 root     root            0 Oct 28 23:28 func.MYD
 4 -rw-rw----    1 root     root         1024 Oct 28 23:28 func.MYI
12 -rw-rw----    1 root     root         8641 Oct 28 23:28 func.frm
 0 -rw-rw----    1 root     root            0 Oct 28 23:28 host.MYD
 4 -rw-rw----    1 root     root         1024 Oct 28 23:28 host.MYI
12 -rw-rw----    1 root     root         8958 Oct 28 23:28 host.frm
 0 -rw-rw----    1 root     root            0 Oct 28 23:28 tables_priv.MYD
 4 -rw-rw----    1 root     root         1024 Oct 28 23:28 tables_priv.MYI
12 -rw-rw----    1 root     root         8877 Oct 28 23:28 tables_priv.frm
 4 -rw-rw----    1 root     root          428 Oct 28 23:28 user.MYD
 4 -rw-rw----    1 root     root         2048 Oct 28 23:28 user.MYI
12 -rw-rw----    1 root     root         9148 Oct 28 23:28 user.frm

Here is a list of my rpms.

[bill@sonam bill]$ rpm -q mysql
mysql-3.23.24-1
[bill@sonam bill]$ rpm -q mysql-devel
mysql-devel-3.23.24-1
[bill@sonam bill]$ rpm -q mysql-server
mysql-server-3.23.24-1

Can anyone point me in the correct direction?  

Thanks,

Bill