docker安装mysql

Updated on in 程序人生 with 0 views and 0 comments

拉取镜像

docker pull mysql:5.7.40

创建文件夹

mkdir -p /hjp/mysql/5.7.40/log
mkdir -p /hjp/mysql/5.7.40/data
mkdir -p /hjp/mysql/5.7.40/conf

创建配置文件

vi /hjp/mysql/5.7.40/conf/custom.cnf

内容如下

[client]
default-character-set=utf8mb4

[mysql]
default-character-set=utf8mb4

[mysqld]
init_connect="SET collation_connection = utf8mb4_unicode_ci"
init_connect="SET NAMES utf8mb4"
character-set-server=utf8mb4
collation-server=utf8mb4_unicode_ci
skip-character-set-client-handshake
skip-name-resolve
explicit_defaults_for_timestamp=true
lower_case_table_names=1
sql_mode=ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

运行容器

docker run --name mysql_5.7.40 -v /hjp/mysql/5.7.40/log:/var/log/mysql -v /hjp/mysql/5.7.40/data:/var/lib/mysql -v /hjp/mysql/5.7.40/conf:/etc/mysql/conf.d -p 3306:3306 -e MYSQL_ROOT_PASSWORD=xdny897@12229 -d mysql:5.7.40
标题：docker安装mysql
作者：wenyl
地址：http://www.wenyoulong.com/articles/2020/05/14/1589444938088.html

↑ ↓