How TO Connect To MYSQL SERVER & RUN SQL Queries Using VSCode

How TO Connect To MYSQL SERVER & Run SQL Queries Using Visual Studio Code. In this video, I am going to show you how to Install or setup MYSQL Server on windows 11, establish a connection to the MYSQL database using VISUAL Studio Code or VSCode and execute SQL Queries. We are going to fix some of the errors “er_not_supported_auth_mode” and successfully connect to the mysql database using VSCode
Check Out My Website - kskroyal.com
~ Buy Me A Coffee
buymeacoffee.com/kskroyal
~ BitCoinAddress
36TPyi2xsUTre1idDZ5pPZFe97mRsrPxpK
--------
TimeStamps
--------
00:00 Introduction
00:36 Download MYSQL & VSCODE
01:29 Installing MySQL Server
04:22 Adding MySQL Path TO Environment Variable
06:36 Connecting to MySQL Database From VSCode
09:16 Writing SQL QUERIES Using VSCODE
------------
Most Recent Videos
------------
Top 10 Must Have Gnome Extensions in 2023: • Top 10 Must Install Be...
Installing Arch Linux On Gaming Laptop: • Installing Arch Linux ...
Ubuntu 23.04 New Features: • Ubuntu 23.04 (Lunar Lo...
Install Ubuntu on Apple Silicon Mac bare Metal: • How TO install UBUNTU ...
Dual Boot Kali linux & Windows 11: • How to Dual Boot Kali ...
Install Kali linux 2023 In Virtual Box: • How To Install Kali Li...
---------
© KSK ROYAL
MereSai
---------

[@jubayershikder7722]

I was struggling with the authentication problem in general. I just randomly clicked just like other videos with no expectations that if it could fix my problem but you just nalied it. Finally I can do my work on sql, Huggggggggggggge thanks brother

[@Codebake]

This video has been a great help. I can't thank you enough! Here to support your future workings.

[@shintaafrn]

OMG you saved my life!!! Thank you so much! I've been trying to find out on how to resolve this problem for days and now I can start to learn SQL. THANKS A LOT!!!!!

[@mohammedfouzan9115]

How do you create a new database on the side panel from vscode

[@bullymaguire7341]

well your commands aren't working can't create user nor im able to grant all privileges it says syntax error

[@xpunxisri]

this is what I was looking for exactly, thank you!

[@saniakumari117]

I tried your steps but while installation , its not showing developer default mode , video time-1:43

[@msann3612]

Hi bro! What can I do about active connection in VSCode??

[@trevorjamesconsideracion1982]

Clear and easy to follow. Thank you!

[@Rex-Solis]

Can you please tell how we can import csv file data into this vs code extension of mysql

[@indraalvine3087]

Hi, thx its helpful But can you make git bash as the administrator to run the mysql in gitbash instead of powershell?

[@markoj2726]

Very good tutorial, thank you!

[@rohitpanjabi4762]

This Helps a lot, but when we already have a SQL file , we are not able to use that using this method, this only works when we do the new query after right clicking on the database in vscode, any workaround for this, I have even done use databasename and select database() ---> this is giving me null as result. please help on this.

[@knowledge_Hub526]

THANKS ALOT SIR YOU MAKES A GREAT PINPOINT SOLUTION VIDEO. THANKS MAN

[@user-nm1fn8uz9k]

great video, such a clear explanation !!

[@akashprathod]

Thank you. Excellent tutorial with successful set up.

[@dreamscomestrue4114]

It shows error 1049 (42000) : unknown database 3306

[@divyeshpatel234]

solution?

[@synosahil]

Your videos are so helpful

[@NotnameFounttokyoghoul]

thank you so much it worked so helpful ❤❤

[@domp6770]

this is really helpful

[@johnbillbarangan6019]

can you do C++ connection with sql using Visual Code Studio?

[@user-kh9wf2sn2o]

when i press the + to create new mysql connection, nothing happens

[@TheSurajJaiswalll]

This video helps me alot bro 🤜🤛

[@_osaid]

thank you soo much!!

[@Diablo-tq8yb]

Bro, the installer of package give me problems

[@a_to_zgaming5977]

good vedio vary help full for me

[@gold_friday]

Why the terminal doesn't recognize mysql --version? I already add that address on local disk C (ex: C:\Program Files\MySQL\MySQL Server 8.0\bin) to Path on Environment. How do I fix that thing??

[@kskroyaltech]

Close the terminal and reopen and try again.

[@user-tw6hc9zb3w]

why i dong have developer option?

[@ubaydillahmaarif6810]

Access denied for user 'root'@'localhost' (using password: YES), (how to fix this) :) pleaseee

[@laizinongcundeniba2352]

Thank you. I wonder what do you do for a living. You kinda manage a bunch of skills that making me a little bit worship.

[@kskroyaltech]

Just KZbin & Agriculture Farming Currently. I Was a Engineering College Drop Out.

[@raveiandelacruz8378]

thank you, so helpful

[@kskroyaltech]

You're welcome!

[@isiltarexilium798]

Man, I love your voice! You're just a Chez from Metal Family!

[@kskroyaltech]

Wow, thank you.

[@DarkWays-oz1cf]

Thanks bro. U good

[@vedant5019]

7:50 at this moment after entering localhost root password and everything the localhost database is not showing

[@sandeepa8755]

Even I am facing the same issue, did you get the solution for this

[@nawelfardeheb5657]

That was helpful, thank youuu

[@kskroyaltech]

You're welcome!

[@osamaalmelhem225]

Thanks!

[@basarunalan1709]

Thank you a lotttt

[@synosahil]

Your videos are so helpful ❤

[@kskroyaltech]

Thank you

[@shubhamsingh-gq9uj]

Thankyou ❤

[@lonewolf.8635]

This video was very helpful

[@kskroyaltech]

Thank you very much

[@fluttterdev1k]

it saved my time thanks bro

[@kskroyaltech]

Amazing

[@Geasoncodm]

it's not working for me, I tried this several times already

[@OthersWork-jl5eh]

this literally solve all my problems

[@kskroyaltech]

Awesome.

[@thethirdeye5454]

I cant create user

[@dariodark4683]

7:40 I entered the username, password, localhost... and the database is just not showing at all. Like nothing appens. Pls help me !

[@xyz-sy8eu]

Same error, did u find the solution ?

[@ikkibrittania7890]

where can i find the connectorrrrrrrrrrrrrrrrrrrrrrr

[@akdattingal]

create user 'root' @'%' identified with mysql_native_password by 'admin'; ERROR 1524 (HY000): Plugin 'mysql_native_password' is not loaded plss help i am stuck here and cant move forward

[@sanskarkedia1987]

thanks

[@StevieB86]

@5.25 - I am getting this error message in the terminal: "The term 'mysql' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again." Any idea what I'm doing wrong? Cheers!

[@kskroyaltech]

Make sure mysql is installed on your computer and you added its install path to the system environment ..

[@StevieB86]

@@kskroyaltech This is where I screwed up, I didn't correctly add the path to the env. Cheers!

[@kskroyaltech]

😊

[@ankita5862]

For some reasons localhost database isnt showing on my vscode and i dont know why is that

[@kskroyaltech]

Which VSCode extension you are using the one I mentioned ?

[@ankita5862]

​@@kskroyaltech hey it worked today i dont know how but it did😅 thanks alot

[@enaaal6724]

Fatal error : uncaught error: Class "mysqli" not found 😢, hooowww

[@vishwasrchonu7134]

Great video!! Amazing font bro, could you please me which it is?

[@kskroyaltech]

Monaco or Avnier next.

[@vishwasrchonu7134]

Nope, it's neither, I later found out it is Anonymous Pro. Please check properly and lemme know

[@Anuj.Rastogi]

bro it worked like magic

[@kskroyaltech]

Yes it does.

[@isachardamgi9]

How can I get the initial link?

[@kskroyaltech]

Initial Link ?

[@srivenibonam73]

Hi bro At 5:45 when i enter password it shows me unknown database 3306 error could you please answer it if possible

[@satyaprasaddevineni9084]

same problem here. Did you sorted the issue ?

[@harshsinha9709]

Why am I not getting server in my MySQL folder

[@harshsinha9709]

Neither I am getting Developer option

[@erichernandez7223]

I've done all the steps. But on vscode, i do the localhost username and password but after clicking enter nothing happens. Please help me if you can

[@kskroyaltech]

Make sure the MY SQL Server is running and try again.

[@malotafionalouella6674]

how do you make sure it's running tho? @@kskroyaltech

[@sphere_1]

While creating a new user it shows "SyntaxError: Unexpected identifier 'user'"

[@kskroyaltech]

This is the format of the MYSQL commands to create a new user: *CREATE USER 'USERNAME'@'localhost' IDENTIFIED BY 'PASSWORD';* then grant all privileges by running this command: *GRANT ALL PRIVILEGES ON * . * TO 'USERNAME'@'localhost';* and lastly run *FLUSH PRIVILEGES;*

[@sphere_1]

thankyou@@kskroyaltech

[@zamsMG]

best

[@yoyo5050]

100000 LIKES DUDE!!!!!!!!!!!!!!!!!! Succinct 🙌🙌🙌🙌🙌🙌🙌🙌🥂🥂🍻🍻🥂🥂🍻🍻⭐⭐⭐⭐⭐⭐

[@jerrydjagni511]

I'm seeing no active connection found

[@kskroyaltech]

Make sure the MYSQL server is running in the background

[@rudranarayan6527]

❤

[@nagarajk3309]

After Enter password, in terminal its shows error 1049 unknown database 3306

[@abhinavrnarayan]

Same problem bro

[@nagarajk3309]

@@abhinavrnarayan did you find solution,? I m moved on workbench

[@abhinavrnarayan]

@@nagarajk3309 no bro I'm also using workbench rn

[@akshitrawat3903]

mysql -h localhost -P 3306 -u root -p.........(before entering the port number its capital 'P' not a small one try checking this)

[@thethirdeye5454]

@@akshitrawat3903 thank you 👍

[@shashankmallick9427]

YOU ARE GREAT!!!!!!!!!!!!!!!!!!!!!

[@sarindasatharasingha7196]

i installed my sql and click + button the occurs this error massage "Error running command mysql.addConnection: command 'mysql.addConnection' not found. This is likely caused by the extension that contributes mysql.addConnection." why and how should i overcome this

[@kskroyaltech]

Which extension you are using ? at 7:03

[@Peter-CDs]

@@kskroyaltech "Error running command mysql.addConnection: command 'mysql.addConnection' not found. This is likely caused by the extension that contributes mysql.addConnection." mysql. This error is such a a pain