【已完成】mysql无法正常启动

为了能快速了解并处理您的问题，请提供以下基础信息：

面板、插件版本：

系统版本：

问题描述：

相关截图（日志、错误）：

itliujia · 发表于 2023-10-25 12:08:01

[root@VM-12-9-centos ~]# cat /www/server/data/*.err | grep -i -C 10 ERROR
2023-07-28T09:36:40.103050Z 0 [Warning] [MY-000081] [Server] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824.
2023-07-28T09:36:40.103142Z 0 [Warning] [MY-010915] [Server] '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.
2023-07-28T09:36:40.103268Z 0 [System] [MY-010116] [Server] /www/server/mysql/bin/mysqld (mysqld 8.0.24) starting as process 22261
2023-07-28T09:36:40.127947Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-07-28T09:36:40.337938Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-07-28T09:36:40.451521Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /tmp/mysqlx.sock
2023-07-28T09:36:40.627022Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2023-07-28T09:36:40.627247Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2023-07-28T09:36:40.657219Z 0 [System] [MY-010931] [Server] /www/server/mysql/bin/mysqld: ready for connections. Version: '8.0.24'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution.
2023-07-28T09:37:22.264143Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.0.24).
2023-07-28T09:37:22.996279Z 0 [System] [MY-010910] [Server] /www/server/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.24)  Source distribution.
2023-07-28T09:37:23.995303Z 0 [Warning] [MY-000081] [Server] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824.
2023-07-28T09:37:23.995399Z 0 [Warning] [MY-010915] [Server] '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.
2023-07-28T09:37:23.995508Z 0 [System] [MY-010116] [Server] /www/server/mysql/bin/mysqld (mysqld 8.0.24) starting as process 25272
2023-07-28T09:37:24.022839Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-07-28T09:37:24.243661Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-07-28T09:37:24.358204Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: /tmp/mysqlx.sock
2023-07-28T09:37:24.469946Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2023-07-28T09:37:24.470172Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2023-07-28T09:37:24.483200Z 0 [System] [MY-010931] [Server] /www/server/mysql/bin/mysqld: ready for connections. Version: '8.0.24'  socket: '/tmp/mysql.sock'  port: 0  Source distribution.
2023-07-28T09:37:32.081965Z 0 [Warning] [MY-000081] [Server] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824.
2023-07-28T09:37:32.082059Z 0 [Warning] [MY-010915] [Server] '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.
2023-07-28T09:37:32.082169Z 0 [System] [MY-010116] [Server] /www/server/mysql/bin/mysqld (mysqld 8.0.24) starting as process 26390
2023-07-28T09:37:32.106102Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-07-28T09:37:32.953162Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-07-28T09:37:33.072140Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /tmp/mysqlx.sock
2023-07-28T09:37:33.092194Z 0 [System] [MY-010229] [Server] Starting XA crash recovery...
2023-07-28T09:37:33.107743Z 0 [System] [MY-010232] [Server] XA crash recovery finished.
2023-07-28T09:37:33.160635Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2023-07-28T09:37:33.160879Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2023-07-28T09:37:33.184337Z 0 [System] [MY-010931] [Server] /www/server/mysql/bin/mysqld: ready for connections. Version: '8.0.24'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution.
2023-07-28T09:37:39.865372Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.0.24).
2023-07-28T09:37:40.602129Z 0 [System] [MY-010910] [Server] /www/server/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.24)  Source distribution.
2023-07-28T09:37:41.625827Z 0 [Warning] [MY-000081] [Server] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824.
2023-07-28T09:37:41.625920Z 0 [Warning] [MY-010915] [Server] '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.
2023-07-28T09:37:41.626031Z 0 [System] [MY-010116] [Server] /www/server/mysql/bin/mysqld (mysqld 8.0.24) starting as process 27618
2023-07-28T09:37:41.649745Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-07-28T09:37:41.858924Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-07-28T09:37:41.973901Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /tmp/mysqlx.sock
2023-07-28T09:37:42.082725Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2023-07-28T09:37:42.082951Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2023-07-28T09:37:42.105848Z 0 [System] [MY-010931] [Server] /www/server/mysql/bin/mysqld: ready for connections. Version: '8.0.24'  socket: '/tmp/mysql.sock'  port: 3307  Source distribution.
2023-07-28T09:39:41.919114Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.0.24).
2023-07-28T09:39:43.920676Z 0 [Warning] [MY-010909] [Server] /www/server/mysql/bin/mysqld: Forcing close of thread 3424  user: 'bi_data'.
2023-07-28T09:39:43.920793Z 0 [Warning] [MY-010909] [Server] /www/server/mysql/bin/mysqld: Forcing close of thread 3441  user: 'bi_data'.

itliujia · 发表于 2023-10-25 13:57:23

已恢复！

【菠萝云】免费装宝塔,4G内存68	★美国CN2高防服务器★打死退款★	★香港CN2云/站群/高防/特价机★	【滴盾】高防服务器专抗DDOS	【多途云】高防CDN
高防服务器，无视一切流量攻击	SSL证书，防止数据被劫持	OV/EV SSL证书，可当日签发	宝塔一键部署DV,EV,OV,SSL证书	A10招租，联系qq394030111
★易探云.香港/美国/国内/游戏云★	【苍穹云】高性能云服务器 1.2折起	【迅线云盒】内网穿透-固定公网IP	高防服务器40核 64G 20M 199/月	【恒爱云】香港低至8元1核1G2M