mysql 5.7安装部署

523 阅读1分钟
  1. 拉取 mysql 5.7
docker pull mysql:5.7
  1. 启动
sudo docker run -p 3306:3306 --name 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

  1. 开放端口
firewall-cmd  --zone=public --add-port=3306/tcp -permanent 
firewall-cmd  --reload 
  1. 地客户端设置远程访问账号
$ sudo docker exec -it mysql bash 
$ mysql -uroot -p123456 
mysql> grant all privileges on *.* to root@'%' identified by "123456";