The first part is the path in the host machine. It comprises two fields separated by a colon. It maps the port 3307 on the host to port 3306 on the container.įinally, the volume tag is used to mount a folder from the host machine to the container.

The ports tag is used to define both host and container ports. Under the environment tag, we have defined the environment variables, which we will use for database authentication. It restarts the container when either the Docker daemon restarts or the container itself is manually restarted. For example, you don’t have to start the container every time you reboot your machine manually. When we use always for the restart tag, the container always restarts. To make our setup process quick and easy, we are using the pre-built official image of MySQL for the image tag. For our application, we only have one service called db.

Inside this, we have to define the services we want to use for our application. We follow our version tag by the services hash. Get more information on Compose file formats from Docker’s documentation here. There are other file formats - 1, 2, 2.x, and 3.x. version: '3.1' services: db: image: mysql restart: always environment: MYSQL_ROOT_PASSWORD: root MYSQL_DATABASE: test_db ports: - '3307:3306' volumes: - $HOME/Desktop/MySQL-Snippets/school.sql:/school.sqlįirst, we are using a version tag to define the Compose file format, which is 3.1. Let’s break down the individual ingredients of the docker-compose.yml file. The MySQL command-line client can run these commands and send them to the MySQL server. MySQL-dump: A mysql-dump contains MySQL queries in plain text.

It’s helpful when your application has multiple stacks, such as a web server and a database server. Docker Compose: We can use Docker compose to run multiple containers and define their properties inside a YAML file.The folder name used in this setup is MySQL-Snippets. We need to put both docker-compose.yml and school.sql files inside the same folder.

For this example, we will use a Docker compose file, a SQL file containing bootstrap data, also known as mysql-dump and macOS.

How to run mysql docker on mac