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

 

 

坑参考：

https://blog.csdn.net/Scirhh/article/details/85619501

 

修改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)