Connect MySql to Visual Stdio Code

 To connect MySql and Visual Studio Code


Step 1:- Go to Visual Studio Code

                Download the extension

                



Step 2:- Just click this icon in VS Code



Step 3:- After clicking above click on add connection



Step 4:- After that it will show like this


Just click on MySql

Step 5:- Then this dialog box will come 


Here take any connection name like democonnect

Database as demodb

After that write your username and password of your Mysql 

You can select Password mode as save for next time not asking password

Now click on test connection (Here connected Successfully message will be displayed)

At last click on Save Connection.

Note:- In the password mode select as Save so that again and again you no need to enter your password. If you want security then just don't save.

 Step 6:- Click on Connect now



Step 7:- Now you can star your MySql code here shown as down and you can run the same code by clicking on run on active connection.



Step 8:- YMySql connection by clicking as show belowou can disconnect the 


After clicking on green icon it will like as shown below


 You can connect the MySql by the same icon.








-----------------------------------------------------------------------------------------------------------------------------
Note:- You can select Connection name and database as your own choice.
-----------------------------------------------------------------------------------------------------------------------------

If you like the information comment and subscribe it as soon as possible.

0 Comments