1、下载mysql5.7镜像dockerpullmysql:5.72，创建mysql容器并启动dockerrun-d-p3306:3306-eMYSQL_USER="ppx"-eMYSQL_PASSWORD="123456"-eMYSQL_ROOT_PASSWORD="123456"--namemysqltest1mysql:5.7--character-set-server=utf8--collat??ion-server=utf8_general_ci解释以上参数：-eMYSQL_USER="":设置用户名-eMYSQL_PASSWORD="":设置密码user-eMYSQL_ROOT_PASSWORD="":设置root用户密码--character-set-server=utf8:设置字符集为utf8--collat??ion-server=utf8_general_cli:设置字符规则为utf8_general_cli3,mountmysqlmkdir/optmkdir/opt/mysqlmkdir/opt/mysql/confmkdir/opt/mysql/data创建修改my.cnf配置文件vim/opt/mysql/conf/my.cnfmy.cnf添加如下内容：[mysqld]user=mysqlcharacter-set-server=utf8default_authentication_plugin=mysql_native_password[client]default-character-set=utf8[mysql]default-character-set=utf8挂载目录可以按照自己的想法搭建，但是上下级关系一定要正确，即mysql下有conf和data。4、创建容器并启动dockerrun-d-p3307:3306--privileged=true-v/opt/mysql/conf/my.cnf:/etc/mysql/my.cnf-v/opt/mysql/data:/var/lib/mysql-eMYSQL_ROOT_PASSWORD=123456--namemysql02mysql:5.7参数说明：--privileged=true：容器内的root拥有真正的root权限，否则容器内的root只是外部普通用户权限-v/opt/mysql/conf/my.cnf:/etc/my.cnf:映射配置文件-v/opt/mysql/data:/var/lib/mysql:映射数据目录5.设置mysql字符编码vi/mydata/mysql/master/conf/my.cnf[client]default-character-set=utf8[mysql]default-character-set=utf8[mysqld]init_connect='SETcollat??ion_connection=utf8_unicode_ci'init_connect='SETNAMESutf8'character-set-server=utf8collat??ion-server=utf8_unicode_ciskip-character-set-客户端握手跳过名称-resolve
