Today I’m going to show you how can you can use Docker to run MySQL Server in your development environment. Using Docker to run MySQL is much easier than manually installing it and for when you have multiple instances of MySQL running at the same time. I’m assuming that you already have Docker Community Edtion install on your machine. If you do not have Docker installed follow the instruction here for your operating system.
If you search online for how to install MySQL using Docker, you will see many different examples on how to do this. I’m going to show how to do it so that you can connect to the database from your IDE and from the applications you are developing.
Type this command at the terminal:
$ docker run -p 3306:3306 --name hb-mysql-example -e MYSQL_ROOT_PASSWORD=Buster -d mysql
Let’s cover what each part of this command is doing:
You use this following command to list which containers are running:
$ docker ps
This command will output something like this to the terminal:
Containers do not start up by default when you turn on your machine or do a restart of your machine. Here I will show you how to start, stop and restart containers.
To start a container, you use this command: docker start containerName.
To start the hb-mysql-example container use this command:
$ docker start hb-mysql-example
To restart a container, you use this command: docker restart containerName.
To restart the hb-mysql-example container use this command:
$ docker restart hb-mysql-example
To stop a container, you use this command: docker stop containerName.
To stop the hb-mysql-example container use this command:
$ docker stop hb-mysql-example
Here I will how to connect to MySQL using IntelliJ. If you do not have IntelliJ, you can download it here.
Follow these steps:
You are now connected to MySQL and can start working with MySQL.
In this post, you learned how to install MySQL using docker, how to start, restart, and stop containers. You also learn how to connect to MySQL from IntelliJ.
Please log in again. The login page will open in a new window. After logging in you can close it and return to this page.