Docker 部署部署 Mysql8.0的方法示例的方法示例
1. 参照官网，安装docker
2.拉取mysql镜像 （默认拉取最新的镜像）8.0.11
docker pull mysql
3.在宿主机创建持久化 mysql data 及mysql.cnf
mkdir /usr/local/mysqlData/test/cnf
mkdir /usr/local/mysqlData/test/data
vi /usr/loal/mysqlData/test/cnf/mysql.cnf
设置本地文件共享：
Docker -> Preferences… -> File Sharing
4.添加操作权限
chmod 777 /usr/local/mysqlData/test/data 备注：挂载时权限验证（操作权限）备注：挂载时权限验证（操作权限）
5.运行镜像，设置初始密码、本机与docker端口的映射与挂载本地数据盘 (启动启动msyql服务服务)
docker run -itd -p 3307:3306 --name test_mysql -v /usr/local/mysqlData/test/conf:/etc/mysql
-v /usr/local/mysqlData/test/data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=123456 mysql
运行结果：
6. 进入test_mysql 容器
Docker exec -it test_mysql bash
如图：
7.在容器内登录mysql
8.查看用户信息
mysql> select user,host,authentication_string from mysql.user;
+------------------+-----------+------------------------------------------------------------------------+
| user | host | authentication_string |
+------------------+-----------+------------------------------------------------------------------------+
| root | % | $A$005$7o{'|'AomAw(QvF#.p5wLtCnrG6yX6XQdDVQivGr96POVL.gKnhIAhUhl3. |
| mysql.infoschema | localhost | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE |
| mysql.session | localhost | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE |
| mysql.sys | localhost | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE |
| root | localhost | $A$005$0.-%i)H{uYi@zFo7uYF82fYw7DsA93vYLr4uZv6I1tSKao0sbzzcDap3 |
+------------------+-----------+------------------------------------------------------------------------+
5 rows in set (0.00 sec)
9.设置权限（为root分配权限，以便可以远程连接）
mysql> grant all PRIVILEGES on *.* to root@'%' WITH GRANT OPTION;
评论0