求助JAVA web大神，为何从其他服务器移植到新服务器后spring连接mysql出错，数据库账户密码都正确。

[horsedavid]

我在其他服务器移植过来的，用户名和密码都正确。
myeclipse出错信息如下：

2017-04-25 15:15:37,656 ERROR [org.springframework.web.context.ContextLoader] -
Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean wit
h name 'sessionFactory' defined in class path resource [applicationContext.xml]:
Invocation of init method failed; nested exception is org.apache.commons.dbcp.D
bcpException: java.sql.SQLException: Access denied for user 'root'@'localhost' (
using password: YES)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory
.initializeBean(AbstractAutowireCapableBeanFactory.java:1338)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory
.doCreateBean(AbstractAutowireCapableBeanFactory.java:473)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory
$1.run(AbstractAutowireCapableBeanFactory.java:409)
at java.security.AccessController.doPrivileged(Native Method)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory
.createBean(AbstractAutowireCapableBeanFactory.java:380)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(Ab
stractBeanFactory.java:264)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSi
ngleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(Abst
ractBeanFactory.java:261)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(Abstra
ctBeanFactory.java:185)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(Abstra
ctBeanFactory.java:164)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInst
antiateSingletons(DefaultListableBeanFactory.java:423)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFac
toryInitialization(AbstractApplicationContext.java:728)
at org.springframework.context.support.AbstractApplicationContext.refresh(Abstr
actApplicationContext.java:380)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(Co
ntextLoader.java:255)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(Cont
extLoader.java:199)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(Con
textLoaderListener.java:45)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:
4842)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:
5303)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:147)
at org.apache.catalina.startup.HostConfig.reload(HostConfig.java:1381)
at org.apache.catalina.startup.HostConfig.checkResources(HostConfig.java:1345)
at org.apache.catalina.startup.HostConfig.check(HostConfig.java:1581)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:284)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSuppor
t.java:95)
at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java
:90)
at org.apache.catalina.core.ContainerBase.backgroundProcess(ContainerBase.java:
1140)
at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processC
hildren(ContainerBase.java:1376)
at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processC
hildren(ContainerBase.java:1380)
at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.run(Cont
ainerBase.java:1348)
at java.lang.Thread.run(Thread.java:744)
Caused by: org.apache.commons.dbcp.DbcpException: java.sql.SQLException: Access
denied for user 'root'@'localhost' (using password: YES)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConne
ctionFactory.java:85)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnect
ionFactory.java:184)
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPoo
l.java:722)
at org.apache.commons.dbcp.AbandonedObjectPool.borrowObject(AbandonedObjectPool
.java:117)
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.ja
va:108)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:3
12)
at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConn
ection(LocalDataSourceConnectionProvider.java:82)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:84)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2009)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1292)
at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory
(LocalSessionFactoryBean.java:814)
at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFacto
ry(LocalSessionFactoryBean.java:732)
at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPropertie
sSet(AbstractSessionFactoryBean.java:211)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory
.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1369)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory
.initializeBean(AbstractAutowireCapableBeanFactory.java:1335)
... 29 more
Caused by: java.sql.SQLException: Access denied for user 'root'@'localhost' (usi
ng password: YES)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:771)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3649)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1176)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2558)
at com.mysql.jdbc.Connection.<init>(Connection.java:1485)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConne
ctionFactory.java:83)
... 43 more
四月 25, 2017 3:15:37 下午 org.apache.catalina.core.StandardContext listenerStart
严重: Exception sending context initialized event to listener instance of class or
g.springframework.web.context.ContextLoaderListener
org.springframework.beans.factory.BeanCreationException: Error creating bean wit
h name 'sessionFactory' defined in class path resource [applicationContext.xml]:
Invocation of init method failed; nested exception is org.apache.commons.dbcp.D
bcpException: java.sql.SQLException: Access denied for user 'root'@'localhost' (
using password: YES)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory
.initializeBean(AbstractAutowireCapableBeanFactory.java:1338)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory
.doCreateBean(AbstractAutowireCapableBeanFactory.java:473)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory
$1.run(AbstractAutowireCapableBeanFactory.java:409)
at java.security.AccessController.doPrivileged(Native Method)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory
.createBean(AbstractAutowireCapableBeanFactory.java:380)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(Ab
stractBeanFactory.java:264)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSi
ngleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(Abst
ractBeanFactory.java:261)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(Abstra
ctBeanFactory.java:185)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(Abstra
ctBeanFactory.java:164)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInst
antiateSingletons(DefaultListableBeanFactory.java:423)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFac
toryInitialization(AbstractApplicationContext.java:728)
at org.springframework.context.support.AbstractApplicationContext.refresh(Abstr
actApplicationContext.java:380)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(Co
ntextLoader.java:255)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(Cont
extLoader.java:199)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(Con
textLoaderListener.java:45)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:
4842)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:
5303)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:147)
at org.apache.catalina.startup.HostConfig.reload(HostConfig.java:1381)
at org.apache.catalina.startup.HostConfig.checkResources(HostConfig.java:1345)
at org.apache.catalina.startup.HostConfig.check(HostConfig.java:1581)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:284)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSuppor
t.java:95)
at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java
:90)
at org.apache.catalina.core.ContainerBase.backgroundProcess(ContainerBase.java:
1140)
at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processC
hildren(ContainerBase.java:1376)
at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processC
hildren(ContainerBase.java:1380)
at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.run(Cont
ainerBase.java:1348)
at java.lang.Thread.run(Thread.java:744)
Caused by: org.apache.commons.dbcp.DbcpException: java.sql.SQLException: Access
denied for user 'root'@'localhost' (using password: YES)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConne
ctionFactory.java:85)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnect
ionFactory.java:184)

[horsedavid]

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"> <property name="driverClassName" value="com.mysql.jdbc.Driver"> </property> <property name="url"> <value>jdbc:mysql://localhost:3306/classnet?useUnicode=true&characterEncoding=UTF-8</value> </property> <property name="username" value="root"></property> <property name="password" value="david"></property> </bean>

[gggggame]

bcpException: java.sql.SQLException: Access denied for user 'root'@'localhost' ( using password: YES) 用数据库连接软件试下能连接不，再就是权限的这两个确认下

[我爱娃哈哈]

用户问题，可以选择新建一个用户就可以了

[paddon]

你的xml配置有问题！

[horsedavid]

数据库连接没有问题，另一个工程能够很好的运行，就是这个不行。

[暖心大人]

数据库路径不变？？？？？

[幽饮烛]

权限问题。 mysql 可以配置同一用户 不同ip 不同域名 不同的权限。