【Druid】Access Denied for User ''@'ip'
来源:互联网 发布:淘宝客服有提成吗 编辑:程序博客网 时间:2024/06/01 07:12
今天在写单元测试时,遇到一个很奇葩的问题,一直在报这样的错误:
Caused by: java.sql.SQLException: Access denied for user ''@'183.134.103.169' (using password: YES) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:998) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:871) at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1665) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1207) at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2249) at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2280) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2079) at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794) at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:44) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.jdbc.Util.handleNewInstance(Util.java:400) at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:399) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:325) at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:148) at com.alibaba.druid.filter.FilterAdapter.connection_connect(FilterAdapter.java:785) at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:142) at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1423) at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1477) at com.alibaba.druid.pool.DruidDataSource.init(DruidDataSource.java:677) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1640) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1581) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1511) ... 62 more
分析来分析去,总是找不到错误的原因。于是想到,难道是Druid的配置问题?
于是重新看了下spring的数据库配置,
<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close"> <property name="url" value="${db.url}"/> <property name="name" value="${db.user}"/> <property name="password" value="${db.password}"/> <property name="initialSize" value="${db.initialSize}"/> <property name="minIdle" value="${db.maxIdle}"/> <property name="maxActive" value="${db.maxActive}"/> <property name="maxWait" value="${db.maxWait}"/> <!-- 配置间隔多久才进行一次检测,检测需要关闭的空闲连接,单位是毫秒 --> <property name="timeBetweenEvictionRunsMillis" value="60000"/> <!-- 配置一个连接在池中最小生存的时间,单位是毫秒 --> <property name="minEvictableIdleTimeMillis" value="60000"/> <property name="validationQuery" value="SELECT 'x'"/> <property name="testWhileIdle" value="true"/> <property name="testOnBorrow" value="false"/> <property name="testOnReturn" value="false"/> <property name="filters" value="config"/> <property name="connectionProperties" value="config.decrypt=true"/> <!-- 每隔5分钟将监控日志输出到日志文件中,单位是毫秒。 --> <property name="timeBetweenLogStatsMillis" value="300000"/> </bean>
发现name这个属性感觉不太对劲,于是查阅文档。
原来这边配置的链接用户名应该是userName,而不是name。改为userName立刻解决问题,于是mark一下。
阅读全文
0 0
- 【Druid】Access Denied for User ''@'ip'
- 解决mysql"Access denied for user'root'@'IP地址'"问题
- 解决mysql“Access denied for user 'root'@'IP地址'
- 解决mysql“Access denied for user 'root'@'IP地址'
- mysql“Access denied for user 'root'@'IP地址'
- 解决mysql"Access denied for user'root'@'IP地址'"问题
- 解决mysql“Access denied for user 'root'@'IP地址'
- 解决mysql"Access denied for user'root'@'IP地址'"问题
- 解决mysql"Access denied for user'root'@'IP地址'"问题
- 解决mysql"Access denied for user'root'@'IP地址'"问题
- 解决mysql“Access denied for user 'root'@'IP地址'
- 解决mysql"Access denied for user'root'@'IP地址'"问题
- 解决mysql"Access denied for user'root'@'IP地址'"问题
- 解决mysql"Access denied for user'root'@'IP地址'"问题
- 解决mysql"Access denied for user'root'@'IP地址'"问题
- 解决mysql“Access denied for user 'root'@'IP地址'
- mysql“Access denied for user 'root'@'IP地址
- 解决mysql“Access denied for user 'root'@'IP地址'
- Java中的多线程你只要看这一篇就够了
- 数据持久化基础知识——应用的沙盒
- <转>BeanUtils Map与Bean转换
- Movie Studio各种轨道如何使用?
- Centos6.5下guacamole 0.9.8配置数据库,实现管理多台电脑
- 【Druid】Access Denied for User ''@'ip'
- itoa函数 和_itoa_s函数
- 从Java文件到字节码文件
- CentOS安装memcached
- HDU 6069 Counting Divisors 【数论】
- 基础算法之三 希尔排序的实现
- 安卓,网页控件,显示网页 Android, web controls, display web pages
- 某个概念
- spring 国际化 java.lang.IllegalArgumentException: Malformed \uxxxx encoding