DEV Community

loading...

Using MySQL with Docker

Rafael Ahrons
A passionate C# developer trying to make some games and have fun while coding
Originally published at luturol.github.io ・1 min read

Using MySQL with Docker

What you need to have installed:

  • Docker

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
Enter fullscreen mode Exit fullscreen mode

Run a container

docker run -e MYSQL_ALLOW_EMPTY_PASSWORD=yes -v folderForVolume:/var/lib/mysql mysql:5.7
Enter fullscreen mode Exit fullscreen mode

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

  1. You need to get the container ID from your mysql container.

    docker container ls
    
  2. 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.

  3. Enter MySQL

    mysql
    

    If it works, then will show in the console that you are inside the mysql. To test just execute a

    show databases

    to check.

References

Discussion (0)