【idea】解决idea连接mysql连接失败Could not create connection to database server. Attempted reconnect 3 times. Giving up.

备注:

mysql包依赖  用的版本:5.1.30

<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.30</version>
</dependency>


解决方法:
在数据库url后面添加一下代码(&amp;是&的转义字符)
?useUnicode=true&amp;characterEncoding=UTF-8&amp;useJDBCCompliantTimezoneShift=true&amp;useLegacyDatetimeCode=false&amp;serverTimezone=UTC

 

参考自:https://www.cnblogs.com/q149072205/p/13040024.html

posted @ 2022-03-21 21:58  狼窝窝  阅读(427)  评论(0)    收藏  举报