Docker-部署MySQL
Docker-MySQL
使用官方镜像快速启动一个MySQL Server实例(MySQL8)
如下
FengZhen$ docker run --name mysql -e MYSQL_ROOT_PASSWORD=123456 -p 53306:3306 -d mysql:latest 906b498c04db2bfe57349760941222ca063c3b169885969c95e5656a55c3a6ff FengZhen$ docker ps CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES 906b498c04db mysql:latest "docker-entrypoint.s…" 9 seconds ago Up 12 seconds 0.0.0.0:53306->3306/tcp mysql
进入MySQL
FengZhen$ docker exec -it 906b498c04db mysql -u root -p mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION; Query OK, 0 rows affected (0.00 sec) mysql> FLUSH PRIVILEGES; Query OK, 0 rows affected (0.01 sec)
在宿主主机进入MySQL
FengZhen$ mysql -u root -p -h192.168.1.102 -P53306
使用Navicat连接失败
Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 2): image not found
解决:
修改账户密码加密规则并更新用户密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER; #修改加密规则
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'; #更新一下用户的密码
3. 刷新权限并重置密码
FLUSH PRIVILEGES; #刷新权限
MySQL5.7.4
启动MySQL容器
FengZhen$ docker run -it --name mysql5.7.4 -p 53307:3306 -e MYSQL_ROOT_PASSWORD=123456 daocloud.io/library/mysql:5.7.4
进入MySQL,修改权限
FengZhen$ docker exec -it mysql5.7.4 mysql -u root -p mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION; Query OK, 0 rows affected (0.00 sec) mysql> FLUSH PRIVILEGES; Query OK, 0 rows affected (0.00 sec)
本地连接测试
FengZhen$ mysql -u root -p -h192.168.1.102 -P53307
使用Navicat连接。