How to Connect to MySQL Database in NetBeans IDE

[@Yahjoiasor]

I really appreciate someone who share his knowledge to help other people. specially me who is in the process of learning. Thank you so much!

[@CodeJava]

Glad it was helpful!

[@8037_a]

@@CodeJava send the link exactly in video

[@CodeJava]

@@8037_a what link do you mean?

[@8037_a]

@@CodeJava the java connector file in netbeams library class does not appear meanwhile i created backend data through phpmyadmin i want to connect databse to my java project

[@nathansuarez5543]

when i click test connection on 4:56 i get this error (Cannot establish a connection to jdbc:mysql://localhost:3306/mysql?zeroDateTimeBehavior=CONVERT_TO_NULL using com.mysql.cj.jdbc.Driver (Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.))

[@sushmareddykolli1336]

were you able to fix it?

[@CJ-xg6pf]

I'm getting the same error

[@anjalivalani69]

I am getting same error you know how to fix it?

[@devashishathawale4807]

Thank you so much, our school textbooks don't help us much at all, this one video helped me solve the problem!

[@CodeJava]

Glad it helped.

[@CoollBoyz-dr5nv]

Bhai main ye pg main padh raha hun aur tu school main 🥲

[@kwandokuhlemhlongo4676]

Man, thank you for sharing this. If it weren't for this video, I would've failed my assignment. I appreciate you.

[@CodeJava]

Glad it helped!

[@Depogramming]

Thanks man , I have spent like 4 hours searching on how to connect database and netbeans , you saved my GPA

[@CodeJava]

Glad I could help

[@nguyenhoan8532]

I had succeeded the first time I tried thism very helpful thank you. But a few days later when I try to do it again it showed this problem(Cannot establish a connection to jdbc:mysql://localhost:3306/mysql?zeroDateTimeBehavior=CONVERT_TO_NULL using com.mysql.cj.jdbc.Driver (Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.) and I dont know how to fix it, please help :(

[@CaptainSlow-qo6mj]

Did u fixed it?

[@tamnguyenthanh1694]

Thank you so much, I lose a night to research but no result but in your video I've resolved my problem

[@CodeJava]

Glad it helped

[@codedrian]

I got this error Cannot establish a connection to jdbc:mysql://localhost:3306/mysql?zeroDateTimeBehavior=CONVERT_TO_NULL using com. What should I do?

[@ride_with_muku]

kyuki mera bhi nhi hua

[@ozonewagle]

Do i need to run xamp & mysql service in background for it to work?

[@CodeJava]

yes, you do have MySQL service running in background, on localhost or on other machine.

[@emito69]

@@CodeJava and is there a way to make the connection using a SQL Service from netbeans? without the need of xampp or mysqlservice?

[@CodeJava]

@@emito69 no way. NetBeans is just an IDE.

[@emito69]

@@CodeJava thanks. i undestand now. i found that there are db servers like H2 that i can embbed in my aplication. i will keep learning. greats!

[@CodeJava]

@@emito69 that's right. check my video: kzbin.info/www/bejne/fqTbhp-FebipnK8

[@elestirensincap1481]

Hello. For some reason, the Localhost section did not appear for me, what should I do? 3:32

[@elestirensincap1481]

Thanks, I just fixed the problem. I forgot to register :D

[@CodeJava]

Glad to know that.

[@pavithramarimuthu2616]

Thanks a lot . really helped me a lot. I was searching for videos and finally found ur clear video and clear guidance .

[@CodeJava]

Glad it helped

[@aryanshah1938]

It keeps on showing connection failed, how did you solve that. I tried everything

[@ngophuocloc5030]

Thanks u =)) after 3 days finally i can connect MySQL with this video =))

[@CodeJava]

Glad I could help!

[@ola6495]

third week and i have not connect it yet

[@divinaviolet3397]

Thank u so much....after many videos finally this worked

[@CodeJava]

You're welcome!

[@mer0925]

Thank you very much, now i can finish my project

[@CodeJava]

You are welcome

[@ayushenma]

it says my table does not exist after insert data 9:25

[@sanjayanuwan42]

CEO of "here"

[@CodeJava]

Happy to help!

[@yiamkarkar5240]

Hi, I got an error "The server time zone value 'Malay Peninsula Standard Time' is unrecognized or represents more than one time zone. You must configure either..." when trying to connect the server, is there any solutions to solve this problem? I'm using the exactly same version of MySQL and Netbeans as yours

[@CodeJava]

which version of your MySQL JDBC driver, 5.1. or 8.0? The latest one will not have time zone issue.

[@yiamkarkar5240]

@@CodeJava I'm using MySQL JDBC driver version 8.0.22. By the way, I already got the solution to solve this problem. Thanks for your reply!

[@blackiethecat8]

@@yiamkarkar5240 how did you solve this problem? i got this error too

[@yiamkarkar5240]

@@blackiethecat8 by specifying the server time zone in the database url, for example: "jdbc:mysql://localhost:3306/mysql?zeroDateTimeBehavior=convert_To_Null&serverTimezone=UTC"

[@picaohg7370]

@@yiamkarkar5240 replace to ?useTimezone=true&serverTimezone=UTC this "?zeroDateTimeBehavior=convert_To_Null&serverTimezone=UTC""

[@picaohg7370]

how i can pull the connection to an jframe archive to send the text field information? i do not know how to pull the connection or this way of service link is only for this purpouses?

[@CodeJava]

then you need to write Java code. Check this video: kzbin.info/www/bejne/mqaonJtuj9h5fdU

[@RahulSingh-yz7jd]

Thank you so much. I couldn't get my task done and you helped me soo much thank you again.

[@CodeJava]

Glad I could help!

[@leandropoma9865]

Thanks!!!, Greetings from Bolivia

[@CodeJava]

Welcome!

[@belahouelmohammedmehdi9687]

I have a little problem when i test connection it dosent succed any ideas??

[@CodeJava]

check JDBC URL, database username, password, port number, schema name... Make sure MySQL server is running.

[@priyanshusingh1075]

in which version u made this project is there any difference in new versions of netbeans and jdbc

[@CodeJava]

I was using NetBeans 12.1 - there might be difference in the new version, but I think it would be similar.

[@codedrian]

Hi. Is it okay that I don't add them in my System variable? I saw some tutorials that they add them in their system variable. Thank you.

[@CodeJava]

add what to system variable?

[@biancapxt]

THANK YOU!!!! I was looking for a solution for hours

[@CodeJava]

You are welcome!

[@PoojaSingh-ig8ki]

you explained it very well....thank u

[@CodeJava]

You are welcome :)

[@toprakarat1018]

I use Microsoft SQL Server Managament and my authentication is Windows Authentication. So, what should i write on host name, port and Username? I dont have it.

[@CodeJava]

with Windows authentication, you don't have to specify username and password. Just specify the JDBC URL like this: jdbc:sqlserver://localhost:1433;databaseName=testdb;integratedSecurity=true;

[@monikashira4611]

Sir after adding mysql connector it show same error in connection of driver what I can do

[@CodeJava]

what is the error?

[@monikashira4611]

@@CodeJava com.mysql.jdbc.Driver This is the error sir

[@barsaraneebarik4141]

If we connect database with service can we access it every frame and no code required for writing?

[@CodeJava]

No, you still need to write code in your Java project. Check this video: kzbin.info/www/bejne/mqaonJtuj9h5fdU

[@austinmumba1803]

Had you created the database already prior to connection?

[@CodeJava]

Yes, suppose that you have some existing databases.

[@austinmumba1803]

@@CodeJava Thanks man!

[@frandychacon7505]

is it the same on Netbeans IDE 8.2? I can't see any database icon on mine

[@CodeJava]

I don't know because I no longer use NB 8, which is too old. Upgrade to Apache NetBeans 12.

[@riyapatil311]

Maybe you'll see library then add library you will get options to add mysql

[@antrung9908]

Thank you so much! This video is very good

[@CodeJava]

You're so welcome!

[@arafatlone1162]

I got an error for Cannot establish a connection to jdbc Do i need to have an SQL ?

[@CodeJava]

Sure, you need to have MySQL server running locally on your computer or remotely on another computer.

[@nourelhouda5251]

Thank you soo much !! i was looking for this for months !!!

[@CodeJava]

Glad it helped!

[@luarcapancho]

Thanks it was very helpfull

[@CodeJava]

You're welcome!

[@pmcrevenant1297]

Strangely... I can't connect because mine kept saying "Connection Failed" what did I do wrong?!

[@CodeJava]

check JDBC url, username, password and make sure the MySQL server is up.

[@pmcrevenant1297]

@@CodeJava Where can I check this JDBC? And how can I check if my MySQL server is up? It doesn't even highlight the "Start Server".

[@jorgeescoto2382]

Great content

[@CodeJava]

thank you!

[@ishaanapte6570]

but bow to add data into the database from java class since i am making GUI

[@CodeJava]

follow this video: kzbin.info/www/bejne/Z6GkZ2djm9ScsJo

[@totallyrandom9063]

this message is showing when i tried to make a new connection? Cannot establish a connection to jdbc:mysql://localhost:3306/mysqltest?zeroDateTimeBehavior=CONVERT_TO_NUL

[@manhnguyen-kc2pi]

a đang ở vn hay ở đâu vậy ạ

[@CodeJava]

VN em.

[@simba4513]

thank you so much!!! finally I solved it!

[@CodeJava]

You're welcome!

[@DeepakKumar-rv9di]

You saved me, Bro!! Thank you so much.

[@CodeJava]

You are welcome!

[@PriyanshuYadav-bq8py]

I think Ravi kumar is your indian friend 😂

[@CodeJava]

haha, is it a common Indian name?

[@shauntiey]

My netbeans doesn't show the option to create a new connection?

[@CodeJava]

I don't know why. Perhaps your NB installation is corrupted. Try to remove and install again.

[@moon_boss123]

thanks a lot ...a now i can do my task's.....

[@CodeJava]

Happy to help

[@pooranasundarpooranasundar9864]

I tried to connect the Database, But it's showing Connection failed. Can you explain how to resolve this ?

[@CodeJava]

That error means one of connection information is incorrect. So check JDBC URL, username, password. Also make sure MySQL server is running.

[@vednande6192]

It is showing me this error.. please help Connection failed: Communications link failure The last packet sent successfully to the server was 0 milliseconds ago.

[@CodeJava]

make sure that mysql server is up and running.

[@vednande6192]

@@CodeJava actually I again installed Java 17 now everything is right.. thanks a lot 🙏😊

[@gustimuhammadaulianursulth7192]

how about when test connection errorr?

[@CodeJava]

then check username, password, JDBC URL... also ensure MySQL server is running

[@efromthestudio]

this helped me a lot thank you!!

[@CodeJava]

Glad it helped!

[@enriquezpastunafranklingeo5960]

hola tengo error al momento de realizar la prueba de coneccion ayúdame please

[@CodeJava]

Ensure that url, username and password are correct. Also MySQL server instance is running.

[@hatran_fitness]

Are you Vietnamese?

[@CodeJava]

yes, I am.

[@ashinkunjumon3295]

For me its showing invalid and not connecting to server

[@ganeshmalo7736]

I can not connect mysql with netbeans ,Any password can i use?

[@CodeJava]

it must be the password you set when installing MySQL.

[@thenatureedits8089]

Helped very much, thanks

[@CodeJava]

Glad it helped

[@nongvunguyen1621]

what password of root can i fill out i have some problem with this

[@CodeJava]

then you have to reset your root password. reference: stackoverflow.com/questions/16556497/mysql-how-to-reset-or-change-the-mysql-root-password

[@anjalivalani69]

Hey beo i am still getting error like connection failed😢

[@CodeJava]

check JDBC URL, username, password.... also make sure MySQL server is actually running.

[@ThuyHoang-di4hs]

anh oi nêu e cài mà nó k thành cong là lỗi do đâu vậy ạ

[@CodeJava]

kiểm tra JDBC driver, JDBC URL, username và password.

[@ThuyHoang-di4hs]

@@CodeJava anh oi anh cho e xin inf đi ạ, em thử mãi không được anh ạ

[@m1das_]

please, next time attach links in the description which you used in the video

[@CodeJava]

ok, thanks for watching :)

[@BroStartup]

i am getting an error when am following the same process Selected mysql-connector-j-8.0.31.jar might cause unexpected problems. Use preferred mysql-connector-java-8.0.17.jar.

[@CodeJava]

I think it's version compatibility or bug of the driver. Thanks for the tip.

[@BroStartup]

@@CodeJava Thanks for the tip. But i can resolve the issue. the problem is different. Actually i working with xampp. Mysql is not started from there i am trying to change the name of user from root to diffrent so that''s way i am getting that error

[@whatshouldido805]

IT WORKED!!!!!! Thank you so much.

[@CodeJava]

You're welcome!

[@parthshah7201]

Thanks for this video

[@CodeJava]

No problem

[@rameshwarsuryawanshi8468]

Sir I have problem to connecting to databases

[@CodeJava]

do you know what the error ?

[@nikeshchannel9730]

Thank you soo much Brother

[@CodeJava]

Most welcome

[@who_thekaushik]

thanks a lot fot the help

[@CodeJava]

You're welcome!

[@Oom_Sakkie]

Awesome

[@yudhanjeffri9433]

thank you so much, you save my day

[@CodeJava]

You're welcome!

[@soniasanmiguel7197]

Excellent

[@CodeJava]

Thank you so much 😀

[@chin_dev7701]

thank you so much it is great

[@CodeJava]

You're welcome 😊

[@yazhilanj4416]

Sir it says cannot establish a connection

[@CodeJava]

Check JDBC URL, username, password, port number... make sure everything is correct. Also checking MySQL instance is running. If connect remotely, check firewall.

[@PRIYADHARSHINI-dl7vm]

I can't add the connector file

[@CodeJava]

why? is there any error?

[@PRIYADHARSHINI-dl7vm]

@@CodeJava noo its my error i didn't do it properly... now i got it thank you very much.... i even completed my project thank you thanks a lot

[@millioner7391]

Connection failed: Access denied for user 'root'@'localhost' (using password: YES) (jdbc:mysql what to do

[@CodeJava]

check username and password - either is incorrect.

[@JohnMichaelRRoma]

what to do if connection failed :(

[@CodeJava]

so check JDBC URL, username, password. And make sure MySQL server is running.

[@frauschwer9197]

Thanks a lot bro

[@CodeJava]

Always welcome

[@cameraman9906]

Thank you dear

[@CodeJava]

Welcome 😊

[@روليناالشافعي]

how I can solve this problem? Cannot establish a connection to jdbc:mysql://localhost:3306/userdb using com.mysql.jdbc.Driver (Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.)

[@mouse6228]

I cannot establish a connection

[@CodeJava]

what is the error message? Check host name, post number, username, password, database name...

[@user-mt2wl]

@@CodeJava Cannot establish a connection to jdbc:mysql://localhost:3306/grosappareils?zeroDateTimeBehavior=CONVERT_TO_NULL using com.mysql.cj.jdbc.Driver (Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.)

[@annupandey841]

@@user-mt2wl how can i solve this error?

[@user-mt2wl]

I resolude this problem juste to download the last version of apache netbeans

[@Nscb1947]

helped a lot thanks

[@CodeJava]

You're welcome!

[@nisa5947]

how do I know the correct password?

[@CodeJava]

You can't know once you forgot. The only way is to reset the root password. Reference: dev.mysql.com/doc/mysql-windows-excerpt/5.7/en/resetting-permissions-windows.html

[@josephoduor2358]

Thank you for this.

[@CodeJava]

My pleasure!

[@swathinunavth8646]

Password is not working can you help with it

[@CodeJava]

so you must use the correct password.

[@nisa5947]

@@CodeJava how do I know the correct password?

[@VIKASSHARMA-ic3dm]

thanks bro

[@CodeJava]

Welcome

[@analys7622]

Hay quá anh :awesome:

[@alejandromattias7663]

this solution does not work for me

[@CodeJava]

what issue did you get?

[@anhtram4181]

Thanks man. It's work!!!

[@CodeJava]

You're welcome!

[@djemilasandza]

Entered root password but shows error

[@CodeJava]

what is the error? check carefully username, password, port number, ... and make sure that MySQL server is actually running.

[@djemilasandza]

The problem is it my own password that if have to put cause it doesn’t work. When I’m testing the connection it says that “Cannot establish a connection to jdbc...

[@oasteadomnuluibucovina]

the best

[@CodeJava]

thanks.

[@jamalelboujamai1927]

tnx

[@CodeJava]

you're welcome :)

[@rajanemani]

COMPILATION ERROR : ------------------------------------------------------------- hospital/editPatient.java:[53,72] error while writing : could not create parent directories 1 error getting this error

[@rajanemani]

can you plz help me ?

[@CodeJava]

maybe your application doesn't have permission to write files (create parent directories).

[@lloyde3202]

My connection failed

[@CodeJava]

check url, username, password and make sure the server is running.

[@rahmamedhat910]

Please, what is password, is this constant word?

[@CodeJava]

No, it is the password you set when MySQL is installed.

[@benahmbugua5518]

thanks alot

[@CodeJava]

You are welcome 😁

[@jessadelacruz2079]

So great!! Thanks!!

[@CodeJava]

You're welcome!

[@yoyo-ct3sh]

audio not clear

[@CodeJava]

Sorry to hear that.

[@blasiusjohn7204]

Good man, tanx

[@CodeJava]

You're welcome!

[@Lelouchvv]

giong giong VN ghe

[@CodeJava]

yes, I'm from Vietnam

[@duonghiep545]

ghê cái j ông cũng biết

[@Lelouchvv]

@@duonghiep545 :))))

[@kshitij5827]

thanks

[@CodeJava]

You're welcome!

[@alexismontales7731]

thanks man!

[@CodeJava]

Happy to help!

[@zdani3]

szarabb gép nem volt kéznél?

[@alevilghost]

Que genial, muchas gracias.

[@CodeJava]

you're welcome.

[@salmali9039]

what's the solation of this problem ? Connection failed: Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. (jdbc:mysql://localhost:3306/newdb?zeroDateTimeBehavior=CONVERT_TO_NULL using com.mysql.cj.jdbc.Driver)

[@CodeJava]

MySQL server might be not running. Check for that.

[@thanuja9912]

Is your error solved

[@sweetcookitalys5700]

what does it mean Connection failed: Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. (jdbc:mysql://localhost:3306/salesdb?zeroDateTimeBehavior=CONVERT_TO_NULL using com.mysql.cj.jdbc.Driver)

[@CodeJava]

make sure MySQL server is running.

[@sweetcookitalys5700]

@@CodeJava I did the restore and I solved ,i I turned off the pc badly

[@thanuja9912]

Is your error solved