欢迎各位兄弟 发布技术文章

这里的技术是共享的

You are here

CENTOS安装完MARIADB后启动不了 MYSQL IS NOT RUNNING, BUT LOCK FILE (/VAR/LOCK/SUBSYS/MYSQL) EXISTS 有大用

[root@admin-node subsys]# service mysql start

Starting MySQL. ERROR! 

[root@admin-node subsys]# service mysql status

 ERROR! MySQL is not running, but lock file (/var/lock/subsys/mysql) exists


/var/lock/subsys/mysql存在的原因可能是以前没有卸载干净或者上次意外退出。

直接将其删除就可以了,删除后再执行service mysql start。

追问:

删了,再启动还是不行,还是会生成空的mysql文件,还是报错

追答:

那应该是# service mysql start这步出错了,/var/log/messages或者dmesg看下有没有错误信息输出?应该是有错误信息的。



来自 

https://www.cnblogs.com/turingbrain/p/5552782.html

https://www.2cto.com/database/201806/755848.html





MySQL is not running, but lock file的解决办法

启动MySQL出错,查看了下状态,发现提示MySQL is not running, but lock file (/var/lock/subsys/mysql[FAILED]: 

一个网友说可能和log文件有关,于是将log文件给移除了,再重启MySQL终于OK了

找了下资料,基本上都是说: 

复制代码代码如下:

# chown -R mysql:mysql /var/lib/mysql 
# rm /var/lock/subsys/mysql 
# service mysql restart 


执行完发现还是这个提示。 

因为是在cPanel服务器上,所以又通过命令: 

复制代码代码如下:

# yum remove mysql mysql-server 


将mysql卸载了,然后重新安装: 

复制代码代码如下:

# /scripts/mysqlup –force 


装好之后发现重启还是出错,又认真看了下,发现pid文件不是以当前的主机名命名的,于是执行: 

复制代码代码如下:

# echo `ps aux | grep mysql | grep “user=mysql” | grep -v “grep” | awk ‘{print $2}'`>> hostname.pid

重新生成了下pid文件,同时修改owner和group为mysql: 

复制代码代码如下:

# chown mysql:mysql hostname.pid 


之后保存再重启还是出错。 

最后查到一个网友说可能和log文件有关,于是将log文件给移除了,再重启MySQL终于OK了。

A MySQL crash on Red Hat system resulted with: 

/etc/init.d/mysql status 

coming back with: 

mysql is not running but lock exists 


Solved by removing the lock file: 

rm /var/lock/subsys/mysql 


If this happens again it may also be necessary to remove the pid file from /var/lib/mysql

来自 https://blog.csdn.net/zhangfan_12871/article/details/79760726

https://www.jb51.net/article/18885.htm

https://yq.aliyun.com/ziliao/114783





[MySQL] 重启MySQL提示ERROR! MySQL is not running, but lock file (/var/lock/subsys/mysql)

重启MySQL数据库服务器提示ERROR! MySQL is not running, but lock file (/var/lock/subsys/mysql),看了下MySQL数据库状态:

 # service mysql status
ERROR! MySQL is not running, but lock file (/var/lock/subsys/mysql) exists

接着查看了下MySQL的错误日志看到:
/usr/sbin/mysqld: unknown option '--safe-show-database'
所以应该是my.cnf文件中配置出错了,将这行给去掉之后重启MySQL成功:

 # service mysql restart
ERROR! MySQL server PID file could not be found!
Starting MySQL.. SUCCESS!
 # service mysql status
SUCCESS! MySQL running (4040)

配置文件my.cnf 丢失,导致mysql服务不能启动等等故障:

[root@centos6 init.d]# service mysqld start
Starting MySQL.. ERROR! The server quit without updating PID file (/var/lib/mysql/centos6.pid).

重新拷贝正确my.cnf配置文件到/etc/目录下

[root@centos6 mysql]# cp support-files/my-large.cnf /etc/my.cnf
cp:是否覆盖"/etc/my.cnf"? y
[root@centos6 mysql]# service mysqld start
Starting MySQL.... SUCCESS!
[root@centos6 mysql]# service mysqld status
 SUCCESS! MySQL running (50035)

运行ok

来自  http://blog.51cto.com/461205160/1731369


MySQL: mysql is not running but lock exists 的解决方法

启动mysql时出现以下错误:

 

解决方法:

[root@YW-APP-002 mysql2]# rm -rf /var/lock/subsys/mysql

 

再次启动mysql,一切正常了:

 

如果出现以下错误:

 

解决方法:

把存放mysql数据库目录的权限设置为mysql用户即可

[root@YW-APP-002 data]# chown -R mysql:mysql mysql2

 

再次重启mysql,一切正常了:

来自  http://blog.51cto.com/linushai/983921

普通分类: