Share your love
Install MySQL in Docker Container on Debian 12 with Easy Steps
In this guide, we want to teach you to Install MySQL in Docker Container on Debian 12 Bookworm. By running MySQL in a Docker container you will get a lot of benefits such as improving your development speed and easy maintenance. Here you can follow the steps below provided by the Orcacore team to install Docker on your Debian 12 create a Docker Container for MySQL and run it.
Table of Contents
Steps To Install MySQL in Docker Container on Debian 12
Before you start to Install MySQL in Docker Container on Debian 12, you need some requirements. Let’s see what we need.
Requirements for MySQL Setup with Docker
First, you must log in to your server as a non-root user with sudo privileges. To do this, you can follow this guide on Initial Server Setup with Debian 12 Bookworm.
Then, you must have Docker running on your server. For this purpose, you can visit this guide on Install Docker CE on Debian 12 Bookworm.
Now follow the steps below to Install MySQL in Docker Container on Debian 12.
Step 1 – Pull MySQL Docker Image on Debian 12
To Install MySQL in Docker Container on Debian 12, you can easily pull the MySQL image from Docker Hub on your server. The official image that is available for MySQL in Docker Hub is mysql. To download the MySQL image on Debian 12, run the command below:
docker pull mysqlWhen your download is completed, you will get the following output:
You can verify your MySQL image download is completed with the command below:
docker imagesOutput
REPOSITORY TAG IMAGE ID CREATED SIZE
mysql latest 8da80fe49fcf 34 hours ago 577MBStep 2 – Start and Run MySQL COntainer on Debian 12
At this point, you must create a container for your MySQL image and start your container on Debian 12.
You can use the docker run command to create and run your MySQL container:
docker run --name mysql -p 3306:3306 -v mysql_volume:/var/lib/mysql/ -d -e "MYSQL_ROOT_PASSWORD=password" mysqlThe options used in the command mean:
- The –name is used for your container name.
- -p option is used for port mapping.
- The -v attach the volume data for your container.
- -d will start and run the container in detached mode.
- The -e option is used for setting a password for your MySQL.
When you run the command, you will get the following output:
Output
5c245750272df99bd294239a57dab4ff3583104b8f2610bfaf2db12f50e74127Then, verify your container is up and running with the following command:
docker psOutput
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
5c245750272d mysql "docker-entrypoint.s…" 44 seconds ago Up 43 seconds 0.0.0.0:3306->3306/tcp, :::3306->3306/tcp, 33060/tcp mysqlStep 3 – Connect To MySQL Docker Container
At this point, you can easily connect to your MySQL shell by using the following commands:
docker exec -it mysql bashThis will change your shell prompt, then, run the command below to access your MySQL shell:
mysql -u root -pEnter the password you have generated for MySQL in the previous step and press enter. You should see:
bash-4.4# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.1.0 MySQL Community Server - GPL
Copyright (c) 2000, 2023, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>That’s it, you are done. From there you can easily work with your MySQL docker container.
Conclusion
At this point, you have learned to Install MySQL in Docker Container on Debian 12 by pulling the latest MySQL image and running the container on your server by using the Docker Run command. Also, you can easily connect to your MySQL shell.
Hope you enjoy it. You may also interested in these articles:
