问题描述
2014-10-3113:19:26,985DEBUG[com.mchange.v2.resourcepool.BasicResourcePool]-Anexceptionoccurredwhileacquiringapoolableresource.Willretry.java.sql.SQLException:Accessdeniedforuser'root'@'localhost'(usingpassword:YES)atcom.mysql.jdbc.SQLError.createSQLException(SQLError.java:1094)atcom.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4226)atcom.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4158)atcom.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:926)atcom.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1748)atcom.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1288)atcom.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2508)atcom.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2541)atcom.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2323)atcom.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:832)atcom.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)atsun.reflect.GeneratedConstructorAccessor141.newInstance(UnknownSource)atsun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)atjava.lang.reflect.Constructor.newInstance(Constructor.java:513)atcom.mysql.jdbc.Util.handleNewInstance(Util.java:408)atcom.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:417)atcom.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:344)atcom.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)atcom.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)atcom.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)atcom.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)atcom.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)atcom.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)atcom.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)atcom.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)<br/><br/><br/>这是报的错,一直循环报这个错求大神帮忙,用户名密码都是root我用管理工具可链接建表截几个图,链接Oracle很好但是换成mysql就不知道哪里出错了,
解决方案
解决方案二:
解决方案三:
用户名密码不对
解决方案四:
哎,每次发完帖子都能把错误调好!这个确实是用户名密码不对报的错,这是properties文件引入的问题,我把properties的数据直接写道c3p0的配置文件中想重新编就好了,再次删c3p0配置中的数据(用户名密码什么的)加载properties文件,就又好了,估计是maven的加载出现问题了,感谢大家!!!
解决方案五:
先试试能不能连上mysql数据库先,