Connect to MySQL in Visual Studio Code Using MySQL Extension | How to Run MySQL in VS Code

welcome to my Channel today in this video tutorial we are going to learn about connecting my schedule to visual studio code using an extension called MySQL management tools so for that we first we will go to extensions and we will search for my schedule now we will click on this first one click on this install to install and this is deleted you can read about the detail of this tool so now my SQL management tool is uh successfully installed so we will close this uh and we will click on this Explorer and now you can see here down here MySQL so we'll click on this and we will click on this plus icon so it is uh we have to provide the host here which is the where MySQL server is installed so we have installed it in our local machine on this computer so we will give it local host and then press enter Then it uh need the username so we are using the root user of the database so we will provide root and then it needs the password so we will uh provide the password and hit enter and then it takes the port number so 3306 is the default that it is used by MySQL so we'll click enter and we'll hit enter now I'll close this and now if I expand this uh localhost this connection now you can see that it is showing an error here not supported authentication uh so we are connecting to the latest version of my schedule which is version 8 so my originate is uh using a new type of authentication which is not supported by this client MySQL your management Tool uh so we have to create a user with the old authentication method so I'll replace this HTML folder and now we will go to this folder and now we will maximize this and we will go to this PC and to C and to the folder we where we have installed MySQL so we installed it in program file so if I go down so it is here MySQL and now to mySQL server at point 0 and to the bin and here I'll type in CMD and hit enter now we have to connect to our myscale server here so for that I will use MySQL the U and here I have to provide the username so I'll provide root and then we have to provide the password HP and hit enter now here I have to provide my password so I will provide my password and now if I hit enter now we are connected to mySQL so now we will create a new user here with required privileges so for that I have copied the um the queries into a text file so I'll go to desktop and open the text file this is the text file so we have to execute these three queries so I will copy the first one Ctrl C this and now I'll go to this and now I'll Ctrl V it here and hit enter now it is successfully query okay successfully executed so now I'll again go here and now I'll copy the second one and I will grant all the Privileges to the Chooser now this query will be a queries will be available in the description of the video so you can copy and paste it in your same D now I'll go again and now we will flush all the Privileges so I'll copy this and now I'll go here and I will control V8 here and hit enter now we will go we will close this close this as well and now a new user is created so I'll go to this Visual Studio code and now we will go to this localhost and now right click on this and delete the connection now we will get we will again create a new connection for this new user so I'll click on this and now I'll again give it local host enter and now the user is skevel user that we have created and the password is password and hit enter and the port is this one and I will hit enter now if I expand this now you can see it has uh all the databases that are uh inside that my cable server now I can run queries on these databases so if I come here and now if I right click on this uh students table and select up 1000 rows so created the query and now if I select this and now it has uh we have these five records in this table and it has fetched all the records here so now um I'll close this and now we can also create a table with this uh from here so I'll use create and table and then I'll use the table name so the table name we will give it uh this BB this is the database name because we want to create it in that this DB dot then we will get the table lamp so we have student table and gender table so I will I want to create a class table inside this and now we have to provide the column names here so I will provide ID which is end comma class This Is War core and I'll put semicolon at the end and now if I execute this now it is executed so now if I right click on this and refresh this database now you can see that the Clause is class table is created so in this way you can run all the crude operations from here onto your mysqable database or MySQL server so I think that's all for today I hope you liked the video if you like the video please like subscribe and comment thank you

Channel: Programming Guru

Views: 27,772

Keywords: connection to mysql in visual studio code, running sql in visual studio code, mysql visual studio code, how to run MySQL in vscode, run sql queries in vscode, connect to mysql in vscode, run mysql queries in vscode, visual studio code and mysql, how to run sql in visual studio code, mysql extension, MySQL Extension, run sql queries in visual studio code, Extension, MySQL, SQL Queries, mysql database, Visual Studio, Database, Tutorial, visual studio code, sql, Sql vscode

Id: 4VLKbZDbpAs

Length: 7min 22sec (442 seconds)

Published: Mon Jan 23 2023