How to start docker

MySQL Database

Docker is a convenient and simple virtualization tool that can easily deploy and manage applications. Among them, MySQL database is the most commonly used relational database in applications. This article will teach you how to start a MySQL database in Docker. Please follow the steps below:

Step 1: Download the MySQL image

First, download the MySQL image on the local host. You can find the MySQL image on DockerHub and execute the following command to download it:

docker pull mysql:latest

This command will download the latest version of the MySQL image.

Step 2: Run the MySQL container

After downloading the MySQL image, the next step is to run the container. Execute the following command to start a MySQL container:

docker run --name mysql -e MYSQL_ROOT_PASSWORD=passwd -d mysql:latest

This command will create a container named "mysql" , and set the root password of the running environment to "passwd". However, you should replace "passwd" with your desired password.

Step 3: Run the MySQL client

Next, you need to open the MySQL client in Docker to verify whether the MySQL container has started successfully. Execute the following command to open MySQL in Docker:

docker run -it --link mysql:mysql --rm mysql sh -c 'exec mysql -h"$MYSQL_PORT_3306_TCP_ADDR" -P"$MYSQL_PORT_3306_TCP_PORT" -uroot -p"$MYSQL_ENV_MYSQL_ROOT_PASSWORD"'

This command will create a new MySQL container and open an interactive shell. You can use this shell to access MySQL, view the database, or perform other operations.

Step 4: Create and use MySQL database

After opening the MySQL client, you can create and use the database. Execute the following command to create and use a database named "test" in the MySQL client:

CREATE DATABASE test;
USE test;

This command will create a database named database of "test" and make it the currently active database in the MySQL client.

Step 5: Close and delete the MySQL container

After you complete the MySQL operation, you should close and delete the MySQL container to release resources on the Docker host. Execute the following command to shut down and delete the MySQL container:

docker stop mysql
docker rm mysql

This command will stop and delete the container named "mysql".

Conclusion

In this article, we have learned how to start a MySQL database in Docker. We've seen how to download the MySQL image, run the MySQL container, create and use the database, and shut down and delete the container. If you need to run a MySQL database in Docker, the above steps will help you get the job done.

The above is the detailed content of How to start docker. For more information, please follow other related articles on the PHP Chinese website!