连接mysql报错java.sql.SQLException: The server time zone value is unrecognized or represe

java.sql.SQLException: The server time zone value 'Öйú±ê׼ʱ¼ä' is unrecognized or represents morethan one time zone. 

原因：MySql安装默认设置为美国时区

解决方法：在url里加上serverTimezone=UTC

jdbc.driverClassName=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/test?serverTimezone=UTC&autoReconnect=true&useUnicode=true&characterEncoding=utf8
jdbc.username=root
jdbc.password=123

 

 

另一种解决方式：https://www.jianshu.com/p/02f16bb0b9f1（感谢大佬，侵删）