错误信息如下:[root@localhost ~]# mysql -uroot -p,下面我们就来聊聊关于centos7重启mysql服务?接下来我们就一起去了解一下吧!
centos7重启mysql服务
错误信息如下:
[root@localhost ~]# mysql -uroot -p
Enter password:
ERROR 2002 (HY000): Can't 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): [ 确定 ]
至此,最后启动成功!!
,