现象:
MySQL服务器强制重启后,发现MySQL自启动失败
分析解决:
查看MySQL错误日志:
2021-03-14 11:35:53 139718215592128 [ERROR] Binlog has bad magic number; It's not a binary log file that can be used by this version of MySQL
2021-03-14 11:35:53 139718215592128 [ERROR] Can't init tc log
2021-03-14 11:35:53 139718215592128 [ERROR] Aborting
解决:
根据MySQL关闭的时间查看最新的数据文件是哪个,然后将它删除即可;