Using MySQL with Docker
What you need to have installed:
With you want to learn more about Docker, you can check my blog post about it by clicking here
Downloading MySQL Image
docker image pull mysql:5.7
Run a container
docker run -e MYSQL_ALLOW_EMPTY_PASSWORD=yes -v folderForVolume:/var/lib/mysql mysql:5.7
Change folderForVolume for a path from a folder to create the volume.
What this command does
It will initialize your container and show you the logs while is initializing, so you can track if some errors appear in the console log.
-e will add MYSQL_ALLOW_EMPTY_PASSWORD environment variable with the value yes. With that, you can enter in mysql without a password.
-v will create a volume with the container to share some data between your pc and the container. With this, you will be able to create another container with the same data without losing any tables or queries.
Entering the container
You need to get the container ID from your mysql container.
docker container ls
With the container Id, now you can enter using the following command:
docker exec -it containerID bash
It will enter inside the container with a bash terminal executing.
If it works, then will show in the console that you are inside the mysql. To test just execute a
show databasesto check.