无法与MySQL服务器连接到Docker中的Spring应用程序？

Question

 tomcat container
    FROM tomcat:8.0.20-jre8
    COPY /target/CTH.war /usr/local/tomcat/webapps/

  version: '3'
services:
  mysql-standalone:
    image: 'mysql:5.7'
    command: mysqld --character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_ci
    volumes:
      - ./docker/provision/mysql/init:/docker-entrypoint-initdb.d
    environment:
      - MYSQL_ROOT_PASSWORD= root
      - MYSQL_USER= root
      - MYSQL_PASSWORD= root
      - MYSQL_DATABASE= CTH
      - MYSQL_DATABASE= CTH_CHAT
    ports:
      - "3307:3306"
  cth-docker-container:
    image: cth-docker-container
    ports:
      - "8082:8082"
    environment:
      CTH_DATASOURCE_DATABASE: CTH
      CTH_DATASOURCE_SERVERNAME: mysql-standalone
      CTH_DATASOURCE_USERNAME: root
      CTH_DATASOURCE_PASSWORD: root
      CTH_DATASOURCE_PORT: 3307

      CTH_CHAT_DATASOURCE_DATABASE: CTH_CHAT
      CTH_CHAT_DATASOURCE_SERVERNAME: mysql-standalone
      CTH_CHAT_DATASOURCE_USERNAME: root
      CTH_CHAT_DATASOURCE_PASSWORD: root
      CTH_CHAT_DATASOURCE_PORT: 3307

    build:
      context: "./"
      dockerfile: "Dockerfile"
    depends_on:
      - mysql-standalone

application.properties：这是spring mvc应用程序，应用程序使用带有两个数据库的MySQL db

1st db
dbuser.local=${CTH_DATASOURCE_USERNAME:root}
dbpassword.local=${CTH_DATASOURCE_PASSWORD:root}
dbdatabaseName.local=${CTH_DATASOURCE_DATABASE:CTH}
dbserverName.local=${CTH_DATASOURCE_SERVERNAME:localhost}
dbportNumber.local=${CTH_DATASOURCE_PORT:3306} 

2nd db
dbuser.cth.chat.local=${CTH_CHAT_DATASOURCE_USERNAME:root}
dbpassword.cth.chat.local=${CTH_CHAT_DATASOURCE_PASSWORD:root}
dbdatabaseName.cth.chat.local=${CTH_CHAT_DATASOURCE_USERNAME:CTH_CHAT}
dbserverName.cth.chat.local=${CTH_CHAT_DATASOURCE_SERVERNAME:localhost}
dbportNumber.cth.chat.local=${CTH_CHAT_DATASOURCE_PORT:3306}

我阅读了创建dockerfile和docker-compose文件的文章https://medium.com/@asce4s/dockerize-spring-mvc-application-a9ffbd11eadb https://github.com/abagayev/docker-bootstrap-collection/tree/master/mysql-figh-databases/docker/provision/mysql/init

但当我执行docker-compose-f docker-compose.yml时，会出现错误

如果我设置了错误的环境或者我的方法不正确，你有什么建议，我一定会帮助我的，谢谢！

Answer 1

在阅读了大量文章之后，我成功地在docker容器中使用MySQL db并在MySQL Workbench中访问应用程序。

这是我的docker-compose文件

version: '3'

services:
  app:
    container_name: cth-app
    build:
      context: .
      dockerfile: Dockerfile
    ports:
      - '8080:8080'
    environment:
      ##db1
      CTH_DATASOURCE_DATABASE: CTH
      CTH_DATASOURCE_HOST: mysqldb
      CTH_DATASOURCE_USERNAME: cth
      CTH_DATASOURCE_PASSWORD: root
      CTH_DATASOURCE_PORT: 3306

      ##db2
      CTH_CHAT_DATASOURCE_DATABASENAME: CTH_CHAT
      CTH_CHAT_DATASOURCE_HOST: mysqldb
      CTH_CHAT_DATASOURCE_USERNAME: cth
      CTH_CHAT_DATASOURCE_PASSWORD: root
      CTH_CHAT_DATASOURCE_PORT: 3306
    depends_on:
      - mysqldb

  mysqldb:
    image: mysql/mysql-server:5.7
    container_name: mysqldb
    command: mysqld --character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_ci
    ##here i am able to access dump file which I'll create two databases 
      with user created for me.
    volumes:
      - ./docker/provision/mysql/init:/docker-entrypoint-initdb.d
    ports:
      - '3308:3306'
    environment:
        MYSQL_ROOT_PASSWORD: root
        MYSQL_USER: cth
        MYSQL_PASSWORD: root

您需要创建一个转储文件，请参阅文章[https://github.com/abagayev/docker-bootstrap-collection/tree/master/mysql-figh-databases]

当您将docker-compose up-d--build

您的应用程序在端口8080上运行，MySQL DB在主机内运行

谢谢！