一、企业级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