数据库启动失败,查看日志,报错如下:
[root@node ~]# tail -f /var/log/mysqld.log
2022-10-21T21:14:08.244836Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2022-10-21T21:14:08.851622Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2022-10-21T21:14:08.851690Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2022-10-21T21:14:08.851712Z 0 [ERROR] Failed to initialize builtin plugins.
2022-10-21T21:14:08.851732Z 0 [ERROR] Aborting
2022-10-21T21:14:08.851787Z 0 [Note] Binlog end
2022-10-21T21:14:08.851888Z 0 [Note] Shutting down plugin 'CSV'
2022-10-21T21:14:08.852118Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
由报错信息可知InnoDB报错
解决方案:
将/valr/lib/mysql目录下的ib_logfile0 ib_logfile1 这两个文件备份后删除
重新启动MySQL服务即可