linux下启动mysql一直报错,MYSQL启动后报错故障问题的解决办法

MYSQL启动后报错故障问题的解决办法

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!

©著作权归作者所有：来自51CTO博客作者djnzjhll的原创作品，如需转载，请与作者联系，否则将追究法律责任