spring boot关于mysql 8.0的连接问题
之前我们习惯用Mysql5.0数据库,连接的时候基本是这么配置的:
spring.datasource.driverClassName = com.mysql.jdbc.Driver
spring.datasource.url = jdbc:mysql://localhost:3306/数据库名?
useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8&useSSL=false
spring.datasource.username= root
spring.datasource.password = 123456
然后在Pom.xml添加配置:
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.32</version>
</dependency>
但是在mysql8.0里你如果还是这样配置,就会报错了,会报数据库连接失败.这就告诉我们不能再像之前那样去配置连接了,我们需要改动.
改动1:
要换成新的驱动程序类是**`com.mysql.cj.jdbc.Driver’**
spring.datasource.driverClassName = com.mysql.cj.jdbc.Drive
改动2:
<dependency>
<gr