pom中修改了MySQL的版本，测试连接数据库报错

Question

java.sql.SQLException: 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.

pom.xml

mysql
mysql-connector-java
runtime

数据源

url: jdbc:mysql://127.0.0.1:3306/imooc_coupon_data?useUnicode=true&characterEncoding=UTF-8
username: root
password: root
driver-class-name: com.mysql.cj.jdbc.Driver

Answer 1

张勤一 2019-12-02 19:46:51

同学你好：

    这是 MySQL 时区设置的问题，解决办法可以参考这篇博客：https://www.cnblogs.com/godwithus/p/9788790.html

    欢迎来 QQ 群随时交流、讨论，也非常感谢同学的支持！

• 提问者 静笃 #1

  现在报这个错
  
  java.lang.IllegalStateException: Failed to load property source from location 'classpath:/application.yml'
  
  idea缓存也清过了

• 提问者 静笃 #2

  非常感谢！

Answer 2

提问者 静笃 2019-12-03 15:28:10

现在报这个错

java.lang.IllegalStateException: Failed to load property source from location 'classpath:/application.yml'

idea缓存也清过了