idea连接MySQL数据库，你可能遇到的坑全到这里。

川长思鸟来 2023-03-14 05:54 25阅读 0赞

第一步，使用并操作数据库必须需要jdbc接口  
官方接口下载地址：https://mvnrepository.com/artifact/mysql/mysql-connector-java  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpZXJlbmJpamkyMQ_size_16_color_FFFFFF_t_70]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpZXJlbmJpamkyMQ_size_16_color_FFFFFF_t_70 1]  
第二步：添加jar到idea中。  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpZXJlbmJpamkyMQ_size_16_color_FFFFFF_t_70 2]![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpZXJlbmJpamkyMQ_size_16_color_FFFFFF_t_70 3][]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpZXJlbmJpamkyMQ_size_16_color_FFFFFF_t_70 4]

第三步：idea中添加连接数据库的驱动  
file -> setting ->plugins->database navigator  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpZXJlbmJpamkyMQ_size_16_color_FFFFFF_t_70 5]  
第四步：安装完成之后，这里会显示DB Navigator,  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpZXJlbmJpamkyMQ_size_16_color_FFFFFF_t_70 6]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpZXJlbmJpamkyMQ_size_16_color_FFFFFF_t_70 7]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpZXJlbmJpamkyMQ_size_16_color_FFFFFF_t_70 8]  
设置完成之后，点击ok即可  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpZXJlbmJpamkyMQ_size_16_color_FFFFFF_t_70 9]  
注意：如果连接的时候出现SystemTimezone 问题，那是数据库的时区是系统默认时区，没有更改到东8区，我们打开cmd命令行，登录之后，输入如下命令：  
查看一下当前时区：  
show variables like’%time\_zone’;  
设置时区:  
set global time\_zone=’+8:00’;  
然后再次点击ok连接，基本就没问题了。  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpZXJlbmJpamkyMQ_size_16_color_FFFFFF_t_70 10]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpZXJlbmJpamkyMQ_size_16_color_FFFFFF_t_70]: /images/20230312/6d905be9c1b54f83994ab6c922c2abb2.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpZXJlbmJpamkyMQ_size_16_color_FFFFFF_t_70 1]: /images/20230312/79e083d917024aaf8e2656184916d6a3.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpZXJlbmJpamkyMQ_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/20200516133736849.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpZXJlbmJpamkyMQ==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpZXJlbmJpamkyMQ_size_16_color_FFFFFF_t_70 3]: /images/20230312/820e43ff655a401288a312a6714f0abf.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpZXJlbmJpamkyMQ_size_16_color_FFFFFF_t_70 4]: /images/20230312/110aebbcb7df4a1fba97cfb05921bc44.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpZXJlbmJpamkyMQ_size_16_color_FFFFFF_t_70 5]: /images/20230312/6056c47d7c2144d386ddf1ff31407016.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpZXJlbmJpamkyMQ_size_16_color_FFFFFF_t_70 6]: /images/20230312/664c0fcf793a4f2db56bf2711f50cd58.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpZXJlbmJpamkyMQ_size_16_color_FFFFFF_t_70 7]: /images/20230312/709d19caa0b444a48362dabd07e639a6.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpZXJlbmJpamkyMQ_size_16_color_FFFFFF_t_70 8]: /images/20230312/d7eb15d8b09f46219f9a492051536ab3.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpZXJlbmJpamkyMQ_size_16_color_FFFFFF_t_70 9]: /images/20230312/9be2f3a6459947eb9237127cff2a6475.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpZXJlbmJpamkyMQ_size_16_color_FFFFFF_t_70 10]: /images/20230312/b99cae3c8406400ebc288d546bb13d90.png