How to Connect to MySQL Server and Run SQL Queries from VSCode (2024) - MySQL in Visual Studio Code

In this video, I'll show you how you can connect to mysql server from vscode and run sql queries from vscode.
We need to install and extension in visual studio code that will allow us to connect to mysql server in our local machine or a remote server. After we have connected to the MySQL server from vs code, we can then inspect the database server, run queries and manage our database directly from visual studio code.
☕Buy me a coffee: www.buymeacoff...
🌐Connect with me:
TikTok: tiktok.com/@thecodecity
Twitter: / thecodecity
Instagram: / thecodecity
Website: thecodecity.com
If you have problems trying to connect to mysql server from vscode, let me know in the comments below.
#vscode #mysql #mysqlvscode #mysqlserver

[@ppragyasharrma5450]

access denied for user@localhost is coming when I saved the test connection database. Can you please help me in this?

[@unnecessarilylonghandle]

check your password

[@mithraiyyappan263]

​​@@unnecessarilylonghandle Can I put 4 digital pin as password? Or any other restrictions for creating password??

[@ADITYAKUMAR-ts1hy]

THANK YOU SO MUCH !! IT WAS REALLY VERY HELPFUL !!

[@eshamohan8896]

Great video and to the point! Thanks a lot

[@werter3649]

thanks man, helped a lot

[@abhishekkumar-hx1io]

Connection error!connect ECONNREFUSED 127.0.0.1:3306 can you tell how to resolve this issue

[@TheCodeCity]

Looks like you are using wrong username/password

[@ushad654]

Even i have the same issue if anyone fixed pls help me

[@ushad654]

If u resolved pls help

[@abhishekkumar-hx1io]

@@TheCodeCity I have not entered any thing from my side, I have followed everything of yours.

[@HelloWorld-lh1wk]

first start the myAdmin server from XAMPP

[@nai_sha8863]

Didn't work for me, it shows connection error. Does anyone know how to resolve it?

[@doggydoggy578]

Do I need mysql installed in my machine first ?

[@Rachelssolutions]

holy first time ever and it worked thank you

[@juanpasten6077]

Thanks but it didn't work for me.

[@sujitmor8646]

how to create a table in by importing of csv file here?

[@MAAMARMOHAMED-jx7vz]

thank you sir

[@uc7602]

Great video. Thanks for sharing!

[@TheCodeCity]

You're welcome! Glad it helped

[@kvelez]

Thanks

[@krikol_77]

How can I execute the whole script instead of executing only one request ? Thanks !

[@krikol_77]

I believe CTRL+A and then run ?

[@TheCodeCity]

did you try this?

[@krikol_77]

@@TheCodeCity yes it’s fixed, just need to put ";" at the end of every request to prevent fails

[@venkatadrivenky9351]

What is password sir

[@jeevan-23]

thanks

[@RajasekharYadav-z1e]

CONNECCTON ERROR is showing

[@cutfebi2094]

me too

[@kergun11]

Good bu not enough. I want to create Stored Procedures and Functions easily