spring boot關(guān)于mysql 8.0的連接問題
之前我們習(xí)慣用Mysql5.0數(shù)據(jù)庫,連接的時候基本是這么配置的:
spring.datasource.driverClassName = com.mysql.jdbc.Driver
spring.datasource.url = jdbc:mysql://localhost:3306/數(shù)據(jù)庫名?
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里你如果還是這樣配置,就會報錯了,數(shù)據(jù)庫連接失敗.這就告訴我們不能再像之前那樣去配置連接了,我們需要改動.
改動1:
要換成新的驅(qū)動程序類是`com.mysql.cj.jdbc.Driver'
spring.datasource.driverClassName = com.mysql.cj.jdbc.Driver
改動2:
<dependency>
? <groupId>mysql</groupId>
? <artifactId>mysql-connector-java</artifactId>
? <version>8.0.11</version>
</dependency>
把version版本號要改了,改成8.0的.
另外,有的同學(xué)在連接的時候可能會報以下的錯誤:
這是告訴你,你在連接數(shù)據(jù)庫的時候,時區(qū)出現(xiàn)了錯誤,你需要在
url = jdbc:mysql://localhost:3306/數(shù)據(jù)庫名
后面添加? ?useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8&useSSL=false
即:
url = jdbc:mysql://localhost:3306/數(shù)據(jù)庫名?useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8&useSSL=false
這樣就不會報錯了.
