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

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

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

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

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

[@iMplimentation]

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

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

[@hanafirjl]

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

[@nknnithinabc]

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

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

[@DrxppyAMV]

@@biswabikashparida9691 no

[@maharun]

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

[@MrBEEOUTCH]

Spent 4 hours and you saved me so much time.

[@soIatido]

THANKK YOU! This was also the last piece I needed

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

[@tarunsingh951]

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

[@techrose]

This tutorial was a life saver! Thank you!!

[@anup_narvekar]

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

[@BoostMyTool]

You're welcome

[@manikanthooli940]

Ur accent is soo good❤

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

[@will_4799]

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]

@@will_4799 thank you so much it worked.

[@black_south5222]

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

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

[@synzyro659]

Keep up the good work man thanks so much 🙏🙏

[@allanjohn7261]

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

[@TheInternetFan]

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

[@TrusteestDesiChhora]

Thank u so Mach one of the video all the problem solve thank you so much❤😊

[@firstprinciples9854]

Very clear and detailed explanation. Thanks

[@VigneshKaniveta]

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

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

[@djeguiwague2911]

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

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

[@khaledhisham3624]

Your English is so great , where are you from

[@omonditony9344]

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

[@حريةكرامة]

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

[@BoostMyTool]

Vous êtes le bienvenu et merci pour votre inscription

[@حريةكرامة]

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

[@SiddharthRay1]

awesome video, straight forward and easy explanation.

[@zeus12345y]

this video was really helpfull,,,thanks broo

[@deepasri9698]

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

[@gizachewalemu4534]

Great Explanation! Thank you Sir.

[@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 kzbin.info/www/bejne/noHQlatug7uSe6s

[@Austin-pw2ud]

kzbin.info/www/bejne/noHQlatug7uSe6s&ab_channel=BoostMyTool

[@tiagodmota5840]

You are the best. Greetings fom 🇧🇷

[@lucindaolivia5156]

At 4:10 what is it after create user 'sqluser' seems like 'e' reply please as soon as🙏🙏

[@BoostMyTool]

it is @ and you can find the entire command in the description of the video

[@yesmanforever1002]

Awesome man, just awesome! Thanks.

[@3r3bu5x9]

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

[@handphoneblogger5434]

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

[@ngumpel222]

Thanks very much for this. It has greatly helped me

[@slowcoding]

Many thanks for clear explanations!

[@nabilakhansah]

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

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

[@SkyV77]

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

[@salmolichandra4068]

'sqltools.getChildrenForTreeItem' failed. error is coming. this is coming when I am creating connection by clicking edit in vs code 5:35

[@stephengeorge5362]

Create a database(mysql) from terminal/command prompt before trying to connect from vs code.

[@danieldanielides]

@@stephengeorge5362 Can you elaborate a bit more? I am receiving the same message. Thanks in advance.

[@gurusaran1879]

4:27 sir i can't understand that symbol... what was that.i have to write that symbol or there's something to write there instead of symbol?

[@bricejoosten5173]

it's just " **.** ", I guess

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

[@aartikhatri2109]

@@marierie101 yrr ye to kisi ne bataya hi nahi even in comments everyone is like run this command in cmd they must hv cleared pehle install kr then uska location dal.........

[@swagbgm4830]

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

[@AbdulraheemShatat]

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

[@marsakatlavincentprajwal289]

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

[@yacinehbrahim6073]

You made my day, thanks a lot

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

[@navyasri271]

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

[@florincordos1097]

I followed all the steps until at the terminal step where i have an error,this is the message from my command prompt:-> The term 'mysql' is not recognized as the name of a cmdlet, function, script file, or operable program. Check t he spelling of the name, or if a path was included, verify that the path is correct and try again.

[@BoostMyTool]

did you execute the command from the bin folder of mysql ? if yes, please check if this folder contains an executable file called "mysql.exe". if you don't have mysql installed, you should install it as explained in this video: kzbin.info/www/bejne/noHQlatug7uSe6s

[@marved-rv2kk]

Can you please help me? I followed all the steps but i have an error: Error opening connection ER_BAD_DB_ERROR: Unknown database 'myshop'

[@shmel850]

same

[@shmel850]

Did you fix it?

[@marved-rv2kk]

@@shmel850 yes just create a database named myshop in mysql terminal

[@marved-rv2kk]

@@shmel850 CREATE DATABASE myshop;

[@Tewahedo16]

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

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

[@minhnguyentue5248]

You are awesome!! thank you very much.

[@zubairahmed-x8d]

thank u so much as i was facing this issue

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

[@iichika504]

Bro "mysql --version" Doesn't work

[@SkyV77]

yes same here

[@dikshantchaturvedi3099]

Its Showing a stupid error and saying "Request connection/GetChildrenForTreeItemRequest failed with message: ER_BAD_DB_ERROR: Unknown database 'myshop'" at 05:39 vid part..... 😐😐😐

[@danieldanielides]

First of all, thanks alot for this videos, I don't have words! 🙏 In my case I am receiving similar error : Request connection/GetChildrenForTreeItemRequest failed with message: ER_ACCESS_DENIED_ERROR: Access denied for user 'Herrniemand'@'localhost' (using password: YES) Any insights @Boostmytool?

[@marsakatlavincentprajwal289]

@@danieldanielides did your problem solved

[@danieldanielides]

@@marsakatlavincentprajwal289 Not yet, unfortunately.

[@animeclips340]

@@danieldanielides In his example, username = sqluser, password = password as you can see here (CREATE USER 'sqluser'@'%' IDENTIFIED WITH mysql_native_password BY 'password';). that will solve your problem in vscode while trying to make connection

[@momorin2566]

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

[@fluttterdev1k]

thanks friend it was a great tutorial

[@hayaalshareef1356]

I have a macbook pro laptop, and I am having issues with running the commands in the terminal. It keeps on saying mysql: command not found. What should I do?

[@Theotav]

brew install mysql

[@hayaalshareef1356]

@@Theotav I do have it installed

[@SoftwareSolutons]

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

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

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

[@GammachuHussein]

Hi brother, do offer private training

[@BoostMyTool]

Hi, yes I do. This is my email address if you need more details: [e-mail]

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

[@bunnyblake3885]

I would love to see Closed Captions on this video!

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

[@yukunshang5315]

It worked! Thanks a lot

[@BoostMyTool]

You're welcome

[@anonymous-3720]

How and Where did you create the password?

[@sjanakys6769]

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

[@ДмитрийБаженов-д3в]

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!

[@thewonder474]

Thank you so much. its really work

[@imonmandal3663]

Thanks a lot for solving my problem

[@BoostMyTool]

You're welcome

[@technicalmindsstudios1977]

hii tanhs for this tutorial iteally helped

[@wearecoader1958]

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

[@MoosaMughal.1]

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

[@Irfanmalik-e6h]

when i run sql files in vscode terminal mysql> source schema.sql; it give this error ERROR: Failed to open file 'schema.sql', error: 2 Please help me

[@stockmarketinusa1251]

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

[@doslidnik1]

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

[@moloko_127]

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

[@cardinal6858]

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

[@user-cd8cg3yr1q]

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

[@LamNguyen-nm1fq]

great video. thanks for sharing

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

[@toancdu]

Thank you so much for your help

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

[@conmoetramtinh]

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

[@luqkiiim]

what is the password at @3:58 ? I never had to enter any passwords

[@X-factor6]

thanks man :)

[@ishikacasley2786]

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