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!
@yongmeichen3811
4 жыл бұрын
finally got it working after this amazing tutorial. THANK YOU.
@filipino3k184
4 жыл бұрын
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..
@ashishagarwal4311
4 жыл бұрын
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/
@NoOneIsHereRightNow
3 жыл бұрын
YOU ARE THE ONLY ONE WHOSE CODE WORK!!
@sukritishukla2695
3 жыл бұрын
This was really helpful. Thank you so much :)
@danam8413
5 жыл бұрын
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?
@bmhsganamela2013
4 жыл бұрын
Exception in thread "main" java.lang.Error: Unresolved compilation problem: This was the result. What might be the problem?
@shrutibhadane4313
5 жыл бұрын
it worked for me. N I am very much thankful to you.
@codec4805
5 жыл бұрын
Shruti Bhadane Glad i could help.
@clopes87
5 жыл бұрын
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
@gayatrigole5230
4 жыл бұрын
Hello sir, I didn't get build path option then what I do?
@oliviazhai1831
2 жыл бұрын
it is very helpful, thanks so muchhhh
@josephpark2093
Жыл бұрын
how did it work without you changing "String databaseName" ?
@CharanMuktha
11 ай бұрын
No need of databaseName in connection sir
@aidangaskin8978
Жыл бұрын
the field "String database" is not used
@simochammoum878
3 жыл бұрын
in the new mysql jar file connecto there is 2 executable jar file . if the -bin.jar didnt work for someone try the other.
@siva4886
3 жыл бұрын
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.
@mabblers
2 жыл бұрын
Mine still doesn't connect: I get Error in the CheckConnection. Any other possible reason? Thanks.
@paarichandrasekaran8365
4 жыл бұрын
database name in java is still blank :)
@proud671
5 жыл бұрын
man you made my day....thank you so much :)
@codec4805
4 жыл бұрын
cheers!
@iosiffurtuna8031
5 жыл бұрын
Thank you so much sir! It worked like a charm :)
@codec4805
4 жыл бұрын
cheers!
@dr3ru
2 жыл бұрын
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."
@Papiii_benz
3 жыл бұрын
Thank you so much!
@vinayvini2628
3 жыл бұрын
I am getting this type of ERROR- Client does not support authentication protocol requested by server; consider upgrading MySQL client
@jagadeshreddyvankala6020
Жыл бұрын
God Gifted child you are 😍
@manasatk2311
5 жыл бұрын
I'm getting communication link failure for this. What to do sir😐
@anuraagsan6129
4 жыл бұрын
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)
@sunnypatil9267
2 жыл бұрын
thanks bro u really helped so greateful
@vaggelismanousakis6147
4 жыл бұрын
Data truncation: Data too long for column 'Password' at row 1 , Any ideas ?
@Ak4russell
3 жыл бұрын
No forward engineer option just reverse engineer
@ashwinipardeshi1799
9 ай бұрын
I am not getting build path option
@pantadeusz293
5 жыл бұрын
Thank you very, very much bro!
@codec4805
4 жыл бұрын
cheers!
@rupertacuesta
5 жыл бұрын
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
@kriya94
4 жыл бұрын
It worked for me thank you 😊👍
@Naidu_Chv
2 жыл бұрын
Thank u bro it's useful
@bennyjwalter566
4 жыл бұрын
Love Your Videos Man I am very thankful and grateful to xD...
@manasatk2311
5 жыл бұрын
Thank you it works,, but how to implement connection Java file to other jsp file,,, how to extend this. Please help in this.
@oussamahamouda9251
4 жыл бұрын
Very helpful, thank you
@ashraysuman3225
4 жыл бұрын
Thanks for the help❤️🙏
@keshav2113
4 жыл бұрын
can you please upload the code??!!
@PrasoonSingh97
3 жыл бұрын
Thanks 🙌🙏
@yashkaliapiano
4 жыл бұрын
great video very helpful
@codec4805
4 жыл бұрын
cheers! Stay tuned for more videos related to Java, Node and React
@dipyamankundu5759
4 жыл бұрын
sir how to change the port number? Can you suggest me??
@27SharathK
5 жыл бұрын
code is working... thank you .. !
@ravrithy4672
3 жыл бұрын
May you create video about connection using oop
@keyhanpartovi4583
4 жыл бұрын
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.
@AhmedAlbadwi
2 жыл бұрын
Thanks
@poojajainapur
4 жыл бұрын
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.
@lilpeeedot
4 жыл бұрын
does this work for NetBeans?
@12sdhungel
5 жыл бұрын
finally thanks dude
@muhammadsaim8110
5 жыл бұрын
I wish I could give you more likes
@deepakhk9439
5 жыл бұрын
but sir jar files not downloods
@kayradenizgoktas
2 жыл бұрын
Thanks Bro
@mr.hassaan7785
5 жыл бұрын
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
@sanskritimishra6785
3 жыл бұрын
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
@deepakhk9439
5 жыл бұрын
super
@MoreYaseen
5 жыл бұрын
how do i put the jar in intellij???
@hamzakhan8393
5 жыл бұрын
you can drag and drop
@MoreYaseen
5 жыл бұрын
@@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.
@maxgoof2757
Жыл бұрын
@tiendatluong296
5 жыл бұрын
is work ty
@mrpipiskin4
Жыл бұрын
пасибо братик
@james-metapod-harden8317
6 жыл бұрын
eclipse is not workbench..... rename your video
@SurajYadav-yd2cu
4 жыл бұрын
workbench is not related to eclipse it is a tool to work in mysql
Пікірлер: 82