java.sql.SQLException: Access denied for user 'root'@'144.0.32.175' (using password: YES)

应用发布测试的时候配合tomcat升级版本从7.0.26升级到.0.52，配置文件都是copy过去的，但是数据库死活连接不上。
新的应用在26的tomcat下可以正常使用，在52下却不行。

报错信息如下：

STACKTRACE:java.sql.SQLException: Access denied for user 'shoa'@'144.0.32.175' (using password: YES)at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2941)at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:868)at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3340)at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1238)at com.mysql.jdbc.Connection.createNewIO(Connection.java:2891)at com.mysql.jdbc.Connection.<init>(Connection.java:1553)at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)at org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)at org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)at org.apache.tomcat.dbcp.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556)at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:173)at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:152)at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:128)at com.fulan.jdev.web.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:119)at com.fulan.jdev.web.orm.ibatis.SqlMapClientTemplate.executeWithListResult(SqlMapClientTemplate.java:160)at com.fulan.jdev.web.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapClientTemplate.java:290)at com.fulan.pub.access.dao.ibatis.SqlMapAccessUrlDao.searchAccessUrl(SqlMapAccessUrlDao.java:55)at com.fulan.pub.access.service.AccessService.createAccessUrl(AccessService.java:18)at com.fulan.pub.front.FrontFilter.doFilter(FrontFilter.java:46)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:193)at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:313)at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)at java.lang.Thread.run(Thread.java:662)** END NESTED EXCEPTION **Attempted reconnect 3 times. Giving up.)at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:173)at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:152)at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:128)at com.fulan.jdev.web.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:119)at com.fulan.jdev.web.orm.ibatis.SqlMapClientTemplate.executeWithListResult(SqlMapClientTemplate.java:160)at com.fulan.jdev.web.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapClientTemplate.java:290)at com.fulan.pub.access.dao.ibatis.SqlMapAccessUrlDao.searchAccessUrl(SqlMapAccessUrlDao.java:55)at com.fulan.pub.access.service.AccessService.createAccessUrl(AccessService.java:18)at com.fulan.pub.front.FrontFilter.doFilter(FrontFilter.java:46)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:193)at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:313)at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)at java.lang.Thread.run(Thread.java:662)Caused by: com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Server connection failure during transaction. Due to underlying exception: 'java.sql.SQLException: Access denied for user 'shoa'@'144.0.32.175' (using password: YES)'.** BEGIN NESTED EXCEPTION ** 

因为配置文件是放在server.xml文件中的，而且server.xml是直接从26COPY过来的、且密码是密文，所以比较奇怪。

1.排查用户是否能从应用访问数据库

排查结果正常

mysql> SELECT User, Host, Password FROM mysql.user;

2.确定排查用户在应用服务器是否授权？

排查结果正常。

grant all privileges on shoa.* to shoa@172.18.64.119 identified by 'shoa';flush privileges;

3.SSH连接mysql服务器登录正常？

排查结果为正常

4.将server.xml中的密码密文修改为明文密码

结果应用启动正常，不报错。

总结：尚不了解我厂加密机制，不同版本服务器即便COPY过来的配置文件也未必起效。很多问题出现在最基本最不想不到的简单的地方。