DataGrip 2019.1 连接mysql 8.0.16

曾经终败给现在 2022-01-20 20:15 158阅读 0赞

\------本文转载----------------  
[https://www.cnblogs.com/linkenpark/p/10908101.html][https_www.cnblogs.com_linkenpark_p_10908101.html]

DataGrip 2019.1 连接mysql 8.0.16  
\#下载mysql Connector/J驱动包  
[https://dev.mysql.com/downloads/connector/j/][https_dev.mysql.com_downloads_connector_j]  
然后解压到一个目录  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTg0MzY5OQ_size_16_color_FFFFFF_t_70]  
\#新建mysql 8.0连接驱动  
打开 DataGrip  
点击 Data Sources  
![在这里插入图片描述][20190609172509953.png]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTg0MzY5OQ_size_16_color_FFFFFF_t_70 1]  
修改下Name，

添加上面解压的connector jar包

编辑URL template两个值，在原来值的后面追加?serverTimezone=UTC，目的是指定时区，东八区表示方法：?serverTimezone=GMT%2B8

> jdbc:mysql://\{host::localhost\}?\[:\{port::3306\}\]\[/\{database\}?\]\[?<&,user=\{user\},password=\{password\},\{:identifier\}=\{:identifier\}>\]?serverTimezone=UTC

> jdbc:mysql://address=(protocol=tcp)(<)(,host=\{host:host\_ipv6:localhost\},port=\{port::3306\},user=\{user\},password=\{password\},\{:identifier\}=\{:identifier\}>)\[/\{database\}\]\[?<&,\{:identifier\}=\{:param\}>\]?serverTimezone=UTC

最后点击Apply即可  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTg0MzY5OQ_size_16_color_FFFFFF_t_70 2]  
测试过，使用自带的 mysql connector v8.0.15的也可以

\#创建连接实例  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTg0MzY5OQ_size_16_color_FFFFFF_t_70 3]

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTg0MzY5OQ_size_16_color_FFFFFF_t_70 4]

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTg0MzY5OQ_size_16_color_FFFFFF_t_70 5]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTg0MzY5OQ_size_16_color_FFFFFF_t_70 6]

[https_www.cnblogs.com_linkenpark_p_10908101.html]: https://www.cnblogs.com/linkenpark/p/10908101.html
[https_dev.mysql.com_downloads_connector_j]: https://dev.mysql.com/downloads/connector/j/
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTg0MzY5OQ_size_16_color_FFFFFF_t_70]: /images/20220121/d26ef8b0e34645d6b2d7549ad9a64fec.png
[20190609172509953.png]: /images/20220121/8e4cfb6c4f3d475ba57fa56abbe7fffd.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTg0MzY5OQ_size_16_color_FFFFFF_t_70 1]: /images/20220121/fc99a35d57d244e29029751b5a014f3c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTg0MzY5OQ_size_16_color_FFFFFF_t_70 2]: /images/20220121/8b38efba43f8472e85da79740aa0cbd5.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTg0MzY5OQ_size_16_color_FFFFFF_t_70 3]: /images/20220121/2c13a0b52c9642d786da1325cefdb4d7.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTg0MzY5OQ_size_16_color_FFFFFF_t_70 4]: /images/20220121/11ce9e43c6b84f709bb8657787ff247a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTg0MzY5OQ_size_16_color_FFFFFF_t_70 5]: /images/20220121/5ec52c4a75fd4025b9829f6d29bf5a00.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTg0MzY5OQ_size_16_color_FFFFFF_t_70 6]: /images/20220121/923ed0e1fc794747b3d2a39ce65b9f89.png