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

Source: Internet
Author: User
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.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.