【待反馈】mysql无法启动
为了能快速了解并处理您的问题，请提供以下基础信息：面板、插件版本：免费版 8.0.3系统版本：Ubuntu 20.04.6 LTS x86_64(Py3.7.9)
ubuntu中安装好之后mysql能安装但是不能启动
相关截图（日志、错误）：
2023-10-24T16:02:38.822531Z 0 option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824.
2023-10-24T16:02:38.822582Z 0 'binlog_format' is deprecated and will be removed in a future release.
2023-10-24T16:02:38.822645Z 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.
2023-10-24T16:02:38.822750Z 0 '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 /www/server/mysql/bin/mysqld (mysqld 8.0.34) starting as process 243595
2023-10-24T16:02:38.906156Z 0 option 'innodb-read-io-threads': unsigned value 128 adjusted to 64.
2023-10-24T16:02:38.906206Z 0 option 'innodb-write-io-threads': unsigned value 128 adjusted to 64.
2023-10-24T16:02:38.907129Z 0 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 InnoDB initialization has started.
2023-10-24T16:02:40.183999Z 1 InnoDB initialization has ended.
2023-10-24T16:02:41.523803Z 0 CA certificate ca.pem is self signed.
2023-10-24T16:02:41.523877Z 0 Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2023-10-24T16:02:41.572907Z 0 X Plugin ready for connections. Socket: /tmp/mysqlx.sock
2023-10-24T16:02:41.572934Z 0 /www/server/mysql/bin/mysqld: ready for connections. Version: '8.0.34'socket: '/tmp/mysql.sock'port: 0Source distribution.
2023-10-24T16:02:43.898224Z 7 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 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 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 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 option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824.
2023-10-24T16:02:48.173605Z 0 'binlog_format' is deprecated and will be removed in a future release.
2023-10-24T16:02:48.173687Z 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.
2023-10-24T16:02:48.173783Z 0 '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 /www/server/mysql/bin/mysqld (mysqld 8.0.34) starting as process 244511
2023-10-24T16:02:48.227745Z 0 option 'innodb-read-io-threads': unsigned value 128 adjusted to 64.
2023-10-24T16:02:48.227805Z 0 option 'innodb-write-io-threads': unsigned value 128 adjusted to 64.
2023-10-24T16:02:48.228742Z 0 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 InnoDB initialization has started.
2023-10-24T16:02:50.575549Z 1 InnoDB initialization has ended.
2023-10-24T16:02:50.854564Z 0 Starting XA crash recovery...
2023-10-24T16:02:50.866435Z 0 XA crash recovery finished.
2023-10-24T16:02:51.097806Z 0 CA certificate ca.pem is self signed.
/www/server/data
您好，安装好后您那边有调整过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。 问题解决了吗楼主
页:
[1]