docker安装mysql

docker run -p 3306:3306 --name my_mysql \
-v /usr/local/docker/mysql/conf:/etc/mysql \
-v /usr/local/docker/mysql/logs:/var/log/mysql \
-v /usr/local/docker/mysql/data:/var/lib/mysql \
-e MYSQL_ROOT_PASSWORD=123456 \
-d mysql:5.7

进入容器

docker exec -it my_mysql /bin/bash

登录mysql

mysql  -u root  -p
输入密码

CREATE USER 'zssz'@'%' IDENTIFIED BY '123456';   创建用户

GRANT ALL ON *.* TO 'zssz'@'%';   授全部权限

GRANT ALL on dbname.* to "zssz"@'%';  把dbname这个数据库的所有操作权限授予zssz这个登录用户

revoke all on *.* from 'zssz'@"%"; 移除用户的权限

liunx下备份数据库

docker exec -it my_mysql mysqldump zssz -u root -p123456 > "/usr/local/docker/mysql/back/data_`date +%Y%m%d`.sql" 
docker exec -i my_mysql mysqldump zssz -u root -p123456 > /usr/local/docker/mysql/back/s1.sql

参考：https://www.cnblogs.com/wangyueping/p/11258028.html