setting up mysql on Fedora Core 4

[ranijee]

I have Fedora Core 4 installed in my server. I want to setup mysql and the steps I took is as follows (I login as root)
I typed -

1. mysql_install_db
2. mysqld_safe

it replies - Starting mysqld daemon with databases from /var/lib/mysql
STOPPING server from pid file /var/run/mysqld/mysqld.pid
060323 15:22:34 mysqld ended

but when I try to type mysqlshow, it gives this error instead

mysqlshow: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

I typed mysqld_safe --log-error=/tmp/mysqld_safe.err &
and the error log contains as below -

060324 10:41:01 mysqld started
060324 10:41:01 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
060324 10:41:01 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 43634.
InnoDB: Doing recovery: scanned up to log sequence number 0 43634
060324 10:41:01 InnoDB: Flushing modified pages from the buffer pool...
060324 10:41:01 InnoDB: Started; log sequence number 0 43634
060324 10:41:01 [ERROR] /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
060324 10:41:01 [ERROR] Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
060324 10:41:01 mysqld ended

I can locate host.frm. I do not know what seems to be the problem. I have login as root.
appreciate the help

 

[ggggus]

It's much easier to install things with yum with fedora core.

try running this from the shell as root

yum install mysql

***************************************
J. Jacobs

http://www.piercedmedia.com