本地计算机上的MySQL服务启动后停止。某些服务在未由其他服务或程序使用时将自动停止

一杯拿铁~

已于 2023-04-23 15:18:59 修改

阅读量208

点赞数

文章标签： mysql 数据库

于 2023-04-23 15:16:43 首次发布

本文链接：https://blog.csdn.net/m0_48703915/article/details/130322349

版权

文章描述了MySQL服务在启动后因binlog文件错误而停止的情况。通过查看错误日志，发现是由于binlog的magicnumber不正确导致的问题。解决方案是找到并删除损坏的binlog文件，从而恢复服务正常运行。

摘要由CSDN通过智能技术生成

本地计算机上的MySQL服务启动后停止。某些服务在未由其他服务或程序使用时将自动停止

1.查看mysql的错误日志

在这里插入图片描述

2.根据日志文件查找到错误

2023-04-21T17:19:43.104019Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
2023-04-21T17:19:43.104045Z 0 [System] [MY-010116] [Server] D:\Computer\Mysql\mysql-8.0.31-winx64\mysql-8.0.31-winx64\bin\mysqld (mysqld 8.0.31) starting as process 8456
2023-04-21T17:19:43.182581Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-04-21T17:19:43.464004Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-04-21T17:19:43.599841Z 0 [ERROR] [MY-010958] [Server] Binlog has bad magic number;  It's not a binary log file that can be used by this version of MySQL.
2023-04-21T17:19:43.600300Z 0 [ERROR] [MY-010041] [Server] Can't init tc log
2023-04-21T17:19:43.600469Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-04-21T17:19:44.785691Z 0 [System] [MY-010910] [Server] D:\Computer\Mysql\mysql-8.0.31-winx64\mysql-8.0.31-winx64\bin\mysqld: Shutdown complete (mysqld 8.0.31)  MySQL Community Server - GPL.