• Register
0 votes

Problem :

I am getting bellow error while I try to connect MySql database with Java using connector 8.0.11

java.sql.sqlnontransientconnectionexception: public key retrieval is not allowed

6.9k points

Please log in or register to answer this question.

1 Answer

0 votes


I also faced above error , in my case it was actually due to the wrong username and password. 

Solving the issue: 

a. Go to the line DriverManager.getConnection("jdbc:mysql://localhost:3306/?useSSL=false", "username", "password"); 

b.The fields username and password must be wrong. You must enter the username and password which you use to start your mysql client. 

Further Readings:


38.6k points
edited by

Related questions

0 votes
1 answer 489 views
Solve this problem.
asked Jan 1 TeamScript 13.5k points
0 votes
1 answer 111 views
Problem: Why I got the error > Java.sql.sqlexception: access denied for user ''@'localhost' (using password: yes)
asked Apr 26 ummeshani 10.8k points
0 votes
1 answer 124 views
Problem: Throws this exception on getConnection(): java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
asked Apr 25 ummeshani 10.8k points
0 votes
1 answer 19 views
Problem: In which type of file is multiple key retrieval not possible?
asked May 7 Irenka Kiri 85.5k points
0 votes
1 answer 18 views
Problem: It has been troubling me for a while, and I'm looking for a solution: Can’t call commit when auto-commit true?
asked Jun 5 Nahil 128k points
1 vote
1 answer 16 views
Problem: Can anyone tell me the solution of this problem? java.sql.sqlnontransientconnectionexception: client_plugin_auth is required
asked Mar 25 MUHAMMAD MUNEEB 83k points
0 votes
1 answer 143 views
Problem: I got this error:TypeError: catching classes that do not inherit from BaseException is not allowed. The result it's that ignores the error and go to the next while but I want to catch the error and print it.
asked May 2 sumaiya simi 43.9k points
0 votes
1 answer 114 views
Problem: I tried my best to solve this situation but it didnt work! any help! Typeerror: catching classes that do not inherit from baseexception is not allowed.
asked Mar 7 Wafa Abu Yousef 6.1k points
0 votes
1 answer 4.1k views
Problem : When I try to run the below code: j=0 while j<5: j=j+1; try: MySellSta=client.get_order(symbol=MySymb,orderId=MySellOrderNum,recvWindow=MyDelay) except client.get_order as mye: print ("This is the error message!{}".format(j)) #End while I got the following error ... #End while The result is that it ignores my error and go to my next while but I want to catch my error and print my error.
asked Dec 27, 2019 alecxe 7.5k points
0 votes
1 answer 64 views
Problem : I am new to C#. I want to know how can I get the value of a given key in a following exception which I am currently facing in C# in a way it affects all the generic classes? Below is the exception which I am currently facing. "The given key was not present in the dictionary." How to fix above exception.
asked Feb 24, 2020 mphil 2.3k points