MySQL error

Anon

We are getting the following error with mysql on RH 7.2 w/php4

The log states teh following:
(date/time)mysqld started
(date/time)/usr/libexec/mysql: Table 'mysql.host' does not exist
(date/time)mysqld ended

Help please

Anon

It seems as though you're missing the key mysql database, which is created on installation. This database should contain six tables: user,db,host,func, column_priv and tab_priv.

Check 1: Is there a directory called <mysql data path>/mysql on your system ?

Check 2: If it is there, then you should see 7 groups of tables, being the form definition, the data and the index files.

If it's not there, then the mysql installation didn't complete successfully. It would probably be worth re-installing the mysql rpm.

Cheers

Anon

This may be a stupid question; however, I selected mySQL with the initial installation on RH 7.2. I cannot find the rpms on the original cd for some reason. I wnet to the mysql site and down loaded the rpms for there. Teh rpms on teh mysql site are different. Do we need to uninstall the rpms first? WIll we looa any configuration for php/apache or should we use the upgrade option?

Anon

Good example of installation / upgrade procedure at:

http://www.redhat.com/support/resources/faqs/RH-apache-FAQ/MySQL/mysql-install.html

The option to upgrade the rpm shouldn't cause any problem, provided you have all the necessary RPMs.

I would try and grab them from the RedHat site just in case RH do any RH specific fiddling with locations etc. The original CDs should contain the Mysql RPM. You may need to use Redhat's installation utility to pull it off the CD (sorry, I use SuSe so not 100% sure of the RedHat tools).

In terms of PHP and Apache, upgrading Mysql should have absolutely no impact (other than needing you to change passwords on the new Mysql database).

Cheers

Anon

Also, I check the mysql log and found the following:
(date/time)mysqld started
(date/time)/user/libexec/mysqld: cannot find file './mysql/host.frm' (errorno
13)
(date/time)mysqld ended

The file is located in /var/lib/mysql/mysql

Help please

Anon

Make sure that all your databases are owned by your daemon user for me a quick 'chmod -R mysql:mysql *' fixed the problem.