docker mysql 的安装和配置使用

134 阅读1分钟
  1. 安装 mysql www.runoob.com/docker/dock…

  2. 进入容器

docker exec -it (镜像id) /bin/bash

  1. 进入 mysql mysql -uroot -p123456

  2. 建立用户并授权 CREATE USER 'root'@'%' IDENTIFIED BY 'root'; GRANT ALL PRIVILEGES ON . TO 'root'@'%'; (版本5.7之前可以: GRANT ALL PRIVILEGES ON . TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;)

GRANT ALL PRIVILEGES ON . TO 'root'@'127.0.0.1' IDENTIFIED BY 'root' WITH GRANT OPTION; GRANT ALL PRIVILEGES ON . TO 'root'@'localhost' IDENTIFIED BY 'root' WITH GRANT OPTION;

FLUSH PRIVILEGES