人生中有些事是不得不做的，于不得不做中勉强去做，是毁灭；于不得不做中做的好，是勇敢。——叶弥《成长如蜕》
今天按照我我这篇博客# docker-compose安装mysql并指定忽略表名大小写以及挂载配置文件踩坑了
发现报错
代码语言：javascript复制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原来是有个值出问题了，我们改一下my.cnf
[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去掉了NO_AUTO_CREATE_USER就好了
