mybatis+spring整合 Thread[C3P0PooledConnectionPoolManagAccess denied for user '27819'@'localhost'

使用cp30数据源，mybatis+spring配置时候，报错， Thread[C3P0PooledConnectionPoolManager[identityToken->1hge1648v7x7xsqhft1n|1e3a43]-HelperThread-#1,5,main]
  java.net.SocketInputStream.socketRead0(Native Method)
  java.net.SocketInputStream.read(SocketInputStream.java:129)

Access denied for user '27819'@'localhost'

 

其他配置都正确

drivername=com.mysql.jdbc.Driver
url=jdbc:mysql://127.0.0.1:3306/login_db
username=root
password=root
maxPoolSize=20
minPoolSize=1
initialPoolSize=1
checkoutTimeout=10000

 

 

<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
        <property name="driverClass" value="${jdbc.drivername}"></property>
        <property name="jdbcUrl" value="${jdbc.url}"></property>
        <property name="user" value="${jdbc.username}"></property>
        <property name="password" value="${jdbc.password}"></property>
        <property name="maxPoolSize" value="${maxPoolSize}"></property>
        <property name="minPoolSize" value="${minPoolSize}"></property>
        <property name="initialPoolSize" value="${initialPoolSize}"></property>
        
        </bean>

 

 

改成这个：

jdbc.drivername=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://127.0.0.1:3306/login_db
jdbc.username=root
jdbc.password=root
maxPoolSize=20
minPoolSize=1
initialPoolSize=1
checkoutTimeout=10000

映射有问题，主要是url和password，把所有的名字前面加上“jdbc.”

 

 

网上还有说mysql连接数过多，没遇到这种情况