Problems and solutions encountered when deploying a project when upgrading the Mysql database from version 5.6.28 to version 8.0.11

The problems and solutions encountered when deploying the project during the upgrade of MySQL database version from 5.6.28 to 8.0.11 are described in detail as follows:

First of all, this project uses hibernate4.2.0, and there is no problem connecting to mysql5.6.28. After changing to 8.0.11, an error is reported when starting

1.Caused by: org.hibernate.HibernateException: Connection cannot be null when 'hibernate.dialect' not set

If an error occurs, configure it

There is no error when starting the project, but an error is reported when accessing the project

2. Access error com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Client does not support authentication protocol requested by server; consider upgrading MySQL client

The reason is: the configuration process of Authentication Method during the installation of mysql8 is based on different encryption methods. If you choose the first strong encryption method, the phenomenon I described before will occur; you should choose the second authentication method, that is, keep the old encryption method.

So there are 3 solutions:

1. Reinstall mysql8, and select the second option to keep the old encryption method.

2.MySQL Installer can directly modify the Authentication Method configuration

3. Directly execute statement modification

mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
Query OK, 0 rows affected (0.11 sec)
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.01 sec)

Note: root is the username, localhost refers to the local machine, mysql_native_password is the old password verification mechanism, and 123456 is the password

Summarize

The above is the problems and solutions encountered in the process of deploying the project when upgrading the Mysql database from version 5.6.28 to version 8.0.11. I hope it will be helpful to everyone. If you have any questions, please leave me a message and I will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!