【已完成】宝塔数据库启动失败
为了能快速了解并处理您的问题，请提供以下基础信息：面板、插件版本：MySQL 8.0.24系统版本：9.2.0
问题描述：MySQL启动失败
相关截图（日志、错误）：2025-07-15T06:35:19.873172Z 0 option ＇max_allowed_packet＇: unsigned value 107374182400 adjusted to 1073741824.2025-07-15T06:35:19.873388Z 0 ＇NO_ZERO_DATE＇, ＇NO_ZERO_IN_DATE＇ and ＇ERROR_FOR_DIVISION_BY_ZERO＇ sql modes should be used with strict mode. They will be merged with strict mode in a future release.2025-07-15T06:35:19.873573Z 0 /www/server/mysql/bin/mysqld (mysqld 8.0.24) starting as process 131742025-07-15T06:35:19.897842Z 1 InnoDB initialization has started.2025-07-15T06:35:20.141229Z 1 InnoDB initialization has ended.2025-07-15T06:35:20.305585Z 0 X Plugin ready for connections. Bind-address: ＇::＇ port: 33060, socket: /tmp/mysqlx.sockmysqld: File ＇./mysql-bin.000001＇ not found (OS errno 2 - No such file or directory)2025-07-15T06:35:20.373517Z 0 Could not open log file.2025-07-15T06:35:20.374224Z 0 Can＇t init tc log2025-07-15T06:35:20.375392Z 0 Aborting2025-07-15T06:35:21.817202Z 0 /www/server/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.24)Source distribution.2025-07-15T06:35:23.939529Z 0 option ＇max_allowed_packet＇: unsigned value 107374182400 adjusted to 1073741824.2025-07-15T06:35:23.939671Z 0 ＇NO_ZERO_DATE＇, ＇NO_ZERO_IN_DATE＇ and ＇ERROR_FOR_DIVISION_BY_ZERO＇ sql modes should be used with strict mode. They will be merged with strict mode in a future release.2025-07-15T06:35:23.939873Z 0 /www/server/mysql/bin/mysqld (mysqld 8.0.24) starting as process 138942025-07-15T06:35:23.961565Z 1 InnoDB initialization has started.2025-07-15T06:35:24.206399Z 1 InnoDB initialization has ended.2025-07-15T06:35:24.375550Z 0 X Plugin ready for connections. Bind-address: ＇::＇ port: 33060, socket: /tmp/mysqlx.sockmysqld: File ＇./mysql-bin.000001＇ not found (OS errno 2 - No such file or directory)2025-07-15T06:35:24.437297Z 0 Could not open log file.2025-07-15T06:35:24.437848Z 0 Can＇t init tc log2025-07-15T06:35:24.438669Z 0 Aborting2025-07-15T06:35:25.894908Z 0 /www/server/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.24)Source distribution.2025-07-15T06:35:28.516488Z 0 option ＇max_allowed_packet＇: unsigned value 107374182400 adjusted to 1073741824.2025-07-15T06:35:28.516605Z 0 ＇NO_ZERO_DATE＇, ＇NO_ZERO_IN_DATE＇ and ＇ERROR_FOR_DIVISION_BY_ZERO＇ sql modes should be used with strict mode. They will be merged with strict mode in a future release.2025-07-15T06:35:28.516779Z 0 /www/server/mysql/bin/mysqld (mysqld 8.0.24) starting as process 146162025-07-15T06:35:28.539977Z 1 InnoDB initialization has started.2025-07-15T06:35:28.780511Z 1 InnoDB initialization has ended.2025-07-15T06:35:28.939205Z 0 X Plugin ready for connections. Bind-address: ＇::＇ port: 33060, socket: /tmp/mysqlx.sockmysqld: File ＇./mysql-bin.000001＇ not found (OS errno 2 - No such file or directory)2025-07-15T06:35:29.017102Z 0 Could not open log file.2025-07-15T06:35:29.017898Z 0 Can＇t init tc log2025-07-15T06:35:29.019101Z 0 Aborting2025-07-15T06:35:30.459105Z 0 /www/server/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.24)Source distribution.2025-07-15T06:35:33.148904Z 0 option ＇max_allowed_packet＇: unsigned value 107374182400 adjusted to 1073741824.2025-07-15T06:35:33.149045Z 0 ＇NO_ZERO_DATE＇, ＇NO_ZERO_IN_DATE＇ and ＇ERROR_FOR_DIVISION_BY_ZERO＇ sql modes should be used with strict mode. They will be merged with strict mode in a future release.2025-07-15T06:35:33.149223Z 0 /www/server/mysql/bin/mysqld (mysqld 8.0.24) starting as process 153402025-07-15T06:35:33.177353Z 1 InnoDB initialization has started.2025-07-15T06:35:33.413224Z 1 InnoDB initialization has ended.2025-07-15T06:35:33.567311Z 0 X Plugin ready for connections. Bind-address: ＇::＇ port: 33060, socket: /tmp/mysqlx.sockmysqld: File ＇./mysql-bin.000001＇ not found (OS errno 2 - No such file or directory)2025-07-15T06:35:33.626514Z 0 Could not open log file.2025-07-15T06:35:33.626871Z 0 Can＇t init tc log2025-07-15T06:35:33.627424Z 0 Aborting2025-07-15T06:35:35.090955Z 0 /www/server/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.24)Source distribution.2025-07-15T06:35:37.722235Z 0 option ＇max_allowed_packet＇: unsigned value 107374182400 adjusted to 1073741824.2025-07-15T06:35:37.722358Z 0 ＇NO_ZERO_DATE＇, ＇NO_ZERO_IN_DATE＇ and ＇ERROR_FOR_DIVISION_BY_ZERO＇ sql modes should be used with strict mode. They will be merged with strict mode in a future release.2025-07-15T06:35:37.722511Z 0 /www/server/mysql/bin/mysqld (mysqld 8.0.24) starting as process 160712025-07-15T06:35:37.753883Z 1 InnoDB initialization has started.2025-07-15T06:35:37.994550Z 1 InnoDB initialization has ended.2025-07-15T06:35:38.151855Z 0 X Plugin ready for connections. Bind-address: ＇::＇ port: 33060, socket: /tmp/mysqlx.sockmysqld: File ＇./mysql-bin.000001＇ not found (OS errno 2 - No such file or directory)2025-07-15T06:35:38.226638Z 0 Could not open log file.2025-07-15T06:35:38.227005Z 0 Can＇t init tc log2025-07-15T06:35:38.227564Z 0 Aborting2025-07-15T06:35:39.669517Z 0 /www/server/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.24)Source distribution.2025-07-15T06:35:42.314245Z 0 option ＇max_allowed_packet＇: unsigned value 107374182400 adjusted to 1073741824.2025-07-15T06:35:42.314373Z 0 ＇NO_ZERO_DATE＇, ＇NO_ZERO_IN_DATE＇ and ＇ERROR_FOR_DIVISION_BY_ZERO＇ sql modes should be used with strict mode. They will be merged with strict mode in a future release.2025-07-15T06:35:42.314517Z 0 /www/server/mysql/bin/mysqld (mysqld 8.0.24) starting as process 167992025-07-15T06:35:42.337613Z 1 InnoDB initialization has started.2025-07-15T06:35:42.566956Z 1 InnoDB initialization has ended.2025-07-15T06:35:42.728860Z 0 X Plugin ready for connections. Bind-address: ＇::＇ port: 33060, socket: /tmp/mysqlx.sockmysqld: File ＇./mysql-bin.000001＇ not found (OS errno 2 - No such file or directory)2025-07-15T06:35:42.788715Z 0 Could not open log file.2025-07-15T06:35:42.789035Z 0 Can＇t init tc log2025-07-15T06:35:42.789526Z 0 Aborting2025-07-15T06:35:44.249873Z 0 /www/server/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.24)Source distribution.2025-07-15T06:35:46.891039Z 0 option ＇max_allowed_packet＇: unsigned value 107374182400 adjusted to 1073741824.2025-07-15T06:35:46.891156Z 0 ＇NO_ZERO_DATE＇, ＇NO_ZERO_IN_DATE＇ and ＇ERROR_FOR_DIVISION_BY_ZERO＇ sql modes should be used with strict mode. They will be merged with strict mode in a future release.2025-07-15T06:35:46.891297Z 0 /www/server/mysql/bin/mysqld (mysqld 8.0.24) starting as process 175232025-07-15T06:35:46.914642Z 1 InnoDB initialization has started.2025-07-15T06:35:47.143056Z 1 InnoDB initialization has ended.2025-07-15T06:35:47.302404Z 0 X Plugin ready for connections. Bind-address: ＇::＇ port: 33060, socket: /tmp/mysqlx.sockmysqld: File ＇./mysql-bin.000001＇ not found (OS errno 2 - No such file or directory)2025-07-15T06:35:47.365909Z 0 Could not open log file.2025-07-15T06:35:47.366382Z 0 Can＇t init tc log2025-07-15T06:35:47.367186Z 0 Aborting2025-07-15T06:35:48.823647Z 0 /www/server/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.24)Source distribution.2025-07-15T06:35:51.566090Z 0 option ＇max_allowed_packet＇: unsigned value 107374182400 adjusted to 1073741824.2025-07-15T06:35:51.566218Z 0 ＇NO_ZERO_DATE＇, ＇NO_ZERO_IN_DATE＇ and ＇ERROR_FOR_DIVISION_BY_ZERO＇ sql modes should be used with strict mode. They will be merged with strict mode in a future release.2025-07-15T06:35:51.566402Z 0 /www/server/mysql/bin/mysqld (mysqld 8.0.24) starting as process 182612025-07-15T06:35:51.591206Z 1 InnoDB initialization has started.2025-07-15T06:35:51.837308Z 1 InnoDB initialization has ended.2025-07-15T06:35:51.992330Z 0 X Plugin ready for connections. Bind-address: ＇::＇ port: 33060, socket: /tmp/mysqlx.sockmysqld: File ＇./mysql-bin.000001＇ not found (OS errno 2 - No such file or directory)2025-07-15T06:35:52.064997Z 0 Could not open log file.2025-07-15T06:35:52.065430Z 0 Can＇t init tc log2025-07-15T06:35:52.066075Z 0 Aborting2025-07-15T06:35:53.512038Z 0 /www/server/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.24)Source distribution.
二进制日志文件./mysql-bin.000001找不到
在/www/server/data/mysql-bin.index内删除对应的文件，重启mysql 阿珂 发表于 2025-7-15 16:39
二进制日志文件./mysql-bin.000001找不到
在/www/server/data/mysql-bin.index内删除对应的文件，重启mysql ...
好的感谢
页:
[1]