Solution for installing MYSQL "mysqld is dead but subsys is locked" on RedHatLinux9

MYSQL is installed on RedHatLinux9 today. However, after servicemysqlstart, the following message is displayed when you view servicemysqlstatus: mysqld is dead, but subsys is locked. At first, I read the log file and the log file prompts: cannotinitializeInnoDBas 'innodb _ data_file_path 'isnotset. ify

MYSQL is installed on Red Hat Linux 9 today, but after service mysql start, the following prompt appears when you view service mysql status:

Mysqld is dead, but subsys is locked

I also read the log file at first, and the log file prompts:

Cannot initialize InnoDB as 'innodb _ data_file_path 'is not set.
If you do not want to use transactional InnoDB tables, add a line
Skip-innodb
To the [mysqld] section of init parameters in your my. cnf
Or my. ini. If you want to use InnoDB tables, add to the [mysqld]
Section, for example,
Innodb_data_file_path = ibdata1: 10 M: autoextend
But to get good performance you shoshould adjust for your hardware
The InnoDB startup options listed in section 2
060806 12:51:01/usr/libexec/mysqld: Incorrect information in file: './mysql/host. frm'
060806 12:51:01 mysqld ended

I will show you the original English version:

1. obviusly the 'ole check the log file for anything nasty

Cat/var/log/mysqld. log

2. Stop the service

Service mysqld stop

3. Check to see if the service stopped, it might be calling the wrong pid.

Ps aux | grep mysql

4. Kill any mysql process that might still be running.

Kill-9 ??? ???

5. (* CAREFUL *) Remove/move/backup any databases from the data directory, only do this step if you need.

Rm-Rf/var/lib/mysql /*

6. Check your global options configuration file, shocould be similar to stevanbt's initial post.

Cat/etc/my. cnf

7. copy over one of the preconfigured 'sample' server-specific options file. global (/etc/my. cnf) file has priority over server-specific file, but these have more options in them and have been tuned for a certain role.

Cp/usr/share/doc/mysql-server -?.??.?? /My-small.cnf/var/lib/mysql

8. Recreate the initial databases, this step is optional as the initscripts will do this anyway.

Mysql_install_db

9. Check and set the runlevels for the service.

Chkconfig -- level 345 mysqld on
Chkconfig -- list mysqld

10. Start the service.

Service mysqld start

11. Check the log file (step 1)

Thats just a basic step through check, most of you have probably already done this.

In fact, the problem of step 9 has been solved.