IDEA无法连接mysql数据库(6种解决方法大全)

缺乏、安全感 2021-09-28 01:40 867阅读 0赞

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21hb3ppeWFuZzE5OTY_size_16_color_FFFFFF_t_70][]

1.本地的mysql没有创建该数据库(笔者就是这个原因!)

查看数据库发现没有,重建就可以了

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21hb3ppeWFuZzE5OTY_size_16_color_FFFFFF_t_70 1][]

测试成功!

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21hb3ppeWFuZzE5OTY_size_16_color_FFFFFF_t_70 2][]

**网上说法:**

2.IP地址不对

[https://blog.csdn.net/qq\_40646143/article/details/81238444][https_blog.csdn.net_qq_40646143_article_details_81238444]

3.mysql版本过高

[https://bbs.csdn.net/topics/392368070?page=1][https_bbs.csdn.net_topics_392368070_page_1]

4.创建的Java项目的路径里包含中文字符

[https://blog.csdn.net/Thomas\_liao1/article/details/84637172][https_blog.csdn.net_Thomas_liao1_article_details_84637172]

5.本地mysql服务没有启动

[https://blog.csdn.net/maoziyang1996/article/details/85334265][https_blog.csdn.net_maoziyang1996_article_details_85334265]

6.3306端口被占用

[https://blog.csdn.net/New\_feature/article/details/83683924][https_blog.csdn.net_New_feature_article_details_83683924]

### (如果,该贴完美解决你的问题,**请点一个赞?谢谢**!) ###

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21hb3ppeWFuZzE5OTY_size_16_color_FFFFFF_t_70]: /images/20210923/5388a3cb484047ebbe811fbbd6fc895a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21hb3ppeWFuZzE5OTY_size_16_color_FFFFFF_t_70 1]: /images/20210923/c73a2ea1e7924411a734471fa4eae01d.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21hb3ppeWFuZzE5OTY_size_16_color_FFFFFF_t_70 2]: /images/20210923/3dbeddbe3b5a493eb7c9f049f48ccc09.png
[https_blog.csdn.net_qq_40646143_article_details_81238444]: https://blog.csdn.net/qq_40646143/article/details/81238444
[https_bbs.csdn.net_topics_392368070_page_1]: https://bbs.csdn.net/topics/392368070?page=1
[https_blog.csdn.net_Thomas_liao1_article_details_84637172]: https://blog.csdn.net/Thomas_liao1/article/details/84637172
[https_blog.csdn.net_maoziyang1996_article_details_85334265]: https://blog.csdn.net/maoziyang1996/article/details/85334265
[https_blog.csdn.net_New_feature_article_details_83683924]: https://blog.csdn.net/New_feature/article/details/83683924