How TO Connect To MYSQL SERVER & RUN SQL Queries Using VSCode
HTML-код
- Опубликовано: 21 июл 2024
- 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
--------- - Наука
This video has been a great help. I can't thank you enough! Here to support your future workings.
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
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!!!!!
this is what I was looking for exactly, thank you!
Clear and easy to follow. Thank you!
Very good tutorial, thank you!
great video, such a clear explanation !!
Hi, thx its helpful
But can you make git bash as the administrator to run the mysql in gitbash instead of powershell?
Thank you. Excellent tutorial with successful set up.
thank you so much it worked so helpful ❤❤
THANKS ALOT SIR YOU MAKES A GREAT PINPOINT SOLUTION VIDEO. THANKS MAN
Your videos are so helpful
this is really helpful
This video helps me alot bro 🤜🤛
Hi bro! What can I do about active connection in VSCode??
How do you create a new database on the side panel from vscode
Can you please tell how we can import csv file data into this vs code extension of mysql
well your commands aren't working can't create user
nor im able to grant all privileges it says syntax error
thank you soo much!!
That was helpful, thank youuu
You're welcome!
thank you, so helpful
You're welcome!
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.
Just RUclips & Agriculture Farming Currently. I Was a Engineering College Drop Out.
good vedio vary help full for me
Man, I love your voice! You're just a Chez from Metal Family!
Wow, thank you.
Your videos are so helpful ❤
Thank you
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.
Thanks bro. U good
Thanks!
This video was very helpful
Thank you very much
I tried your steps but while installation , its not showing developer default mode ,
video time-1:43
Thank you a lotttt
it saved my time thanks bro
Amazing
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??
Close the terminal and reopen and try again.
Thankyou ❤
this literally solve all my problems
Awesome.
can you do C++ connection with sql using Visual Code Studio?
It shows error 1049 (42000) : unknown database 3306
solution?
bro it worked like magic
Yes it does.
Great video!! Amazing font bro, could you please me which it is?
Monaco or Avnier next.
Nope, it's neither, I later found out it is Anonymous Pro. Please check properly and lemme know
thanks
7:50 at this moment after entering localhost root password and everything the localhost database is not showing
Even I am facing the same issue, did you get the solution for this
Bro, the installer of package give me problems
when i press the + to create new mysql connection, nothing happens
why i dong have developer option?
7:40 I entered the username, password, localhost... and the database is just not showing at all. Like nothing appens. Pls help me !
Same error, did u find the solution ?
@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!
Make sure mysql is installed on your computer and you added its install path to the system environment ..
@@kskroyaltech This is where I screwed up, I didn't correctly add the path to the env. Cheers!
😊
100000 LIKES DUDE!!!!!!!!!!!!!!!!!! Succinct 🙌🙌🙌🙌🙌🙌🙌🙌🥂🥂🍻🍻🥂🥂🍻🍻⭐⭐⭐⭐⭐⭐
Access denied for user 'root'@'localhost' (using password: YES), (how to fix this) :)
pleaseee
I cant create user
best
For some reasons localhost database isnt showing on my vscode and i dont know why is that
Which VSCode extension you are using the one I mentioned ?
@@kskroyaltech hey it worked today i dont know how but it did😅 thanks alot
it's not working for me, I tried this several times already
where can i find the connectorrrrrrrrrrrrrrrrrrrrrrr
Hi bro
At 5:45 when i enter password it shows me unknown database 3306 error could you please answer it if possible
same problem here. Did you sorted the issue ?
How can I get the initial link?
Initial Link ?
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
Make sure the MY SQL Server is running and try again.
how do you make sure it's running tho?
@@kskroyaltech
Why am I not getting server in my MySQL folder
Neither I am getting Developer option
While creating a new user it shows "SyntaxError: Unexpected identifier 'user'"
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;*
thankyou@@kskroyaltech
Fatal error : uncaught error: Class "mysqli" not found 😢, hooowww
I'm seeing no active connection found
Make sure the MYSQL server is running in the background
❤
After Enter password, in terminal its shows error 1049 unknown database 3306
Same problem bro
@@abhinavrnarayan did you find solution,? I m moved on workbench
@@nagarajk3309 no bro I'm also using workbench rn
mysql -h localhost -P 3306 -u root -p.........(before entering the port number its capital 'P' not a small one try checking this)
@@akshitrawat3903 thank you 👍
YOU ARE GREAT!!!!!!!!!!!!!!!!!!!!!
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
Which extension you are using ? at 7:03
@@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
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