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

[@vivekjadhav9744]

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

[@divine-favouranigbogu413]

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

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

[@maharun]

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

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

[@hanafirjl]

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

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

[@nknnithinabc]

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

[@MrBEEOUTCH]

Spent 4 hours and you saved me so much time.

[@firstprinciples9854]

Very clear and detailed explanation. Thanks

[@tarunsingh951]

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

[@SiddharthRay1]

awesome video, straight forward and easy explanation.

[@slowcoding]

Many thanks for clear explanations!

[@gizachewalemu4534]

Great Explanation! Thank you Sir.

[@trevorjamesconsideracion1982]

THANKK YOU! This was also the last piece I needed

[@yesmanforever1002]

Awesome man, just awesome! Thanks.

[@techrose]

This tutorial was a life saver! Thank you!!

[@nabilakhansah]

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

[@omonditony9344]

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

[@3r3bu5x9]

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

[@yacinehbrahim6073]

You made my day, thanks a lot

[@anup_narvekar]

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

[@BoostMyTool]

You're welcome

[@deepasri9698]

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

[@user-ln6ol8yy6q]

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

[@BoostMyTool]

Vous êtes le bienvenu et merci pour votre inscription

[@user-ln6ol8yy6q]

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

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

[@djeguiwague2911]

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

[@Tomreado]

You are a hero!

[@ngumpel222]

Thanks very much for this. It has greatly helped me

[@aamalservices7630]

Thank you, appreciate your help

[@minhnguyentue5248]

You are awesome!! thank you very much.

[@susamay]

Finally! Working.

[@manikanthooli940]

Ur accent is soo good❤

[@LamNguyen-nm1fq]

great video. thanks for sharing

[@nicetomeetugaming7024]

Thanks this video is helpful.

[@allanjohn7261]

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

[@tiagodmota5840]

You are the best. Greetings fom 🇧🇷

[@yukunshang5315]

It worked! Thanks a lot

[@BoostMyTool]

You're welcome

[@user-dc3ou2jt4v]

thank u so much as i was facing this issue

[@black_south5222]

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

[@thewonder474]

Thank you so much. its really work

[@dc-tlc9654]

Thank you!!! 👍

[@imonmandal3663]

Thanks a lot for solving my problem

[@BoostMyTool]

You're welcome

[@espiritualidadedesvendada]

Thank you very much!!

[@nilamkautkar4206]

Very useful..thanks

[@TotallynotBINH]

Thank you so much my good sir

[@zeus12345y]

this video was really helpfull,,,thanks broo

[@toancdu]

Thank you so much for your help

[@anniesmith6165]

Thank you so muuuuch!!

[@Icyhandss]

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

[@fluttterdev1k]

thanks friend it was a great tutorial

[@TheC1tss]

THANK YOU !!!!

[@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!

[@liongamer538]

thanks bro nice explained

[@laovoyage]

Good Work !

[@Rex14550]

Excellent Video.

[@sandipmaurya7371]

Thanks a lot brother

[@SkyV77]

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

[@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.

[@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.

[@navyasri271]

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

[@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.

[@bunnyblake3885]

I would love to see Closed Captions on this video!

[@johanesalberto6136]

thanks brother

[@TheInternetFan]

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

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

[@ommishra7]

Thank you

[@Jesuisjusteunchat]

thanks you for this video

[@saikatdas252]

thanks a lot🙌

[@HanaNoufal]

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

[@MohamedAli-vt6kh]

Lifesaver!

[@animaacharya5061]

thank you 😊

[@zengarden6956]

Nice

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

[@Tewahedo16]

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

[@technicalmindsstudios1977]

hii tanhs for this tutorial iteally helped

[@Angela-Gee]

MERCI BCP

[@khaledhisham3624]

Your English is so great , where are you from

[@X-factor6]

thanks man :)

[@hemantkumardas3333]

Thanks Sir...

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

[@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!

[@modestasriabovas3977]

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

[@modestasriabovas3977]

Would be great if someone helped me out.

[@maccoskuni8646]

@@modestasriabovas3977 Hey budy on your cmd just cd to C:\Program Files\MySQL\MySQL Server 8.0\bin

[@maccoskuni8646]

@@modestasriabovas3977 Find your mysql folder then navigate to bin and then run mysql --version

[@BoostMyTool]

watch this video czcams.com/video/hPmdx8NV_EI/video.html

[@Austin-pw2ud]

czcams.com/video/hPmdx8NV_EI/video.html&ab_channel=BoostMyTool

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

[@SoftwareSolutons]

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

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

[@dyar6301]

Thank u

[@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…

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

[@sathishkumar2852]

thanks man

[@josiah8789]

for those having trouble with "check the manual that corresponds to your mysql server version for the right syntax to suer near 'IDENTIFIED BY 'password' "
try this
CREATE USER 'user'@'localhost' IDENTIFIED BY 'password';
GRANT ALL ON *.* to user_name@localhost IDENTIFIED BY 'password';
replace user_name with whatever your username is, and i think password is supposed to be replaced with whatever you set your password to

[@kamilapassos1441]

muuuuuuuuuuuuuuuuuuuito bommmm, me ajudou demaissss!!!!!!!!!!!!!!! nota 10

[@VigneshKaniveta]

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

[@doslidnik1]

Add subtitles please, you must access checkboks in settings of video

[@wearecoader1958]

Simple explain that is good but i want to ask how to connect with our java program.❤

[@marsakatlavincentprajwal289]

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

[@saiei]

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'PRIVILAGES ON *-* TO 'sqluser'@'%'' at line 1

[@akhiljella5958]

@@samuellazar554 this also not working, facing same error

[@kingoflegends1029]

​@@akhiljella5958 in the second line
GRANT ALL PRIVILEGES ON . TO 'sqluser'@'%' WITH GRANT OPTION;
the "." needs to be surrounded by ' * ' symbol, youTube uses the symbol to format text to bold " *Like this* " so it doesn't show up in reply

[@jamaljaafar6355]

You need to Change ‘ into ' attention on that

[@hazikali6434]

@@samuellazar554 mysql> CREATE USER 'sqluser'@'%' IDENTIFIED BY 'password';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'sqluser'@'%' WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;
use this

[@hazikali6434]

you have to add two asterisk before and after full stop (.)

[@marwenmtg]

😍bil7ram tounsi inti hhhhh