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

In this Java tutorial, I'll show you step-by-step how to connect a MySQL database to your Java application in IntelliJ IDEA 2023 Easily and Quickly

I'll start by downloading, installing, and configuring MySQL Server and MySQL Workbench. Then we'll create a simple database and test the connection.

Next, I'll demonstrate using the MySQL Connector/J JDBC driver to establish connectivity between IntelliJ IDEA and MySQL. I'll show you how to add the dependency, create the connection string, and write Java code to connect to the database.

MySQL Server and Workbench:

MySQL Connector:

⏲ Timestamp:
00:00 - 00:08: Intro
00:08 - 00:31: Downloading MySQL Server and Workbench Installer
00:32 - 01:48: Configuring Installation
01:49 - 02:30: Creating a Schema in Workbench
02:31 - 04:00: Creating SQL Table in Workbench
04:01 - 04:52: Inserting data to our Table
04:53 - 05:11: Checking Insert Data
05:12 - 06:06: Downloading MySQL Connector JAR File
06:07 - 07:13: Configuring JAR File to Project (IntelliJ)
07:14 - 10:18: Creating Example Project
10:19 - 11:04: Demo + Outro

See more of my content below:

-------------------------------SOCIAL-------------------------------

-----------------------------Keyboard Specs-----------------------------
MageGee 60% Mechanical Keyboard
Tape Mod
Foam Mod
Akko CS Jelly Black Switches (Lubed with 205g0 Krytox)
PBT DYE-SUB Keycaps

Extra Tags:
ASMR Programming, ASMR Coding, ASMR keyboard typing, ASMR Java, No Talking Coding, No Talking, No talking programming, no talking asmr, no talking asmr keyboard, Java Project, Login application, Swing Library, Swing Framework, Software Engineer, Software Developer, Graphical User Interface, asmr programming java, java gui, java coding asmr, coding no talking, programming no talking, speed coding, intellij idea, keyboard asmr, mechanical keyboard asmr, mechanical keyboard for programming, programming asmr no talking, swing gui, tutorial, asmr tutorial, MySQL, MySQL Workbench, MySQL Server installation, MySQL Server

#MySQL #Java #IntelliJ #JDBC #Database #Connectivity #Tutorial #Coding #Programming #DatabaseConnection #MySQLWorkbench #MySQLConnector #CRUD #Insert #Update #Delete #Query #Beginner #Newbie #IDE #Integrate

[freytryggvason]

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

[SifatUllah-]

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.

[heine]

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!

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

[generate-your-ip]

Thankyou for helping my assignment.
Subsribed 🎉

[satmar]

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

[papimar]

thank you so much dude! very nice video

[TheDarkSide]

good way of teaching easy-to understand

[cadetharshit]

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

[tavo]

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

[mekvil]

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

[erickboneti]

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?

[musabnet]

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

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

[vledolf]

Very nice video. Could you make a SpringBoot tutorial?

[thiagofonseca]

Conseguir entender perfeitamente, me ajudou demais

[rudreshrathod]

Hello please make a video on Tomcat configuration with intellij ide

[nurzulaikha]

I cannot use my connectivity port because already use

How can i make it unused

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

[oknowu]

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