How to install MySQL and connect with Java (JDBC) in VSCODE | JDBC Connectivity in Java with MySQL 🚀

Рет қаралды 121,087

Күн бұрын

Hi in this video tutorial, you will learn how to install MySQL server on your computer and will connect with vscode.
Will also learn how to download and add the MySQL connector jar file to your VS Code classpath then we learn how to create a database and a table using SQL commands and write a Java program that connects to the database using JDBC driver.
00:00 Intro
01:12 Why JDBC code is not running?
01:48 Some Doubts of beginners?
03:41 How to download MySQL.
05:16 How to install MySQL.
13:16 Creating new Java JDBC application in vscode.
15:43 Why java application is not running?
16:16 connect MySQL with Java (JDBC) in vscode.
19:03 Let's Discuss more things about upcoming lecture.
19:40 If you are not able to download and install perfectly.
➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖
🙋🏼‍♂️Hello All Kaise Ho Sare ❓
Welcome to my KZfaq channel Coding Wallah ❤️
🎦Video Kaise lagi any feedback to improve ❓
🙏🏼PLEASE COMMENT YOUR VALUABLE FEEDBACK 💬
𝙈𝙤𝙧𝙚 𝘾𝙤𝙣𝙩𝙚𝙣𝙩
📚 Java Tutorial for Beginners in Hindi = 🔎 • Java Tutorial for Begi...
🌟 Star Patterns in Java =🔎 • Star Pattern Programs ...
👨‍💻 Java Full Stack Developer Series = 🔎 • JAVA Developer Series ...
📖 OOPs in Java =🔎 • OOPs Concepts in Java ...
👨‍💻 Exception Handling in java = 🔎 • Exception Handling in ...
❤️ 10 Min Tutorials = 🔎 • Explain in 10 Mins 🔥
🔥 DSA Old Playlist = 🔎 • DSA + Mostly Asked Int...
🚀 Personal Tips + Roadmaps = 🔎 • Guidance - By Coding W...
W𝙖𝙣𝙩𝙨 𝙩𝙤 𝙨𝙪𝙥𝙥𝙤𝙧𝙩 𝙢𝙚 💖
𝐏𝐫𝐚𝐲𝐞𝐫s = 1 𝑳𝑰𝑲𝑬 for my Video
𝐒𝐮𝐩𝐩𝐨𝐫𝐭 = 𝙎𝙃𝘼𝙍𝙀 with your friends
𝐅𝐞𝐞𝐝𝐛𝐚𝐜𝐤= U can comment here
𝐌𝐨𝐭𝐢𝐯𝐚𝐭𝐢𝐨𝐧 = 𝙎𝙐𝘽𝙎𝘾𝙍𝙄𝘽𝙀 𝙎𝙐𝘽𝙎𝘾𝙍𝙄𝘽𝙀
Social Medial Accounts For Contact and Help 💖
❤️Instagram ( Updates )- / codingwallahsir
📝Telegram ( Notes or Pdf ) - t.me/CodingWallahSir
🐶Twitter - / codingwallah
🙋🏼‍♂️Facebook - / codingwallah
𝙃𝙖𝙨𝙩𝙖𝙜𝙨
#javaprogramming #javatutorial #codingwallah #learncoding

Пікірлер: 299

@CodingWallahSir Жыл бұрын

// sound kesi h video me ab and ye code aap loog copy kar sakte ho next video me ye sab smja dunga don't worry agar apne meri JDBC in 10 mintues ki video dekhi h tab apko smaj a rha hoga ye code i guess ? JDBC in 10 min - kzfaq.info/get/bejne/g7WBmbemtM-mqac.html Eclipse Setup - kzfaq.info/get/bejne/fMh_mbGgvdjJpo0.html VS code setup - kzfaq.info/get/bejne/Y5aIY6V5sauUdJs.html ---------------------------------------------- import java.sql.Connection; import java.sql.DriverManager; import java.sql.Statement; import javax.swing.JOptionPane; public class CreateDB { public static void main(String[] args) throws Exception { try { String url = "jdbc:mysql://localhost:3306/"; String databaseName = "shivam"; String userName = "root"; String password = "BangBang@1234"; Connection connection = DriverManager.getConnection(url,userName, password); String sql = "CREATE DATABASE " + databaseName; Statement statement = connection.createStatement(); statement.executeUpdate(sql); statement.close(); JOptionPane.showMessageDialog(null, databaseName + " Database has been created successfully", "System Message", JOptionPane.INFORMATION_MESSAGE); } catch (Exception e) { e.printStackTrace(); } } }

@gayuvtech 4 ай бұрын

Sir MySQL installation ke time MySQL connecter nhi show horha h

@AryanKumar-vk1ex 14 күн бұрын

Sir, finally I have run my program because of your efforts. Thank You Sir!😊

@adarshmishra9376 Жыл бұрын

Thank you so much sir 2 ghante se yt pe dhund rha hu aapka hi video kaam aya Thank you sir🙏🙏🙏🙏🙏❤️❤️

@user-bf4zq7rc5k 11 ай бұрын

Best video i have ever seen till now . sab kuch bataya ha aapne thank you so much sir.

@shakti715 5 ай бұрын

Thank you... it really help me.. when working in VSCode

@JANVIRUPAPARA-df5fw 11 ай бұрын

THANK YOUUUU SO MUCH BHAIYA Setup ho gayaaa🤩💓💫🥳🥳🥳🥳

@YaSHRaJ-ou9qy 5 ай бұрын

sir download p mera connector ni aara

@superclasher007 7 ай бұрын

sir connector to aa hi nhi rha hai kya karu please help

@ujjwalpatidar3528 5 ай бұрын

Thank you sir, you totally solved my problem..

@sauravgitte 6 ай бұрын

Very simply and beautifully explained 😊😊

@studypoint8265 10 ай бұрын

can you please tell me how to do the same in macos for C++, also I have xampp mysql database

@tanugupta9333 Жыл бұрын

bhaiya mere m connector ka option hi nhi aa rha

@vinayaksahu1617 4 ай бұрын

same

@vedantkadu 9 күн бұрын

@@vinayaksahu1617 same here. solve hua hoga to btade bhai

@learncode74 10 ай бұрын

Sir connector or vs code ka option nahi aa raha hai setup me kya kare

@jamitkumar7251 3 ай бұрын

mere me bhi connector wala option nhi aarha

@vedantkadu 9 күн бұрын

same here. solve hua hoga to btade bhai

@technologybaba192 Жыл бұрын

Sir my sql for vs code ka option hi nahi aa raha hai kya karu ?

@sy-04pranjalishinde.5 7 ай бұрын

Mee tooo😢

@Hosteler128 7 ай бұрын

Mee too

@jayeshnayee6735 6 ай бұрын

Muhje bhi kya kre???

@sanasayyad1872 6 ай бұрын

Same

@casualonly5624 5 ай бұрын

At 7:00 min of video you will see Filter search bar Type 'connector' and press Enter you'll see 'MySQL connector'...

@ahankamat Жыл бұрын

sir jo code hain createDB mein , where is it available?

@Hemantlawania 10 ай бұрын

Hi sir i have downloaded Mysql installer 8.0.34 & in this my sql java connector not present so plz suggest me which version of java connector i have download?

@amritasingh5632 9 ай бұрын

yes ..i also faced same issue

@Hemantlawania 9 ай бұрын

@@amritasingh5632 so u can download jar file also then this issue get resolved

@shardulrastogi4369 9 ай бұрын

@@amritasingh5632 same issue, did it resolve ?

@amritasingh5632 9 ай бұрын

@@shardulrastogi4369 yaa ..it was resolved

@harshitbansal1104 8 ай бұрын

@@ayushkathariya which link

@apoorvpradhan5125 7 ай бұрын

Thank you very much sir 🙏🏻🙏🏻

@nikhilmaurya6617 7 ай бұрын

sir thank you for the perfect solution for jdbc connection it helpe me a lot 😍😍😍😍😍😍

@_MeetHirpara 5 ай бұрын

sir you will explain it very well thank you sir

@Ektabharti_183 3 күн бұрын

Done sir.... thanku so much it's so simple 👍

@harshitrajput8199 6 ай бұрын

mysql connection wala option show hi nahi ho raha mujha now what i have to do? pls give me soln

@vedantkadu 9 күн бұрын

same here. solve hua hoga to btade bhai

@jbmrdairyfarm Жыл бұрын

Sir aap k pdhane ka tarika bht osm hh muje phli baar KZfaq pr asa koi channel Mila hu jo itna deeply jakr padhata hh. ❤❤

@CodingWallahSir Жыл бұрын

Thanks jatin for your valuable feedback ❤️❤️

@pamidiram2437 8 ай бұрын

very nice explained anna ..

@pratudoquantoelado9333 6 ай бұрын

Thank you !

@aryapandey6407 8 ай бұрын

thank u so much sir 😊😊👍👍

@rushikeshghevari1716 Жыл бұрын

Thanks sir 😊

@dikshakumari5848 Ай бұрын

thank you so much.

@atulsoni3895 4 ай бұрын

Hello sir ye java projects down me show nahi kar raha hai recerence option bhi show nahi kar raha hai vscode me please help sir

@Jasneet Жыл бұрын

Thankyou So much sir, Ho gaya mera sab kuch sahi sahi

@CodingWallahSir Жыл бұрын

Good

@SatyamKumar-xx1or Жыл бұрын

Not get the vs code option to mark on it

@vrinda_van_wasi 10 ай бұрын

Sir vs code me connector j nhi show ho rha h

@sanatanitells855 Жыл бұрын

sir intellij me nhi kar sakta hu kya ye sab?

@5e3satyasanthosh30 Ай бұрын

Thank you sir

@anantshukla6395 8 ай бұрын

You are awesome sir .. sir please provide the proper course as you mentioned in java developer road map 12LPA video ... I WOULD LOVE TO JOIN .❤

@CodingWallahSir 8 ай бұрын

Will try to plain otherwise you can follow only this playlist.

@tauheed0532 Жыл бұрын

how to connect jdbc in intellij IDEA

@sksufiyanali1275 Жыл бұрын

Thank you bhaii❤

@rafiikhan-R2lofi Жыл бұрын

Thanku sir❤❤

@surajjha2887 Ай бұрын

I am using vs code. when i simply click on 'run code' i am getting driver not found error. Then i downloaded 'Extension Pack for java' from the vs code extension menu. This has a separate option to run java. Whenever i click on 'run java' then it works but when i click on 'run code' it doesn't work.

@pagalgamer2635 3 ай бұрын

Sir plz a big request plz Solve it - When I use intellij IDE for coding JDBC then after some time My laptop turned into blue screen 😢

@Revana04 Жыл бұрын

please provide code link for every videos in comment section

@vinayvats8231 6 ай бұрын

Sir can u tell how to connect sql and jdbc in macos

@chandrakalagandreti2257 Ай бұрын

Sir,In the windows service name :MySQL80 it shows an error like the window service name is already used.what should I do.

@jayeshnayee6735 6 ай бұрын

Plz make video for installation setup first to end basic se

@rohitthakur6397 11 ай бұрын

Thankyou so much sir. 🙏

@CodingWallahSir 10 ай бұрын

Most welcome

@vanshkhanna515 2 ай бұрын

Thanks sir

@soundaryabejugam608 11 ай бұрын

Thank you so much. It helps me a lot...

@CodingWallahSir 11 ай бұрын

Glad to hear that

@SIRUHUBTV 2 ай бұрын

@@CodingWallahSir sir pls reply us the solution of "vs code and connection option is not visible" Thank you

@ayaanmukri5110 9 ай бұрын

@CodingWallahSir Sir mere device me MySQL already installed hai but maine sirf workbench , shell and server install kiya tha to ab agar me firse install karuga to mere existing databases pe koi effect nahi hoga na ? and plus sir mujhe visual studios ka option hi nahi aa raha downloads me .

@NikhilMohite-official 5 ай бұрын

Bro did you get the solutions.. I am having same problem

@vivaanyadav1st 11 ай бұрын

MySQL Connectors and MySQL for Visual Studio are not sowing in latest version of MySQL

@sakshigonjare2932 6 ай бұрын

Did you find the solution

@HarshVardhanTiwari-md3dz 2 ай бұрын

Thank u so much....

@Sidymohamed_12 2 ай бұрын

please can you send me the code ?

@user-zd7ou5lc7b 5 ай бұрын

i just downloaded it butvs code option is not showing up in available products i have downloaded the latest version yet, what should i do now?

@vedantkadu 9 күн бұрын

same here. solve hua hoga to btade bhai

@infamous_SUSIL 4 ай бұрын

sir mera java project niche show nhi kar raha hai jahan aap ne jar file import kia

@devabdul Жыл бұрын

Thank you so much sir

@CodingWallahSir Жыл бұрын

Most welcome

@rahuljangid8227 6 ай бұрын

bhaiya please java developer series me videos ke sequence sahe order me krdo bahot confusion hoo rahe he. please bhaiya

@shivammallik2359 Жыл бұрын

i have downloded 8.0.33 version and they have removed in application section they have removed mysql for vs what to do?

@CodingWallahSir Жыл бұрын

Please ask your doubt in my discord server setup config channel, support team or community will help you.

@MuhammadShahid-ci9sf Жыл бұрын

Thanks sir video bhot ache hy

@CodingWallahSir Жыл бұрын

Thanks for your feedback muhmmad, I just made videos for these like comments

@PiyushKumar-tp4ns Жыл бұрын

😢their is no har file in mys ststem.

@user-fj9fq3wk8j 4 ай бұрын

My sql connector likha aa raha ha refrenced libraries ma ab magar not connected aa raha ha ab kya kara

@richasaraswat8813 Ай бұрын

laptop me my sql pehle se install ho to jar file kese install karenge

@benudharapradhan7015 Жыл бұрын

64bit can i also download

@1stGames Жыл бұрын

After downloading mysql server and router installation fail. other things are installed. what should I do?

@kumaraditya5513 13 күн бұрын

make sure you are downloading the latest version AS this happens with older versions and since new vesion mai connector included nahi hota toh same version wala tumhe download karna hoga connector.

@TheHariPutraOfficially 9 ай бұрын

Sir you are doing noble job .. Lord Krishna make your aim to come true HARE Krishna

@shardulrastogi4369 9 ай бұрын

Hello, were options of Connector in java, and Mysql for VS code available in MySQL installer.

@kaliostech Жыл бұрын

sir 2 baar reinstall kia fir bhi same issue aa rha hai help!!

@liveab9780 10 ай бұрын

Kitna data store ho sakta hai isme?

@Ankii_kumar Жыл бұрын

Thanks sir 🎉 ❤ , webpage me link kese kya jata hai backend ko 1 video me ye bhi bata dijiyega please

@CodingWallahSir Жыл бұрын

okay

@wamu17 5 ай бұрын

Sir kindly explain that code in detail i didn't get what was written inside that code ❤

@NeetuSharma-sk2pg 19 күн бұрын

Sir ive only three items in mySpl "Mysql documentation 8.0", "Mysql installer for windows", "sample and example 8.0"....what should i do to get connector...??

@vedantkadu 9 күн бұрын

same here. solve hua hoga to btade bhai

@user-ul8fh3ng6j Жыл бұрын

how can i get sql command line client ? bhai please help me iam unable to find command line client is this any seperate software which we have to install irrespective to sql ????

@muskansah4487 Жыл бұрын

I'm facing the same issue. were you able to solve it?

@raghuveersinghbora1424 Жыл бұрын

Command line client aa jaega apane aap, bas sir ne jesa kiya vesa karo. Kaha se open karna h batata hu : Press win key, then type Mysql, dikh jaega, password daal ke khol lena

@AbhishekSingh-b4u 20 күн бұрын

mere me ye karne ke bad bhi likh rha driver not found.. what can I do now??

@swapnilchaudhari9796 11 ай бұрын

did same process still not working

@sanatanitells855 Жыл бұрын

sir vo code kaha se likhu

@jp.studypointprayagraj 9 ай бұрын

Sir microsoft SQL server per java swing project with visual studio code se connection ki video bana kar dalo within 1 day

@danv2141 Жыл бұрын

sir your video difrent of all

@CodingWallahSir Жыл бұрын

thanks dear for your vaulable feedback

@raushanbaitha4391 3 ай бұрын

bhaiya woh server aur router install hone mwin error aara hai kya karna hai help please

@niteshtiwari9708 4 ай бұрын

sir there is no option for mysql for vs code

@kalyanisalokhe2371 4 ай бұрын

i needthe code for jdbc connection

@yashiverma994 2 ай бұрын

Sir command line open krne ke baad jb password daal rhe h tb apne aap hi page close ho jata h.. kya kyu

@Manishjha1234 14 күн бұрын

Thank you very much sir. Main abhi MYSQL 8.0.38 install kiya hun hun . Isme connector ka option nahi hai.

@saurabhtahashildar560 14 күн бұрын

Koi solution mila?

@bhanubhusan4009 3 ай бұрын

connect ho gaya lekin ek code ko dubara run kr rahe hai toh error aa raha hai while creating database , any reason?

@sereenasebastian6715 Жыл бұрын

Nothing is visible for me under java projects. What should i do??

@CodingWallahSir Жыл бұрын

Hi sareena please drop your issue on my discord server - support team will help you

@GameInOne Жыл бұрын

16:17 There is no java projects in my vscode 🤨 Help!!! Edit:Never mind i found it but can anyone share me the code used in video?

@CodingWallahSir Жыл бұрын

you can get from my coummunity tab, snip of code is there and if you want to understand this code please watch my full jdbc lecture on it

@rahulsingh36033 8 ай бұрын

Sir My laptop ( type and networking) ke interface main Next ka option nahi aa raha hai

@rahulsingh36033 8 ай бұрын

Kya kaare

@beargrill5159 7 ай бұрын

I don't have mysql connectors option😢😢😢😢

@anupamkumar6796 6 ай бұрын

Same here buddy please help me if you have done

@aadityatrivedi7601 Ай бұрын

sir vs code ka configuration nahi aa raha aur jdbc vs code se bhi connect nahi hoo rah hai

@debankurbhattacharjee3021 Жыл бұрын

Can I use postgres or SQL Server ! Because I'm proficient in those 🥺

@CodingWallahSir Жыл бұрын

ofcourse, if you know very well

@DnyaneshwarGaikwad-gl1yb 10 ай бұрын

Funny way to learn .....😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍

@user-cd8cg3yr1q Жыл бұрын

Referenced libraries under Java project is not visible . Please help me with this sir 😭 🙏

@CodingWallahSir Жыл бұрын

have you added ?

@saurabhtahashildar560 14 күн бұрын

Vs Code option and connector wala option nahi hai so iska koi solution?

@dipa6010 6 ай бұрын

cammand line client app open nahi ho rahi he password ka issue nahi he open hi nahi ho rahi he

@MukulKumar-pp7gb 4 ай бұрын

Sir ye code kaha se uthau ya type kru , please help🙏 18:04

@KrunalSolanki-f7c 11 күн бұрын

Sir is setup ki files kahase laye aap Vo kese laye

@nikitagarg6339 5 ай бұрын

Hi Sir Good Morning, I can't see Connector in MYSQL in program files can you help me with this please

@vedantkadu 9 күн бұрын

same here. solve hua hoga to btade bhai

@bindubadeti334 3 ай бұрын

It's not showing MySQL connector and visual studio options

@bindubadeti334 3 ай бұрын

Y sir??

@sanasayyad1872 4 ай бұрын

❤❤❤

@Mohammad_Mihad Жыл бұрын

❤

@-PavanSingh 10 ай бұрын

sir mysql for vscode option is not showing what should i do?

@darkclaw12 10 ай бұрын

Not showing in mine too

@thakursitanshusingh4385 Жыл бұрын

curantly no Abbreviations of JDBC. Its called only JDBC. because of copyright issues.

@chiraglalwani2995 Жыл бұрын

Sir 64 bit vala download kar lay kya Windows (x86,64bit) 8.0.32 657.6 MB vaal sir

@chiraglalwani2995 Жыл бұрын

Because mara processor Intel core i5 8250U hai cpu 1.60, 1.80 ghz 64 bit 8 gb ram hai

@CodingWallahSir Жыл бұрын

Ha 64bit wala kr sakte ho

@mustafabohra6581 Жыл бұрын

sir at 6:48 MySQL for visual studio ka option show ahi ho rha he

@shreyashkakde9315 Жыл бұрын

I am undergoing the same program, did you find a solution?

@swapnilsharma7605 Жыл бұрын

@@shreyashkakde9315 same bro, did you?

@-PavanSingh 10 ай бұрын

sm prob bro did you gt it?@@shreyashkakde9315

@sakshigonjare2932 6 ай бұрын

Did anyone find the solution please reply

@narusingh7518 3 ай бұрын

sir I understand but I am unable to see the code

@kiran_vanve_2066 7 ай бұрын

thank you

@CodingWallahSir 7 ай бұрын

Welcome!