IDEA连接mysql数据库错误
Connection to @localhost failed.
[08001] Could not create connection to database server. Attempted reconnect 3 times. Giving up.
产生原因
时区问题。mysql默认美国时区,在中国与之时区不对应
jdbc-connector版本
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.21</version>
</dependency>
解决方案
在URL处进行修改,改为UTC世界统一时区
jdbc:mysql://localhost:3306/test?serverTimezone=UTC