docker run mysql

拉取镜像

docker pull mysql:8.0

 

创建挂载卷

mkdir -p /data/mysql/conf
mkdir -p /data/mysql/data
mkdir -p /data/mysql/logs

创建配置文件

vi /data/mysql/conf/my.cnf

[client]
port = 3308
default-character-set = utf8mb4
 
[mysql]
port = 3308
default-character-set = utf8mb4
 
[mysqld]
# bind-address = 0.0.0.0
# port = 3306
 
max_connections=10000
 
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
 
# 设置时区和字符集
# default-time-zone='+8:00'
character-set-client-handshake=FALSE
init_connect='SET NAMES utf8mb4 COLLATE utf8mb4_unicode_ci'
 
gtid-mode=ON
enforce-gtid-consistency = ON

运行

docker run  --restart=always  --name mysql8.0  -v /data/mysql/conf:/etc/mysql/conf.d  -v /data/mysql/data:/var/lib/mysql  -v /data/mysql/log:/var/log  -v /data/mysql/mysql-files:/var/lib/mysql-files -p 3306:3306  -e MYSQL_ROOT_PASSWORD='123456'   -d mysql:8.0  --lower_case_table_names=1