Connect to MySQL Database and Run SQL Queries Using Visual Studio Code (2022) and MySQL Extension
HTML-код
- Опубликовано: 21 июл 2024
- Connect to MySQL Server using vscode. Setup MySQL Connection in Visual Studio Code and Run SQL Queries using MySQL Management Tool extension. How to install and use MySQL Extension with Visual Studio Code. How to run SQL queries from Visual Studio Code. How to fix ER_NOT_SUPPORTED_AUTH_MODE Client does not support authentication protocol requested by server; consider upgrading mysql client. *******************************
Connect to MySQL Database using vscode and SQLTools Extension: • Connect to MySQL Datab...
Install MySQL Server : • How to Install MySQL S...
*******************************
Create new MySQL user with old authentication method:
CREATE USER 'sqluser'@'%' IDENTIFIED WITH mysql_native_password BY 'password';
GRANT ALL PRIVILEGES ON . TO 'sqluser'@'%';
FLUSH PRIVILEGES;
********************************** .
***********************************
🔥 Complete Udemy Courses :
Build E-commerce Web Application using ASP.NET Core : www.udemy.com/course/aspnet-c...
Build E-commerce Web API using ASP.NET Core : www.udemy.com/course/build-as...
Build E-commerce Web Application using React JS : www.udemy.com/course/build-co...
⬇️ Free Document Proofreading ⬇️
► Grammarly : grammarly.go2cloud.org/SH3YB
You saved my life. I was dealing with this error for about 2 hours and luckily I found your video. Thanks a lot. ❤❤
Thank you, I kid you not, I spent probably about 5 hrs trying to figure this out, thank you :)
nice. there are very limited information available out there on how to properly connect VS 2022 or C++ to sql server.
So I was able to create a new user in the cmd but once I delete the old connection in vs code and add the newly made connection from the cmd, I’m still getting an error: er not supported auth mode…
sir tysm!! this was exactly the help ive needed all day
This is very very very best video for connecting SQL server database to visual studio code
Tq
Thanks, good Sir, this one did the job for me. The other extensions I tried had no option to enter the path for the SSL certificate.
Gracias porque muchos solo muestras cuando se conecta pero no cuando hay un error Ni lo muestra solo que todo es perfecto para ellos Gracias por muestra las dos Causas
Can I use MySQL from vscode without installing MySQL community server ? I tried to install MySQL community server but the custom and other options shows initialising database ( may take too long ) error when i installed the MySQL community server.
really helpful ! thankyou sir.
Awesome! Thank you!
Thank you very much, sir, much appreciated
sir i was not existing the create user sqluser and password it come on error if it comes an error then what would we do
Your video is very useful! thanks
Can I use this method to connect in Microsoft Visual Studio 2022?
Makasih banget Kak, ini bantu aku banget buat bikin Tugas Akhir. semoga dimudahkan semla urusan kakak :D
Hallo kak, aku jg lagi kerjain project visual studio. Boleh diskusi bareng?
still showing same error as before using the new user
what to do ?
while command grant all privileges it is showing no database selected. how to resolve it?
i can't find MySQL folder in file explorer, what might be the reason?
Mee to...
Have you checked the program files in c drive.
Tell me how do you installed MySQL 8?
I need this setup please help me
This is exactly what I needed! Thank you 😊
bro my error not removing can you help me 😭
@@gauravmandal8866 me too
Heart full ❤ thanks for you bro
is there any way to go back on the orignal settings
Thanks a bunch!
it is a great video, Thank you so much. I have one question: How to import an online database to vs code using mysql
Thanks a lot, man ! You skipped lots of work by me😃 !
Please can you connect webpage to save data to MySQL database when you click the submit button on your signup page 2:05
does this process runs in windows 7 ultimate? I did all the steps but It is still error.
gotta try this out !! been so frustrated with the error : (
what do you do when u get this error: ERROR 1046 (3D000): No database selected
I keep getting error 1045 mysql 28000 access denied for user. happens after i use the GRANT ALL PRIVILEGES. Can you help?
thanks alot !
Thank you so much
i am not able to find mysql folder in Program Files
ERROR 1396 (HY000): Operation CREATE USER failed for 'sqluser'@'%' any solution for this
Thank you!!!
Sir is there any way that I can reach out to you and show some pictures pls pls , i have exams in 7 days pls pls
God bless your soul mate i was looking for this all day . Big thanks from Greece.
he is from Tunisia aka Carthage . I know my countrymen when they speak English hahahah from millions I can grab that accent
Hi
How to export the results table to csv file ?
thanks a lot😊
man, I don't know what I'm watching here...I just to know how to open(connect) my WordPress in VisualStudio so I can customize my theme. I've already installed WordPress in my localhost...can you help a beginner like me
how to do the same in macbook?
I've followed all the procedures, but why does it still error?:(
My connection not showing in vs code so i tried to reconnect it but it not showing
I could not add connection localhost its not showing after giving username root password plz give me reply i need to fix this
The commend are all gived but error also come
It showing access denied
nice teacher ❤️❤️
nice video ❤
error at grant all command
great!
For those of you guys still experiencing access denied, if you type exactly just like in the video, please type in "password" as the new password.
Good luck mate !
thanks bro.
that was helpfull
thank you so much!
Thank you:)
Thanks bro😊
Sir when i am creating a new user it's showing me this error
ERROR 1396 (HY000): Operation CREATE USER failed for 'sqluser'@'%'
Me too were u able to fix it?
@@cutieshortie01 no vro 🥲🥲
I changed 'sqluser'@'%' to 'sqluser'@'localhost' I hope this helps
@@Artist19 hey im not able to create user . any help ?
@@Artist19 yes it helped me tq
QUESTION.
How do I share my database to another computer?
I am using Workbench SQL and I want my database to be access to other computer. basically I have mini POS system and is workable. the problem is that, I cannot share my database to other pc since my program have 3 windows, one for clerk, one for cashier, and one for manager.
can you help?
no me sale la tabla :C helme
WHAT IF, MY MYSQL HASN'T ANY PASSWORD?
STILL its showing same error😭😭
Did EXACTLY as told. Still showing error.
Update - Now it is connected. The mistake I was making was after creating sqluser using CREATE USER, I was giving the password in VS Code as my Password to connect to mysql server. But the password to give in VS Code is password which is what is written in CREATE USER. So just user password as password and it will be connected.
Thanks A lot
Thank u so muchhh 💥💥💥
Thank you so much
Someone pin this message.
Awsm
bro mera error hat nhi rha hai
bro can you please help me in this I got error
#IndiansSavesLifes
The senond command gave me wrror
You are Tunisian 100%: ya weld bledi
your comands not working in 2023
Bin folder ni aarha 😢
Are Moroccan YOU Brother
3la hsab lahdja rak tban weld bladi, fe9tlek😅
Nothing happened sir....😕
Because software is MySQL 8.0.29 and in visual studio code, I want to connect ..... that why....!
Robojax voice
What's the password?
I got this one, but I dont know how to fix it.
ER_ACCESS_DENIED_ERROR: Access denied for user ''@'localhost' (using password: YES)
yarhem waldik