CentOS7中如何在Docker在容器中连接MySQL数据库

淡淡的烟草味﹌ 2023-06-27 05:34 7阅读 0赞

## CentOS7中如何在Docker在容器中使用MySQL数据库 ##

1.  `docker ps -a` 查看docker运行镜像![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MDY4OTgyMg_size_16_color_FFFFFF_t_70]
2.  `docker exec -it mysql bash` 进入mysql镜像![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MDY4OTgyMg_size_16_color_FFFFFF_t_70 1]
3.  `mysql -u root -p`\-u是用户名为root（管理员）-p是密码为空![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MDY4OTgyMg_size_16_color_FFFFFF_t_70 2]
4.  `show databases;`查看所有数据库![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MDY4OTgyMg_size_16_color_FFFFFF_t_70 3]
5.  用`systemctl status firewalld` 命令查看防火墙状态，如果防火墙开启则连接不上数据库，关闭即可，Active: inactive (dead) dead代表关闭，running代表开启![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MDY4OTgyMg_size_16_color_FFFFFF_t_70 4]
6.  用`systemctl stop firewalld`命令停止防火墙![在这里插入图片描述][20200103164038616.png]
7.  查看一下防火墙状态`systemctl status firewalld`![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MDY4OTgyMg_size_16_color_FFFFFF_t_70 5]
8.  使用mysql库：`use mysql`![在这里插入图片描述][20200103162426935.png]
9.  查询信息：`select user,host from user;`![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MDY4OTgyMg_size_16_color_FFFFFF_t_70 6]
10. host字段中，localhost表示只允许本机访问，要实现远程连接，可以将root用户的host改为%，%表示允许任意host访问，如果需要设置只允许特定ip访问，则应改为对应的ip update user set host="%" where user=“root”;![在这里插入图片描述][20200103162446324.png]
11. `flush privileges;`重启服务![在这里插入图片描述][20200103162231752.png]
12. 连接navicat测试是否能连接成功数据库![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MDY4OTgyMg_size_16_color_FFFFFF_t_70 7]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MDY4OTgyMg_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20200103155719640.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MDY4OTgyMg==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MDY4OTgyMg_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20200103160320929.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MDY4OTgyMg==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MDY4OTgyMg_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/2020010316265638.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MDY4OTgyMg==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MDY4OTgyMg_size_16_color_FFFFFF_t_70 3]: https://img-blog.csdnimg.cn/20200103161110801.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MDY4OTgyMg==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MDY4OTgyMg_size_16_color_FFFFFF_t_70 4]: https://img-blog.csdnimg.cn/20200103163654769.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MDY4OTgyMg==,size_16,color_FFFFFF,t_70
[20200103164038616.png]: https://img-blog.csdnimg.cn/20200103164038616.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MDY4OTgyMg_size_16_color_FFFFFF_t_70 5]: https://img-blog.csdnimg.cn/20200103163443179.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MDY4OTgyMg==,size_16,color_FFFFFF,t_70
[20200103162426935.png]: https://img-blog.csdnimg.cn/20200103162426935.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MDY4OTgyMg_size_16_color_FFFFFF_t_70 6]: https://img-blog.csdnimg.cn/20200103162512579.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MDY4OTgyMg==,size_16,color_FFFFFF,t_70
[20200103162446324.png]: https://img-blog.csdnimg.cn/20200103162446324.png
[20200103162231752.png]: https://img-blog.csdnimg.cn/20200103162231752.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MDY4OTgyMg_size_16_color_FFFFFF_t_70 7]: https://img-blog.csdnimg.cn/20200103162134250.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MDY4OTgyMg==,size_16,color_FFFFFF,t_70