[Spring] MySQL 연동 - 설정하기

1. MySQL 설치 

• homebrew를 이용하여 설치
• $ brew install mysql

 

2. 필요한 dependency 추가

dependencies {
    implementation 'org.springframework.boot:spring-boot-starter-jdbc'
    implementation 'org.springframework.boot:spring-boot-starter-thymeleaf'
    implementation 'org.springframework.boot:spring-boot-starter-web'
    implementation 'org.mybatis.spring.boot:mybatis-spring-boot-starter:2.1.4'
    compileOnly 'org.projectlombok:lombok'
    developmentOnly 'org.springframework.boot:spring-boot-devtools'
    runtimeOnly 'mysql:mysql-connector-java'
    annotationProcessor 'org.springframework.boot:spring-boot-configuration-processor'
    annotationProcessor 'org.projectlombok:lombok'
    testImplementation 'org.springframework.boot:spring-boot-starter-test'
}

 

3. application.properties에서 db 설정하기

spring.datasource.hikari.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.hikari.jdbc-url=jdbc:mysql://localhost:3306/board?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC
spring.datasource.hikari.username=root
spring.datasource.hikari.password=123123
spring.datasource.hikari.connection-test-query=SELECT 1

• "spring.datasource.hikari.jdbc-url"부분에서 "serverTimezone=UTC"를 추가하기 전에는 "The server time zone value ‘KST’ is unrecognized or represents more than one time zone" 에러가 발생했었다. 
• 위 에러는 mysql-connector-java 버전 5.1.X 이후 버전부터 KST 타임존을 인식하지 못하는 이슈 때문이라고 한다.
• "serverTimezone=UTC"를 추가해 문제를 해결하자.