[docker-compose]springboot 连接不到 mysql

问题：如题目所示

1 ，docker-compose_mysql.yml

version: '1' services: jeecg_boot_mysql: build: context: ./db environment: MYSQL_ROOT_PASSWORD: 123456 MYSQL_ROOT_HOST: '%' TZ: Asia/Shanghai restart: always hostname: jeecg_boot_mysql container_name: jeecg_boot_mysql image: "mysql:5.7.44" command: --character-set-server=utf8mb4 --collation-server=utf8mb4_general_ci --explicit_defaults_for_timestamp=true --lower_case_table_names=1 --max_allowed_packet=128M --bind-address=0.0.0.0 ports: - "3366:3306" networks: - szdz_network networks: szdz_network: name: szdz_network 

首先运行 mysql

2 ，然后往数据库导入数据

3 ，docker-compose.yml

version: '1' services: jeecg_boot_mysql: build: context: ./db environment: MYSQL_ROOT_PASSWORD: 123456 MYSQL_ROOT_HOST: '%' TZ: Asia/Shanghai restart: always hostname: jeecg_boot_mysql container_name: jeecg_boot_mysql image: "mysql:5.7.44" command: --character-set-server=utf8mb4 --collation-server=utf8mb4_general_ci --explicit_defaults_for_timestamp=true --lower_case_table_names=1 --max_allowed_packet=128M --bind-address=0.0.0.0 ports: - "3366:3306" networks: - szdz_network jeecg_boot_redis: image: "redis:7.2.4" ports: - "9379:6379" restart: always hostname: jeecg_boot_redis container_name: jeecg_boot_redis networks: - szdz_network jeecg_boot_system: build: context: ./jeecg-module-system/jeecg-system-start restart: on-failure depends_on: - jeecg_boot_redis - jeecg_boot_mysql container_name: jeecg_boot_system image: "registry.cn-hangzhou.aliyuncs.com/xuegao_zn_data/zn:20240515_1044" environment: "jeecg_boot_redis_host": "jeecg_boot_redis" "jeecg_boot_redis_port": "9379" "jeecg_boot_mysql_host": "jeecg_boot_mysql" "jeecg_boot_mysql_port": "3366" "jeecg_boot_mysql_database": "jeecg_boot" "jeecg_boot_mysql_username": "root" "jeecg_boot_mysql_password": "123456" hostname: jeecg_boot_system ports: - "8080:8080" networks: - szdz_network networks: szdz_network: name: szdz_network 

4 ，sprinboot

 datasource: master: url: jdbc:mysql://${jeecg_boot_mysql_host}:${jeecg_boot_mysql_port}/${jeecg_boot_mysql_database}?characterEncoding=UTF-8&useUnicode=true&useSSL=false&tinyInt1isBit=false&allowPublicKeyRetrieval=true&serverTimezOne=Asia/Shanghai&allowMultiQueries=true username: ${jeecg_boot_mysql_username} password: ${jeecg_boot_mysql_password} driver-class-name: com.mysql.cj.jdbc.Driver redis: database: 0 host: ${jeecg_boot_redis_host} port: ${jeecg_boot_redis_port} password: '' 

遇到问题： redis 可以正常的链接，但是 mysql 死活连不上

报错：

2024-05-15 18:35:53 2024-05-15 10:35:53.371[jeecg-system] [8082] [main] [ERROR] [,] [com.alibaba.druid.pool.DruidDataSource:943] - init datasource error, url: jdbc:mysql://jeecg_boot_mysql:3366/jeecg_boot?characterEncoding=UTF-8&useUnicode=true&useSSL=false&tinyInt1isBit=false&allowPublicKeyRetrieval=true&serverTimezOne=Asia/Shanghai&allowMultiQueries=true 2024-05-15 18:35:53 com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure 2024-05-15 18:35:53 2024-05-15 18:35:53 The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. 2024-05-15 18:35:53 at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174) 2024-05-15 18:35:53 at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64) 

我自己排查问题 1 ，我查询过 Google 和 openai ，但是没有找到解决办法 2 ，我查看过 docker network inspect szdz_network ，发现确实是在一个网络环境中。