Docker-----安装mysql镜像并配置远程连接

1.拉取镜像

docker pull mysql:5.7

2.创建外部挂载

mkdir -p /iids/mysql

3.运行镜像并将数据挂在本地

docker run \
-d \
-p 3306:3306 \
-e MYSQL_ROOT_PASSWORD=root  \
-v /iids/mysql:/var/lib/mysql  \
--name mysql  \
mysql:5.7 \
--character-set-server=utf8mb4 \
--collation-server=utf8mb4_unicode_ci

3.修改mysql远程连接

//进入mysql容器内部
docker exec -it mysql bash  
//登陆mysql
mysql -u root -p 
//设置运行远程连接root用户
grant all PRIVILEGES ON *.* TO 'root'@'%'  WITH GRANT OPTION ; 
//刷新操作
FLUSH PRIVILEGES; 
//查看root用户密码加密策略
use mysql; 
select user,plugin from user where user='root';  
//修改密码加密策略
ALTER USER 'root'@'%' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER; 
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'root';
//刷新操作
FLUSH PRIVILEGES;

这样就可以远程连接数据库了