1.拉取mysql 5.7
docker pull mysql:5.7
2.运行mysql 5.7容器
mkdir mysql_docker
cd mysql_docker/
echo $PWD
docker run --name mysqlserver -v $PWD/conf:/etc/mysql/conf.d -v $PWD/logs:/logs -v $PWD/data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=123456 -d -i -p 3306:3306 mysql:5.7
3.进入到容器中
docker exec -it mysqlserver bash
mysql -uroot -p
4.开启远程访问权限
use user;
update user set host = '%' where user = 'root';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '你的密码' WITH GRANT OPTION;
FLUSH PRIVILEGES;
EXIT;
5. 添加阿里云服务器防火墙规则
安全——>添加规则——>选择mysql