Navicat of MySQL连接和使用

落日映苍穹つ 2021-10-12 23:08 343阅读 0赞

## 请先安装MySQL服务 ##

MySQL数据库安装：[https://blog.csdn.net/shenqiankk/article/details/99756531][https_blog.csdn.net_shenqiankk_article_details_99756531]

## 新建连接 ##

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NoZW5xaWFua2s_size_16_color_FFFFFF_t_70]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NoZW5xaWFua2s_size_16_color_FFFFFF_t_70 1]

## 如果出现Can’t connect to MySQL server on ‘localhost’ 的报错 ##

那么请先去下载MySQL数据库：[https://blog.csdn.net/shenqiankk/article/details/99756531][https_blog.csdn.net_shenqiankk_article_details_99756531]

## Navicat无法连接mysql ##

![在这里插入图片描述][20190820142812106.png]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NoZW5xaWFua2s_size_16_color_FFFFFF_t_70 2]  
**输入密码连接mysql服务器**

1.  `use mysql;`
2.  `alter user 'root'@'localhost' identified with mysql_native_password by '连接数据的密码';`
3.  `flush privileges;`

**然后重新建立一个数据库连接就可以了**  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NoZW5xaWFua2s_size_16_color_FFFFFF_t_70 3]

## 新建数据库 ##

连接上数据库后，剩下就是对Navicat数据的使用熟悉。

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NoZW5xaWFua2s_size_16_color_FFFFFF_t_70 4]  
字符集选择：[https://blog.csdn.net/shenqiankk/article/details/99859141][https_blog.csdn.net_shenqiankk_article_details_99859141]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NoZW5xaWFua2s_size_16_color_FFFFFF_t_70 5]

## 新建数据表 ##

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NoZW5xaWFua2s_size_16_color_FFFFFF_t_70 6]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NoZW5xaWFua2s_size_16_color_FFFFFF_t_70 7]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NoZW5xaWFua2s_size_16_color_FFFFFF_t_70 8]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NoZW5xaWFua2s_size_16_color_FFFFFF_t_70 9]

## MySQL数据库操作语句： ##

[https://blog.csdn.net/shenqiankk/article/details/99704345][https_blog.csdn.net_shenqiankk_article_details_99704345]

[https_blog.csdn.net_shenqiankk_article_details_99756531]: https://blog.csdn.net/shenqiankk/article/details/99756531
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NoZW5xaWFua2s_size_16_color_FFFFFF_t_70]: /images/20211013/b0a8e61dfd8342f3a6b4d03f2589244b.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NoZW5xaWFua2s_size_16_color_FFFFFF_t_70 1]: /images/20211013/34bc3beae05d41ac81e9eab1f54898cf.png
[20190820142812106.png]: /images/20211013/aa2b18607bfe48fba123249fc24d55b4.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NoZW5xaWFua2s_size_16_color_FFFFFF_t_70 2]: /images/20211013/acd5af39e98c46f197397c92611af031.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NoZW5xaWFua2s_size_16_color_FFFFFF_t_70 3]: /images/20211013/5687a6d01def4b35b0f03b36d2c7b1ff.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NoZW5xaWFua2s_size_16_color_FFFFFF_t_70 4]: /images/20211013/d0818f44f9124469b667572c8c9bf7e9.png
[https_blog.csdn.net_shenqiankk_article_details_99859141]: https://blog.csdn.net/shenqiankk/article/details/99859141
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NoZW5xaWFua2s_size_16_color_FFFFFF_t_70 5]: /images/20211013/13d5bfce8ab641c998e9e69abd4313cf.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NoZW5xaWFua2s_size_16_color_FFFFFF_t_70 6]: /images/20211013/16b052fa27bf4aeab6f7bc6280ab5e85.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NoZW5xaWFua2s_size_16_color_FFFFFF_t_70 7]: /images/20211013/fb9323e4a4ef4e2a856f388f1026a14c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NoZW5xaWFua2s_size_16_color_FFFFFF_t_70 8]: /images/20211013/eb7955a633f44a51947b0b8e7386306b.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NoZW5xaWFua2s_size_16_color_FFFFFF_t_70 9]: /images/20211013/e1a1cd091bb8412287bae89fcfecf4a9.png
[https_blog.csdn.net_shenqiankk_article_details_99704345]: https://blog.csdn.net/shenqiankk/article/details/99704345