java.sql.SQLException: Access denied for user 'Administrator'@'localhost'

绝地灬酷狼 2022-01-21 23:05 177阅读 0赞

org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: An attempt by a client to checkout a Connection has timed out.
    	at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
    	at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:82)
    	at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:68)
    	at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:315)
    	at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:75)
    	at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:61)
    	at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:303)
    	at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:154)
    	at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:102)
    	at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:82)
    	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:120)

我在整合mybatis和spring的时候，测试数据库连接时报了标题所示错误，我的数据库连接配置如下：

driver=com.mysql.jdbc.Driver
    url=jdbc:mysql://localhost:3306/seckill?useUnicode=true&characterEncoding=utf-8
    username=root
    password=123

找了很久都不知道为什么错了，最后把username改成user就好了。应该是username这个变量和系统的某个变量冲突了。  
改成

driver=com.mysql.jdbc.Driver
    url=jdbc:mysql://localhost:3306/seckill?useUnicode=true&characterEncoding=utf-8
    user=root
    password=123

这里配置也需要更改就好了  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MDgwNzI0Nw_size_16_color_FFFFFF_t_70]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MDgwNzI0Nw_size_16_color_FFFFFF_t_70 1]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MDgwNzI0Nw_size_16_color_FFFFFF_t_70]: /images/20220122/0b32354bd1964e34b9b5bee8465fb40c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MDgwNzI0Nw_size_16_color_FFFFFF_t_70 1]: /images/20220122/cef6b43df8f54363b924e7ad370cd08e.png