springboot2.0 mysql 5.0 和6.0配置


一般报错 java.sql.SQLNonTransientConnectionException: CLIENT_PLUGIN_AUTH is required 就是jdbc对应的mysql版本出错

5.0 需要制定版本 不用管最后子版本 


        
            mysql
            mysql-connector-java
            5.1.30
        

对应application.yml

spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    username: root
    password: 123456
    url: jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8&allowMultiQueries=true&useSSL=false&serverTimezone=GMT%2b8

6.0 


        
            mysql
            mysql-connector-java
        

对应application.yml 要加个 cj