Connect to MySQL Database from Visual Studio Code and Run SQL Queries using SQLTools Extension

Setup MySQL Connection in Visual Studio Code and Run SQL Queries using SQLTools. How to install and use SQLTools with Visual Studio Code. How to run SQL queries from Visual Studio Code. How to fix couldn't find any drivers installed yet. How to fix ER_NOT_SUPPORTED_AUTH_MODE Client does not support authentication protocol requested by server; consider upgrading mysql client.
*******************************
Free Document Proofreading
Grammarly: grammarly.go2cloud.org/SH3YB
********************************
Create new MySQL user with old authentication method:
CREATE USER 'sqluser'@'%' IDENTIFIED WITH mysql_native_password BY 'password';
GRANT ALL PRIVILEGES ON . TO 'sqluser'@'%';
FLUSH PRIVILEGES; .
***********************************
🔥 Complete Udemy Courses :
Build E-commerce Web Application using ASP.NET Core : www.udemy.com/course/aspnet-c...
Build E-commerce Web API using ASP.NET Core : www.udemy.com/course/build-as...
Build E-commerce Web Application using React JS : www.udemy.com/course/build-co...
⬇️ Free Document Proofreading ⬇️
► Grammarly : grammarly.go2cloud.org/SH3YB

[@vaylx2253]

Man, this is the second time I watch this video, several months apart, and it's the second it saves me life. THANK YOU SO MUCH!!!!!

[@richiemello3447]

What a steep learning curve for something that is supposed to be straight forward. Thanks for the video!!!

[@tvstation8102]

Great video, was the last piece I needed to get VSCODE talking to a database. Signed a budding developer:)

[@nknnithinabc]

Tried a lot of vids for connect mysqlworkbench with IDE, none worked, this one is a life saviour

[@jessicabragg5261]

After searching for like 30 minutes trying to find this answer, you video saved my sanity! Thank you!

[@entertainment-bx7sb]

it didnt worked in mine

[@slimshady6242]

Are you really that beautiful

[@divine-favouranigbogu413]

THANK YOU!!! You don't know how helpful your video was to me

[@livisliquoro5572]

Hi, When I am setting up connections I am not getting list under connections tab in order to get connect and disconnect connection. Can you please help me in this

[@jeanahollings]

oy my gosh, thank you, thank you, thank you! i've been stuck on this for weeks now! you're walk through included every problem i ran into with vs code! i

[@BoostMyTool]

Thank you too for your subscription to the channel

[@vivekjadhav9744]

Great video & awesome explanation. Saved me a lot of time. Now I can enjoy SQL with the comfort of VS code

[@maharun]

Thanks a lot. You're the best! Short and concise!

[@ReasonablyRetro]

Hey thank you! I got everything working up until trying to click the magnifying glass and see what I have inserted into my tables. I get the error "ERROR: Error while showing table records Cannot read properties of undefined (reading 'total')" source is the SQLtools extension. Nothing on the github the ticket has been open for 2 years LOL. Any thoughts? Cheers!

[@hanafirjl]

thanks a lot it works, i browsed a bit and couldn't find the answer before i stumbled upon this great vid 👌

[@allanjohn7261]

please i have been getting ER_BAD_DB_ERROR: Unknown database 'shop' after setting up my connection

[@Tewahedo16]

Before I do what you show as do I have to do anything ?other than downloading visual studio code?

[@MrBEEOUTCH]

Spent 4 hours and you saved me so much time.

[@AthelstanEngland]

thanks, I thought this was the answer but using MariaDB 10.5.8 and trying to create the user using this old password format gives the error [check.... syntax to use near ' BY 'password' ' at line 1.] It seems on github that this function is depreciated. Any thoughts? I can't get connected using either VSCode or VS 2022.

[@firstprinciples9854]

Very clear and detailed explanation. Thanks

[@usoppgostoso]

In my case, I'm trying to connect to a MySQL server on Azure, and it has SSL. Couldn't find any option to use my CA Certificate.

[@3091mrcrowley]

Awesome, it worked! You explained the whole thing very clearly! Thanks a lot man!

[@biswabikashparida9691]

Grant privileges one not working for me

[@biswabikashparida9691]

Pls help

[@Icyhandss]

why my command prompt says 'mysql' is not recognized as an internal or external command, operable program or batch file. ?

[@cspointbysaurav]

My connection has been created and sql queries are executing successfully but in connections tab there are no connections can you please help me with this?

[@tarunsingh951]

Man you are awesome!! thank you very much. You saved me from a lot of trouble.

[@navyasri271]

When typing grant all privileges command...its saying that no database selected

[@SoftwareSolutons]

Did you tried it , with a huge database remotely ?It is terribly slow there...

[@SiddharthRay1]

awesome video, straight forward and easy explanation.

[@cardinal6858]

Hello can we make a html css php and mysql app only with vs code? Without use xamp or other same thing?

[@SkyV77]

bro how ur cmd prompt shows mysql ? mine says that no such thing found

[@gizachewalemu4534]

Great Explanation! Thank you Sir.

[@HanaNoufal]

i am still getting the error mysql not recognized by internal or external.....even after copy paste..ing the path

[@HafizBehroz]

bro how can i connect mt4 account into my website . so whatever i will trade it will show me as performance or graph in my website dashboard

[@moloko_127]

Why dont I have the button for execution the sql code ?

[@user-ci9ty6dl6m]

hi there! I done all instructions and finally I have got the connection. But I get error when Im trying make require : Cannot read properties of undefined (reading 'undefined') Help me please!

[@techrose]

This tutorial was a life saver! Thank you!!

[@slowcoding]

Many thanks for clear explanations!

[@stockmarketinusa1251]

how to open the project in this which i have already in my computr

[@sjanakys6769]

Firstmy sql connection not showing ^ arrow and in command prompt is not recognize as internal or external command

[@MananSuriGaming]

after i type the password it says ERROR 2059 (HY000): Authentication plugin 'caching_sha2_password' cannot be loaded: The specified module could not be found plss help

[@UwU-dx5hu]

Please please please help me. The sqltool icon which is on the left sidebar of vs code disappeared. Without that I am not Being able to connect to mysql. Pleade tell me how can i bring back the icon

[@ngn1810]

After I created the new database, I was unable to execute it...it said 'query with errors'...somebody help

[@ishikacasley2786]

do we have to create a new username and password for every db connection?

[@yesmanforever1002]

Awesome man, just awesome! Thanks.

[@trevorjamesconsideracion1982]

THANKK YOU! This was also the last piece I needed

[@motodad1856]

I get this error : Connect ECONNREFUSED, what does this mean.

[@nabilakhansah]

Thank you so much sir, it worked! your explained is so good

[@kiaraargueta2011]

Not sure if I’m the only one but it’s not letting me run it on my Mac. When I try opening run.bat it takes me back to visual studio code…

[@greenary3587]

sir my cmd only playing microsoft play store coding download even when i download python from website it will not work and when i download with microsoft it will work what i do for solve this problem i dont understan what the problem

[@marsakatlavincentprajwal289]

Sir still i am getting access denied error for user in vs code

[@TheInternetFan]

4:16 couldn't you use the Terminal that is part of VS Code instead of resorting to command prompt.

[@omonditony9344]

You've saved my ass within a skiddle of minutes Thanks so much

[@subhashnisoundhar7654]

I was open the vs code to set a database and start it to connect the process of database and in connection settings ther was error like self signed certificate in certificate chain.....help me to slove this problem sir😢

[@googlewasmyyidea]

Does he create a new user at hostname % or x?

[@handphoneblogger5434]

4:23 I stopped here...error 1524 plugin mysql native password is not loaded please help

[@Sheikh_shakir]

While granting privileges it is showing ne error "no database selected" can anyone here help me?

[@yacinehbrahim6073]

You made my day, thanks a lot

[@hellomyfriend974]

What is the command prompt codes on Linux

[@user-cd8cg3yr1q]

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

[@mfAdvice]

Can this will be connect with Ubuntu server database??

[@deepasri9698]

Thanks for this video.. It worked so well for me too.. Have a nice day😊

[@conmoetramtinh]

Error opening connection self signed certificate in certificate chain. Help me solve this plzz

[@3r3bu5x9]

thanks a ton! vs code is unreal! it can run anything!

[@user-yo1dy8lz2z]

I can't run the cmd code, what is the problem?

[@jnandeepdevsarma2966]

after saving the script run on active connection missing. Kindly help

[@VigneshKaniveta]

it is showing=> connect ECONNREFUSED ::1:3306

[@djeguiwague2911]

Thanks for this video.. It worked so well for me too.. Have a nice day

[@candy7333]

'mysql' is not recognized as an internal or external command, operable program or batch file.

[@black_south5222]

Thanks for this tutorial , your accent seems like you are Tunisian

[@user-ln6ol8yy6q]

تحية للتوانسة متابعك الجديد من المغرب keep up the good work

[@BoostMyTool]

Vous êtes le bienvenu et merci pour votre inscription

[@user-ln6ol8yy6q]

@@BoostMyTool لا شكرا على واجب..اتمنى لك مسيرة موفقة

[@swagbgm4830]

I got an Error opening connection Access denied for user 'admin'@'localhost'(using password:YES)

[@trevorjohnson7128]

when going to CMD, i get the error 'mysql' is not recognized as an internal or external command, operable program or batch file. any fixes?

[@BoostMyTool]

see this: kzbin.info/www/bejne/noHQlatug7uSe6s

[@maximorodriguez6849]

how can i get it on mac

[@LamNguyen-nm1fq]

great video. thanks for sharing

[@AbdulraheemShatat]

4:01 - I get stuck when typing my password as it denies access.

[@fernandadaisy25]

I have to ensure something. So we must install MySQL firstly to our local system in order to successfully run it in vscode, is that true?

[@marierie101]

Yes

[@hariprasad7743]

Error opening connection Unknown database 'mydatabase' source:MYsql extension ,error showing like this any one help me out

[@momorin2566]

but do I have to first create a username and password named "admin"?

[@aamalservices7630]

Thank you, appreciate your help

[@benc7910]

Hi, at @2:08 in the field 'Database' , you have 'myshop' , is it required to first create a database somewhere else and then use it when creating a connection ? Thank you

[@williamherewini8357]

I had this question too. One way to go about it is: Run "mysql -u root -p" in cmd. Then create a database using: CREATE DATABASE myshop;

[@biroluzun5126]

@@williamherewini8357 thank you so much it worked.

[@minhnguyentue5248]

You are awesome!! thank you very much.

[@ngumpel222]

Thanks very much for this. It has greatly helped me

[@tiagodmota5840]

You are the best. Greetings fom 🇧🇷

[@zeus12345y]

this video was really helpfull,,,thanks broo

[@nicetomeetugaming7024]

Thanks this video is helpful.

[@xeliotrop]

I have a problem at 4:00 it says ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

[@PriyaVerma-zk2zx]

I am facing same problem how did you solved it?

[@xeliotrop]

@@PriyaVerma-zk2zx I somehow managed to reset my password but I can't remember exactly how I did it

[@iamkashyapkumar]

Open task manager > go to services > search for mysql80 or something like this > right click and start the service

[@vikalpparashar7898]

go sudo or if that doesnt work in sudo try mysql -u root mysql

[@Chandankumaryck]

@@PriyaVerma-zk2zx did you solved the problem

[@anup_narvekar]

This video is a life saver! Thanks a ton!!!

[@BoostMyTool]

You're welcome

[@vineetakajodiya]

Hi, When I am setting up connections I am not getting a list under the connections tab in order to get connect and disconnect connections. Can you please help me with this..

[@cspointbysaurav]

I am facing same problem can you please help me ?

[@prateekpal7391]

version not showing please help its showing ; - 'mysql' is not recognized as an internal or external command operable program or batch file

[@tkurtalan]

Should change the directory to bin folder by the following command: cd Program Files\MySQL\MYSQL Server 8.0\bin But ofcourse go to main directory first by the command: cd\

[@__._.._._.]

@@tkurtalan it's showing system cannot find the path specified

[@iam.mystic]

There's another video in the i button. Worked out for me

[@imonmandal3663]

Thanks a lot for solving my problem

[@BoostMyTool]

You're welcome

[@manikanthooli940]

Ur accent is soo good❤

[@pradeepc2751]

I can't connect to the server what to do

[@fluttterdev1k]

thanks friend it was a great tutorial

[@nilamkautkar4206]

Very useful..thanks

[@saansardar1215]

Sir please tell me which version of Microsoft visual studio code is stable??i basically do everything in visual studio code be it sql files,c,c++,python etc.But recently i formatted my whole pc.Now i need to install again

[@BoostMyTool]

you cannot choose the version, vscode will update itself to the latest version automatically

[@likithgummidi7576]

when i typed first command in command propt it is saying :" mysql' is not recognized as an internal or external command, operable program or batch file." what should do here admin

[@Hadi-gv9fb]

did you find the solution?

[@dhanushetty2908]

What did you type for password in command promt

[@rajatsharma5892]

Thanks, Sir but how to give a name to an untitled query.

[@alphabetagamma3113]

while installing, the errors i got are different from the ones you are seeing. also when I am trying to check my MySQL version on command prompt, i cant see the version. can anyone please help?

[@rain_yy]

same problem

[@Tomreado]

You are a hero!

[@user56290]

I have done all the things in the video, but still getting the same error and databases are not showing. what should I do?

[@thathojohannes1862]

same here ey

[@thewonder474]

Thank you so much. its really work

[@anonymous-3720]

How and Where did you create the password?