当前位置: 技术问答>linux和unix
如何解决mysql无法启动,mysql dead but subsys locked
来源: 互联网 发布时间:2016-07-27
本文导语: mysql dead but subsys locked mysqld 已死,但是 subsys 被锁 我是先用rpm 安装了mysql,然后又编译安装了一个mysql 后来我把他们都删了,又用rpm 安装,可是还是不行 网上找的两种方法都试过了,还是不行, 方法一 解...
mysql dead but subsys locked
mysqld 已死,但是 subsys 被锁
我是先用rpm 安装了mysql,然后又编译安装了一个mysql 后来我把他们都删了,又用rpm 安装,可是还是不行
网上找的两种方法都试过了,还是不行,
方法一
解决办法如下
shell> service mysqld stop
shell> rm -fr /var/lib/mysql/*
shell> rm /var/lock/subsys/mysqld
shell> killall mysqld
shell> service mysqld start
含义如下:
1. 停止MYSQL服务
2. 删除/var/lib/mysql/下的所有文件,我想这些文件可能是MYSQL5.1留下来的.
3. 删除锁定文件
4. 杀死所有mysqld进程
5. 启动MYSQL服务
方法二
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问题都已经解决了。
mysqld 已死,但是 subsys 被锁
我是先用rpm 安装了mysql,然后又编译安装了一个mysql 后来我把他们都删了,又用rpm 安装,可是还是不行
网上找的两种方法都试过了,还是不行,
方法一
解决办法如下
shell> service mysqld stop
shell> rm -fr /var/lib/mysql/*
shell> rm /var/lock/subsys/mysqld
shell> killall mysqld
shell> service mysqld start
含义如下:
1. 停止MYSQL服务
2. 删除/var/lib/mysql/下的所有文件,我想这些文件可能是MYSQL5.1留下来的.
3. 删除锁定文件
4. 杀死所有mysqld进程
5. 启动MYSQL服务
方法二
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问题都已经解决了。
|
用yum安装吧:
# yum install mysql* -y