Skip to content

Instantly share code, notes, and snippets.

@ksundong
Created April 23, 2020 11:17
Show Gist options
  • Select an option

  • Save ksundong/5e054b1d0e343f5c02a564e4e8396375 to your computer and use it in GitHub Desktop.

Select an option

Save ksundong/5e054b1d0e343f5c02a564e4e8396375 to your computer and use it in GitHub Desktop.
MySQL KST Timezone 인식 못하는 오류 해결

The server time zone value 'KST' 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.

해결 방법은 두가지

  1. jdbc 접속 url query string에 serverTimezone=Asia/Seoul을 입력하기

  2. mysql 타임존 설정

    [mysqld]
    default_time_zone='+09:00'
    
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment