docker安装mysql及解决中文编码问题

1.下载mysql
docker pull mysql
2.docker运行mysql

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

3.进入mysql容器
docker exec -it 8770feff5089 /bin/bash
4.使用mysql
mysql -uroot -p
5.建库建表插入数据
create database test;
use test；
create table a(id int,name varchar(20),age int);
insert into a values(1,‘张三’,10);
select * from a;

发现有中文乱码
1.新建my.cnf文件

[client]
default_character_set=utf8
[mysqld]
collation_server = utf8_general_ci
character_set_server = utf8
2.重启mysql

3.重新查询数据发现已经没有乱码