Error reporting restore:

Public Key Retrieval is not allowed

Background description

MySQL 8.0Springboot

Error reporting solution

Add the following to the URL of the project configuration file:

allowPublicKeyRetrieval=true

Detailed demonstration

Open the application.yaml file of springboot.

The application.xml file generated by springboot by default is only in different formats, which means the same and does not affect. The SSM project finds the URL configuration in mybatis, which is the same. Add allowpublickeyretrieval = true at the end of the URL. Note that you need to connect with “&”.

# Springboot application.yaml File
# DataSource Config
spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/vueadmin?useUnicode=true&useSSL=false&characterEncoding=utf8&serverTimezone=Asia/Shanghai&allowPublicKeyRetrieval=true
    username: root
    password: 123456