How to connect Java Project with MySQL Workbench

[jorgebulnes]

YOU ARE THE BEST! I only needed to add the JAR file to my project, and BOOM it worked! you saved my life and thanks to you I'll have a 100 for sure!

[filipinok]

I am getting a error and exception saying you have an error in your sql sytax ; and check the manual that correspondence to your sql version and etc..

[josephpark]

how did it work without you changing "String databaseName" ?

[danam]

Hello, i tried your tutorial but it sidn't work for me.i'm using netbeans and my OS is windows 10, i tried many ways to get connected to the mysql database but it never worked.am i missing something?

[ashishagarwal]

I am getting this error: Exception in thread "main" java.sql.SQLException: Access denied for user ''@'localhost' (using password: YES). can u help me with this ??

[mabblers]

Mine still doesn't connect: I get Error in the CheckConnection. Any other possible reason? Thanks.

[bmhsganamela]

Exception in thread "main" java.lang.Error: Unresolved compilation problem:

This was the result. What might be the problem?

[gayatrigole]

Hello sir, I didn't get build path option then what I do?

[clopes]

I can not drag the jar file into the main project, it only allows me to drop it in 'source packages' and after that there is not add to build path option

[vinayvini]

I am getting this type of ERROR- Client does not support authentication protocol requested by server; consider upgrading MySQL client

[siva]

Exception in thread "main" java.sql.SQLException: Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property.
i got this exception plz help to resolve this.

[anuraagsan]

doen't work
gives the error

Wed Jul 01 19:12:16 CDT 2020 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.
Exception in thread "main" Unknown database
at Method)
at Source)
at Source)
at Source)
at
at
at
at
at
at
at
at
at
at
at
at
at
at Method)
at Source)
at Source)
at Source)
at
at
at
at Source)
at Source)
at Strato.main(Strato.java:15)

[vaggelismanousakis]

Data truncation: Data too long for column 'Password' at row 1 , Any ideas ?

[yongmeichen]

finally got it working after this amazing tutorial. THANK YOU.

[drru]

thanks for the tutorial.
i have this result.
do you know how i can fix it?

"The server time zone value 'ora solare Europa occidentale' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support."

[CharanMuktha]

No need of databaseName in connection sir

[rupertacuesta]

Once connected, how would I edit it, I'm using java netbeans how would I edit it through there? For example to add a name etc

[manasatk]

I'm getting communication link failure for this. What to do sir😐

[paarichandrasekaran]

database name in java is still blank :)

[dipyamankundu]

sir how to change the port number? Can you suggest me??