Docker starts MySQL configuration implementation process

Preface

You can check how to start MySQL and some interpretations of MySQL on the official website. Attach the official website address

Start another mysql container instance and run the mysql command mysql is the world's most popular open source database. Because of its proven performance, reliability, and ease of use, MySQL has become the leading database choice for web-based applications, ranging from personal projects and websites, through e-commerce and information services, all the way to high-profile web properties including Facebook, Twitter, YouTube, Yahoo! and many more.

Actual combat process

By checking the official website for specific white papers, you can find out that you can use this command to execute

This is the most basic way to start MySQL. However, since MySQL needs to be accessed via a port before it can be opened, this simple command only opens a container and a database container, but there is no entry access. You can add the parameters below the official website.

Let's start by explaining its main commands and details one by one

When using run -d to run in the background, if the MySQL container is not downloaded, it will automatically download the latest version. You can also docker search mysql
Get the image docker pull mysql
When running a container, you need to mount its files. You can mount multiple files with the following command:

-v /home/gaokaoli/usr/mydata/mysql/log:/var/log/mysql mounts the container's log folder to the corresponding location on the host -v /home/gaokaoli/usr/mydata/mysql/data:/var/lib/mysql mounts the container's data folder to the corresponding location on the host -v /home/gaokaoli/usr/mydata/mysql/conf:/etc/mysql/conf.d mounts the container's custom configuration folder to the corresponding location on the host

Other main parameters in the command are as follows:

-d Run in the background
-p port mount
-v volume mount can mount multiple
-e environment configuration setting password
--name container name

Finally, the mounted image command is

docker run -d -p 3306:3306 -v /home/gaokaoli/mysql/conf:/etc/mysql/conf.d -v /home/gaokaoli/mysql/data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=12345678 --name mysql001 mysql

Check whether the startup is successful

The specific IP used to open the database through the Navicat software is the local IP address of the virtual machine instead of the address in the container

Conducting the test

The above is the details of the implementation process of Docker starting MySQL configuration. For more information about Docker starting MySQL configuration implementation, please pay attention to other related articles on 123WORDPRESS.COM!