Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to connect to MySQL server from Visual Studio Code

I recently downloaded the MySQL server and want to connect to it using VSCode, after i installed the VSCode extension, i still have little idea on how to connect to the server/database. All the guides online seem to cover Visual Studio C++.

like image 552
Greatguy Avatar asked Jun 24 '20 09:06

Greatguy


People also ask

Can you connect MySQL to Visual Studio?

To create a connection to an existing MySQL database: Start Visual Studio and open the Server Explorer by clicking Server Explorer from the View menu. Right-click the Data Connections node and then select Add Connection.

Can we use MySQL with VS Code?

MySQL Shell For VS Code integrates the MySQL Shell directly into VS Code development workflows and was released last week. This extension to the popular VS Code platform enables interactive editing and execution of SQL for MySQL Databases and optionally the MySQL Database Service for several simultaneous sessions.


1 Answers

When you install the plugin vscode-database you have some buttons in the footer menu bar to connect to your database. When you open the plugin there is a short tutorial how to connect.

https://marketplace.visualstudio.com/items?itemName=bajdzis.vscode-database

like image 147
René Höhle Avatar answered Oct 15 '22 10:10

René Höhle