作为建议的答案，您可以尝试使用mysql_native_password身份验证插件而不是caching_sha2_password身份验证插件。

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'your_password_here'; 

此解决方案适用于MacOS Sierra，并运行MySQL 8.0.11版本。请确保您在构建路径中添加了驱动程序-“添加外部jar”应该与SQL版本匹配。

String url = "jdbc:mysql://localhost:3306/syscharacterEncoding=utf8&useSSL=false&serverTimezone=UTC&rewriteBatchedStatements=true";

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

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

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

在MySQL 8.0中，默认的身份验证插件由mysql_native_password更改为caching_sha2_password。 有关此更改的更多信息，请参阅https://dev.mysql.com/doc/refman/8.0/en/upgrading-from-previous-series.html#upgrade-caching-sha2-password。

这意味着为了使用caching_sha2_password，连接必须执行以下操作之一:

使用安全连接(useSSL=true) 使用未加密的连接，支持使用RSA密钥对交换密码(useSSL=false和其他配置参数-见https://dev.mysql.com/doc/refman/8.0/en/caching-sha2-pluggable-authentication.html)

你有几个选择:

ALTER the users to use the mysql_native_password plugin (like how it was doing historically and will also work with older clients / connections which don't support caching_sha2_password) useSSL=true useSSL=false and configure public key retrieval (this doesn't mean using allowPublicKeyRetrieval=true which would avoid the error - but defeats the objective of this extra security and is slow - it does mean using something like server-public-key-path to point to the client side copy of the public key)

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>

作为建议的答案，您可以尝试使用mysql_native_password身份验证插件而不是caching_sha2_password身份验证插件。

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'your_password_here';