1. 의존성 추가

우선 mysql-connector와 JPA 라이브러리를 추가한다.

Maven: pom.xml

<dependencies>
  <!-- Mysql -->
  <dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <scope>runtime</scope>
  </dependency>

  <!-- JPA -->
  <dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-data-jpa</artifactId>
  </dependency>
</dependencies>

Gradle: build.gradle

dependencies {
  compile 'mysql:mysql-connector-java'
  compile 'org.springframework.boot:spring-boot-starter-data-jpa'
}

2. Spring 설정

추가한 라이브러리에 설정값을 부여한다.

application.properties

# server
server.port=8080

# jpa common
spring.jpa.show-sql=true
spring.jpa.hibernate.ddl-auto=update
spring.jpa.generate-ddl=true

# jpa mysql
spring.jpa.database=mysql
spring.datasource.url=jdbc:mysql://localhost:3306/{database_name}?useUnicode=true&serverTimezone=Asia/Seoul
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.username={sql_username}
spring.datasource.password={sql_password}

3. Database 추가

사용할 데이터베이스를 UTF-8 charset으로 추가한다.

mysql.server start

mysql -u root -p

CREATE DATABASE {database_name} DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;

4. 서버 실행

서버가 정상적으로 실행된다.

Errors

MySQL JDBC 에러 해결 "The server time zone value 'KST' is unrecognized or represents more than one time zone. "