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

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

[@OlufowobiOlabode]

Brooooo you’re the greatest man I’ve been trying this for months. Big ups man just followed, God bless

[@kskroyaltech]

Super .and thank you so much

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

[@Codebake]

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

[@dreamscomestrue4114]

It shows error 1049 (42000) : unknown database 3306

[@divyeshpatel234]

solution?

[@SURYAS-re8oe]

Instead of using 3306 use 33060 to create local host port

[@_aman2602_]

if still after entering 33060 the error is showing up then install mysql community server from google and then setup it in your terminal or cmd and then come here and type the name of database as - information_schema

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

[@saniakumari117]

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

[@rushinggodz3314]

yes even it did not showing to me

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

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

[@soIatido]

Clear and easy to follow. Thank you!

[@knowledge_Hub526]

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

[@isiltarexilium798]

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

[@kskroyaltech]

Wow, thank you.

[@LUISCAÑIBANOMATEOS]

great video, such a clear explanation !!

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

[@xpunxisri]

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

[@msann3612]

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

[@synosahil]

Your videos are so helpful ❤

[@kskroyaltech]

Thank you

[@NotnameFounttokyoghoul]

thank you so much it worked so helpful ❤❤

[@a_to_zgaming5977]

good vedio vary help full for me

[@markoj2726]

Very good tutorial, thank you!

[@akashprathod]

Thank you. Excellent tutorial with successful set up.

[@synosahil]

Your videos are so helpful

[@indraalvine3087]

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

[@TheSurajJaiswalll]

This video helps me alot bro 🤜🤛

[@domp6770]

this is really helpful

[@Rex-Solis]

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

[@mohammedfouzan9115]

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

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

[@govindatudu6460]

Thankyou bro ❤😊

[@lonewolf.8635]

This video was very helpful

[@kskroyaltech]

Thank you very much

[@johnbillbarangan6019]

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

[@GetAccess-z2j]

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

[@nawelfardeheb5657]

That was helpful, thank youuu

[@kskroyaltech]

You're welcome!

[@NANI-zb2ql]

Thank you so much brother!!!

[@raveiandelacruz8378]

thank you, so helpful

[@kskroyaltech]

You're welcome!

[@fluttterdev1k]

it saved my time thanks bro

[@kskroyaltech]

Amazing

[@yoyo5050]

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

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

[@OthersWork-jl5eh]

this literally solve all my problems

[@kskroyaltech]

Awesome.

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

😊

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

[@Diablo-tq8yb]

Bro, the installer of package give me problems

[@ubaydillahmaarif6810]

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

[@Doxing-i8n]

why i dong have developer option?

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

[@AnalyticalAnuj]

bro it worked like magic

[@kskroyaltech]

Yes it does.

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

[@harshsinha9709]

Why am I not getting server in my MySQL folder

[@harshsinha9709]

Neither I am getting Developer option

[@ikkibrittania7890]

where can i find the connectorrrrrrrrrrrrrrrrrrrrrrr

[@thethirdeye5454]

I cant create user

[@Geasoncodm]

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

[@isachardamgi9]

How can I get the initial link?

[@kskroyaltech]

Initial Link ?

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

[@YouPI227]

Where are the links ?

[@kskroyaltech]

Links to ?

[@jerrydjagni511]

I'm seeing no active connection found

[@kskroyaltech]

Make sure the MYSQL server is running in the background

[@DarkWays-oz1cf]

Thanks bro. U good

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

[@_osaid]

thank you soo much!!

[@shubhamsingh-gq9uj]

Thankyou ❤

[@basarunalan1709]

Thank you a lotttt

[@enaaal6724]

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

[@osamaalmelhem225]

Thanks!

[@harshitasharma4034]

Thanks

[@sanskarkedia1987]

thanks

[@zamsMG]

best

[@rudranarayan6527]

❤

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

[@shashankmallick9427]

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

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