离线docker中安装mysql_docker容器中安装mysql5.7（详细图解）

一、拉取镜像

docker pull mysql:5.7

创建数据目录

mkdir /usr/local/dockerdata/mysql/conf

mkdir /usr/local/dockerdata/mysql/logs

mkdir /usr/local/dockerdata/mysql/mysql

二、创建配置文件

设置编码为utf8mb4

cd /usr/local/dockerdata/mysql/conf

vi my.cnf

需要手动添加上[client]和[mysql]。

[client]

default-character-set = utf8mb4

[mysql]

default-character-set = utf8mb4

[mysqld]

character-set-client-handshake = FALSE

character-set-server = utf8mb4

collation-server = utf8mb4_unicode_ci

init_connect='SET NAMES utf8mb4'

default-time_zone = '+8:00' #默认时区配置

sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

#设置数据库支持分组

lower_case_table_names=1 #表名不区分大小写

设置utf