mysql8安装和部署

mysql8.0详细安装教程参考文章

 

一、拉取mysql8.0数据库镜像

docker pull mysql:8.0

二、创建配置、数据、日志挂载目录

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

三、新建my.cnf配置文件

1、进入配置文件夹

cd /data/mysql/conf

2、新建my.cnf文件

vi my.cnf

3、添加配置信息

[client]
port = 3360
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

四、启动mysql8.0镜像

1、启动命令

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