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!
来源: http://www.bubuko.com/infodetail-2663167.html