Mysql服务启动失败 [Server] I/O error reading the header from the binary log.

作者：数据挖掘灵魂 | 2024-01-16 13:47:01

踩

错误信息如下：

2020-12-08T08:41:34.003470Z 0 [ERROR] [MY-010958] [Server] I/O error reading the header from the binary log.
2020-12-08T08:41:34.004821Z 0 [ERROR] [MY-010041] [Server] Can't init tc log
2020-12-08T08:41:34.006049Z 0 [ERROR] [MY-010119] [Server] Aborting

-----------

2020-12-08T08:49:00.150380Z 0 [System] [MY-010116] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.19) starting as process 13436
mysqld: File '.\DESKTOP-IR5UPKH-bin.000033' not found (OS errno 2 - No such file or directory)
2020-12-08T08:49:02.906655Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
2020-12-08T08:49:02.907263Z 0 [ERROR] [MY-010041] [Server] Can't init tc log
2020-12-08T08:49:02.907913Z 0 [ERROR] [MY-010119] [Server] Aborting

故障排除步骤：

1. Mysql服务启动失败，到Mysql安装目录下查找错误日志(DESKTOP-IR5UPKH.err是"计算机名".err)：

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/article/detail/40032