Springboot —— 解决Access denied for user ‘‘@‘localhost‘ (using password: NO)

1. 问题描述

测试SpringBoot程序接口时报错了，出现了如下异常

java.sql.SQLException: Access denied for user ''@'172.18.0.1' (using password: NO)at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129) ~[mysql-connector-java-8.0.23.jar:8.0.23]at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-java-8.0.23.jar:8.0.23]at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:833) ~[mysql-connector-java-8.0.23.jar:8.0.23]at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:453) ~[mysql-connector-java-8.0.23.jar:8.0.23]at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:246) ~[mysql-connector-java-8.0.23.jar:8.0.23]at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198) ~[mysql-connector-java-8.0.23.jar:8.0.23]

2. 问题定位

使用idea自动填写导入的配置内容，修改前如下

3.问题解决

实际正确的配置参数应该如下,修改完毕后重启程序即成功解决

参考:/DENG8623048/article/details/86475323