Docker MySQL8

Docker MySQL8

$ mkdir -p /home/tester/data/docker/mysql
$ cat > /home/tester/data/docker/mysql/my.cnf <<EOF
[mysqld]
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
datadir         = /var/lib/mysql
secure-file-priv= NULL
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

# Custom config should go here
!includedir /etc/mysql/conf.d/

default_authentication_plugin= mysql_native_password
EOF
$ docker run -d --name mysql8 \
--privileged=true \
-v /home/tester/data/docker/mysql/my.cnf:/etc/mysql/my.cnf:rw \
-v /home/tester/data/docker/mysql/log:/var/log/mysql \
-v /home/tester/data/docker/mysql/data:/var/lib/mysql \
-p 3306:3306 -e MYSQL_ROOT_PASSWORD=123456 \
mysql

–name mysql8： 容器别名
-e MYSQL_ROOT_PASSWORD=123456：初始化设置的root用户的密码为123456
–lower_case_table_names=1：启动时就指定大小写不敏感
-p 3306:3306：表示在这个容器中使用3306端口(第二个)映射到本机的端口号也为33261(第一个)
-d：表示detached，意味着执行完这句命令后控制台将不会被阻碍，可继续输入命令操作；
-v: 宿主机地址:容器地址之间的映射