Detailed explanation of how to use DockerHub's official MySQL image

Mysql relational database management system

MySQL is an open source small relational database management system developed by the Swedish MySQL AB company. MySQL is widely used in small and medium-sized websites on the Internet. Due to its small size, fast speed, low total cost of ownership, and especially the characteristics of open source, many small and medium-sized websites choose MySQL as their website database in order to reduce the total cost of website ownership.

#MySQL is a widely used open source relational database, so how to obtain the Mysql Docker image? Let’s take a look at how to use DockerHub’s official MySQL image through this article. Friends in need can refer to it.

Preface

Recently I have been trying to make a centos-based MySQL image based on the official centos image. However, after production, it was found that the image size has exceeded 1.5G, which is too bloated for ordinary Docker images. The mysql image officially provided by Docker Hub is only 324MB. At present, I haven't found any good way to reduce the size of the image I made, so I will use the official one first!

docker pull mysql:5.7

How to use this Docker image?

1. Start a Mysql Server container (default port 3306)

docker run --name mysql -e MYSQL_ROOT_PASSWORD=root -d mysql:5.7

2. Start another container and access the Mysql server through a link

docker run --name some-app --link mysql:mysql -d application-that-uses-mysql

3. Start another Container, access the Mysql server through the Mysql command line

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

4. Enter the server console

docker exec -it mysql bash

5. View the Mysql server log

docker logs mysql

For more information, please refer to the official website for details :https://hub.docker.com/_/mysql/.

The above is a detailed explanation of how to use DockerHub’s official MySQL image. For more related content, please pay attention to the PHP Chinese website (www.php.cn)!