jdbc ssl conection failed

Question

I've been working on a project on mySQL and i have to create an interface to it in ECLIPSE OXYGEN.The problem is JDBC does not let me create one. I ve been getting the error

"Fri Jan 12 21:49:19 GMT+02:00 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification. SQLException: java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: NO)".

When trying to set SSL as true, i get, SSL IS NOT SUPORTED BY THE SERVER(As a side not SSL is placed as "if available" and still not working). Does somebody know how i can bypass it on JAVA so it doesn;t check for SSL?

Added quote for error message

Thomas Smyth
– Thomas Smyth

2018-01-12 21:14:16 +00:00
Commented Jan 12, 2018 at 21:14 — Thomas Smyth
– Thomas Smyth, Commented Jan 12, 2018 at 21:14

Mikhail Zharnikov · Accepted Answer · 2018-01-12 20:27:44Z

1

I think it's the problem you didn't set the mysql password. If you set the mysql password and set the password when connection, it will work.

answered Jan 12, 2018 at 20:27

Mikhail Zharnikov

1781 silver badge13 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Diana G Over a year ago

Could you explain?(If you are reffering to the password for the account on mysql(root password) i do have one).

Mikhail Zharnikov Over a year ago

for mysql connection in java, the required parameters are username, password and mysql url with 3306 port. And if you make the password field as '', you will get error. For secure aspects, it's good to set the mysql root password.

Diana G Over a year ago

Yes. I forgot to put the password when creating the connection in JDBC.Thank you!

Mikhail Zharnikov Over a year ago

Glad to help you. If you are satisfied, will you vote my answer?

Collectives™ on Stack Overflow

jdbc ssl conection failed

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related