【已完成】9.2面板默认安装mysql 9 后因默认配置文件无法启动
默认安装mysql 9.0.1的时候 因默认配置文件中的 query_cache_type=1 导致无法启动注释后恢复正常
2024-11-24T03:25:36.328968Z 0 MySQL Server - start.
2024-11-24T03:25:36.575399Z 0 option ＇max_allowed_packet＇: unsigned value 107374182400 adjusted to 1073741824.
2024-11-24T03:25:36.575430Z 0 ＇binlog_format＇ is deprecated and will be removed in a future release.
2024-11-24T03:25:36.575477Z 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.
2024-11-24T03:25:36.575564Z 0 /www/server/mysql/bin/mysqld (mysqld 9.0.1) starting as process 1087456
2024-11-24T03:25:36.597390Z 0 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.
2024-11-24T03:25:36.599046Z 1 InnoDB initialization has started.
2024-11-24T03:25:37.056261Z 1 InnoDB initialization has ended.
2024-11-24T03:25:37.374952Z 0 CA certificate ca.pem is self signed.
2024-11-24T03:25:37.374984Z 0 Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2024-11-24T03:25:37.381223Z 0 unknown variable ＇query_cache_type=1＇.
2024-11-24T03:25:37.381910Z 0 Aborting
2024-11-24T03:25:38.947201Z 0 /www/server/mysql/bin/mysqld: Shutdown complete (mysqld 9.0.1)Source distribution.
2024-11-24T03:25:38.947225Z 0 MySQL Server - end.
您好，这个问题如果没有解决的话，请重新发帖哈，这篇帖子就关闭了
页:
[1]