docker pull mysql 5.7_docker 部署mysql 5.7

1. 登录docker hub 查找  https://hub.docker.com/ mysql 5.7 镜像

2. docker pull mysql ：5.7 镜像

3.启动mysql镜像 挂载时出现小坑

docker run \

--name mysql \

-v $PWD/mysql:/var/lib/mysql \

-p 3306:3306 \

-e MYSQL_ROOT_PASSWORD=root \

-d mysql:5.7

坑参考：

修改mysql密码：

mysql> ALTER user 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';

Query OK, 0 rows affected (0.00 sec)

mysql> FLUSH PRIVILEGES;

Query OK, 0 rows affected (0.00 sec)

mysql>

四、授予远程登录权限

mysql> grant all privileges on *.* to root@"%" identified by "password" with grant option;

Query OK, 0 rows affected, 1 warning (0.04 sec)

mysql> flush privileges;

Query OK, 0 rows affected (0.00 sec)