Тёмный

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

Ksk Royal
Подписаться 131 тыс.
Просмотров 81 тыс.
0% 0

Опубликовано:

 

7 сен 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 111   
@jubayershikder7722
@jubayershikder7722 8 месяцев назад
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
@OlufowobiOlabode 12 дней назад
Brooooo you’re the greatest man I’ve been trying this for months. Big ups man just followed, God bless
@kskroyaltech
@kskroyaltech 11 дней назад
Super .and thank you so much
@shintaafrn
@shintaafrn 3 месяца назад
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!!!!!
@dreamscomestrue4114
@dreamscomestrue4114 5 месяцев назад
It shows error 1049 (42000) : unknown database 3306
@divyeshpatel234
@divyeshpatel234 Месяц назад
solution?
@SURYAS-re8oe
@SURYAS-re8oe Месяц назад
Instead of using 3306 use 33060 to create local host port
@Codebake
@Codebake 10 месяцев назад
This video has been a great help. I can't thank you enough! Here to support your future workings.
@laizinongcundeniba2352
@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
@kskroyaltech Год назад
Just RU-vid & Agriculture Farming Currently. I Was a Engineering College Drop Out.
@vedant5019
@vedant5019 11 месяцев назад
<a href="#" class="seekto" data-time="470">7:50</a> at this moment after entering localhost root password and everything the localhost database is not showing
@sandeepa8755
@sandeepa8755 6 месяцев назад
Even I am facing the same issue, did you get the solution for this
@gold_friday
@gold_friday 9 месяцев назад
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
@kskroyaltech 9 месяцев назад
Close the terminal and reopen and try again.
@knowledge_Hub526
@knowledge_Hub526 10 месяцев назад
THANKS ALOT SIR YOU MAKES A GREAT PINPOINT SOLUTION VIDEO. THANKS MAN
@rohitpanjabi4762
@rohitpanjabi4762 6 месяцев назад
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.
@xpunxisri
@xpunxisri 4 месяца назад
this is what I was looking for exactly, thank you!
@isiltarexilium798
@isiltarexilium798 11 месяцев назад
Man, I love your voice! You're just a Chez from Metal Family!
@kskroyaltech
@kskroyaltech 11 месяцев назад
Wow, thank you.
@Rex-Solis
@Rex-Solis 3 месяца назад
Can you please tell how we can import csv file data into this vs code extension of mysql
@saniakumari117
@saniakumari117 9 месяцев назад
I tried your steps but while installation , its not showing developer default mode , video time-<a href="#" class="seekto" data-time="103">1:43</a>
@rushinggodz3314
@rushinggodz3314 12 дней назад
yes even it did not showing to me
@msann3612
@msann3612 9 месяцев назад
Hi bro! What can I do about active connection in VSCode??
@soIatido
@soIatido 5 месяцев назад
Clear and easy to follow. Thank you!
@johnbillbarangan6019
@johnbillbarangan6019 3 месяца назад
can you do C++ connection with sql using Visual Code Studio?
@NANI-zb2ql
@NANI-zb2ql Месяц назад
Thank you so much brother!!!
@user-nm1fn8uz9k
@user-nm1fn8uz9k 7 месяцев назад
great video, such a clear explanation !!
@ubaydillahmaarif6810
@ubaydillahmaarif6810 8 месяцев назад
Access denied for user 'root'@'localhost' (using password: YES), (how to fix this) :) pleaseee
@a_to_zgaming5977
@a_to_zgaming5977 7 месяцев назад
good vedio vary help full for me
@dariodark4683
@dariodark4683 10 месяцев назад
<a href="#" class="seekto" data-time="460">7:40</a> I entered the username, password, localhost... and the database is just not showing at all. Like nothing appens. Pls help me !
@xyz-sy8eu
@xyz-sy8eu 3 месяца назад
Same error, did u find the solution ?
@akashprathod
@akashprathod 6 месяцев назад
Thank you. Excellent tutorial with successful set up.
@OthersWork-jl5eh
@OthersWork-jl5eh 3 месяца назад
this literally solve all my problems
@kskroyaltech
@kskroyaltech 3 месяца назад
Awesome.
@indraalvine3087
@indraalvine3087 Год назад
Hi, thx its helpful But can you make git bash as the administrator to run the mysql in gitbash instead of powershell?
@NotnameFounttokyoghoul
@NotnameFounttokyoghoul 9 месяцев назад
thank you so much it worked so helpful ❤❤
@user-kh9wf2sn2o
@user-kh9wf2sn2o 2 месяца назад
when i press the + to create new mysql connection, nothing happens
@vishwasrchonu7134
@vishwasrchonu7134 3 месяца назад
Great video!! Amazing font bro, could you please me which it is?
@kskroyaltech
@kskroyaltech 2 месяца назад
Monaco or Avnier next.
@vishwasrchonu7134
@vishwasrchonu7134 2 месяца назад
Nope, it's neither, I later found out it is Anonymous Pro. Please check properly and lemme know
@synosahil
@synosahil Год назад
Your videos are so helpful ❤
@kskroyaltech
@kskroyaltech Год назад
Thank you
@markoj2726
@markoj2726 10 месяцев назад
Very good tutorial, thank you!
@mohammedfouzan9115
@mohammedfouzan9115 7 месяцев назад
How do you create a new database on the side panel from vscode
@domp6770
@domp6770 Год назад
this is really helpful
@synosahil
@synosahil Год назад
Your videos are so helpful
@raveiandelacruz8378
@raveiandelacruz8378 11 месяцев назад
thank you, so helpful
@kskroyaltech
@kskroyaltech 11 месяцев назад
You're welcome!
@TheSurajJaiswalll
@TheSurajJaiswalll 10 месяцев назад
This video helps me alot bro 🤜🤛
@lonewolf.8635
@lonewolf.8635 9 месяцев назад
This video was very helpful
@kskroyaltech
@kskroyaltech 9 месяцев назад
Thank you very much
@harshitasharma4034
@harshitasharma4034 Месяц назад
Thanks
@nawelfardeheb5657
@nawelfardeheb5657 5 месяцев назад
That was helpful, thank youuu
@kskroyaltech
@kskroyaltech 5 месяцев назад
You're welcome!
@akdattingal
@akdattingal 2 месяца назад
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
@nagarajk3309
@nagarajk3309 Год назад
After Enter password, in terminal its shows error 1049 unknown database 3306
@abhinavrnarayan
@abhinavrnarayan Год назад
Same problem bro
@nagarajk3309
@nagarajk3309 Год назад
@@abhinavrnarayan did you find solution,? I m moved on workbench
@abhinavrnarayan
@abhinavrnarayan Год назад
@@nagarajk3309 no bro I'm also using workbench rn
@akshitrawat3903
@akshitrawat3903 10 месяцев назад
mysql -h localhost -P 3306 -u root -p.........(before entering the port number its capital 'P' not a small one try checking this)
@thethirdeye5454
@thethirdeye5454 8 месяцев назад
@@akshitrawat3903 thank you 👍
@Diablo-tq8yb
@Diablo-tq8yb 9 месяцев назад
Bro, the installer of package give me problems
@fluttterdev1k
@fluttterdev1k Год назад
it saved my time thanks bro
@kskroyaltech
@kskroyaltech Год назад
Amazing
@enaaal6724
@enaaal6724 6 месяцев назад
Fatal error : uncaught error: Class "mysqli" not found 😢, hooowww
@StevieB86
@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
@kskroyaltech Год назад
Make sure mysql is installed on your computer and you added its install path to the system environment ..
@StevieB86
@StevieB86 Год назад
@@kskroyaltech This is where I screwed up, I didn't correctly add the path to the env. Cheers!
@kskroyaltech
@kskroyaltech Год назад
😊
@user-tw6hc9zb3w
@user-tw6hc9zb3w 8 месяцев назад
why i dong have developer option?
@ankita5862
@ankita5862 10 месяцев назад
For some reasons localhost database isnt showing on my vscode and i dont know why is that
@kskroyaltech
@kskroyaltech 10 месяцев назад
Which VSCode extension you are using the one I mentioned ?
@ankita5862
@ankita5862 10 месяцев назад
​@@kskroyaltech hey it worked today i dont know how but it did😅 thanks alot
@ikkibrittania7890
@ikkibrittania7890 5 месяцев назад
where can i find the connectorrrrrrrrrrrrrrrrrrrrrrr
@_osaid
@_osaid Год назад
thank you soo much!!
@DarkWays-oz1cf
@DarkWays-oz1cf Год назад
Thanks bro. U good
@basarunalan1709
@basarunalan1709 9 месяцев назад
Thank you a lotttt
@erichernandez7223
@erichernandez7223 11 месяцев назад
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
@kskroyaltech 11 месяцев назад
Make sure the MY SQL Server is running and try again.
@malotafionalouella6674
@malotafionalouella6674 11 месяцев назад
how do you make sure it's running tho? @@kskroyaltech
@AnalyticalAnuj
@AnalyticalAnuj 11 месяцев назад
bro it worked like magic
@kskroyaltech
@kskroyaltech 11 месяцев назад
Yes it does.
@osamaalmelhem225
@osamaalmelhem225 9 месяцев назад
Thanks!
@yoyo5050
@yoyo5050 4 месяца назад
100000 LIKES DUDE!!!!!!!!!!!!!!!!!! Succinct 🙌🙌🙌🙌🙌🙌🙌🙌🥂🥂🍻🍻🥂🥂🍻🍻⭐⭐⭐⭐⭐⭐
@srivenibonam73
@srivenibonam73 9 месяцев назад
Hi bro At <a href="#" class="seekto" data-time="345">5:45</a> when i enter password it shows me unknown database 3306 error could you please answer it if possible
@satyaprasaddevineni9084
@satyaprasaddevineni9084 7 месяцев назад
same problem here. Did you sorted the issue ?
@shubhamsingh-gq9uj
@shubhamsingh-gq9uj 11 месяцев назад
Thankyou ❤
@sphere_1
@sphere_1 10 месяцев назад
While creating a new user it shows "SyntaxError: Unexpected identifier 'user'"
@kskroyaltech
@kskroyaltech 10 месяцев назад
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
@sphere_1 10 месяцев назад
thankyou@@kskroyaltech
@Geasoncodm
@Geasoncodm 10 месяцев назад
it's not working for me, I tried this several times already
@harshsinha9709
@harshsinha9709 8 месяцев назад
Why am I not getting server in my MySQL folder
@harshsinha9709
@harshsinha9709 8 месяцев назад
Neither I am getting Developer option
@thethirdeye5454
@thethirdeye5454 8 месяцев назад
I cant create user
@sanskarkedia1987
@sanskarkedia1987 9 месяцев назад
thanks
@isachardamgi9
@isachardamgi9 10 месяцев назад
How can I get the initial link?
@kskroyaltech
@kskroyaltech 10 месяцев назад
Initial Link ?
@jerrydjagni511
@jerrydjagni511 10 месяцев назад
I'm seeing no active connection found
@kskroyaltech
@kskroyaltech 10 месяцев назад
Make sure the MYSQL server is running in the background
@zamsMG
@zamsMG Год назад
best
@rudranarayan6527
@rudranarayan6527 Год назад
@sarindasatharasingha7196
@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
@kskroyaltech Год назад
Which extension you are using ? at 7:03
@Peter-CDs
@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
@shashankmallick9427 10 месяцев назад
YOU ARE GREAT!!!!!!!!!!!!!!!!!!!!!
Далее
Will A Guitar Boat Hold My Weight?
00:20
Просмотров 68 млн
Fake watermelon by Secret Vlog
00:16
Просмотров 9 млн
How to Use VS Code to Run SQL on a Database
15:06
Просмотров 279 тыс.
Install Linux instead of Windows 11 - Here's how!
15:10
How To Connect MySQL To VsCode.. (For Windows)
16:03
Просмотров 17 тыс.
7 Amazing CLI Tools You Need To Try
18:10
Просмотров 322 тыс.
New to Linux? Yeah, DON'T Use Manjaro...
15:55
Просмотров 206 тыс.