docker-compose安装mysql坑

2023-08-30 19:42:34 2023-08-30T11:42:34.815640Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-08-30 19:42:36 2023-08-30 11:42:36+00:00 [ERROR] [Entrypoint]: mysqld failed while attempting to check config
2023-08-30 19:42:36     command was: mysqld --default-authentication-plugin=mysql_native_password --lower_case_table_names=1 --verbose --help --log-bin-index=/tmp/tmp.0M9uzTlVJk
2023-08-30 19:42:36     2023-08-30T11:42:36.592544Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
2023-08-30 19:42:36 2023-08-30T11:42:36.592567Z 0 [ERROR] [MY-000077] [Server] /usr/sbin/mysqld: Error while setting value 'STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' to 'sql_mode'.
2023-08-30 19:42:36 2023-08-30T11:42:36.593741Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-08-30 19:42:39 2023-08-30 11:42:39+00:00 [ERROR] [Entrypoint]: mysqld failed while attempting to check config
2023-08-30 19:42:39     command was: mysqld --default-authentication-plugin=mysql_native_password --lower_case_table_names=1 --verbose --help --log-bin-index=/tmp/tmp.TTCHBVqF9r
2023-08-30 19:42:39     2023-08-30T11:42:39.955222Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
2023-08-30 19:42:39 2023-08-30T11:42:39.955244Z 0 [ERROR] [MY-000077] [Server] /usr/sbin/mysqld: Error while setting value 'STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' to 'sql_mode'.
2023-08-30 19:42:39 2023-08-30T11:42:39.956426Z 0 [ERROR] [MY-010119] [Server] Aborting

[mysqld]
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
character_set_server=utf8mb4