Docker 安装MySQL5.7
1、拉取docker镜像
docker pull mysql:5.7
2、建立映射文件夹目录(此处为windows环境,其他Linux等环境也是一样的)
docker run -p 3306:3306 --name mysql -v D:/syrigmophonia/docker/env/mysql/conf:/etc/mysql/conf.d -v D:/syrigmophonia/docker/env/mysql/logs:/logs -v D:/syrigmophonia/docker/env/mysql/data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=root -d mysql:5.7
注:创建好容器以后,可能无法访问mysql,需要重启容器: docker restart mysql
3、设置远程访问
(1)执行命令进入容器
docker exec -it mysql /bin/bash
(2)进入MySQL
mysql -u root -p
(3)授权
grant all privileges on *.* to root@"%" identified by "123456" with grant option;
flush privileges;