docker pull mysql #可以选择特定版本,如 docker pull mysql 5.5
docker images
mkdir /opt/mysql
cd /opt/mysql
docker run --name mysqlserver -v /opt/mysql /conf:/etc/mysql/conf.d -v /opt/mysql /logs:/logs -v /opt/mysql /data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=123456 -d -i -p 3306:3306 mysql:latest
docker ps -a 查看 docker进程
docker exec -it mysqlserver bash
mysql -uroot -p
设置远程访问
use mysql;
select host,user from user;
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
flush privileges;
firewall-cmd --zone=public --list-ports 查看所有打开的端口
firewall-cmd --zone=public --add-port=3306/tcp --permanent # 开放3306端口
firewall-cmd --zone=public --remove-port=3306/tcp --permanent #关闭3306端口(这里只是演示一下怎么关闭开放的端口)
firewall-cmd --reload # 配置立即生效
重启防火墙 systemctl restart firewalld.service