centos系统有一次异常关机后启动mysql一直报错 #/etc/init.d/mysqld start Starting MySQL.. ERROR! The server quit without updating PID file (/data/mysql/linux-01.pid). 查看错误日志如下 [root@linux-01 ~]# tail /data/mysql/linux-01.err 2018-06-28 21:34:28 2726 [Note] Shutting down plugin 'CSV' 2018-06-28 21:34:28 2726 [Note] Shutting down plugin 'MRG_MYISAM' 2018-06-28 21:34:28 2726 [Note] Shutting down plugin 'MEMORY' 2018-06-28 21:34:28 2726 [Note] Shutting down plugin 'MyISAM' 2018-06-28 21:34:28 2726 [Note] Shutting down plugin 'sha256_password' 2018-06-28 21:34:28 2726 [Note] Shutting down plugin 'mysql_old_password' 2018-06-28 21:34:28 2726 [Note] Shutting down plugin 'mysql_native_password' 2018-06-28 21:34:28 2726 [Note] Shutting down plugin 'binlog' 2018-06-28 21:34:28 2726 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete 解决方法: #cd /data/mysql/ #ls aria_log.00000001 ib_buffer_pool ib_logfile1 mysql aria_log_control ibdata1 linux-01.err performance_schema auto.cnf ib_logfile0 multi-master.info test 删除ibdata1 ib_logfile0 ib_logfile1 3个文件 #rm ibdata1 ib_logfile0 ib_logfile1 启动mysql #/etc/init.d/mysqld start Starting MySQL......... SUCCESS!