【已解答】mysql 启动不了了

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

面板、插件版本：8.0.1

系统版本：

问题描述：在重启 Mysql 时,一直启动失败,无法启动

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

2023-08-08T09:30:36.368414Z 0 [Warning] [MY-000081] [Server] option ＇max_allowed_packet＇: unsigned value 10737418240 adjusted to 1073741824.

2023-08-08T09:30:36.368501Z 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-08-08T09:30:36.369906Z 0 [System] [MY-010116] [Server] /www/server/mysql/bin/mysqld (mysqld 8.0.24) starting as process 10196

2023-08-08T09:30:36.412151Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.

2023-08-08T09:30:37.917719Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.

2023-08-08T09:30:39.411335Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: ＇::＇ port: 33060, socket: /tmp/mysqlx.sock

您好，您复制下面的命令到终端中执行，执行成功把执行结果截图发出来，这个命令使用来查看mysql的error错误日志

1. cat /www/server/data/*.err|grep -i -C 10 error

复制代码

您好我也是遇到了同样的错误，请问怎么解决

堡塔运维小林 发表于 2023-8-8 18:28
您好，您复制下面的命令到终端中执行，执行成功把执行结果截图发出来，这个命令使用来查看mysql的error错误 ...

[root@ecs-895b-0006 ~]# cat /www/server/data/*.err|grep -i -C 10 error                                      2023-10-18T06:10:13.208629Z 0 [Warning] [MY-000081] [Server] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824.
2023-10-18T06:10:13.208672Z 0 [Warning] [MY-011070] [Server] 'binlog_format' is deprecated and will be removed in a future release.
2023-10-18T06:10:13.208731Z 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-10-18T06:10:13.208801Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
2023-10-18T06:10:13.208824Z 0 [System] [MY-010116] [Server] /www/server/mysql/bin/mysqld (mysqld 8.0.34) starting as process 31354
2023-10-18T06:10:13Z UTC - mysqld got signal 11 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
BuildID[sha1]=b0b60de58b3868f09816f72faf017887b8f546ce
Thread pointer: 0x0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0 thread_stack 0x100000
/www/server/mysql/bin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x2c) [0x1d54c94]
/www/server/mysql/bin/mysqld(print_fatal_signal(int)+0x35c) [0xfb772c]
/www/server/mysql/bin/mysqld(handle_fatal_signal+0x74) [0xfb77cc]
[0x4000229c066c]
[root@ecs-895b-0006 ~]#

宝塔用户_kwjdio 发表于 2023-10-18 15:01
[root@ecs-895b-0006 ~]# cat /www/server/data/*.err|grep -i -C 10 error                             ...

您好，这个错误信息表明 MySQL 服务器崩溃并且产生了信号 11。信号 11 通常是指段错误（Segmentation Fault），这通常是由于程序访问了无效的内存地址或者发生了内存访问错误导致的。这可能是由于软件漏洞或者硬件问题引起的，您可以参考这个文档教程去排查一下https://blog.51cto.com/u_16175448/7494034 ，如果还是不能解决问题，建议您联系专业的数据库维护机构进行处理