Nutz
  1. 主页/
  2. 问答
NutzCN Logo
问答 druid 错误，密码和用户名是正确，项目能正常运行，但是日志有错误.
发布于 2932天前 作者 CXW0504 14839 次浏览 复制 上一个帖子 下一个帖子
标签: 无 
2021070357	Druid-ConnectionPool-Create-1743776012	ERROR	com.alibaba.druid.pool.DruidDataSource	create connection error, url: jdbc:mysql://127.0.0.1:3306/hgd
java.sql.SQLException: Access denied for user 'root'@'127.0.0.1' (using password: YES) 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:959) 
    	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3870) 
    	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3806) 
    	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:871) 
    	at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1686) 
    	at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1207) 
    	at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2254) 
    	at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2285) 
    	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2084) 
    	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:795) 
    	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:44) 
    	at sun.reflect.GeneratedConstructorAccessor38.newInstance(Unknown Source) 
    	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) 
    	at java.lang.reflect.Constructor.newInstance(Constructor.java:526) 
    	at com.mysql.jdbc.Util.handleNewInstance(Util.java:404) 
    	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:400) 
    	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:327) 
    	at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:148) 
    	at com.alibaba.druid.filter.stat.StatFilter.connection_connect(StatFilter.java:211) 
    	at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:142) 
    	at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1388) 
    	at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1442) 
    	at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:1881)
2021100358	Druid-ConnectionPool-Create-1743776012	ERROR	com.alibaba.druid.pool.DruidDataSource	create connection error, url: jdbc:mysql://127.0.0.1:3306/hgd
java.sql.SQLException: Access denied for user 'root'@'127.0.0.1' (using password: YES) 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:959) 
    	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3870) 
    	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3806) 
    	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:871) 
    	at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1686) 
    	at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1207) 
    	at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2254) 
    	at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2285) 
    	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2084) 
    	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:795) 
    	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:44) 
    	at sun.reflect.GeneratedConstructorAccessor38.newInstance(Unknown Source) 
    	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) 
    	at java.lang.reflect.Constructor.newInstance(Constructor.java:526) 
    	at com.mysql.jdbc.Util.handleNewInstance(Util.java:404) 
    	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:400) 
    	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:327) 
    	at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:148) 
    	at com.alibaba.druid.filter.stat.StatFilter.connection_connect(StatFilter.java:211) 
    	at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:142) 
    	at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1388) 
    	at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1442) 
    	at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:1881)
2021130360	Druid-ConnectionPool-Create-1743776012	ERROR	com.alibaba.druid.pool.DruidDataSource	create connection error, url: jdbc:mysql://127.0.0.1:3306/hgd
java.sql.SQLException: Access denied for user 'root'@'127.0.0.1' (using password: YES) 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:959) 
    	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3870) 
    	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3806) 
    	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:871) 
    	at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1686) 
    	at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1207) 
    	at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2254) 
    	at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2285) 
    	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2084) 
    	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:795) 
    	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:44) 
    	at sun.reflect.GeneratedConstructorAccessor38.newInstance(Unknown Source) 
    	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) 
    	at java.lang.reflect.Constructor.newInstance(Constructor.java:526) 
    	at com.mysql.jdbc.Util.handleNewInstance(Util.java:404) 
    	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:400) 
    	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:327) 
    	at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:148) 
    	at com.alibaba.druid.filter.stat.StatFilter.connection_connect(StatFilter.java:211) 
    	at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:142) 
    	at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1388) 
    	at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1442) 
    	at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:1881)
3 回复

mysql抛出的异常明显写着密码错

@wendal
但是我的密码和账户？

db.url=jdbc:mysql://127.0.0.1:3306/yundauseUnicode=true&characterEncoding=utf-8
db.username=cao
db.password=cao
db.validationQuery=select 1
db.maxActive=100

@cxw0504 报错信息里面显示用户名是root，根据这个线索去查查

添加回复
请先登陆
回到顶部