Centos7上MySQL5.7.12系统不兼容启动失败问题处理

来源：互联网发布：图像特征匹配算法编辑：程序博客网时间：2024/06/14 04:15

1、报错信息
[root@spark01 ~]# /etc/init.d/mysqld start
Starting mysqld (via systemctl): Job for mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xe" for details.
[FAILED]

2、打开MySQL的告警日志
2016-01-20T10:00:19.935771Z 0 [ERROR] /usr/sbin/mysqld: Can't create/write to file '/var/run/mysqld/mysqld.pid' (Errcode: 2 - No such file or directory)
2016-01-20T10:00:19.935795Z 0 [ERROR] Can't start server: can't create PID file: No such file or directory
160120 18:00:20 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

MySQL服务在启动的时候，不能创建pid文件。

在终端看一下该目录是否存在，不存在。
于是，创建了/var/run/mysqld/目录，重启MySQL服务；
/var/run/mysqld/的属主和属组还是root，mysql并不能在其中创建文件，后修改该目录的属主和属组，启动OK。

[root@master ~]# mkdir -p /var/run/mysqld/
[root@spark01 ~]# chown mysql.mysql /var/run/mysqld/
[root@master ~]# /etc/init.d/mysqld start

3、创建Mysql启动shell文件脚本

[root@master ~]# cat start-mysql.sh #!/bin/bashmkdir -p /var/run/mysqld/chown mysql.mysql /var/run/mysqld//etc/init.d/mysqld start

每次开机后手动执行，或放在定时调度里。

0 0