docker-compose mysql 起不来

[tarihub]

What Happend

执行

MYSQL_ROOT_PASSWORD=$(openssl rand -base64 16) docker-compose up -d

Error Messages

报错

mysql-local-1  | 2025-07-01 01:10:24+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.42-1.el9 started.
mysql-local-1  | 2025-07-01 01:10:24+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
mysql-local-1  | 2025-07-01 01:10:24+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.42-1.el9 started.
mysql-local-1  | 2025-07-01 01:10:24+00:00 [Note] [Entrypoint]: Initializing database files
mysql-local-1  | 2025-07-01T01:10:24.775653Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
mysql-local-1  | 2025-07-01T01:10:24.775677Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.42) initializing of server in progress as process 80
mysql-local-1  | 2025-07-01T01:10:24.792963Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
mysql-local-1  | 2025-07-01T01:10:25.038482Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
mysql-local-1  | 2025-07-01T01:10:25.592857Z 0 [ERROR] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-000029 - File '/docker-entrypoint-initdb.d/init.sql' not found (OS errno 1 - Operation not permitted)
mysql-local-1  | 2025-07-01T01:10:25.593167Z 0 [ERROR] [MY-010455] [Server] Failed to open the bootstrap file /docker-entrypoint-initdb.d/init.sql
mysql-local-1  | 2025-07-01T01:10:25.593183Z 0 [ERROR] [MY-013236] [Server] The designated data directory /var/lib/mysql/ is unusable. You can remove all files that the server added to it.
mysql-local-1  | 2025-07-01T01:10:25.593197Z 0 [ERROR] [MY-010119] [Server] Aborting
mysql-local-1  | 2025-07-01T01:10:27.398801Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.42)  MySQL Community Server - GPL.
mysql-local-1 exited with code 1

Environment

• OS: macos arm

Additional Context

解决方法，docker compose mysql 部分改为如下

  mysql-local:
    image: mysql:8.0
    command: --default-authentication-plugin=mysql_native_password

    environment:
      MYSQL_ROOT_PASSWORD: ${MYSQL_ROOT_PASSWORD}
    volumes:
      - "db-data:/var/lib/mysql"
      - "$PWD/db/my.cnf:/etc/my.cnf"
      # - "$PWD/db/init.sql:/docker-entrypoint-initdb.d/init.sql"
    ports:
      - "3306:3306"

mysql 起来后手动导入 init.sql

mycli -h 127.0.0.1 -uroot  < db/init.sql

网上也遇到挺多用 init file 出错的，暂时不知道啥根本原因

因为 docker 里 目录看着权限还挺正常，mysql用户也能读

drwxr-xr-x   1 root root  16 Jul  1 01:44 docker-entrypoint-initdb.d

-rw-r--r-- 1 root root 54K Jul  1 01:00 init.sql

[j3ttt]

感谢 @tarihub 调试。根本原因是我们的配置让 init.sql被执行了两次

1. 第一次：mysql --init-file /docker-entrypoint-initdb.d/init.sql
2. 第二次：mysql 容器的entrypoint.sh 里面也会执行 /docker-entrypoint-initdb.d/*

直接原因是执行两次 init.sql 会导致类似下面这种语句报错，无法 ADD COLUMN 两次。

ALTER TABLE `collector_log`
    ADD COLUMN `collector_record_id` bigint(20) unsigned DEFAULT NULL COMMENT '采集记录id';

（并且mysql语法不支持 ADD COLUMN IF NOT EXISTS）

[tarihub]

感谢 @tarihub 调试。根本原因是我们的配置让 init.sql被执行了两次

1. 第一次：mysql --init-file /docker-entrypoint-initdb.d/init.sql
2. 第二次：mysql 容器的entrypoint.sh 里面也会执行 /docker-entrypoint-initdb.d/*

直接原因是执行两次 init.sql 会导致类似下面这种语句报错，无法 ADD COLUMN 两次。

ALTER TABLE `collector_log`
    ADD COLUMN `collector_record_id` bigint(20) unsigned DEFAULT NULL COMMENT '采集记录id';

（并且mysql语法不支持 ADD COLUMN IF NOT EXISTS）

还是有点问题

docker logs

2025-07-01 13:21:43+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.42-1.el9 started.
2025-07-01 13:21:43+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2025-07-01 13:21:43+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.42-1.el9 started.
ls: cannot open directory '/docker-entrypoint-initdb.d/': Operation not permitted