linux重启mysql数据库命令重启mysql服务命令_生活百科

【linux重启mysql数据库命令重启mysql服务命令】错误信息如下:
# mysql -uroot -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
# /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
# /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/
# 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/
# chown mysql.mysql /var/run/mysqld/
3.最后再次尝试重新启动
# /etc/init.d/mysqld start
Starting mysqld (via systemctl): < 确定 >
至此，最后启动成功!!

linux重启mysql数据库命令 重启mysql服务命令

linux重启mysql数据库命令重启mysql服务命令