docker 安装MySQL

docker 安装MySQL

安装mysql

拉取mysql镜像
docker pull mysql:5.7

运行mysql
docker run -itd --name mysql -p 3306:3306 -e MYSQL_ROOT_PASSWORD=123456 mysql:5.7

进入容器
docker exec -it mysql bash

连接mysql
mysql -u root -p

修改配置文件
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
FLUSH PRIVILEGES;
alter user 'root'@'%' identified with mysql_native_password by '123456';

设置mysql开机自启
docker update mysql --restart=always

查看防火墙状态
systemctl status firewalld

开启firewalld防火墙
systemctl start firewalld.service

关闭防火墙命令
systemctl stop firewalld.service```