解决Connections could not be acquired from the underlying database!

果冻奶酪

于 2021-02-08 12:44:21 发布

439

分类专栏： Mybatis Spring maven

本文链接：https://blog.csdn.net/qq_43104182/article/details/113755081

版权

Mybatis 同时被 3 个专栏收录

6 篇文章 0 订阅

订阅专栏

Spring

3 篇文章 0 订阅

订阅专栏

maven

4 篇文章 0 订阅

订阅专栏

搭建ssm运行时报错

在用ssm搭建项目报了如下一系列错误,为远程连接 MySQL 8 时的错误
在这里插入图片描述
完整的错误信息

org.springframework.web.util.NestedServletException: 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: Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: Connections could not be acquired from the underlying database!
### The error may exist in com/fj/dao/BookMapper.xml
### The error may involve com.fj.dao.BookMapper.getAllBooks

解决方案

1.驱动配置有误：driver=com.mysql.cj.jdbc.Driver
2.数据库连接地址有误：url=jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf8
3.密码或帐号有误：username=root
password=root
4.数据库未启动或无权访问
5.mysql root没有远程访问的权限，需要增加权限，增加权限的步骤如下：
进入mysql数据库：
grant all privileges on . to ‘root’@’%’ identified by ‘root’ with grant option;
flush privileges;