19. MySQL ??? ??
MySQL 5.* ?? ?? ??? ?
?? Sat Jul 21 11:17:59 PDT 2018 WARN: Establishing SSL connection without
server's identity verification is not recommended. ?According to MySQL
5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be
established by default if explicit option isn't set.? For compliance with
existing applications not using SSL the ?verifyServerCertificate property is
set to 'false'?. You need either to explicitly disable SSL by setting
useSSL=false?, or set ?useSSL=true and provide truststore? for server
certificate verification.
?? jdbc:mysql:/localhost:3306/springboot??useSSL=false
MySQL 8.* ?? ?? ??? ?
?? com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException
: Public Key Retrieval is not allowed
?? jdbc:mysql:/localhost:3306/springboot?useSSL=false&?allowPublicKeyRetr
ieval=true
MySQL ???? (GPL) ??
¡ñ MySQL ?? MariaDB ?? ??
¡ñ ?? ?? ?? ?? ?? ??
43. ??? ??? 4?: PostgreSQL
??? ??
<dependency>
<groupId>?org.postgresql?</groupId>
<artifactId>?postgresql?</artifactId>
</dependency>
PostgreSQL ?? ? ?? ?? (docker)
docker run -p 5432:5432 -e POSTGRES_PASSWORD=pass -e
POSTGRES_USER=keesun -e POSTGRES_DB=springboot --name postgres_boot -d
postgres
docker exec -i -t postgres_boot bash