Migrating from MySQL version 7 to 8

MySQL Migration from version 7 to version 8:

Here is the simple and few steps which we need to follow to migrate to higher version or latest version.

                               

Step 1: We need to set the timezone in hibernate database configuration file as below:

  ?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC



Note:

In Case if you are working with xml file replace & symbol by &amp

Step 2: If you are working with spring mvc, Set the dependency in pom.xml

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