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