Docker mysql5.7 设置字符集 解决中文乱码问题

一、企业级Docker下运行mysql5.7容器实例

docker run -d -p 3306:3306 --privileged=true -v /xzuse/mysql/log:/var/log/mysql -v /xzuse/mysql/data:/var/lib/mysql -v /xzuse/mysql/conf:/etc/mysql/conf.d -e MYSQL_ROOT_PASSWORD=123456 --name mysql mysql:5.7

二、新建my.cnf

在my.cnf文件中输入以下代码

[client]
default_character_set=utf8
[mysqld]
collation_server = utf8_general_ci
character_set_server = utf8

 三、重启mysql容器实例并重新进入查看字符编码

docker restart mysql
docker exec -it mysql /bin/bash
mysql -uroot -p
show VARIABLES LIKE ‘character%’;

四、要写含有中文的sql 语句，参考我写的这篇 https://blog.csdn.net/weixin_61161835/article/details/127290572?spm=1001.2014.3001.5501https://blog.csdn.net/weixin_61161835/article/details/127290572?spm=1001.2014.3001.5501