【SQL】【Springboot】Could not create connection to database server.
程序员文章站
2022-05-01 15:55:02
...
mysqll版本号和maven中pom文件中配置的mysql-connector版本号不同,在将pom文件中的版本号改成本地mysql的版本号以后再更新maven问题解决。
小tips:
1.如何知道自己的mysql版本号:
在任何一个能执行sql语句的地方执行语句:select version() from dual;
它就会返回一个版本号
2.如果这个方法不好使,可以试试将mysql驱动名改成:com.mysql.cj.jdbc.Driver
实验楼的教程中 使用的
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
pom依赖中版本没有标注
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
出现了上述问题
解决方案
个人环境使用MySQL 5.1
添加版本标注
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.21</version>
</dependency>
把spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver 的CJ去掉
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
成功解决
上一篇: Xshell虚拟终端的使用
下一篇: IDEA连接数据库失败@localhost failed. [08001] Could not create connection to database server. Attempte
推荐阅读
-
pycharm连接mysql是出现Connection to orm02@127.0.0.1 failed. [08001] Could not create connection to database server. Attempted reconnect 3 times. Giving up.
-
[08001] Could not create connection to database server. Attempted reconnect 3 times. Giving up.
-
初次使用MYSQL,IDEA连接MYSQL出现 [08001] Could not create connection to database server.
-
Could not create connection to database server. Attempted reconnect 3 times. Giving up.
-
【SQL】【Springboot】Could not create connection to database server.
-
IDEA连接数据库失败@localhost failed. [08001] Could not create connection to database server. Attempte
-
Connection to @localhost failed. [08001] Could not create connection to database server. Attempt
-
idea连接MySQL报错Could not create connection to database server. Attempted reconnect 3 times. Giving up.
-
Connection to [email protected] failed. [08001] Could not create connection to database server. Attemp
-
[08001] Could not create connection to database server. Attempted reconnect 3 times. Giving up.