Issues Starting mySQL

[jasontc]

For the life of me I can not get mySQL server to start.

Background:
System: Red Hat 8.0
mySQL verion: whatever shipped with 8.0

I think I have read the mysql.com documentation enough to determine either a. I'm clueless b. I'm clueless or c. all of the above.

I have ran mysql_install_db, appears to work as expected.

When I run safe_mysqld & I get the following:

root@thunderball mysql]# Starting mysqld daemon with databases from /var/lib/mysql
021028 17:15:16 mysqld ended

The error messages in the log read as following:
021028 17:15:16 mysqld started
021028 17:15:16 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
021028 17:15:16 mysqld ended

Even though host.frm is at /var/lib/mysql/mysql/host.frm

Thanks ahead of time for any help.

[jasontc]

Here is my "my.cnf" file:

ysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-innodb
skip-locking

[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

[jljdavidson]

I had the same problem with RH 8.0. The problem lies in the mysql_install_db script. For some reason, the script is missing an insert statement that creates a 'mysql' row in the 'db' table.

I added this insert statement: INSERT INTO db VALUES ('$hostname','mysql','','Y','Y','Y','Y','Y','Y','N ','Y','Y','Y');
to the mysql_install_db script where it's creating the 'db' table.

The modified script can be found at http://home.attbi.com/~jljdavidson/TodayTidbit.html The new insert statement I added is about halfway down the script - I've added my initials (JLJD) and a comment right before the new insert statement.

I reran the script and I was then able to start mysql.