sudo docker pull mysql:5.6

mkdir -p /data/docker/mysql/data /data/docker/mysql/logs /data/docker/mysql/conf

sudo docker run -p 33061:3306 --name mysql -v /data/docker/mysql/conf:/etc/mysql -v /data/docker/mysql/logs:/logs -v /data/docker/mysql/data:/usr/data -e MYSQL_ROOT_PASSWORD=123456 -d mysql:5.6

sudo docker start mysql

sudo docker exec -it mysql bash

mysql -u root -p

GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY '新密码' WITH GRANT OPTION;

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '新密码' WITH GRANT OPTION;

flush privileges;

exit

cp /usr/my.cnf /etc/mysql/my.cnf

exit

sudo nano /data/docker/mysql/conf/my.cnf

# 增加内容开始

[client]

default-character-set=utf8

[mysql]

default-character-set=utf8

[mysqld]

character-set-server=utf8

# 结束

sudo docker restart mysql