About the configuration problem of MyBatis connecting to MySql8.0 version

When learning mybatis, I encountered an error, the error is as follows:

Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

Cause:

• The local database version is MySQL 8.0
• Import the MySQL jar package version in the pom.xml configuration file as

The error is caused by the inconsistency between the local database version and the jar package version imported into MySQL

Solution:

[1] Install the corresponding version of the database locally. Since I have MySQL 5.6 and MySQL 8.0 installed locally, switching the database to MySQL 5.6 solves the problem.
[2] Modify the pom.xml configuration file, no need to switch the database

<dependency>
   <groupId>mysql</groupId>
   <artifactId>mysql-connector-java</artifactId>
   <version>8.0.18</version>
</dependency>

Supplement: Mybatis connection to mysql8.0 is abnormal

The reference to entity "serverTimezone" must end with the ';' delimiter.

Reference to entity 'serverTimeZone' must end with a ';' delimiter.
The solution is to use & instead in the xml configuration file.
Right now

<property name="jdbcUrl"> jdbc:mysql://localhost:3306/exam?characterEncoding=utf8&amp;serverTimezone=UTC </property>

This is the end of this article about the configuration issues of MyBatis connecting to MySql8.0 version. For more relevant MyBatis connecting to MySql8.0 content, please search for previous articles on 123WORDPRESS.COM or continue to browse the following related articles. I hope everyone will support 123WORDPRESS.COM in the future!