[docker-compose]springboot 连接不到 mysql

[RedBeanIce]

问题：如题目所示

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 ，发现确实是在一个网络环境中。

[q0000001]

你走容器内网络就不需要 3366 的端口，走 3306 就行。3366 是映射到宿主机的

[RedBeanIce]

@q0000001 感谢！！我去试试！

[q0000001]

@RedBeanIce 但是你说 redis 能连，我持怀疑态度。等你反馈

[RedBeanIce]

@q0000001 果然是大佬所言，

我将 3366 改为 3306 ，整个部署就正常了。

[keakon]

提醒一下，如果你不需要在外部访问 mysql ，只需要 jeecg_boot_system 能访问到 jeecg_boot_mysql ，那么不需要配置 ports ，同一个 network 下可以互相访问。暴露数据库是有风险的。

[RedBeanIce]

@keakon 感谢指点。