How to install mysql in docker container (steps)

Docker is a containerization technology. When using Docker containers, you need to install various software, including database software. MySQL is a popular relational database software. In this article, we will explain how to install MySQL inside a Docker container.

Installing Docker
Before installing MySQL, you need to install Docker first. Docker supports multiple operating systems such as Linux, macOS, and Windows. The process of installing Docker is slightly different under different operating systems. We take Ubuntu as an example.

Step 1: Update the system
Before installing Docker, you first need to update the system. Open a terminal and enter the following command:

$ sudo apt-get update

This command will check for updates and update existing packages to ensure that the operating system is up to date.

Step 2: Install Docker
After updating the operating system, you can start installing Docker. In Ubuntu, you can install Docker using the following command:

$ sudo apt-get install docker-ce

This command will download and install Docker. After the installation is complete, you can use the following command to start Docker:

$ sudo systemctl start docker

Next, use the following command to check whether the startup is successful:

$ sudo systemctl status docker

If the result shows active (running), Docker has been started successfully. You can test whether Docker is working properly by running the following command:

$ sudo docker run hello-world

If the console outputs "Hello from Docker!", Docker has been installed and working properly.

Installing MySQL
After Docker is installed and started, you can start installing MySQL.

Step 1: Search for available MySQL images
There are many available MySQL images on Docker Hub. You can search for available versions through the following command:

$ sudo docker search mysql

You can select the corresponding version as needed and download it using the following command:

$ sudo docker pull mysql:{version}

Here, {version} should be replaced with the required version number. For example, if you want to install MySQL version 5.7, use the following command:

$ sudo docker pull mysql:5.7

If the download speed is slow, you can speed up the download:

$ sudo docker pull registry.docker-cn.com/library/mysql:{version}

Step 2: Create a MySQL container
After downloading the MySQL image, you can use the following command to create a MySQL container:

$ sudo docker run --name mysql-container -e MYSQL_ROOT_PASSWORD=your_password -d mysql:{version}

Here, {version} is the version number of MySQL, and your_password is the root user password of MySQL .

This command will create a container named mysql-container and run it in the background. If everything is fine, you can use the following command to see if the container is running:

$ sudo docker ps

This command will list all running containers.

At this point, MySQL has been installed and executed in the Docker container. You can now connect using the root user password and get started.

Summary
This article introduces how to install MySQL in a Docker container. First, you need to install Docker, then search and download the MySQL image on Docker Hub, and finally use the docker run command to create the MySQL container. With these simple steps, you can easily run MySQL in a Docker container.

The above is the detailed content of How to install mysql in docker container (steps). For more information, please follow other related articles on the PHP Chinese website!