Shulou(Shulou.com)06/02 Report--

This article introduces the knowledge of "what to pay attention to when using a high version of mysql1.8". Many people will encounter such a dilemma in the operation of actual cases, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

The comments for the mysql1.8 driver in the 1.pom file are opened, introducing a dependency on a higher version of mysql.

Mysql

Mysql-connector-java

8.0.11

Mysql

Mysql-connector-java

Add to the 2.pom file

Com.alibaba

Druid

1.1.10

In 3.ms.properties

Change jdbc.driver to com.mysql.cj.jdbc.Driver

Add serverTimezone=GMT%2B8 after jdbc.url

Add allowPublicKeyRetrieval=true to jdbc.url (to avoid PublicKeyRetrieval is not allowed errors)

Change the zeroDateTimeBehavior=convertToNull of jdbc.url to zeroDateTimeBehavior=convert_To_Null

4. Right-click any project properties

① java Build Path removes the old version of JRE (below 1.8), and JRE System Library selects the installed version of jdk1.8.

② java Compiler changed javaSE to 1.8

③ Project Facets changed java to 1.8

This is the end of the content of "what to pay attention to when using a higher version of mysql1.8". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

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.