This article is to document how to create MySQL docker container and use it in Java development.
Create a MySQL docker container
- Install docker toolbox (in this case, I use 1.9.1c)
- Open docker terminal
- Run following command
$ docker run --detach --env MYSQL_ROOT_PASSWORD=password1 --env MYSQL_USER=psun
--env MYSQL_PASSWORD=password1 --env MYSQL_DATABASE=netgloo_blog --name mys
ql --publish 3306:3306 mysql:latest
Run SQL command in the existing docker container
- Run following command to bring up a terminal with existing docker container
docker exec -it mysql bash - Now you should enter the bash prompt. So you can run following command to log into mysql -u root -p;
- You should enter mysql prompt. You can use following commands to do sql query
show databases;
use [database_name];
show tables;
select ... from ...;
docker-machine ip default
In my case, it's 192.168.99.100Clone the spring boot sample from https://github.com/netgloo/spring-boot-samples/tree/master/spring-boot-mysql-springdatajpa-hibernate
Open the project and modify IP and MySQL user credential in application.properties file.
# Connection url for the database "netgloo_blog"
spring.datasource.url = jdbc:mysql://192.168.99.100:3306/netgloo_blog
# Username and password
spring.datasource.username = root
spring.datasource.password = password1
After that run the project by running
mvn spring-boot:run