本机Navicat连接华为云服务器中的mysql

小咪咪 2023-06-21 07:17 39阅读 0赞

**配置数据库**

1.设置数据库允许外网访问  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L01hc3Rlcl9LaW4_size_16_color_FFFFFF_t_70]进入数据库中，切换至mysql库，查看user表中是否有host为%的字段，  
如果没有则需要添加，设置外网允许访问。

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;

![在这里插入图片描述][20191211161656474.png]设置成功后刷新数据库  
![在这里插入图片描述][2019121116173417.png]  
刷新成功后退出重新进入

**开放华为云端口**  
选中服务器，进入安全组  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L01hc3Rlcl9LaW4_size_16_color_FFFFFF_t_70 1]  
进入入方向规则，选择快速添加  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L01hc3Rlcl9LaW4_size_16_color_FFFFFF_t_70 2]选择Mysql（3306）点击确定  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L01hc3Rlcl9LaW4_size_16_color_FFFFFF_t_70 3]随后刷新，便可看见端口已开放  
**![在这里插入图片描述][20191211162408282.png]连接测试**  
打开本地Navicat  
建立连接，IP地址为云服务器的弹性ip地址，ip地址要处于绑定状态，输入端口号，用户名，密码  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L01hc3Rlcl9LaW4_size_16_color_FFFFFF_t_70 4]进行连接测试  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L01hc3Rlcl9LaW4_size_16_color_FFFFFF_t_70 5]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L01hc3Rlcl9LaW4_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20191211161351440.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L01hc3Rlcl9LaW4=,size_16,color_FFFFFF,t_70
[20191211161656474.png]: https://img-blog.csdnimg.cn/20191211161656474.png
[2019121116173417.png]: https://img-blog.csdnimg.cn/2019121116173417.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L01hc3Rlcl9LaW4_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20191211162005801.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L01hc3Rlcl9LaW4=,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L01hc3Rlcl9LaW4_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/20191211162147328.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L01hc3Rlcl9LaW4=,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L01hc3Rlcl9LaW4_size_16_color_FFFFFF_t_70 3]: https://img-blog.csdnimg.cn/2019121116225453.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L01hc3Rlcl9LaW4=,size_16,color_FFFFFF,t_70
[20191211162408282.png]: https://img-blog.csdnimg.cn/20191211162408282.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L01hc3Rlcl9LaW4_size_16_color_FFFFFF_t_70 4]: https://img-blog.csdnimg.cn/2019121116270610.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L01hc3Rlcl9LaW4=,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L01hc3Rlcl9LaW4_size_16_color_FFFFFF_t_70 5]: https://img-blog.csdnimg.cn/2019121116280447.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L01hc3Rlcl9LaW4=,size_16,color_FFFFFF,t_70