使用dbcp连接池的时候 org.springframework.jdbc.CannotGetJdbcConnectionException:

[怯-]

异常如下：
五月 07, 2017 5:30:03 下午 org.apache.catalina.core.StandardWrapperValve invoke
严重: Servlet.service() for servlet [springDispatcherServlet] in context with path [/springmybatis] threw exception [Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:
### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Cannot create PoolableConnectionFactory (Access denied for user 'root'@'localhost' (using password: YES))
### The error may exist in file [D:\Tomcat\webapps\springmybatis\WEB-INF\classes\com\hellojava\springmybatis\entity\UserMapper.xml]
### The error may involve com.hellojava.springmybatis.dao.IUserDao.loadbyId
### The error occurred while executing a query
### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Cannot create PoolableConnectionFactory (Access denied for user 'root'@'localhost' (using password: YES))] with root cause
java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:911)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3953)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1276)
......

spring的配置文件如下：

<bean id="dataSource" class="org.apache.tomcat.dbcp.dbcp2.BasicDataSource">
<property name="driverClassName" value="com.mysql.jdbc.Driver"></property>
<property name="url" value="jdbc:mysql://localhost:3306/mydatabase"></property>
<property name="username" value="root"></property>
<property name="password" value="123"></property>
<property name="initialSize" value="50"></property>
</bean>

[怯-]

spring 的配置文件如下： <bean id="dataSource" class="org.apache.tomcat.dbcp.dbcp2.BasicDataSource"> <property name="driverClassName" value="com.mysql.jdbc.Driver"></property> <property name="url" value="jdbc:mysql://localhost:3306/mydatabase"></property> <property name="username" value="root"></property> <property name="password" value="123"></property> <property name="initialSize" value="50"></property> </bean>

[李德胜1995]

Access denied for user 'root'@'localhost' (using password: YES)。。。。root用户没有权限？？？

[怯-]

引用 2 楼 pany1209 的回复:

Access denied for user 'root'@'localhost' (using password: YES)。。。。root用户没有权限？？？

总感觉不是11 那如何查看 root的 用户权限？