docker 安装 mysql

小插曲：
docker: Error response from daemon: Get https://registry-1.docker.io/v2/: net/http: request canceled while waiting for connection (Client.Timeout exceeded while awaiting headers).

vi /etc/docker/daemon.json
{
"registry-mirrors": ["https://docker.mirrors.ustc.edu.cn","https://registry.docker-cn.com","http://hub-mirror.c.163.com"]
}

// 1创建目录
mkdir -p /root/docker-data/mysql/log
mkdir -p /root/docker-data/mysql/data
mkdir -p /root/docker-data/mysql/conf

 

// 2设置权限
chmod 755 -R /root/docker-data/mysql

// 3my.conf 内容
[client]
#socket = /usr/mysql/mysqld.sock
default-character-set = utf8mb4
[mysqld]
#pid-file = /var/run/mysqld/mysqld.pid
#socket = /var/run/mysqld/mysqld.sock
#datadir = /var/lib/mysql
#socket = /usr/mysql/mysqld.sock
#pid-file = /usr/mysql/mysqld.pid
datadir = /usr/mysql/data
character_set_server = utf8mb4
collation_server = utf8mb4_bin
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/

 

// 4运行
docker run -p 3306:3306 --name mysql8 \
--restart=always -e MYSQL_ROOT_PASSWORD=rootroot \
-v /root/docker-data/mysql/data:/var/lib/mysql:rw \
-v /root/docker-data/mysql/log:/var/log/mysql:rw \
-v /root/docker-data/mysql/conf/my.cnf:/etc/mysql/my.cnf:rw \
-v /etc/localtime:/etc/localtime:ro \
-d mysql:8.0