[java] java mysql 연동시 오류

Posted on | Edited on | In | Comments:

The server time zone value ‘KST’ is unrecognized or represents more than one time zone

https://yenaworldblog.wordpress.com/2018/01/24/java-mysql-연동시-발생하는-에러-모음/

public key retrieval is not allowed

mysql 8.x 버전 이후로 발생
jdbc url에 allowPublicKeyRetrieval=true&useSSL=false 필요

1
jdbc:mysql://localhost:3306/dev-product?useUnicode=true&characterEncoding=utf8&allowPublicKeyRetrieval=true&useSSL=false