RedHatLinux9上安装MYSQL“mysqld已死，但是subsys被锁”的解决方案

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了RedHatLinux9上安装MYSQL“mysqld已死，但是subsys被锁”的解决方案，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含2182字，纯文字阅读大概需要4分钟。

内容图文

今天在Red Hat Linux 9上面安装了MYSQL，但是在service mysql start以后，查看service mysql status的时候出现以下提示：mysqld

今天在Red Hat Linux 9上面安装了MYSQL，但是在service mysql start以后，，查看service mysql status的时候出现以下提示：

mysqld 已死，但是 subsys 被锁

我起初还看了日志文件，日志文件提示：

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:10M:autoextend
But to get good performance you should adjust for your hardware
the InnoDB startup options listed in section 2 at
060806 12:51:01 /usr/libexec/mysqld: Incorrect information in file: './mysql/host.frm'
060806 12:51:01 mysqld ended

我把原版的英文发给大家看看：

1. Obviously 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 to.

rm -Rf /var/lib/mysql/*

6. Check your global options configuration file, should 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.

其实做到step 9问题都已经解决了。

内容总结

以上是互联网集市为您收集整理的RedHatLinux9上安装MYSQL“mysqld已死，但是subsys被锁”的解决方案全部内容，希望文章能够帮你解决RedHatLinux9上安装MYSQL“mysqld已死，但是subsys被锁”的解决方案所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端

---