1、新建mysql实例
docker run -d -p 3306:3306 --privileged=true
-v /feiuse/mysql/log:/var/log/mysql
-v /feiuse/mysql/data:/var/lib/mysql
-v /feiuse/mysql/conf:/etc/mysql/conf.d
-e MYSQL_ROOT_PASSWORD=123456
–name mysql
mysql:5.7
2、由于会存在汉字乱码的问题,在对应前面设置的目录/feiuse/mysql/conf文件夹下添加my.cnf配置文件。
[client]
default_character_set=utf8
[mysqld]
collation_server = utf8_general_ci
character_set_server = utf8
3、重新启动mysql,并查看mysql编码
docker restart mysql
docker exec -it mysql bash
mysql -uroot -p
输入密码,进入mysql
show variables like ‘character%’;
可以看到有些编码方式变成了utf-8