阿超 > docker-compose安装mysql坑

docker-compose安装mysql坑

2023-08-30

运维

人生中有些事是不得不做的，于不得不做中勉强去做，是毁灭；于不得不做中做的好，是勇敢。——叶弥《成长如蜕》

今天按照我我这篇博客# docker-compose安装mysql并指定忽略表名大小写以及挂载配置文件踩坑了

发现报错

1
2
3
4
5
6
7
8
9
10
11
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

1
2
3
[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就好了