Access denied for user ‘root‘@‘localhost‘ (using password: YES)解决方法

在使用SpringBoot整合MyBatis的时，出现了如下报错:

java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129) ~[mysql-connector-java-8.0.29.jar:8.0.29]
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-java-8.0.29.jar:8.0.29]
	at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:828) ~[mysql-connector-java-8.0.29.jar:8.0.29]
	at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:448) ~[mysql-connector-java-8.0.29.jar:8.0.29]
	at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:241) ~[mysql-connector-java-8.0.29.jar:8.0.29]
.........

在确认MySQL服务已经启动与登录密码正确后，发现SpringBoot的.yml格式的配置文件的datasource的password属性需要使用双引号包起来。

如下：

spring:
  datasource:
    url: jdbc:mysql://localhost:3306/springboot_db
    driver-class-name: com.mysql.jdbc.Driver
    username: root
    password: "000000"

连接成功，程序成功运行。