linux部署mysql数据库,启动报错:Starting MySQL.The server quit without updating PID file (/[FAILED]mysqld/mysqld.pid).
解决方法:
- 查看报错日志没有报错信息
190419 09:52:29 mysqld_safe Starting mysqld daemon with databases from /home/mysql/data
190419 09:52:29 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
- 查看是否开启 selinux.打开配置文件, 命令为: vi /etc/selinux/config
# This file controls the state of SELinux on the system.
# SELINUX= can take one of these three values:
# enforcing - SELinux security policy is enforced.
# permissive - SELinux prints warnings instead of enforcing.
# disabled - No SELinux policy is loaded.
SELINUX=disabled
# SELINUXTYPE= can take one of three values:
# targeted - Targeted processes are protected,
# minimum - Modification of targeted policy. Only selected processes are protected.
# mls - Multi Level Security protection.
SELINUXTYPE=targetedSELINUX=disabled 默认关闭,排除,如果值不是disabled,请改成disabled
- 查看是否有僵尸进程,如果有的话杀掉. 查看进程命令: ps -ef|grep mysqld , 杀掉进程命令: kill -9 进程号
没有僵尸进程 ,排除 - 查看硬盘是否没有空间 命令: df -h ,没问题,排除
Filesystem Size Used Avail Use% Mounted on
/dev/vda1 40G 2.2G 36G 6% /
devtmpfs 234M 0 234M 0% /dev
tmpfs 244M 0 244M 0% /dev/shm
tmpfs 244M 456K 244M 1% /run
tmpfs 244M 0 244M 0% /sys/fs/cgroup
tmpfs 49M 0 49M 0% /run/user/0- 网上有说删除多余的my.cnf之后启动成功, 查找my.cnf命令: find / -name my.cnf .删除没用的文件之后启动,继续报错.排除
- 查看mysql运行状态报:MySQL is not running, but lock file (/var/lock/subsys/mysql[FAILED],将这个文件删除之后运行状态不报锁定文件问题了,但是启动mysql服务还是报错:
root@langguofeng data]# service mysql status
MySQL is not running, but lock file (/var/lock/subsys/mysql[FAILED]
[root@langguofeng data]# ^C
[root@langguofeng data]# rm -rf /var/lock/subsys/mysql
[root@langguofeng data]# service mysql status
MySQL is not running [FAILED]
[root@langguofeng data]# service mysql start
Starting MySQL.The server quit without updating PID file (/[FAILED]mysqld/mysqld.pid).
[root@langguofeng data]# -
此时的我已经崩溃了,还是重新部署吧
参考:CentOS7安装MySQL5.7
分分钟完成mysql部署 -
时隔多年又碰见这个破问题了，但是这次不能重新安装了。有数据啊。
检查你的my.conf配置文件，我这次是该配置文件出的问题。配置文件配置错误导致的报这个错误