【SpringBoot填坑记录】Spring Boot 不能加载 com.mysql.jdbc.Driver ，出现CLIENT_PLUGIN_AUTH is required异常问题

2020-04-15 14:13:19.655  INFO 11428 --- [io-8081-exec-10] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Starting...
2020-04-15 14:13:19.656  WARN 11428 --- [io-8081-exec-10] com.zaxxer.hikari.util.DriverDataSource  : Registered driver with driverClassName=com.mysql.jdbc.Driver was not found, trying direct instantiation.
2020-04-15 14:13:21.021 ERROR 11428 --- [io-8081-exec-10] com.zaxxer.hikari.pool.HikariPool        : HikariPool-1 - Exception during pool initialization.
Caused by: com.mysql.cj.exceptions.UnableToConnectException: CLIENT_PLUGIN_AUTH is required
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_131]
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_131]
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_131]
    at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_131]
    at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) ~[mysql-connector-java-8.0.19.jar:8.0.19]
    at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:85) ~[mysql-connector-java-8.0.19.jar:8.0.19]
    at com.mysql.cj.protocol.a.NativeAuthenticationProvider.connect(NativeAuthenticationProvider.java:205) ~[mysql-connector-java-8.0.19.jar:8.0.19]
    at com.mysql.cj.protocol.a.NativeProtocol.connect(NativeProtocol.java:1340) ~[mysql-connector-java-8.0.19.jar:8.0.19]
    at com.mysql.cj.NativeSession.connect(NativeSession.java:157) ~[mysql-connector-java-8.0.19.jar:8.0.19]
    at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:956) ~[mysql-connector-java-8.0.19.jar:8.0.19]
    at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:826) ~[mysql-connector-java-8.0.19.jar:8.0.19]
    ... 110 common frames omitted

先贴上报错信息

最近在学习SpringBoot,用Spring Boot +Maven搭建了多模块项目，整合MySQL之后, 启动项目后查询数据，控制台抛出无法加载com.mysql.jdbc.Driver，还有异常信息CLIENT_PLUGIN_AUTH is required。

试过了各种解决方案,终于找到此项目出现问题的原因，原来父Pom.xml的<parent>标签向导帮忙生成的为2.2.6.RELEASE版本

查看了以前的项目是使用<version>2.0.2.RELEASE</version>，原来是版本太高导致，修改配置，启动没问题。

记录下，怕以后在踩坑。

顺便记录下，关于出现CLIENT_PLUGIN_AUTH is required异常信息的几种解决方案。

1、调整mysql-connector-java的版本为5x以下。

2、修改application.yml中

将driver-class-name: com.mysql.jdbc.Driver改为

driver-class-name: com.mysql.cj.jdbc.Driver

3、application.yml中

spring.datasource.url配置增加

&serverTimezone=GMT%2B8&useSSL=false