Why use Docker install MySQL

1、docker Fast installation , Efficient ;

2、docker Good isolation , You can install countless mysql example , No interference with each other , As long as the mapping host port is different ;

3、 Less occupied resources ,MB Level , And the server installation GB Level ;

4、 Start speed seconds , And the server installation start minute level ;

5、 Performance close to native , The server installation is low ;

6、 The data backup 、 transfer ,docker More convenient and powerful ;

7、 Unloading management is more convenient and clean , Delete the container and image directly ;

8、 stability , Just promise docker There's no problem with the environment ,mysql Is no problem .

One 、 Installation steps

1. Pull the mirror image

Use here 5.7 Version as an example , If you want to install other versions, just change the version number , If you want to install the latest version, change the version number to latest

docker pull mysql:5.7

2. Create the mount file directory

#  For storing logs 
mkdir -p /srv/mysql/log
#  Used to store application data 
mkdir -p /srv/mysql/data
#  Used to store  MYSQL  The configuration file 
mkdir -p /srv/mysql/conf

3. Configure environment variables

export MYSQL_HOME=/srv/mysql

2. Start the mirror

docker run -d -p 3306:3306 --name mysql -v $MYSQL_HOME/log:/var/log/mysql -v $MYSQL_HOME/data:/var/lib/mysql -v $MYSQL_HOME/conf:/etc/mysql/conf.d/ -e MYSQL_ROOT_PASSWORD=123456 --restart=always --privileged=true mysql:5.7

-d Running the image in the background

-p 3306:3306 Will mirror the 3306 Port mapping to server's 3306 port .

--name mysql Give the container an alias

-v $MYSQL_HOME/log:/var/log/mysql Mount the log folder in the container to the corresponding /var/log/mysql In the folder

-v $MYSQL_HOME/data:/var/lib/mysql Mount the data folder in the container to the corresponding /var/lib/mysql In the folder

-v $MYSQL_HOME/conf:/etc/mysql/conf.d/ Mount the configuration folder of the container to the corresponding /etc/mysql In the folder

-e MYSQL_ROOT_PASSWORD=123456 take MySQL Password set to 123456

--restart=always Set the restart policy of the container to Docker Automatic restart on restart

--privileged=true Add specific permissions to the container . because Centos7 Security Selinux Some security permissions are prohibited , Lead to mysql and mariadb Mounting in progress /var/lib/mysql An error message will be prompted when

mysql:5.7 What is running MySQL Image name

3. View startup log

docker logs mysql

Two 、 Client connection

Use here Navicat Premium16 Tool for connection test :

host ： install MySQL The public network of the machine IP
port ：3306（ Default ）
user name ：root（ Default ）
password ：123456