docker搭建失败

[s7safe]

正常docker搭建，mysql启动失败

[s7safe]

mysql_1 | 2024-05-17T01:21:07.906538Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
mysql_1 | 2024-05-17T01:21:07.991299Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
mysql_1 | 2024-05-17T01:21:08.008425Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
mysql_1 | 2024-05-17T01:21:08.008603Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
mysql_1 | 2024-05-17T01:21:08.079362Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
mysql_1 | 2024-05-17T01:21:08.080078Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
mysql_1 | 2024-05-17T01:21:08.080402Z 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-001146 - Table 'mysql.component' doesn't exist
mysql_1 | 2024-05-17T01:21:08.080446Z 0 [Warning] [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-003543 - The mysql.component table is missing or has an incorrect definition.
mysql_1 | 2024-05-17T01:21:08.080666Z 0 [ERROR] [MY-000067] [Server] unknown variable 'default-authentication-plugin=mysql_native_password'.
mysql_1 | 2024-05-17T01:21:08.082030Z 0 [ERROR] [MY-010119] [Server] Aborting
mysql_1 | 2024-05-17T01:21:09.605572Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.4.0) MySQL Community Server - GPL.
mysql_1 | 2024-05-17T01:21:09.605613Z 0 [System] [MY-015016] [Server] MySQL Server - end.
mysql_1 | 2024-05-17 09:22:11+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.4.0-1.el9 started.
mysql_1 | 2024-05-17 09:22:12+08:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
mysql_1 | 2024-05-17 09:22:12+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.4.0-1.el9 started.
mysql_1 | '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
mysql_1 | 2024-05-17T01:22:14.277258Z 0 [System] [MY-015015] [Server] MySQL Server - start.
mysql_1 | 2024-05-17T01:22:15.201422Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.4.0) starting as process 1
mysql_1 | 2024-05-17T01:22:15.219775Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
mysql_1 | 2024-05-17T01:22:16.611350Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
mysql_1 | mysqld: Table 'mysql.plugin' doesn't exist
mysql_1 | 2024-05-17T01:22:17.201915Z 0 [ERROR] [MY-010735] [Server] Could not open the mysql.plugin table. Please perform the MySQL upgrade procedure.
mysql_1 | 2024-05-17T01:22:17.202478Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
mysql_1 | 2024-05-17T01:22:17.202793Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
mysql_1 | 2024-05-17T01:22:17.203102Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
mysql_1 | 2024-05-17T01:22:17.203694Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
mysql_1 | 2024-05-17T01:22:17.203903Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
mysql_1 | 2024-05-17T01:22:17.204175Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
mysql_1 | 2024-05-17T01:22:17.204370Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
mysql_1 | 2024-05-17T01:22:17.396823Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
mysql_1 | 2024-05-17T01:22:17.487794Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
mysql_1 | 2024-05-17T01:22:17.502071Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
mysql_1 | 2024-05-17T01:22:17.502131Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
mysql_1 | 2024-05-17T01:22:17.509487Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
mysql_1 | 2024-05-17T01:22:17.519455Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
mysql_1 | 2024-05-17T01:22:17.520206Z 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-001146 - Table 'mysql.component' doesn't exist
mysql_1 | 2024-05-17T01:22:17.520314Z 0 [Warning] [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-003543 - The mysql.component table is missing or has an incorrect definition.
mysql_1 | 2024-05-17T01:22:17.520832Z 0 [ERROR] [MY-000067] [Server] unknown variable 'default-authentication-plugin=mysql_native_password'.
mysql_1 | 2024-05-17T01:22:17.525253Z 0 [ERROR] [MY-010119] [Server] Aborting
mysql_1 | 2024-05-17T01:22:19.091325Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.4.0) MySQL Community Server - GPL.
mysql_1 | 2024-05-17T01:22:19.091359Z 0 [System] [MY-015016] [Server] MySQL Server - end.
mysql_1 | 2024-05-17 09:23:21+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.4.0-1.el9 started.
mysql_1 | 2024-05-17 09:23:22+08:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
mysql_1 | 2024-05-17 09:23:22+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.4.0-1.el9 started.
mysql_1 | '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
mysql_1 | 2024-05-17T01:23:23.611534Z 0 [System] [MY-015015] [Server] MySQL Server - start.
mysql_1 | 2024-05-17T01:23:24.977378Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.4.0) starting as process 1
mysql_1 | 2024-05-17T01:23:24.991043Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
mysql_1 | 2024-05-17T01:23:26.014000Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
mysql_1 | mysqld: Table 'mysql.plugin' doesn't exist
mysql_1 | 2024-05-17T01:23:26.602608Z 0 [ERROR] [MY-010735] [Server] Could not open the mysql.plugin table. Please perform the MySQL upgrade procedure.

[rfma]

docker-compose.yaml文件中，修订mysql基础镜像为：
mysql:
image: mysql:5.7.41
测试可通过！

[starscow]

试过了不行

[ComposerLM]

修改 docker-compose.yml 文件为如下文件--

version: '3'
services:
web:
build: .
restart: always
container_name: w5_web
#platform: "linux/amd64"
ports:
- "8888:8888"
depends_on:
- mysql
- redis
environment:
MYSQL_HOST: "mysql"
MYSQL_PORT: 3306
MYSQL_DATABASE: "w5_db"
MYSQL_USER: "root"
MYSQL_PASSWORD: "w5_12345678"
REDIS_HOST: "redis"
REDIS_PORT: 6379
REDIS_DATABASE: 0
REDIS_PASSWORD: ""
volumes:
- ./docker/config.ini:/w5/config.ini
- ./docker/apps:/w5/apps
- ./docker/logs:/opt
- /etc/localtime:/etc/localtime
networks:
- w5Net

mysql:
image: mysql:5.7
restart: always
container_name: w5_mysql
ports:
- "3306:3306"
volumes:
- ./docker/sql:/docker-entrypoint-initdb.d
- ./docker/conf.d:/etc/mysql/conf.d
- ./docker/mysql_db:/var/lib/mysql
environment:
MYSQL_ROOT_PASSWORD: "w5_12345678"
TZ: Asia/Shanghai
command:
--max_connections=1000
--character-set-server=utf8mb4
--collation-server=utf8mb4_general_ci
--default-authentication-plugin=mysql_native_password
networks:
- w5Net

redis:
image: redis:alpine
restart: always
container_name: w5_redis
environment:
REDIS_PASSWORD: ""
volumes:
- ./docker/redis_db:/data
networks:
- w5Net

networks:
w5Net:
driver: bridge

[15160412968]

试过了不行

需要先删除之前的mysql_db目录