Connect MySQL to Java in IntelliJ 2024 | Full JDBC Tutorial for DB Connectivity

[@SifatUllah-12]

What! I literally have been searching for this exact topic, and your video came right up. Easy, straight forward, and easily one of the best videos to understand in one go. You're becoming my favorite java content creator and you're so underrated.

[@TapTap_196]

Thanks! I appreciate your comment 😀

[@freytryggvason5488]

Simple and straight forward video in a highly digestible format. Thank you!

[@TapTap_196]

No problem! Glad it helped, and thanks 😀

[@markreonal4805]

straight to the point ans super simple thank you g

[@heine9257]

Thank you very much! i never comment on any yt video, but wanted to thank you for your helpful videos on java, it is very much appriciated, you are talented!

[@TapTap_196]

Glad to help 😀

[@DerLucht]

Thank you SO DAMN MUCH, I've literally been on the edge of desparation and I finally managed to do everything right, OH GOD thank you sir :'''')

[@TapTap_196]

No problem, glad it helped 😀

[@davi0kaipper]

great content man!

[@RithveckhDhamodharan]

Hey, Jar file is missing after the extract, what to do?

[@MERJORIEDELICANO]

thank you so much, keep it up

[@TapTap_196]

Thanks!, glad it helped 😀

[@tavo8632]

For me is very important this video, because I usually delete my DataBase

[@TapTap_196]

Thanks! Glad you found it helpful 😀

[@Little_Miracle_Halepa]

Your keyboard sounds really good!

[@TapTap_196]

Thanks!

[@automationtester19]

thanks for the simple explanation

[@TapTap_196]

Glad to help 😀

[@mekvil1337]

Hello, i have problem that everything works fine in Intellj idea, but if i export the jar file with dependecies mysql it says java.sql.SQLException: No suitable driver found for

[@TapTap_196]

Hello are you using maven for your project? If so maybe try adding it as a dependency instead of as an external JAR. mysql mysql-connector-java 8.0.33

[@nomthandazomaphula4366]

Hi how did you end up solving it, I have the same issue.

[@generate-your-ip]

Thankyou for helping my assignment. Subsribed 🎉

[@TapTap_196]

No problem, glad it helped 😀

[@Arun30802]

No bullshit talks. Upto the point and leaves. Thanks bruh‼️

[@TapTap_196]

Thanks! Glad it helped 😀

[@satmar1331]

nice useful for me and keep posting video's like this ...

[@TapTap_196]

Thanks, glad it helped 😃. And will do

[@TheDarkSide2003]

good way of teaching easy-to understand

[@TapTap_196]

Thanks, glad it helped 😀

[@papimar2441]

thank you so much dude! very nice video

[@TapTap_196]

No problem, glad it helped 😀

[@KrisBold1212]

Bro was probably recording this at 4 am

[@abdullaharif2492]

thanks for the help

[@TapTap_196]

No problem, glad it helped 😀

[@MicheleWM5]

thank you 😊

[@TapTap_196]

No problem 😀

[@modelschoolgohad6601]

thanks

[@TapTap_196]

No problem, glad it helped 😁

[@felipeborges474]

kudos from brazil

[@TapTap_196]

Thanks!

[@Rikkivlogs68]

Thanks a lot men

[@TapTap_196]

No problem 😀

[@walterjocoski]

tyvm mate

[@TapTap_196]

No problem, glad it helped 😀

[@numberzero6833]

THANK YOU

[@TapTap_196]

Glad to help 😀

[@sqcristal8417]

Good lesson

[@TapTap_196]

Thanks 😀

[@alucard2477]

Thanks hope I can get this right

[@TapTap_196]

No problem, and you will 😎

[@YohannesAssefa-wk5oo]

Thank you

[@TapTap_196]

No problem 😀

[@cadetharshit6833]

Bro but i m not getting the jar file after extracting it

[@MWNCorp]

Hallo Sir, Can you create a stylish tutorial for a Java connector to Kafka in the form of a JAR, enabling seamless connectivity to a PostgreSQL database?

[@TapTap_196]

I am not too familiar with Kafka or PostgresSQL, but possibly in the future when I have time to learn it 😃

[@adelingt]

thanks!!

[@TapTap_196]

No problem! Glad it helped 😀

[@numnuggettwin6515]

YOUR MY GOAT TY

[@TapTap_196]

Glad you found my video helpful 😀

[@musabnet]

Thank you 🌹 And how to connect more than 2 pcs with the same database

[@TapTap_196]

No problem, glad it helped 😀. Hmm...I'm not exactly sure but if you are trying to make it so that they connect to your MySQL server you can try this phoenixnap.com/kb/mysql-remote-connection Alternatively, you can try find a hosting site to host your MySQL database like Render: docs.render.com/deploy-mysql and you wouldn't need to create your own server and the other pc can connect to the hosting site's servers instead which might be safer. Hopefully this helps, and good luck 👍

[@dxtfps]

a life saver

[@TapTap_196]

Glad it helped 😀

[@vledolf1573]

Very nice video. Could you make a SpringBoot tutorial?

[@TapTap_196]

I appreciate it 🙏. I only know a little bit about springboot, but I'll consider it in the future 😅

[@nomthandazomaphula4366]

Please help I got the following error when I try to run the program and have since been using other videos to solve it but to no avail... Error: Could not find or load main class Main Caused by: java.lang.ClassNotFoundException: Main

[@TapTap_196]

Hello, that issue happens because it can't find the main method in your project. Make sure to have one class that has the "public static void main(String[] args)" Let me know if this helps

[@rudreshrathod2211]

Hello please make a video on Tomcat configuration with intellij ide

[@TapTap_196]

I'll consider it, but from what I've seen it seems like I'll need a paid version of IntelliJ to do that

[@InesKetata]

hi , i have a problem database is not created in my sql i have tried to resolve this problem but it's not working what should i do?

[@TapTap_196]

Hello, which part are you in that you are experiencing this error? Are you having problems creating the schema?

[@christianmendoza7085]

I have the same problem , I put run database but still at the end in the Java file it runs an error at result set due to it not finding the symbol

[@TapTap_196]

@@christianmendoza7085 ​ Hello, could you paste in the error that you are getting? Also can you tell me what part of the video you are on? Make sure that the column-id you pass in the "resultSet.getString("column-id")" that it matches with what you created in the database schema.

[@dermagier4942]

5:05 SELECT * FROM USERS LIMIT 0,1000 and its an error... why .. i did the same then you...

[@TapTap_196]

Hello, what type of error did you get? Make sure to highlight the schema you are working on by double clicking it. The schema should be bolded

[@reverseclockgaming2572]

@@TapTap_196 thanks bro i was having the same error and this fixed it😃

[@RodzGeraldCachero]

My code is error😭 where did you find the jdbc on your jdbc:mysql://

[@TapTap_196]

Hello, what error are you getting? Is it showing up in the console? " jdbc:mysql://" is the protocol that we use to connect to our mysql database through java.

[@JunjunShinobi]

why you could not use maven intellj

[@TapTap_196]

Oh yeah it is another way of doing it. I might consider making one for those that are using Maven

[@nurzulaikha1624]

I cannot use my connectivity port because already use How can i make it unused

[@TapTap_196]

Hello are you referring to this part @1:10? I'm unfortunately not too familiar with changing the MySQL settings, but this might help you out: stackoverflow.com/questions/29866204/how-to-change-the-default-port-of-mysql-from-3306-to-3360 Let me know if it helps.

[@erickboneti4175]

For some reason even after adding the jar file, the imports still doesn't work, so i have to add "requires java.sql" to module.info.java, i don't get it, could someone help me?

[@TapTap_196]

Hello, are you using JavaFX by chance? If so, then you will also need to add the requires java.sql in the module.info.java file.

[@thiagofonseca1649]

Conseguir entender perfeitamente, me ajudou demais

[@TapTap_196]

Thanks! Glad it helped 😃

[@oknowu8824]

I'm using eclipse and it says Access denied for user 'root'@'localhost' (using password: YES) any solutions??

[@TapTap_196]

Hello, could you tell me which part you are at? Also make sure that the password you are using is the same one you created @1:17.

[@pancake4691]

I get the same message when I run it but I am using intelliJ . Idk what went wrong since I copied every step edit: I fixed it by putting my password I created earlier at 1:17 like Tap said, I somehow did not hear the part where you said to use the password you created earlier and just copied your "password" on accident in the code section at 8:43 lol

[@TapTap_196]

@@pancake4691 No worries, and yeah after rewatching I should've been more specific about it in the video 😅

[@manzialvinthierry]

Hey in mySQL the SELECT * FROM USERS ; Can't work

[@TapTap_196]

Hello, you might need to add in the schema before users. So if you are using the same schema in the video try "SELECT * FROM login_schema.USERS"

[@oknowu8824]

Thank you ​@@TapTap_196

[@ajaykumar.d958]

I LOVE NEEJAY

[@anuragpandey9794]

I forgot the password any method to retrieve it

[@TapTap_196]

Hello for that you might need to reset your password. This might be helpful: stackoverflow.com/questions/50691977/how-to-reset-the-root-password-in-mysql-8-0-11

[@TheDarkSide2003]

straight way do some java project for us pls

[@TapTap_196]

Hello, I do have Java projects in my channel if you want to check them out 😀

[@sathstud]

Access denied for user 'root'@'localhost' (using password: YES) ...... .. pls help

[@TapTap_196]

Hello, did you make sure to use your password that you created during the setup? If not then try to use your password instead of the one in the video. If this isn't it, try this solution: stackoverflow.com/questions/41645309/mysql-error-access-denied-for-user-rootlocalhost Hopefully this helps

[@rdxdevil5083]

zoom in ? can't see anything....

[@TapTap_196]

Yeah this is an issue with my older video, but I'm still trying to improve 😅

[@ajaykumar.d958]

YOU KNOW I KNOW .............

[@ajaykumar.d958]

BYE UNCLE

[@ajaykumar.d958]

HIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII

[@ajaykumar.d958]

IM SLEEPY

[@ajaykumar.d958]

BECAUSE OF THIS VIDEO

[@dermagier4942]

was to fast you skip so much .. i can´t follow you at the itellij think wtf...

[@TapTap_196]

Hello. If you find the video too fast, you might want to consider adjusting the playback speed to 0.75 or 0.5. Hopefully this helps

[@dermagier4942]

Regarding the transition to IntelliJ, I’m not understanding how you obtained this folder/ project 6:09. When I open mine, I don’t see anything similar. Consequently, at 10:20, I’m encountering a million errors and ‘e.printStackTrace()’ is underlined in yellow.” @@TapTap_196

[@makarovgregoir1446]

bro can you speak more quietly so we can't hear you at all!!!!!!

[@TapTap_196]

Apologies I was still new to video editing, but I take this into consideration in my current videos.

[@Saiyan412]

This is one of your easiest tutorial, better than that weather gui😂but still i faced problem, showing error after running code on intelij idea,it showed , 1 - SQLException 2 - SQLError.java:121 3- SQLExceptionmapping.java:113 4-connectionImpl.java:449 5-connectionImpl.java:234 6-NonregisteringDriver.java:100 7-DriverManager.java:682 8-DriverManager.java:230 All these errors at once

[@TapTap_196]

Hello, did you place the JDBC JAR in the project structure around @7:13? I'm thinking that is what is causing the issue as the JAR is used to connect to the MySQL Database.