IDEA连接本地mysql失败

问题描述:

IDEA连接本地mysql失败

Connection to lanyuekeji@localhost failed.
[08001] Could not create connection to database server. Attempted reconnect 3 times. Giving up.

The specified database user/password combination is rejected: com.mysql.cj.exceptions.InvalidConnectionAttributeException: The server time zone value '?D1ú±ê×?ê±??' 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.

翻译一下错误“ The server time zone value '?D1ú±ê×?ê±??' is unrecognized or represents more than one time zone”是时区不对，故在URL后面加上?serverTimezone=GMT%2B8   解决问题