IDEA连接MySQL以及需要注意

1.点击右侧database，点击左上角加号，点击Data Source ，选择MySQL

2.输入相应信息

 3，点击下方的Test按钮，此时会出现错误，这代表出现错误

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.

我们需要在url进行修改

在url后方追加

?useUnicode=true&characterEncoding=UTF-8&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC

 此时在尝试连接，就成功了

 

 点击OK，即可