Docker 安装mysql

Docker 安装mysql

• 下载镜像

docker pull mysql:5.7

• 如果不挂载

docker run -p 3306:3306 --name mysql -e MYSQL_ROOT_PASSWORD=123456 -d mysql:5.7

• 如果挂载

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

• 进入容器内部

docker exec -it mysql bash

mysql -uroot -p123456
mysql> grant all privileges on *.* to root@'%' identified by "123456";
mysql> flush privileges;

• 如果需要处理防火墙

#查看防火墙状态
firewall-cmd --state  
#停止防火墙
systemctl stop firewalld.service
#禁止防火墙开机启动	
systemctl disable firewalld.service 

• 设置开机自启

docker update --restart=always mysql