In the examples, we will use Docker version 20.10.10, build b485636 on a Mac.

Basic knowledge of Docker and related commands like docker build, run, execute, etc will be useful for this guide.

Prerequisites #īefore we get our hands dirty with some code and CLI commands, below are some good to have prerequisites: In the next section, we will list out some good to have things prior to jumping into the code to run MySQL with Docker. To know the above reasons in a bit more detail please do read the why use docker post.

A new team member can be productive in hours, not days given docker and other tools are set up in an efficient way.

Usually with docker, if it runs on your machine it will run on another software engineer’s machine, on a staging environment, and on production too, given some compatibility is maintained.

Using any version of MySQL like 5.6, 5.7, or 8 as per project or any other reason is very easy.

There are multiple great reasons to use any database including MySQL with Docker for local development, some of them are as follows: Why use MySQL with Docker for local development #

Adding MySQL to and existing Node.js app using docker-compose.

Why use MySQL with Docker for local development.

In this tutorial, we will detail how to use MySQL with Docker and docker-compose step-by-step keeping things easy to comprehend. Using MySQL with Docker and docker-compose makes it very easy and fast to test out any changes in any application using MySQL as the database. # Install docker-compose v1.MySQL is one of the most popular relational databases of all time. # Setup a virutalenv $ virtualenv -python =(which python3 ). # Disable docker-compose from using the Docker CLI when executing a build # Fish shell # $ set -gx COMPOSE_DOCKER_CLI_BUILD 0 # Bash $ export COMPOSE_DOCKER_CLI_BUILD =0 # Get the list of connections $ podman system connection ls # Set the DOCKER_HOST variable (docker server) # Fish shell # $ set -gx DOCKER_HOST # Bash $ export DOCKER_HOST = # Test $ docker version # Host: MacOS # Edit the ~/.ssh/config and add the following to the bottom $ sudo sed -i 's/short-name-mode='enforcing'/short-name-mode='permissive'/g' /etc/containers/nf

bashrc for the user core $ vi ~/.bashrcĭocker () # Reduce this security feature to be on-par with the experience we're used to with Docker. # SSH into the machine $ podman machine ssh

# Start the machine $ podman machine start # Start a podman machine with 2 vCPUs and 4GBs of RAM and 15GBs of Disk space $ podman machine init -cpus 2 -m 4096 -disk-size 15

Docker for mac compose version