How to Connect XAMPP(PhpMyAdmin) MySQL Database to Visual Studio [Step By Step]

welcome to this video in this video we will see how we can connect our database that we can access from PHP management to visual studio code so let's get started first of all Press Your Windows key and type Sam and now we click on start and start again so we start on these two and let's check what database we want to connect our Visual Studio code so go to your browser and type localhost my admin is open you can see a bunch of MySQL databases here so there's fast users there is these other things like test but let's see what we can ask users so we have a database here class users and we'll have a bunch of tables inside fast users we have table users here and inside table user as you can see we have these three rows so we have some data so now we'll connect this database to our Visual Studio code open your Visual Studio now in your Visual Studio code click on this extensions icon or hit Ctrl shift in x and we'll type MySQL so it will show you a bunch of options now you need to select this one from region so click on this and click install this is all you will see this options disabled and uninstall and you will see these two options on here database and usql so click database I already had this extension so I can see this so let me just delete this for now okay so let's write connection name since we are connected to our local design index I'll just write local DB and in order to write anything here now we need to select MySQL so you can see you can connect to a bunch of databases here but we will connect to mySQL now host is our localhost username is root and Port is 306 now in your case Port might be different so you can check Port here but it is since 3306 here we will keep it three zero six I have not had any password to my local database and after all these things I don't see I did not have to change anything and you can add a specific database here or not and if you don't add a specific database here you will see all the bunch of databases that you that this user has access to Okay so let's save and as you can see this is the receipt so now if I click on this localhost for DB it will show me all the databases that the root user has access to so I can click on flash users and I can click on tables and if I click on table users you can see if I show all the columns here now I can see all the data inside this table by clicking on this and it will show me all the data that is inside this thing so now we have successfully connected to our database from my visual studio code as you can see here this is the editor that we have in our pH environment and we have now connected to that database using our Visual Studio code if you have any questions let me know

Channel: The Code City

Views: 53,710

Keywords: How to connect mysql to visual studio, connect xampp mysql to visual studio, connect xampp mysql phpmyadmin to visual studio, connect phpmyadmin to visual studio

Id: fU9ngotJz1w

Length: 3min 14sec (194 seconds)

Published: Thu Jun 22 2023