spring-boot项目连接数据库报错Access denied for user ‘root‘@‘localhost‘ (using password: YES)

application.yml中datasource配置如下
注意密码配置为 0******3

spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/dbname?serverTimezone=UTC
    username: root
    password: 012345

因配置区分类型最终读取到的密码实际不是012345，而是12345，密码错误导致数据库连接不上
解决方法为：在配置密码时若密码首位为0，加双引号标识字符串

spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/dbname?serverTimezone=UTC
    username: root
    password: "012345"

参考链接：

https://blog.csdn.net/u012862619/article/details/80482485
https://blog.csdn.net/jackback17566/article/details/103897946