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