使用druid连接池报错Access denied for user ‘‘@‘localhost‘ (using password: YES)

最新推荐文章于 2024-07-31 10:29:06 发布

码的艺术家

最新推荐文章于 2024-07-31 10:29:06 发布

阅读量3.9k

点赞数 21

分类专栏：后端文章标签： bug

本文链接：https://blog.csdn.net/qq_34902437/article/details/104157138

版权

后端专栏收录该内容

9 篇文章 0 订阅

订阅专栏

关于这条报错结果有很多可能，我遇到的问题是在 druid 的配置文件中，键值对的健写错了，必须完完全全和官方文档一样。特别是不能有空格，这个最好大家一个一个框一下每一行后面看看有无空格。

报错提示

2月 03, 2020 3:18:47 下午 com.alibaba.druid.pool.DruidDataSource error
严重: init datasource error
java.sql.SQLException: Access denied for user ''@'localhost' (using password: YES)
	at mysql.connector.java@8.0.19/com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
	at mysql.connector.java@8.0.19/com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
	at mysql.connector.java@8.0.19/com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
	at mysql.connector.java@8.0.19/com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:836)
	at mysql.connector.java@8.0.19/com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:456)
	at mysql.connector.java@8.0.19/com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:246)
	at mysql.connector.java@8.0.19/com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:197)
	at druid@1.0.9/com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:148)
	at druid@1.0.9/com.alibaba.druid.filter.stat.StatFilter.connection_connect(StatFilter.java:211)
	at druid@1.0.9/com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:142)
	at druid@1.0.9/com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1377)
	at druid@1.0.9/com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1431)
	at druid@1.0.9/com.alibaba.druid.pool.DruidDataSource.init(DruidDataSource.java:618)
	at druid@1.0.9/com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:915)
	at druid@1.0.9/com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:911)
	at JDBC_DAO/com.www.utils.DruiUtils.getConnection(DruiUtils.java:49)
	at JDBC_DAO/daoImpl.UserImpl.geTable_user02s(UserImpl.java:24)
	at JDBC_DAO/serviceImpl.UserServiceImpl.geTable_user02s(UserServiceImpl.java:21)
	at JDBC_DAO/test.Test.main(Test.java:25)