How to Connect to MySQL Database in IntelliJ IDEA

In this video, I'd like to share with you how to work with MySQL databases inside IntelliJ IDEA using its Database tool, so you don't have to use any external tools like MySQL Workbench or MySQL Command Line Client.

In details, you will learn:
- Define a datasource and Make connection to a MySQL database
- Create a new table
- Update data in a table
- Execute SQL statements
- Use SQL inspection suggestion in Java code

Suppose that you're using these software programs:
- Java Development Kit (JDK)
- IntelliJ IDEA Ultimate
- MySQL Community server

#intellij #mysql #jdbc #java #database

[nguyentuankietfplhcm]

Thanks for the tutorial bro Nam, I'm starting to use IntelliJ and find it a bit difficult to handle.
Ps: Ravi Kumar is happy to show up in every video.

[JayCeeSquared]

So I tried this and end up getting a ConnectionException Error where it says; [08501] Communication link failure ; The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. Connection refused: connect.

I also don't have any schemas or databases in the beginning, how do I create those so that I can connect them. And when I right click new it doesn't let me create a new table or schema or anything really around 6:46

[hienvan]

Thanks Code Java, this is the first time i come to with your channel.

[pateldivya]

hello sir! i can not find oprtion database in view>tool window. so i download Database plugins but still i am not able to see "database". please help me

[NghiaBuiVan-xs]

Thanks for sharing. But I'm facing a bit diffficult, I have around 300 tables, How to search them by table name?

[tenalisolanki]

Hello sir, Thank you to create a good video and explain it very well with the easy stuff.
I was able to configure MySQL with IntelliJ idea successfully.
But when I try to run project after creating connection it show me error.
Error: No suitable driver found for

I have student database with appointment table and its showing in Database window.
I was try with many way but it was not working. Please help me sir.

[jowengonzales]

Can i run this for stand-alone program and without connectivity on internet?

[oc]

Do any one have a video how to set up Sql on IntelliJ IDEA 2021.1.1 version(anything close to it also).Cuz I can't seem to find the way this person doing it on the video. It's different set up how to connect sql with IntelliJ. Also how to set up the framework. Thank you all for the help?

[dgh]

lol u just start out with a project already containing stuff... like META-INF folder.... better explanation would be appreciated