9.2面板默认安装mysql 9 后因默认配置文件无法启动

默认安装mysql 9.0.1的时候 因默认配置文件中的 query_cache_type=1 导致无法启动
注释后恢复正常

1. 2024-11-24T03:25:36.328968Z 0 [System] [MY-015015] [Server] MySQL Server - start.
   
2. 2024-11-24T03:25:36.575399Z 0 [Warning] [MY-000081] [Server] option ＇max_allowed_packet＇: unsigned value 107374182400 adjusted to 1073741824.
   
3. 2024-11-24T03:25:36.575430Z 0 [Warning] [MY-011070] [Server] ＇binlog_format＇ is deprecated and will be removed in a future release.
   
4. 2024-11-24T03:25:36.575477Z 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.
   
5. 2024-11-24T03:25:36.575564Z 0 [System] [MY-010116] [Server] /www/server/mysql/bin/mysqld (mysqld 9.0.1) starting as process 1087456
   
6. 2024-11-24T03:25:36.597390Z 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.
   
7. 2024-11-24T03:25:36.599046Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
   
8. 2024-11-24T03:25:37.056261Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
   
9. 2024-11-24T03:25:37.374952Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
   
10. 2024-11-24T03:25:37.374984Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
    
11. 2024-11-24T03:25:37.381223Z 0 [ERROR] [MY-000067] [Server] unknown variable ＇query_cache_type=1＇.
    
12. 2024-11-24T03:25:37.381910Z 0 [ERROR] [MY-010119] [Server] Aborting
    
13. 2024-11-24T03:25:38.947201Z 0 [System] [MY-010910] [Server] /www/server/mysql/bin/mysqld: Shutdown complete (mysqld 9.0.1)  Source distribution.
    
14. 2024-11-24T03:25:38.947225Z 0 [System] [MY-015016] [Server] MySQL Server - end.

复制代码