How to install MySQL and connect with Java (JDBC) in VSCODE | JDBC Connectivity in Java with MySQL 🚀
Vložit
- čas přidán 27. 07. 2024
- 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 CZcams 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
// 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 - czcams.com/video/MOQfTuOiBys/video.html
Eclipse Setup - czcams.com/video/FbOfNoXrevY/video.html
VS code setup - czcams.com/video/-0X0BHLE0Dg/video.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();
}
}
}
Sir MySQL installation ke time MySQL connecter nhi show horha h
Thank you so much sir 2 ghante se yt pe dhund rha hu aapka hi video kaam aya
Thank you sir🙏🙏🙏🙏🙏❤️❤️
Sir, finally I have run my program because of your efforts. Thank You Sir!😊
Best video i have ever seen till now . sab kuch bataya ha aapne thank you so much sir.
Thank you... it really help me.. when working in VSCode
THANK YOUUUU SO MUCH BHAIYA
Setup ho gayaaa🤩💓💫🥳🥳🥳🥳
Very simply and beautifully explained 😊😊
Thank you sir, you totally solved my problem..
Sir connector or vs code ka option nahi aa raha hai setup me kya kare
mere me bhi connector wala option nhi aarha
same here. solve hua hoga to btade bhai
bhaiya mere m connector ka option hi nhi aa rha
same
@@vinayaksahu1617 same here. solve hua hoga to btade bhai
Thank you very much sir 🙏🏻🙏🏻
sir thank you for the perfect solution for jdbc connection it helpe me a lot 😍😍😍😍😍😍
Sir aap k pdhane ka tarika bht osm hh muje phli baar CZcams pr asa koi channel Mila hu jo itna deeply jakr padhata hh. ❤❤
Thanks jatin for your valuable feedback ❤️❤️
Thankyou So much sir, Ho gaya mera sab kuch sahi sahi
Good
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?
yes ..i also faced same issue
@@amritasingh5632 so u can download jar file also then this issue get resolved
@@amritasingh5632 same issue, did it resolve ?
@@shardulrastogi4369 yaa ..it was resolved
@@ayushkathariya which link
sir you will explain it very well thank you sir
very nice explained anna ..
Done sir.... thanku so much it's so simple 👍
Thanks sir 😊
thank u so much sir 😊😊👍👍
it worked👍👍👍👍, you ended my three days torture to make jdbc connector work👻
happy to help you
Thank you !
thank you so much.
Thanku sir❤❤
Thank you bhaii❤
Sir my sql for vs code ka option hi nahi aa raha hai kya karu ?
Mee tooo😢
Mee too
Muhje bhi kya kre???
Same
At 7:00 min of video you will see Filter search bar
Type 'connector' and press Enter you'll see 'MySQL connector'...
sir connector to aa hi nhi rha hai kya karu please help
Thankyou so much sir. 🙏
Most welcome
sir download p mera connector ni aara
Thank you sir
Thank you so much. It helps me a lot...
Glad to hear that
@@CodingWallahSir sir pls reply us the solution of "vs code and connection option is not visible"
Thank you
Thank you so much sir
Most welcome
Thank u so much....
please can you send me the code ?
mysql connection wala option show hi nahi ho raha mujha now what i have to do? pls give me soln
same here. solve hua hoga to btade bhai
sir jo code hain createDB mein , where is it available?
Thanks sir video bhot ache hy
Thanks for your feedback muhmmad, I just made videos for these like comments
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 .❤
Will try to plain otherwise you can follow only this playlist.
can you please tell me how to do the same in macos for C++, also I have xampp mysql database
Thanks sir
sir your video difrent of all
thanks dear for your vaulable feedback
Sir you are doing noble job .. Lord Krishna make your aim to come true
HARE Krishna
Hello, were options of Connector in java, and Mysql for VS code available in MySQL installer.
Plz make video for installation setup first to end basic se
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?
same here. solve hua hoga to btade bhai
please provide code link for every videos in comment section
could not find mysql connector 7:23 ...please help
Sir vs code me connector j nhi show ho rha h
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.
Not get the vs code option to mark on it
MySQL Connectors and MySQL for Visual Studio are not sowing in latest version of MySQL
Did you find the solution
Funny way to learn .....😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍
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
finally database was connected successfully
Can you find MySQL connector?
Sir,In the windows service name :MySQL80 it shows an error like the window service name is already used.what should I do.
how to connect jdbc in intellij IDEA
Sir can u tell how to connect sql and jdbc in macos
After downloading mysql server and router installation fail. other things are installed. what should I do?
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.
sir intellij me nhi kar sakta hu kya ye sab?
Thanks sir 🎉 ❤ , webpage me link kese kya jata hai backend ko 1 video me ye bhi bata dijiyega please
okay
sir u so good
Thanks and welcome
Sir microsoft SQL server per java swing project with visual studio code se connection ki video bana kar dalo within 1 day
@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 .
Bro did you get the solutions.. I am having same problem
thank you
Welcome!
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...??
same here. solve hua hoga to btade bhai
i have downloded 8.0.33 version and they have removed in application section they have removed mysql for vs what to do?
Please ask your doubt in my discord server setup config channel, support team or community will help you.
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 😢
bhaiya please java developer series me videos ke sequence sahe order me krdo bahot confusion hoo rahe he. please bhaiya
❤❤❤
Sir kindly explain that code in detail i didn't get what was written inside that code ❤
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 ????
I'm facing the same issue. were you able to solve it?
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
🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥
❤
I don't have mysql connectors option😢😢😢😢
Same here buddy please help me if you have done
sir mera java project niche show nhi kar raha hai jahan aap ne jar file import kia
curantly no Abbreviations of JDBC. Its called only JDBC. because of copyright issues.
sir at 6:48 MySQL for visual studio ka option show ahi ho rha he
I am undergoing the same program, did you find a solution?
@@shreyashkakde9315 same bro, did you?
sm prob bro
did you gt it?@@shreyashkakde9315
Did anyone find the solution please reply
😢their is no har file in mys ststem.
Sir My laptop ( type and networking) ke interface main Next ka option nahi aa raha hai
Kya kaare
laptop me my sql pehle se install ho to jar file kese install karenge
Jinke ismai installation ke time my sql for VS code ka option nahi aa raha vo uske bina baki process follow karke dekho....
Mere ismai mai bhi nahi aa raha tha lekin maine baki steps follow ki to sab perfectly run hua 👍
good
Are bhai ek bat bolo hamare pass to code nahi hai to ham kaise connect kare
ok ..I will try ...I was facing this issue
Bhai ho gaya itni khusi 😅😅😅
😅😅👍👍
@@CodingWallahSir wahan pe naa connector installation ke samaye dikha nahi Raha haii ap ko fhir se file ke upar click kar k j connector ko download karna padega tab jake hoga
@@CodingWallahSir bass itna chota sa Kam karna hai jiska bhi nahi ho raha
@@CodingWallahSir sir advance java ka ek free course Lao naa sir ek dum free main
@@bb1sr716 bro can you more elaborate your solution?
Thank you very much sir. Main abhi MYSQL 8.0.38 install kiya hun hun . Isme connector ka option nahi hai.
Koi solution mila?
64bit can i also download
Can I use postgres or SQL Server ! Because I'm proficient in those 🥺
ofcourse, if you know very well
Nothing is visible for me under java projects. What should i do??
Hi sareena please drop your issue on my discord server - support team will help you
Ho gya sir
Good 👍 easy tha
My sql connector likha aa raha ha refrenced libraries ma ab magar not connected aa raha ha ab kya kara
Thanks sir video is best
Thanks for liking and commenting your feedback
It's not showing MySQL connector and visual studio options
Y sir??
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?
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
sir there is no option for mysql for vs code
thanks sir
👍👍
sir mysql for vscode option is not showing what should i do?
Not showing in mine too
How to do this using xampp . please make a video on this😢
Bht pehle Kiya h try krunga time Mila to
mere me ye karne ke bad bhi likh rha driver not found.. what can I do now??
Hi Sir Good Morning, I can't see Connector in MYSQL in program files can you help me with this please
same here. solve hua hoga to btade bhai
Sir command line open krne ke baad jb password daal rhe h tb apne aap hi page close ho jata h.. kya kyu
Referenced libraries under Java project is not visible . Please help me with this sir 😭 🙏
have you added ?
connect ho gaya lekin ek code ko dubara run kr rahe hai toh error aa raha hai while creating database , any reason?
Bro i'm not getting MySQL connectors in the Available product while installing
same here. solve hua hoga to btade bhai
@@vedantkadudon't know bhai, I didn't install it.
Kitna data store ho sakta hai isme?