1、修改MySQL 8.0 的密码验证机制
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root';
2、把
jdbc.driverClass=com.mysql.jdbc.Driver
改成
jdbc.driverClass=com.mysql.cj.jdbc.Driver
3、mysql-connector-java版本改成8.0
https://mvnrepository.com/artifact/mysql/mysql-connector-java
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.11</version>
</dependency>
4、8.0是不需要建立ssl连接的,你需要显示关闭,即url中的useSSL=false最后你需要设置CST,CST可视为美国、澳大利亚、古巴或中国的标准时间serverTimezone=UTC。
jdbc.url=jdbc\:mysql\://localhost\:3306/taxplus?useSSL\=false&serverTimezone\=UTC&useUnicode\=true&characterEncoding\=utf-8&zeroDateTimeBehavior\=CONVERT_TO_NULL&transformedBitIsBoolean\=true&allowMultiQueries\=true&autoReconnect\=true
按照如上步骤,即可成功连接MySQL 8.0