搭建springboot项目时遇到的小错误
今天在搭建springboot项目时启动项目报错:
org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLException:
Access denied for user ''@'localhost' (using password: NO)
错误信息截图
网上找到的答案大部分说时mysql权限问题,我用idea的database连接了一下,能连通,排除权限问题,最终找到方案,时配置文件的问题。
我的配置信息:
spring:
application:
name: EurekaClient
datasource:
url: jdbc:mysql://localhost:3306/Demo?characterEncoding=utf8&useSSL=false
data-username: root
data-password: root
driverClassName: com.mysql.jdbc.Driver
其中的username和password配置写错了,idea会提示“ data-username: root data-password: root”,这样的配置导致了数据库连接问题,应该改成:
spring:
application:
name: EurekaClient
datasource:
url: jdbc:mysql://localhost:3306/Demo?characterEncoding=utf8&useSSL=false
username: root
password: root
driverClassName: com.mysql.jdbc.Driver