[Kotlin - API 서버 이슈 3] java.sql.SQLException: The server time zone value 'KST' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver.....

java.sql.SQLException: The server time zone value 'KST' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver..... 해결하기

Error Message >>
java.sql.SQLException: The server time zone value 'KST' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver.....


time zone 'KST'를 인식하지 못해서 발생하는 에러이다.


해결방법은 ?serverTimezone=UTC를 application.properties 파일의 url 뒷부분에 추가하면 된다.

spring.datasource.url=jdbc:mysql://localhost/sys?serverTimezone=UTC
spring.datasource.username=
spring.datasource.password=
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver

이제 서버가 잘돌아간다.  :)

2020-07-02 18:21:48.592  INFO 89116 --- [           main] com.example.parayo.ParayoApplicationKt   : Started ParayoApplicationKt in 4.377 seconds (JVM running for 4.964)