[报错解决]java.sql.SQLException: Access denied for user ‘root‘@‘192.168.40.1‘ (using password: YES)

往昔时光

已于 2024-03-31 09:28:11 修改

阅读量220

点赞数 2

分类专栏： ⑦ 开发时遇到的问题文章标签： java 开发语言 mysql

于 2024-03-31 09:27:21 首次发布

本文链接：https://blog.csdn.net/wlkuym/article/details/137191072

版权

⑦ 开发时遇到的问题专栏收录该内容

27 篇文章 0 订阅

订阅专栏

org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException: 
### Error querying database.  Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: Access denied for user 'root'@'192.168.45.1' (using password: YES)
### The error may exist in com/itheima/dao/BookDao.java (best guess)
### The error may involve com.itheima.dao.BookDao.selectById
### The error occurred while executing a query
### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: Access denied for user 'root'@'192.168.45.1' (using password: YES)

报错解决：数据库密码配置不对，导致链接不了数据库

#2.配置相关信息
spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://rhel:3306/test_db?serverTimezone=UTC
    username: root
    password: root #修改为自己的密码