IDEA 连接数据库报错（IDEA cannot connect to a database）

目录

问题描述：

问题原因：

解决办法：

IDEA接数据库如果有其他问题，可以按照以下方法逐步排除：

---

 

问题描述：

使用IDEA自带的Database配置一个本地的mysql连接，通过cmd查看数据库连接正常。用户名、密码、URL、需要的驱动皆无误，却总是报如下错误：com.mysql.cj.exceptions.InvalidConnectionAttributeException: The server time zone value 'Öйú±ê׼ʱ¼ä' is unrecognized or represents more than one time zone.

java.lang.RuntimeException: com.mysql.cj.exceptions.InvalidConnectionAttributeException: The server time zone value 'Öйú±ê׼ʱ¼ä' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeCon