当前位置:论坛首页 > Linux面板 > 求助

【待反馈】mysql无法启动

发表在 Linux面板2023-10-25 00:20 [复制链接] 2 1478

为了能快速了解并处理您的问题,请提供以下基础信息:
面板、插件版本:免费版   8.0.3

系统版本:Ubuntu 20.04.6 LTS x86_64(Py3.7.9)
ubuntu中安装好之后mysql能安装但是不能启动

相关截图(日志、错误):

2023-10-24T16:02:38.822531Z 0 [Warning] [MY-000081] [Server] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824.
2023-10-24T16:02:38.822582Z 0 [Warning] [MY-011070] [Server] 'binlog_format' is deprecated and will be removed in a future release.
2023-10-24T16:02:38.822645Z 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-24T16:02:38.822750Z 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-24T16:02:38.822784Z 0 [System] [MY-010116] [Server] /www/server/mysql/bin/mysqld (mysqld 8.0.34) starting as process 243595
2023-10-24T16:02:38.906156Z 0 [Warning] [MY-000081] [Server] option 'innodb-read-io-threads': unsigned value 128 adjusted to 64.
2023-10-24T16:02:38.906206Z 0 [Warning] [MY-000081] [Server] option 'innodb-write-io-threads': unsigned value 128 adjusted to 64.
2023-10-24T16:02:38.907129Z 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=4294967296. Please use innodb_redo_log_capacity instead.
2023-10-24T16:02:38.909370Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-10-24T16:02:40.183999Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-10-24T16:02:41.523803Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2023-10-24T16:02:41.523877Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2023-10-24T16:02:41.572907Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: /tmp/mysqlx.sock
2023-10-24T16:02:41.572934Z 0 [System] [MY-010931] [Server] /www/server/mysql/bin/mysqld: ready for connections. Version: '8.0.34'  socket: '/tmp/mysql.sock'  port: 0  Source distribution.
2023-10-24T16:02:43.898224Z 7 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2023-10-24T16:02:44.014066Z 7 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2023-10-24T16:02:44.072479Z 7 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2023-10-24T16:02:44.084811Z 8 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2023-10-24T16:02:48.173555Z 0 [Warning] [MY-000081] [Server] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824.
2023-10-24T16:02:48.173605Z 0 [Warning] [MY-011070] [Server] 'binlog_format' is deprecated and will be removed in a future release.
2023-10-24T16:02:48.173687Z 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-24T16:02:48.173783Z 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-24T16:02:48.173816Z 0 [System] [MY-010116] [Server] /www/server/mysql/bin/mysqld (mysqld 8.0.34) starting as process 244511
2023-10-24T16:02:48.227745Z 0 [Warning] [MY-000081] [Server] option 'innodb-read-io-threads': unsigned value 128 adjusted to 64.
2023-10-24T16:02:48.227805Z 0 [Warning] [MY-000081] [Server] option 'innodb-write-io-threads': unsigned value 128 adjusted to 64.
2023-10-24T16:02:48.228742Z 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=4294967296. Please use innodb_redo_log_capacity instead.
2023-10-24T16:02:48.231007Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-10-24T16:02:50.575549Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-10-24T16:02:50.854564Z 0 [System] [MY-010229] [Server] Starting XA crash recovery...
2023-10-24T16:02:50.866435Z 0 [System] [MY-010232] [Server] XA crash recovery finished.
2023-10-24T16:02:51.097806Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
/www/server/data

使用道具 举报 只看该作者 回复
发表于 2023-10-25 09:24:20 | 显示全部楼层
您好,安装好后您那边有调整过MySQL的配置文件吗?您提供的日志内Please use innodb_redo_log_capacity instead.这个是让您更换到这个参数使用。其次还有option 'innodb-write-io-threads': unsigned value 128 adjusted to 64.错误,这个错误是指innodb-write-io-threads的值128调整为64。
使用道具 举报 回复 支持 反对
发表于 2024-3-9 17:40:23 | 显示全部楼层
问题解决了吗楼主
使用道具 举报 回复 支持 反对
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

普通问题处理

论坛响应时间:72小时

问题处理方式:排队(仅解答)

工作时间:白班:9:00 - 18:00

紧急运维服务

响应时间:3分钟

问题处理方式:宝塔专家1对1服务

工作时间:工作日:9:00 - 18:30

宝塔专业团队为您解决服务器疑难问题

立即付费处理

工作时间:09:00至24:00

快速回复 返回顶部 返回列表