centos7重启mysql服务解决Centos7重启导致mysql服务启动失败问题

导读错误信息如下:[root@localhost~]#mysql-uroot-p，下面我们就来聊聊关于centos7重启mysql服务?接下来我们就一起去了解一....

错误信息如下:[root@localhost ~]# mysql -uroot -p，下面我们就来聊聊关于centos7重启mysql服务?接下来我们就一起去了解一下吧!

centos7重启mysql服务

错误信息如下:

[root@localhost ~]# mysql -uroot -p

Enter password:

ERROR 2002 (HY000): Cant connect to local MySQL server through socket /var/lib/mysql/mysql.sock (111)

[root@localhost ~]# /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.

[失败]

错误产生的原因是:

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

解决办法:

创建了/var/run/mysqld/目录，重启MySQL服务

实际步骤：

1.创建相关目录，命令如下:

mkdir -p /var/run/mysqld/

2.再次尝试启动:

/etc/init.d/mysqld start

[root@localhost ~]# /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.

[失败]

依旧启动失败，问题原因在于 /var/run/mysqld/的属主和属组还是root，mysql并不能在其中创建文件，后修改该目录的属主和属组，启动OK。

解决步骤:

1.查看相关目录所属权限

ls -ld /var/run/mysqld/

[root@localhost ~]# ls -ld /var/run/mysqld/

drwxr-xr-x. 2 root root 40 7月 4 19:01 /var/run/mysqld/

2.修改权限:

chown mysql.mysql /var/run/mysqld/

[root@localhost ~]# chown mysql.mysql /var/run/mysqld/

3.最后再次尝试重新启动

[root@localhost ~]# /etc/init.d/mysqld start

Starting mysqld (via systemctl): [ 确定 ]

至此，最后启动成功!!