Docker-----安装mysql镜像并配置远程连接
1.拉取镜像
docker pull mysql
2.查看镜像
docker image ls
3.运行镜像
docker run -p 3306:3306 -e MYSQL_ROOT_PASSWORD=密码 -d mysql
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 EXPIRE NEVER;
ALTER USER ‘root’@’%’ IDENTIFIED WITH mysql_native_password BY ‘密码’;
//刷新操作
FLUSH PRIVILEGES;