Connection Java-MySql Public Key Retrieval is not allowed

Question

I try to connect MySql database with Java using connector 8 0 11  Everything seems to be ok but I have this exception      Exception in thread  main  java sql SQLNonTransientConnectionException  Public Key Retrieval is not allowed   Stack Trace       Exception in thread  main  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    Connector Manager   public class ConnectionManager        public static final String serverTimeZone    UTC       public static final String serverName    localhost       public static final String databaseName   biblioteka       public static final int portNumber   3306      public static final String user    anyroot       public static final String password    anyroot        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

User · Accepted Answer

You should add client option to your mysql-connector allowPublicKeyRetrieval=true to allow the client to automatically request the public key from the server. Note that AllowPublicKeyRetrieval=True 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.

https://mysql-net.github.io/MySqlConnector/connection-options/

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

example:

jdbc:mysql://localhost:3306/db?allowPublicKeyRetrieval=true&useSSL=false

User · Answer

Alternatively to the suggested answers you could try and use mysql native password authentication plugin instead of caching sha2 password authentication plugin   ALTER USER  root   localhost  IDENTIFIED WITH mysql native password BY  your password here

User · Answer

I solve this issue using below configuration on spring boot framework  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

User · Answer

For DBeaver users    Right click your connection  choose  Edit Connection  On the  Connection settings  screen  main screen  click on  Edit Driver Settings  Click on  Connection properties  Right click the  user properties  area and choose  Add new property  Add two properties   useSSL  and  allowPublicKeyRetrieval  Set their values to   false  and  true  by double clicking on the  value  column

User · Answer

I was also facing such an issue while dockerizing our existing application  The solution si to add allowPublicKeyRetrieval connection option of MySQL with a value of true to the JDBC connection string  If that is not working   try adding useSSL option to false as well    The resultant string would look like this     jdbc mysql    lt database server ip gt  3306 databaseName allowPublicKeyRetrieval true amp useSSL false

User · Answer

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   mysql -u USERNAME -p   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

User · Answer

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

User · Answer

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   command  --default-authentication-plugin mysql native password

User · Answer

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   String url    jdbc mysql   localhost 3306 syscharacterEncoding utf8 amp useSSL false amp serverTimezone UTC amp rewriteBatchedStatements true

User · Answer

This also can be happened due to wrong user name or password  As solutions I ve added  allowPublicKeyRetrieval true amp useSSL false part but still I got error then I checked the password and it was wrong

User · Answer

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 allowPublicKeyRetrieval true flag  but I kept getting the error   What fixed it for me was doing Project- gt Clean in Eclipse and Clean 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

User · Answer

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 Startup screen of mysql  Note  The portname 3306 might be different in your case

User · Answer

Use  jdbc url as    jdbc mysql   localhost 3306 Database dbName allowPublicKeyRetrieval true amp useSSL false    PortNo  3306 can be different in your configuation

User · Answer

Update the useSSL true in spring boot application connection with mysql   jdbc mysql   localhost 3306 demo useUnicode true amp characterEncoding utf8 amp useSSL true amp useLegacyDatetimeCode false amp serverTimezone UTC

User · Answer

When doing this from DBeaver I had to go to  quot Connection settings quot  - gt   quot SSL quot  tab and then    uncheck the  quot Verify server certificate quot  check the  quot Allow public key retrival quot   This is how it looks like   Note that this is suitable for local development only

User · Answer

Give connection URL as  jdbc mysql   localhost 3306 hb student tracker allowPublicKeyRetrieval true amp useSSL false amp serverTimezone UTC

[java] Connection Java-MySql : Public Key Retrieval is not allowed

Examples related to java

Examples related to mysql

Examples related to exception

Examples related to connector