【已解答】mysql启动失败

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

面板、插件版本Linux面板8.0.32 测试版免费版 [url=]8.0.3[/url]
  系统版本：Alibaba Cloud 3 (Soaring Falcon) x86_64(Py3.7.8)

问题描述：

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

Welcome to Alibaba Cloud Elastic Compute Service !

Updates Information Summary: available
    30 Security notice(s)
        13 Important Security notice(s)
        17 Moderate Security notice(s)
Run "dnf upgrade-minimal --security" to apply all updates.More details please refer to:
https://help.aliyun.com/document_detail/416274.html
Last login: Fri Oct 20 12:48:50 2023 from 127.0.0.1
[root@iZ8vb0hyjd7cr0Z ~]# cat /www/server/data/*.err|grep -i -C 10 error
2023-03-02T15:02:16.431976Z 0 [Warning] [MY-000081] [Server] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824.
2023-03-02T15:02:16.432078Z 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-03-02T15:02:16.432156Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
2023-03-02T15:02:16.432180Z 0 [System] [MY-010116] [Server] /www/server/mysql/bin/mysqld (mysqld 8.0.32) starting as process 513727
2023-03-02T15:02:16.452426Z 0 [Warning] [MY-013907] [InnoDB] Deprecated configuration parameters innodb_log_file_size and/or innodb_log_files_in_group have been used to compute innodb_redo_log_capacity=536870912. Please use innodb_redo_log_capacity instead.
2023-03-02T15:02:16.454264Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-03-02T15:02:16.722124Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-03-02T15:02:16.963833Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2023-03-02T15:02:16.963868Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2023-03-02T15:02:16.989419Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /tmp/mysqlx.sock
2023-03-02T15:02:16.989534Z 0 [System] [MY-010931] [Server] /www/server/mysql/bin/mysqld: ready for connections. Version: '8.0.32'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution.
2023-03-02T15:02:22.811625Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.0.32).
2023-03-02T15:02:24.401300Z 0 [System] [MY-010910] [Server] /www/server/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.32)  Source distribution.
2023-03-02T15:02:25.477721Z 0 [Warning] [MY-000081] [Server] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824.
2023-03-02T15:02:25.477831Z 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-03-02T15:02:25.477907Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
2023-03-02T15:02:25.477930Z 0 [System] [MY-010116] [Server] /www/server/mysql/bin/mysqld (mysqld 8.0.32) starting as process 515367
2023-03-02T15:02:25.498211Z 0 [Warning] [MY-013907] [InnoDB] Deprecated configuration parameters innodb_log_file_size and/or innodb_log_files_in_group have been used to compute innodb_redo_log_capacity=536870912. Please use innodb_redo_log_capacity instead.
2023-03-02T15:02:25.499979Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-03-02T15:02:25.793260Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-03-02T15:02:26.012440Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2023-03-02T15:02:26.012475Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2023-03-02T15:02:26.029244Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: /tmp/mysqlx.sock
2023-03-02T15:02:26.029334Z 0 [System] [MY-010931] [Server] /www/server/mysql/bin/mysqld: ready for connections. Version: '8.0.32'  socket: '/tmp/mysql.sock'  port: 0  Source distribution.
2023-03-02T15:02:33.589424Z 0 [Warning] [MY-000081] [Server] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824.
2023-03-02T15:02:33.589533Z 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-03-02T15:02:33.589640Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
2023-03-02T15:02:33.589666Z 0 [System] [MY-010116] [Server] /www/server/mysql/bin/mysqld (mysqld 8.0.32) starting as process 516082
2023-03-02T15:02:33.610267Z 0 [Warning] [MY-013907] [InnoDB] Deprecated configuration parameters innod

您好，您上面的这个是之前的日志信息，3月份的，您是不是切换过mysql的存储目录呢？把您执行的命令的目录换成现在mysql的存储目录再去执行看看

堡塔运维小林 发表于 2023-10-20 17:37
您好，您上面的这个是之前的日志信息，3月份的，您是不是切换过mysql的存储目录呢？把您执行的命令的目录换 ...

最新的 报错截图

lanwenkai 发表于 2023-10-20 17:51
最新的 报错截图

您好，您复制下面的命令到终端中执行，执行成功后再去启动mysql看看是否正常

1. cd /你的数据库存储目录
   
2. mv ibdata1 ibdata1.bak
   
3. mv ib_logfile0 ib_logfile0.bak
   
4. mv ib_logfile1 ib_logfile1.bak

复制代码

堡塔运维小林 发表于 2023-10-20 18:22
您好，您复制下面的命令到终端中执行，执行成功后再去启动mysql看看是否正常
...

还是一样的

堡塔运维小林 发表于 2023-10-20 18:22
您好，您复制下面的命令到终端中执行，执行成功后再去启动mysql看看是否正常
...

还是不行

之前都是没有问题的 服务器重启一下 突然就这样了

lanwenkai 发表于 2023-10-24 02:13
之前都是没有问题的 服务器重启一下 突然就这样了

您好，这个错误看起来与 C++ 标准库 GLIBCXX 版本相关，通常是因为在运行 MySQL 时，系统或运行时链接到 MySQL 的库的版本不匹配引起的。特别是，它表明 MySQL 需要使用 C++ 标准库的特定版本，而您的系统上的 C++ 标准库版本较低，缺少必需的符号，您检查一下您的glibcxx版本是否发生过改变，按照这个思路去排查解决看看，如果还是不能解决，建议您联系专业的数据库运维机构去修复数据库。

问题解决了吗？我也出现这种情况了