The MySQL password is correct, but the startup error is unable to create initial connections of pool Access denied for user ‘root‘@‘localhost

problem

Recently imported a SpringBoot project , After local configuration , The error is always reported when the project is started ：

2020-12-17 15:46:42.136 ERROR 19320 --- [restartedMain] o.a.tomcat.jdbc.pool.ConnectionPool      : Unable to create initial connections of pool.

java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)

At first, I thought the database password was wrong , But after checking it several times, I found that the password was ok , There are two ways online ：

1. When configuring the database username and password Write the data

FALSE ：

spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/hah
spring.datasource.data-username=root
spring.datasource.data-password=123456

Modified ：

spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/hah
spring.datasource.username=root
spring.datasource.password=123456

2.Yml Double quotation marks should be added when configuring the password of the database in the configuration file

spring:
  datasource:
    driver-class-name: com.mysql.jdbc.Driver
    url: jdbc:mysql://localhost:3306/blog?useUnicode=true&characterEncoding=utf-8
    username: root
    password: "123456"

however , Neither of these methods has solved my problem

terms of settlement

1. Open the installation mysql The location of the database , stay my.ini Add... At the end of the configuration file
skip-grant-tables

2. restart MySQL service

The reason for this error is that the code is executing sql Statement error and lost login permission