Docker provides a lightweight, portable, and efficient containerization platform, while MySQL offers a robust relational database system. In this article, we will explore the steps about how to setup MySQL Database in a Docker container with docker-compose script.
Looking out to setup PostgreSQL in Docker container? This article will walk you through the step-by-step process to setup PostgreSQL in a Docker container.
Table of Contents
Benefits of using MySQL in Docker
- Portability: Docker containers encapsulate the MySQL environment, ensuring consistent behavior across different systems.
- Ease of Deployment: Docker simplifies MySQL deployment, reducing setup time and ensuring reproducibility in various environments.
- Version Control: Docker lets you keep track of different versions of MySQL images, making it easy to go back to a previous state if needed.
- Infrastructure as Code (IaC): Include MySQL containers in your infrastructure code practices to improve automation.
How to Setup MySQL Database in Docker
Creating a MySQL database in Docker is a simple way for developers and system administrators to handle databases in a consistent and repeatable way. In this easy guide, we’ll walk you through the steps of setting up MySQL in Docker.
Create a Docker Compose Script
Start by making a Docker Compose script. In it, you’ll define the MySQL image and set up the credentials. The script fetches the latest image from the registry and creates a user profile with an initial database.
Generate a docker-compose.yml file with the following content. Customize the username, password, and database name as per your specific requirements.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 | # // docker-compose.yml version: '3.8' services: mysql: image: mysql:latest container_name: mysql environment: MYSQL_ROOT_PASSWORD: sb1234 MYSQL_DATABASE: sbdb MYSQL_USER: stackblogger MYSQL_PASSWORD: sb123 ports: - "3306:3306" volumes: - mysql_data:/var/lib/mysql volumes: mysql_data: |
This file helps create a MySQL service with specific settings, making sure data stays even if the container is restarted. You can change the environment variables to customize the MySQL setup as needed.
Build the Docker Container
Next, go ahead and create and start the Docker container. This involves getting the MySQL image, setting up the database, and making the first user linked to a specific database.
Execute the following command to initiate the construction and deployment of the container.
1 2 3 | docker compose up --build -d mysql |
With the database now operational, let us examine the logs to verify its successful initiation.
Run the following command to get the container logs.
1 2 3 | docker logs mysql |
The MySQL database has been successfully configured and initiated within the Docker container.
Connect to MySQL Database
The last thing to do is connect to the MySQL database using the username, password, and database name you set in the Docker Compose script.
Run the following command to connect to the MySQL database.
1 2 3 | docker exec -it mysql mysql -u stackblogger -p |
Syntax is:
docker exec -it <container name> mysql -u <username> -p
Running the command will ask you to enter the password. Once you enter the password, it will connect to the database, and the following screen will appear.
Run the following command in the MySQL environment to check the initial database.
1 2 3 | show databases; |
It will show sbdb database is created by default. Set the sbdb as default database and create a table in it.
1 2 3 4 5 6 7 8 9 | use sbdb; CREATE TABLE user (name varchar(250), email varchar(200)); INSERT INTO user VALUES ('Jameer', 'jameer@stackblogger.com'); SELECT * FROM user; |
Conclusion
Here’s a summary of setting up a MySQL database in a Docker container:
- Make a Docker Compose script to get the latest MySQL image.
- Set up the initial username, password, and database configuration in Docker Compose Script.
- Build and start the container.
- Connect to the MySQL database using the specified credentials.
Are you using MongoDB in a Docker container? This article could assist you if you find yourself stuck and need help.
