docker 运行 mysql5.7 中文乱码 group by

• 进入docker 容器

docker exec -it ${容器ID} /bin/sh

• 修改mysql配置

vim /etc/mysql/mysql.conf.d/mysqld.cnf
在[mysqld]后,添加如下内容:

sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
character-set-server=utf8
default-time_zone = '+8:00' 

vim /etc/mysql/conf.d/mysql.cnf
在[mysql]后,添加如下内容:

default-character-set=utf8

重启mysql:

service mysql restart

或者直接重启docker容器

docker restart ${容器ID}