java.sql.SQLException: The server time zone value

이슈

• 스프링 웹 프로젝트에서 MySQL/MariaDB 서버에 접속 시 한글문제로 timezone 관련 에러

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.

Caused by: com.mysql.cj.exceptions.InvalidConnectionAttributeException: 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.

해결

1. 웹 프로젝트 내 스프링 설정 방법

• DB 연결 URL parameter 추가: serverTimezone=UTC

spring.datasource.hikari.jdbc-url=jdbc:mysql://localhost:3307/test?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC

2. MariaDB 서버 내 설정 방법

1. MySQL/MariaDB 설치 경로 이동
2. default-time-zone = "+9:00" 설정 추가

   • 설치경로/data/my.ini

       [mysqld]
       default-time-zone = "+9:00"
     

   • (default-time-zone = “Asia/Seoul” 해당 설정 해결안됨)
3. MySQL/MariaDB 재시작

[참고]

• https://offbyone.tistory.com/318