blocks|key|4315721|text|您应该将客户端选项添加到mysql连接器allowPublicKeyRetrieval=true中，以允许客户端自动从服务器请求公钥。请注意，AllowPublicKeyRetrieval=True可能允许恶意代理执行MITM攻击以获取明文密码，因此它在默认情况下是假的，必须显式启用。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|4315722|https://mysql-net.github.io/MySqlConnector/connection-options/|4315723|在使用useSSL=false进行测试/开发时，您也可以尝试添加它|4315724|示例：|4315725|jdbc:mysql://localhost:3306/db?allowPublicKeyRetrieval=true&useSSL=false|code-block|syntax|javascript|4315726|entityMap|0|LINK|mutability|MUTABLE|url^0|K|S|1Z|S|0|0|1Q|0|0|3|C|0|0|0^^$0|@$1|2|3|4|5|6|7|X|8|@$9|Y|A|Z|B|C]|$9|10|A|11|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|12|8|@]|D|@$9|13|A|14|1|15]]|E|$]]|$1|H|3|I|5|6|7|16|8|@$9|17|A|18|B|C]]|D|@]|E|$]]|$1|J|3|K|5|6|7|19|8|@]|D|@]|E|$]]|$1|L|3|M|5|N|7|1A|8|@]|D|@]|E|$O|P]]|$1|Q|3|-4|5|6|7|1B|8|@]|D|@]|E|$]]]|R|$S|$5|T|U|V|E|$W|G]]]]

You should add client option to your mysql-connector <code>allowPublicKeyRetrieval=true</code> to allow the client to automatically request the public key from the server. Note that <code>AllowPublicKeyRetrieval=True</code> could allow a malicious proxy to perform a MITM attack to get the plaintext password, so it is False by default and must be explicitly enabled.

<a href="https://mysql-net.github.io/MySqlConnector/connection-options/" rel="noreferrer">https://mysql-net.github.io/MySqlConnector/connection-options/</a>

you could also try adding <code>useSSL=false</code> when you use it for testing/develop purposes 

example:

<pre><code>jdbc:mysql://localhost:3306/db?allowPublicKeyRetrieval=true&amp;useSSL=false
</code></pre>

blocks|key|4315638|text|我在spring+boot+framework上使用下面的配置解决了这个问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4315639|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|code-block|syntax|javascript|4315640|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

I solve this issue using below configuration on spring boot framework

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

blocks|key|4315786|text|此解决方案适用于运行MySQL版本8.0.11的MacOS西拉。请确保您在构建路径中添加的驱动程序-+"add+external+jar“应与SQL版本匹配。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4315787|String+url+=+"jdbc:mysql://localhost:3306/syscharacterEncoding=utf8&useSSL=false&serverTimezone=UTC&rewriteBatchedStatements=true";|code-block|syntax|javascript|4315788|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

This solution worked for MacOS Sierra, and running MySQL version 8.0.11. Please make sure driver you have added in your build path - "add external jar" should match up with SQL version.

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

blocks|key|4315728|text|在我的例子中，这是用户错误。我使用的root用户的密码无效。我不确定为什么我没有收到身份验证错误，而是收到了这条神秘的消息。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|4315729|entityMap^0|I|4|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

In my case it was user error. I was using the <code>root</code> user with an invalid password. I am not sure why I didn't get an auth error but instead received this cryptic message.

blocks|key|4315884|text|在我的例子中，上述错误实际上是由于错误的用户名和密码造成的。解决问题:+1.转到行DriverManager.getConnection("jdbc:mysql://localhost:3306/?useSSL=false"，"+username+"，"+password+")；username和password字段可能是错误的。输入用来启动mysql客户端的用户名和密码。用户名通常是超级用户，密码是在出现类似Startup+screen+of+mysql的屏幕时输入的字符串|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|4315885|注意:端口名称3306在您的情况下可能有所不同。|4315886|entityMap|0|LINK|mutability|MUTABLE|url|https://i.stack.imgur.com/GLfhY.png^0|5R|N|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@$A|O|B|P|1|Q]]|C|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@]|C|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]]]

The above error in my case was actually due to the wrong username and password.
Solving the issue:
1. Go to the line DriverManager.getConnection("jdbc:mysql://localhost:3306/?useSSL=false", "username", "password");
The fields username and password might be wrong. Enter the username and password which you use to start your mysql client. The username is generally root and password is the string which you enter when a screen similar to this appears <a href="https://i.stack.imgur.com/GLfhY.png" rel="nofollow noreferrer">Startup screen of mysql</a>

Note: The portname 3306 might be different in your case.

blocks|key|4315955|text|我发现这个问题很令人沮丧，因为我昨天能够与数据库交互，但今天早上回来后，我开始收到这个错误。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4315956|我尝试添加allowPublicKeyRetrieval=true标志，但一直收到错误。|offset|length|style|CODE|4315957|修复它的方法是在Eclipse中执行Project->Clean，并在Tomcat服务器上执行Clean。其中一个(或两个)修复了它。|4315958|我不明白为什么，因为我使用Maven构建我的项目，并且在每次代码更改后重新启动我的服务器。非常恼人..。|4315959|entityMap^0|0|5|S|0|I|E|1B|5|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@$D|P|E|Q|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|R|8|@$D|S|E|T|F|G]|$D|U|E|V|F|G]]|9|@]|A|$]]|$1|J|3|K|5|6|7|W|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|X|8|@]|9|@]|A|$]]]|M|$]]

I found this issue frustrating because I was able to interact with the database yesterday, but after coming back this morning, I started getting this error.

I tried adding the <code>allowPublicKeyRetrieval=true</code> flag, but I kept getting the error.

What fixed it for me was doing <code>Project-&gt;Clean</code> in Eclipse and <code>Clean</code> on my Tomcat server. One (or both) of those fixed it.

I don't understand why, because I build my project using Maven, and have been restarting my server after each code change. Very irritating...

blocks|key|4315906|text|将连接URL指定为jdbc:mysql://localhost:3306/hb_student_tracker?allowPublicKeyRetrieval=true&useSSL=false&serverTimezone=UTC|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4315907|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Give connection URL as 
jdbc:mysql://localhost:3306/hb_student_tracker?allowPublicKeyRetrieval=true&amp;useSSL=false&amp;serverTimezone=UTC

blocks|key|4315954|text|如果您在连接mysql+(运行mysql的本地或mysql容器)时遇到以下错误：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4315955|java.sql.SQLNonTransientConnectionException:不允许公钥检索|4315956|解决方案:在数据库服务中添加以下行：|4315957|command:+--default-authentication-plugin=mysql_native_password|code-block|syntax|javascript|4315958|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|N|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|O|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|P|8|@]|9|@]|A|$I|J]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

If you are getting the following error while connecting the mysql (either local or mysql container running the mysql):

java.sql.SQLNonTransientConnectionException: Public Key Retrieval is not allowed

Solution:
Add the following line in your database service:

<pre><code>command: --default-authentication-plugin=mysql_native_password
</code></pre>

blocks|key|4315991|text|用mysql更新spring+boot应用连接中的useSSL=true；|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4315992|jdbc:mysql://localhost:3306/demo?useUnicode=true&characterEncoding=utf8&useSSL=true&useLegacyDatetimeCode=false&serverTimezone=UTC|code-block|syntax|javascript|4315993|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Update the useSSL=true in spring boot application connection with mysql;

<pre><code>jdbc:mysql://localhost:3306/demo?useUnicode=true&amp;characterEncoding=utf8&amp;useSSL=true&amp;useLegacyDatetimeCode=false&amp;serverTimezone=UTC
</code></pre>

blocks|key|4316137|text|首先，请确保您的数据库服务器已启动并正在运行。我得到了相同的错误，在尝试了这里列出的所有答案后，我发现我的数据库服务器没有运行。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4316138|您可以在MySQL工作台或命令行中使用以下命令进行检查|4316139|mysql+-u+USERNAME+-p|code-block|syntax|javascript|4316140|这听起来很明显，但很多时候我们假设数据库服务器一直处于启动和运行状态，特别是当我们在本地机器上工作时，当我们重新启动/关闭机器时，数据库服务器将自动关闭。|4316141|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|N|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|O|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|P|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

First of all, please make sure your Database server is up and running. 
I was getting the same error, after trying all the answers listed here I found out that my Database server was not running.

You can check the same from MySQL Workbench, or Command line using 

<pre><code>mysql -u USERNAME -p
</code></pre>

This sounds obvious, but many times we assume that Database server is up and running all the time, especially when we are working on our local machine, when we restart/shutdown the machine, Database server will be shutdown automatically.

blocks|key|4316181|text|这也可能是由于错误的用户名或密码造成的。作为解决方案，我添加了allowPublicKeyRetrieval=true&useSSL=false部件，但仍然出现错误，然后我检查了密码，发现它是错误的。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|4316182|entityMap^0|V|15|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

This also can be happened due to wrong user name or password.
As solutions I've added <code>allowPublicKeyRetrieval=true&amp;useSSL=false</code> part but still I got error then I checked the password and it was wrong.

blocks|key|4316227|text|我的问题出在pom.xml+(spring+boot)。我的pom.xml对不同的数据库有两个依赖项。请确保仅保留MySQL依赖项，并删除任何其他数据库依赖项。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|4316228|entityMap^0|6|7|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

My problem was in <code>pom.xml</code> (spring boot).
My pom.xml had two dependencies entries for different databases. Make sure to keep only the MySQL dependency and remove any other database dependency entry.

blocks|key|4316194|text|另一种方式，在DBeaver上。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4316195|您可以编辑数据库的连接，转到连接设置中的SSL选项卡。有一个复选框“允许公钥检索”将其标记为true。这就解决了问题。|4316196|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

Another way, on DBeaver.
You can edit the connection of a database, go to SSL tab in connection settings. There's a checkbox &quot;allow public key retrieval&quot; mark it as true. That'll sove the issue.

blocks|key|4316323|text|当我遇到root账号的公钥检索不被允许的问题时，我更新了这个参数。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4316324|​|4316325|📷|atomic|offset|length|4316326|4316327|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/8593808fb22a1b34bc59c053c91a06de.png|imageAlt^0|0|0|0|1|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|T|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@$G|V|H|W|1|X]]|A|$]]|$1|I|3|C|5|6|7|Y|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|K|$L|$5|M|N|O|A|$P|Q|R|-4]]]]

I updated this parameter when I faced the issue of &quot;public-key-retrieval-is-not-allowed&quot; with root account.
<a href="https://i.stack.imgur.com/xxj11.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/xxj11.png" alt="DBeaver update this parameter" /></a>

I try to connect MySQL database with Java using connector 8.0.11. Everything seems to be OK, but I get this exception:
<pre><code>Exception in thread &quot;main&quot; java.sql.SQLNonTransientConnectionException: Public Key Retrieval is not allowed at
 com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:108) at 
 com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:95) at
 com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at 
 com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:862) at 
 com.mysql.cj.jdbc.ConnectionImpl.(ConnectionImpl.java:444) at
 com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:230) at
 com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:226) at
 com.mysql.cj.jdbc.MysqlDataSource.getConnection(MysqlDataSource.java:438) at
 com.mysql.cj.jdbc.MysqlDataSource.getConnection(MysqlDataSource.java:146) at
 com.mysql.cj.jdbc.MysqlDataSource.getConnection(MysqlDataSource.java:119) at
 ConnectionManager.getConnection(ConnectionManager.java:28) at
 Main.main(Main.java:8)
 
</code></pre>
Here is my Connection Manager class:
<pre><code>public class ConnectionManager {

 public static final String serverTimeZone = &quot;UTC&quot;;
 public static final String serverName = &quot;localhost&quot;;
 public static final String databaseName =&quot;biblioteka&quot;;
 public static final int portNumber = 3306;
 public static final String user = &quot;anyroot&quot;;
 public static final String password = &quot;anyroot&quot;;
 
 public static Connection getConnection() throws SQLException {
 
 MysqlDataSource dataSource = new MysqlDataSource();
 
 dataSource.setUseSSL( false );
 dataSource.setServerTimezone( serverTimeZone );
 dataSource.setServerName( serverName );
 dataSource.setDatabaseName( databaseName );
 dataSource.setPortNumber( portNumber );
 dataSource.setUser( user );
 dataSource.setPassword( password );
 
 return dataSource.getConnection();
 }
}
</code></pre>

Connection Java - MySQL : Public Key Retrieval is not allowed

身份验证

SQL数据库

数据库

服务器

Eclipse

容器

MySQL

MacOS

Java

我尝试使用连接器8.0.11连接MySQL数据库和Java。一切似乎都很好，但我得到了一个例外：Exception in thread "main" java.sql.SQLNonTransientConnectionException: Public Key Retrieval is not allowed at  ...

问Connection Java - MySQL :不允许公钥检索
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Connection Java - MySQL :不允许公钥检索EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Connection Java - MySQL :不允许公钥检索
EN