SpringBoot Access denied for user ''@'localhost' (using password: NO)

springboot做demo出现错误，java.sql.SQLException：对用户''@ localhost'拒绝访问（使用密码：NO）
java.sql.SQLException: Access denied for user ''@'localhost' (using password: NO)
根据提示发现是“ ”用户访问而不是“root”用户，估计是idea提示写的代码 data-username: root 格式不对于是尝试更改，最终成功

更改前
spring:
  mvc:
    view:
      prefix: /WEB-INF/views/
suffix: .jsp
datasource:
    url: jdbc:mysql://127.0.0.1:3306/sqtest
data-username: root
data-password: 123456
driver-class-name: com.mysql.jdbc.Driver

更改后

datasource:
  url: jdbc:mysql://127.0.0.1:3306/sqtest
username: root
password: 123456
driver-class-name: com.mysql.jdbc.Driver

转载于:https://www.cnblogs.com/astrand/p/10329645.html