无法打开连接-Spring MVC 4.x-MySql 8

Question

我已经将MySQL从5.x更新到了8.x。还更改了POM文件中的相关版本。一旦我尝试启动应用程序，我的应用程序就会以下面粘贴的JDBC连接错误开始。

<properties>
        <springVersion>4.2.4.RELEASE</springVersion>
        <spring.security.version>4.2.4.RELEASE</spring.security.version>
        <dbGroupId>mysql</dbGroupId>
        <dbArtifactId>mysql-connector-java</dbArtifactId>
        <dbArtifactVersion>8.0.11</dbArtifactVersion>
    </properties>

以上是我使用的版本，

任何关于如何解决这个问题的投入都将是真正有帮助的。谢谢

Answer 1

解决方案是使用MySQL的OLD_PASSWORD函数更新数据库用户的密码。例如：

[chris@office ~]$ mysql -u root -p mysql

Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 267
Server version: 5.1.41-3ubuntu12.1 (Ubuntu)

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use mysql;
Database changed

mysql> update user set Password=OLD_PASSWORD('password') WHERE User='username';

Query OK, 0 rows affected (0.02 sec)
Rows matched: 0  Changed: 0  Warnings: 0

mysql> flush privileges;

Query OK, 0 rows affected (0.00 sec)

mysql>

请参阅以下内容:https://dev.mysql.com/doc/refman/5.5/en/old-client.html