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++.
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.
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.
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
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With