MySQL 启动报错信息如下:
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 detai...
编译安装的mysql启动出现报错:
Starting MySQL. ERROR! The server quit without updating PID file (/data/mysql/fxq-1.pid).
分析原因:
非正常关机导致:
解决办法:
vim /etc/my.cnf
加入一行:
innodb_force_recovery= 1