docker 安装mysql 5.7

1.拉取mysql 5.7镜像

docker pull mysql:5.7

2. 创建mysql容器

docker run -p 3306:3306 --name ownMysql -v $PWD/conf:/etc/mysql/conf.d -v $PWD/logs:/logs -v $PWD/data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=123456 -d mysql:5.7
​
# 将当前目录下的conf挂载到容器下的/etc/mysql/conf.d
-v $PWD/conf:/etc/mysql/conf.d
-v $PWD/logs:/logs
-v $PWD/data:/var/lib/mysql
# 初始化root用户的密码
-e MYSQL_ROOT_PASSWORD=123456
# 指定以哪个镜像为模板创建容器
-d mysql:5.7

3.配置mysql

# 查看容器获取容器id
docker ps -a
# 进入容器
docker exec -it 69bb78dc03b3 /bin/bash
# 登入mysql
mysql -u root -p 123456
# 修改权限（建立用户并授权所有ip都可登陆，账户名密码都为root）
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION
​
GRANT ALL PRIVILEGES ON *.* TO 'root'@'127.0.0.1' IDENTIFIED BY 'root' WITH GRANT OPTION
​
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'root' WITH GRANT OPTION
​
# 刷新使配置生效
FLUSH PRIVILEGES

结束

授权后就可以用root:root在任何地方登陆，可以使用navicat等工具连接