spring.datasource.url=jdbc:mysql://localhost:3306/database?createDatabaseIfNotExist=true&allowPublicKeyRetrieval=true&useSSL=false

您可以将这一行插入到应用程序中。属性文件，这意味着，

spring.datasource.url=jdbc:mysql://localhost:3306/ This one uses mysql as the database service. I think this can changed by using relavent name and the port of your database name. database?createDatabaseIfNotExist=true = use the database named database if you haven't already make a database like that, make a new one. allowPublicKeyRetrieval=true = to allow the client to automatically request the public key from the server. (This part might be additional) useSSL=false = This will disable SSL and also suppress the SSL errors

此外，要警惕同一文件中的spring.jpa.database-platform=org.hibernate.dialect.MySQL8Dialect属性。

最后检查是否在pom.xml文件的dependencies中添加了以下依赖项。

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

我在spring引导框架上使用下面的配置解决了这个问题

spring.datasource.url=jdbc:mysql://localhost:3306/db-name?useUnicode=true&characterEncoding=UTF-8&allowPublicKeyRetrieval=true&useSSL=false
spring.datasource.username=root
spring.datasource.password=root

spring.datasource.url=jdbc:mysql://localhost:3306/database?createDatabaseIfNotExist=true&allowPublicKeyRetrieval=true&useSSL=false

您可以将这一行插入到应用程序中。属性文件，这意味着，

spring.datasource.url=jdbc:mysql://localhost:3306/ This one uses mysql as the database service. I think this can changed by using relavent name and the port of your database name. database?createDatabaseIfNotExist=true = use the database named database if you haven't already make a database like that, make a new one. allowPublicKeyRetrieval=true = to allow the client to automatically request the public key from the server. (This part might be additional) useSSL=false = This will disable SSL and also suppress the SSL errors

此外，要警惕同一文件中的spring.jpa.database-platform=org.hibernate.dialect.MySQL8Dialect属性。

最后检查是否在pom.xml文件的dependencies中添加了以下依赖项。

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

在对现有应用程序进行dockerization时，我也遇到过这样的问题。解决方案是在JDBC连接字符串中添加MySQL的allowPublicKeyRetrieval连接选项，值为true。 如果这是不工作，尝试添加useSSL选项为false以及。

结果字符串看起来像这样:

jdbc:mysql://<database server ip>:3306/databaseName?allowPublicKeyRetrieval=true&useSSL=false

这也可能发生由于错误的用户名或密码。 作为解决方案，我添加了allowPublicKeyRetrieval=true&useSSL=false部分，但我仍然得到了错误，然后我检查了密码，它是错误的。

当我遇到根帐户“不允许公开密钥检索”的问题时，我更新了这个参数。