Dockerizing a MySQL Database: Step-by-Step Tutorial

Dockerizing a MySQL Database: Step-by-Step Tutorial

Here is a step-by-step tutorial on how to dockerize a MySQL database:

Step 1: Install Docker
– Make sure you have Docker installed on your machine. You can download and install Docker from the official website (

Step 2: Create a Dockerfile
– Create a new file called "Dockerfile" in your project directory.
– Open the Dockerfile and add the following content:

FROM mysql:latest
COPY ./sql-scripts/ /docker-entrypoint-initdb.d/

– In this example, we are using the latest version of the MySQL Docker image as the base image.
– We set the root password, create a new database, and create a new user with a password.
– We also copy any SQL scripts from the "sql-scripts" directory to the Docker container’s initialization directory.

Step 3: Create SQL Scripts
– Create a new directory called "sql-scripts" in your project directory.
– Add any SQL scripts that you want to run during the initialization of the MySQL database to this directory.

Step 4: Build the Docker Image
– Open a terminal or command prompt and navigate to your project directory.
– Run the following command to build the Docker image:

docker build -t my-mysql .

– This command builds the Docker image using the Dockerfile in the current directory and tags it as "my-mysql".

Step 5: Run the Docker Container
– Run the following command to start a new Docker container from the image:

docker run -d -p 3306:3306 –name my-mysql-container my-mysql

– This command starts a new Docker container named "my-mysql-container" from the "my-mysql" image.
– The "-d" flag runs the container in detached mode.
– The "-p" flag maps the container’s port 3306 to the host’s port 3306, allowing you to access the MySQL database from your machine.

Step 6: Verify the MySQL Database
– Open a MySQL client (such as MySQL Workbench or the MySQL command-line client) and connect to the MySQL database running in the Docker container.
– Use the credentials you specified in the Dockerfile (root password, database name, user, and password) to connect to the database.
– Verify that the database and tables created by your SQL scripts are present and functioning correctly.

That’s it! You have successfully dockerized a MySQL database. You can now distribute and run your MySQL database as a Docker container on any machine with Docker installed.

Let's talk

If you want to get a free consultation without any obligations, fill in the form below and we'll get in touch with you.