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 , 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/
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 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
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 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."
"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.
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.
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.
YOU ARE THE ONLY ONE WHOSE CODE WORK!!
No need of databaseName in connection sir
This was really helpful. Thank you so much :)
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..
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 ??
Same problem do u know how to change it
most probably you guys are using the wrong credentials
@@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/
it worked for me. N I am very much thankful to you.
Shruti Bhadane Glad i could help.
God Gifted child you are 😍
it is very helpful, thanks so muchhhh
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)
how did it work without you changing "String databaseName" ?
thanks bro u really helped so greateful
Exception in thread "main" java.lang.Error: Unresolved compilation problem:
This was the result. What might be the problem?
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
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?
Thank you so much sir! It worked like a charm :)
cheers!
Hello sir, I didn't get build path option then what I do?
man you made my day....thank you so much :)
cheers!
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.
database name in java is still blank :)
Thank u bro it's useful
great video very helpful
cheers! Stay tuned for more videos related to Java, Node and React
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."
in the new mysql jar file connecto there is 2 executable jar file . if the -bin.jar didnt work for someone try the other.
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
May you create video about connection using oop
It worked for me thank you 😊👍
I'm getting communication link failure for this. What to do sir😐
Mine still doesn't connect: I get Error in the CheckConnection. Any other possible reason? Thanks.
Love Your Videos Man I am very thankful and grateful to xD...
Thanks for the help❤️🙏
No forward engineer option just reverse engineer
Thank you it works,, but how to implement connection Java file to other jsp file,,, how to extend this. Please help in this.
does this work for NetBeans?
Very helpful, thank you
Thank you so much!
Data truncation: Data too long for column 'Password' at row 1 , Any ideas ?
thanks, you'r amazing ;)
just a question, how you got row number 17? ("com.mysql.jdbc.Driver") ??
"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 🙌🙏
sir how to change the port number? Can you suggest me??
super
I wish I could give you more likes
Thank you very, very much bro!
cheers!
can you please upload the code??!!
Thanks
I am getting this type of ERROR- Client does not support authentication protocol requested by server; consider upgrading MySQL client
the field "String database" is not used
code is working... thank you .. !
Thanks Bro
I am not getting build path option
but sir jar files not downloods
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.
how do i put the jar in intellij???
you can drag and drop
@@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.
When i click connect to database my workbench crashes. Whats the solution
The same thing happened to me when using a distro of Linux (Fedora 29), when I upgraded, and downloaded MySQL workbench everything was fine.
@@okenyigabriel2575 mine ia solved but i have done it manually
i had to install the atest version of mysql in order for it to be compatible with workbench
finally thanks dude
i dont remeber my mysql workbench password ..help
Follow this link: dev.mysql.com/doc/mysql-windows-excerpt/5.7/en/resetting-permissions-windows.html
is work ty
пасибо братик
eclipse is not workbench..... rename your video
workbench is not related to eclipse it is a tool to work in mysql
what a waste of time