Ubuntu里尝试打开Mysql遇到如下报错
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
经验判断是因为Mysql服务没有启动,所以启动Mysql服务
systemctl start mysql
Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details.
无法启动,根据提示输入以下命令查看报错信息
systemctl status mysql.service
得到以下报错信息
mysql.service - MySQL Community Server
Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: en
Active: activating (start-post) (Result: exit-code) since 六 2018-05-05 09:30
Process: 3047 ExecStart=/usr/sbin/mysqld (code=exited, status=1/FAILURE)
Process: 3040 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exit
Main PID: 3047 (code=exited, status=1/FAILURE); : 3048 (mysql-systemd-s
CGroup: /system.slice/mysql.service
└─control
├─3048 /bin/bash /usr/share/mysql/mysql-systemd-start post
└─3092 sleep 1
根据报错信息,基本判断是配置文件错误导致无法启动,检查了一遍配置文件,确实发现问题,修复后Mysql就能正常启动了。