配置Spring Boot Docker和Mysql [英] Configuring Spring boot Docker and Mysql

问题描述

我是Spring Boot和Docker的新手.

I am new to Spring Boot and Docker.

我正在尝试创建一个连接到mysql并使用Docker来运行两者的Spring Boot应用程序.

I am trying to create a Spring Boot application connecting to mysql and using Docker to run both.

我遵循的步骤 Step1 -创建了mysql映像并开始运行它.

Steps I followed Step1 - Created mysql image and started running it.

docker run --name=docker-mysql --env="MYSQL_ROOT_PASSWORD=root" --env="MYSQL_PASSWORD=root" --env="MYSQL_DATABASE=test" mysql

Step2 创建了SpringBoot应用程序

Step2 Created a SpringBoot application

docker build -f Dockerfile -t gradle-springboot-docker .

Step3 运行Spring Boot应用程序并与Mysql链接

Step3 Ran the Spring Boot app and linked with Mysql

docker run -t --name gradle-springboot-docker --link docker-mysql:mysql -p 8080:8080 gradle-springboot-docker

它给mysql提供了基本的连接错误.我已经列出了以下application.properties.自从我使用Docker以来，我的连接信息正确吗? mysql的主机是什么?

It gives basic connection error to mysql. I have listed the below application.properties. Is my connection information correct since I am using Docker. What would be the host for mysql?

SSL properties
server.port=8080

#DataSource
datasource.driver = com.mysql.jdbc.Driver
datasource.url= jdbc:mysql://localhost:3306/test? 
autoReconnect=true&useSSL=false            
datasource.username=root
datasource.password=root

# Hibernate
hibernate.dialect = org.hibernate.dialect.MySQL5Dialect
hibernate.show_sql = true
hibernate.lazy = true
hibernate.max_fetch_depth = 3
hibernate.packagesToScan = com.springboot.poc
# Once DB is created change below property to 'update'
hibernate.hbm2ddl.auto = update

推荐答案

您应该使用mysql的容器名称作为主机名，因为这些链接在一起，因此从春天开始就可以通过其名称发现mysql容器.因此，您需要将datasource.url= jdbc:mysql://localhost:3306/test?更改为datasource.url= jdbc:mysql://docker-mysql:3306/test?

You should use the container name of mysql as the hostname, since these are linked the mysql container is discoverable by its name from spring. So you need to change datasource.url= jdbc:mysql://localhost:3306/test? to datasource.url= jdbc:mysql://docker-mysql:3306/test?

或者您可以使用别名，如@ g00glen00b建议的那样，例如:datasource.url= jdbc:mysql://mysql:3306/test?

Or you can use the alias, as @g00glen00b suggested, like: datasource.url= jdbc:mysql://mysql:3306/test?

这篇关于配置Spring Boot Docker和Mysql的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！