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

MYSQL is installed on RedHatLinux9 today, but after servicemysqlstart, the following prompt appears when you view servicemysqlstatus: mysqld

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

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.