Shulou(Shulou.com)05/31 Report--

Xiaobian to share with you how to upgrade MySql5.x to MySql8.x, I believe most people do not know how, so share this article for everyone's reference, I hope you have a lot of harvest after reading this article, let's go to understand it together!

Mysql 5.x is different from Mysql 8.0.x

application.properties

Comments out for version 8.0.x.

spring.datasource.driver-class-name=com.mysql.jdbc.Driver//spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driverspring.datasource.username=root//Your username. default rootspring.datasource.password=123456//your password. Rootspring.datasource.url=jdbc:mysql://127.0.0.1:3306/sell? characterEncoding=utf-8&useSSL=false//spring.datasource.url=jdbc:mysql://127.0.0.1:3306/sell? useUnicode=true&characterEncoding=UTF8&useSSL=false&serverTimezone=UTCspring.jpa.show-sql=trueserver.context-path=/sell//server.servlet.context-path=/sell

MySql5.x Upgrading MySql8.x is very easy, generally only two steps are required

1. Replace the new jar package

mysql mysql-connector-java 8.0.18

2. Replace new driver class

com.mysql.cj.jdbc.Driver

3. To replace the new url connection, you need to specify the time zone

#Set the time to serverTimezone=GMT%2B8#Complete urlString url="jdbc:mysql://"+dbHost+":"+dbPort+"/"+dbName+"? " + "serverTimezone=GMT%2B8&useUnicode=true&characterEncoding=utf-8" + "&port="+dbPort+"&autoReconnect=true"; above is "MySql5.x how to upgrade to MySql8.x" all the content of this article, thank you for reading! I believe that everyone has a certain understanding, hope to share the content to help everyone, if you still want to learn more knowledge, welcome to pay attention to the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.