[Docker] Run MySQL in Docker Container

Running MySQL in a Docker Container is great for being able to emulate various environments. The more advanced containers will include a bunch of executables and runtimes that will allow you to do run more intricate commands. These commands can be very useful for sharing with other teams for testing purposes. It doesn't matter what runtimes they have on their end, by using the docker command, you'll be able to specify what runtimes to use to execute your code.

docker run -p 3306:3306 -d --name demo-db -e MYSQL_USER=user -e MYSQL_PASSWORD=mysql -e MYSQL_ROOT_PASSWORD=root mysql:5.7

You can stop the container:

docker ps ## to get running container id
docker stop <ID>

If you try to run the mysql again, you will get an error saying that demo-db already exist.
You can remove that container by:

docker rm demo-db

Later you can add --rm to tell docker remove previous container

docker run -p 3306:3306 -d --name demo-db -e MYSQL_USER=user -e MYSQL_PASSWORD=mysql -e MYSQL_ROOT_PASSWORD=root --rm mysql:5.7