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?

[@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

[@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!

[@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

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

[@ayushenma]

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

[@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

[@divinaviolet3397]

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

[@CodeJava]

You're welcome!

[@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

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

[@mer0925]

Thank you very much, now i can finish my project

[@CodeJava]

You are welcome

[@leandropoma9865]

Thanks!!!, Greetings from Bolivia

[@CodeJava]

Welcome!

[@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

[@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!

[@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

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

[@PoojaSingh-ig8ki]

you explained it very well....thank u

[@CodeJava]

You are welcome :)

[@biancapxt]

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

[@CodeJava]

You are welcome!

[@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

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

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

[@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;

[@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!

[@nourelhouda5251]

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

[@CodeJava]

Glad it helped!

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

[@antrung9908]

Thank you so much! This video is very good

[@CodeJava]

You're so welcome!

[@sanjayanuwan42]

CEO of "here"

[@CodeJava]

Happy to help!

[@luarcapancho]

Thanks it was very helpfull

[@CodeJava]

You're 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.

[@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

[@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

[@jorgeescoto2382]

Great content

[@CodeJava]

thank you!

[@ashinkunjumon3295]

For me its showing invalid and not connecting to server

[@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

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

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

[@simba4513]

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

[@CodeJava]

You're welcome!

[@efromthestudio]

this helped me a lot thank you!!

[@CodeJava]

Glad it helped!

[@DeepakKumar-rv9di]

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

[@CodeJava]

You are welcome!

[@thenatureedits8089]

Helped very much, thanks

[@CodeJava]

Glad it helped

[@ganeshmalo7736]

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

[@CodeJava]

it must be the password you set when installing MySQL.

[@moon_boss123]

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

[@CodeJava]

Happy to help

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

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

[@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 🙏😊

[@hatran_fitness]

Are you Vietnamese?

[@CodeJava]

yes, I am.

[@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

[@parthshah7201]

Thanks for this video

[@CodeJava]

No problem

[@gustimuhammadaulianursulth7192]

how about when test connection errorr?

[@CodeJava]

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

[@who_thekaushik]

thanks a lot fot the help

[@CodeJava]

You're welcome!

[@whatshouldido805]

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

[@CodeJava]

You're welcome!

[@yudhanjeffri9433]

thank you so much, you save my day

[@CodeJava]

You're welcome!

[@rameshwarsuryawanshi8468]

Sir I have problem to connecting to databases

[@CodeJava]

do you know what the error ?

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

[@nikeshchannel9730]

Thank you soo much Brother

[@CodeJava]

Most welcome

[@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

[@manhnguyen-kc2pi]

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

[@CodeJava]

VN em.

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

[@chin_dev7701]

thank you so much it is great

[@CodeJava]

You're welcome 😊

[@JohnMichaelRRoma]

what to do if connection failed :(

[@CodeJava]

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

[@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

[@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

[@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 ạ

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

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

[@frauschwer9197]

Thanks a lot bro

[@CodeJava]

Always welcome

[@PriyanshuYadav-bq8py]

I think Ravi kumar is your indian friend 😂

[@CodeJava]

haha, is it a common Indian name?

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

[@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

[@soniasanmiguel7197]

Excellent

[@CodeJava]

Thank you so much 😀

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

[@cameraman9906]

Thank you dear

[@CodeJava]

Welcome 😊

[@m1das_]

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

[@CodeJava]

ok, thanks for watching :)

[@anhtram4181]

Thanks man. It's work!!!

[@CodeJava]

You're welcome!

[@alejandromattias7663]

this solution does not work for me

[@CodeJava]

what issue did you get?

[@VIKASSHARMA-ic3dm]

thanks bro

[@CodeJava]

Welcome

[@Oom_Sakkie]

Awesome

[@zdani3]

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

[@rahmamedhat910]

Please, what is password, is this constant word?

[@CodeJava]

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

[@analys7622]

Hay quá anh :awesome:

[@jessadelacruz2079]

So great!! Thanks!!

[@CodeJava]

You're welcome!

[@lloyde3202]

My connection failed

[@CodeJava]

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

[@benahmbugua5518]

thanks alot

[@CodeJava]

You are welcome 😁

[@oasteadomnuluibucovina]

the best

[@CodeJava]

thanks.

[@yoyo-ct3sh]

audio not clear

[@CodeJava]

Sorry to hear that.

[@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).

[@blasiusjohn7204]

Good man, tanx

[@CodeJava]

You're welcome!

[@alexismontales7731]

thanks man!

[@CodeJava]

Happy to help!

[@kshitij5827]

thanks

[@CodeJava]

You're welcome!

[@alevilghost]

Que genial, muchas gracias.

[@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 :))))

[@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