关于IDEA连接mysql数据库失败：
Connection to [email protected] failed. [08001] Could not create connection to database server. Attempted reconnect 3 times. Giving up.
![IDEA连接数据库失败@localhost failed. [08001] Could not create connection to database server. Attempte](https://image.shishitao.com:8440/aHR0cHM6Ly9waWFuc2hlbi5jb20vaW1hZ2VzLzI1Ny8yZTMwMTE3NjcwNjJmNzQ0MmI2NjUwOWVhNmFhZjVkMS5wbmc%3D.png?w=700&webp=1 "IDEA连接数据库失败@localhost failed. [08001] Could not create connection to database server. Attempte")
解决办法：在URL后面加上?serverTimezone=UTC
![IDEA连接数据库失败@localhost failed. [08001] Could not create connection to database server. Attempte](https://image.shishitao.com:8440/aHR0cHM6Ly9waWFuc2hlbi5jb20vaW1hZ2VzLzIyNy85M2Y3ZTlkY2ZlMDM5MDdkMGEzZjdhOTViNDg5MmNiMy5wbmc%3D.png?w=700&webp=1 "IDEA连接数据库失败@localhost failed. [08001] Could not create connection to database server. Attempte")
连接成功!
根本原因是因为时区设置的问题。
UTC代表的是全球标准时间 ，但是我们使用的时间是北京时区也就是东八区，比实际时间要早8小时。
UTC + (＋0800) = 本地（北京）时间