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!

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

This was really helpful. Thank you so much :)

YOU ARE THE ONLY ONE WHOSE CODE WORK!!

Thank you so much sir! It worked like a charm :)

@codec4805

4 жыл бұрын

cheers!

man you made my day....thank you so much :)

@codec4805

4 жыл бұрын

cheers!

Love Your Videos Man I am very thankful and grateful to xD...

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

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."

It worked for me thank you 😊👍

in the new mysql jar file connecto there is 2 executable jar file . if the -bin.jar didnt work for someone try the other.

it worked for me. N I am very much thankful to you.

@codec4805

5 жыл бұрын

Shruti Bhadane Glad i could help.

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

it is very helpful, thanks so muchhhh

Thanks for the help❤️🙏

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..

Exception in thread "main" java.lang.Error: Unresolved compilation problem: This was the result. What might be the problem?

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?

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.

thanks bro u really helped so greateful

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

Very helpful, thank you

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

Thank you so much!

Thank you it works,, but how to implement connection Java file to other jsp file,,, how to extend this. Please help in this.

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

Thank you very, very much bro!

@codec4805

4 жыл бұрын

cheers!

Thank u bro it's useful

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

code is working... thank you .. !

finally thanks dude

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

does this work for NetBeans?

the field "String database" is not used

database name in java is still blank :)

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

thanks, you'r amazing ;) just a question, how you got row number 17? ("com.mysql.jdbc.Driver") ??

@hamzakhan8393

4 жыл бұрын

"com.mysql.jdbc.Driver" is name of the Java Database Connectivity (JDBC) Driver Class. In order to tell the DriverManager which Driver to make connection with, you need to specify a class name. Thats what we are doing here.

Thanks 🙌🙏

I am not getting build path option

can you please upload the code??!!

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" com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database 'autoreconnect=true&usessl=false' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.mysql.jdbc.Util.handleNewInstance(Util.java:403) at com.mysql.jdbc.Util.getInstance(Util.java:386) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3933) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3869) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:864) at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1707) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1217) at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2189) at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2220) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2015) at com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:768) at com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:47) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.mysql.jdbc.Util.handleNewInstance(Util.java:403) at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:385) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:323) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at Strato.main(Strato.java:15)

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

May you create video about connection using oop

but sir jar files not downloods

God Gifted child you are 😍

great video very helpful

@codec4805

4 жыл бұрын

cheers! Stay tuned for more videos related to Java, Node and React

No forward engineer option just reverse engineer

I wish I could give you more likes

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 ??

@elisadevid5660

3 жыл бұрын

Same problem do u know how to change it

@codec4805

3 жыл бұрын

most probably you guys are using the wrong credentials

@ashishagarwal4311

3 жыл бұрын

@@elisadevid5660 , If it is done then its fine. If not pls , check prepare statement and username(I had made mistake in both these parameters). Also u can refer to link: www.mysqltutorial.org/connecting-to-mysql-using-jdbc-driver/

hi , thank you for the video.. i followed you , getting output like this. no error are there. Kindly assist me. The user to connect as The password to use when connecting The name of the class that the driver should use for creating socket connections to the server. This class must implement the interface 'com.mysql.jdbc.SocketFactory' and have public no-args constructor.

Thanks Bro

Thanks

super

No need of databaseName in connection sir

When i click connect to database my workbench crashes. Whats the solution

@okenyigabriel2575

5 жыл бұрын

The same thing happened to me when using a distro of Linux (Fedora 29), when I upgraded, and downloaded MySQL workbench everything was fine.

@mr.hassaan7785

5 жыл бұрын

@@okenyigabriel2575 mine ia solved but i have done it manually

@bianca-dariamihai6402

3 жыл бұрын

i had to install the atest version of mysql in order for it to be compatible with workbench

i dont remeber my mysql workbench password ..help

@codec4805

3 жыл бұрын

Follow this link: dev.mysql.com/doc/mysql-windows-excerpt/5.7/en/resetting-permissions-windows.html

how do i put the jar in intellij???

@hamzakhan8393

4 жыл бұрын

you can drag and drop

@MoreYaseen

4 жыл бұрын

@@hamzakhan8393 it didnt work that way, i looked up a few other ways and found out that you can choose to download it into a library.

is work ty

пасибо братик

eclipse is not workbench..... rename your video

@SurajYadav-yd2cu

4 жыл бұрын

workbench is not related to eclipse it is a tool to work in mysql

what a waste of time