MySQL Database for Visual Studio 2019 | Getting Started

hello everyone welcome back once again in this video we will look at mysql for visual studio 2019 we will look at how we can download the mysql installer and install all the necessary components but before we get started please make sure you subscribe to the channel if you haven't so let's get to it then my sql is a relational database management system rdbms based on a structured query language which ranks virtually on all platforms including linux units windows etc and it's also an open source software so my sql is a is based on a server on a client server model and its core is the mysql server which handles all the database instructions or commands mysql is also available for separate programs in a client server networked environment and can also be embedded or linked into a separate applications so in this video we'll also look at my mysql workbench so mysql workbench is just a unified visual tool for database architects developers and dbas my sql workbench provides data modeling sql development and comprehensive administration tools for server configurations and so on so to get started obviously we have to open a browser we i've got this one here google and we have to type in my sql installer so once we actually do that then the first result as you can see here download mysql installer so that's exactly what we're going to do so once we click on that just wait for it to load so it will will be actually taken to this page mysql community download so what we do is actually click on the first bit the windows x i mean x86 or 32-bit so you select which one is actually applicable to what system you're using right so we just click on this bit here download and here you can you can say no thanks and this will actually start the download process right so i'm not gonna i'm just gonna cancel it because i've already got it so what i'm gonna do is just going to pull it out so once you actually download it download it you have to then you click on run so that's what i'm going to do so just in a sec okay i'm just going to do it from here anyway so obviously you'll be prompted by windows to actually to allow the installation to go through so once that happens here this is where you get the installer 1.4 and here this is the the window that you actually get once you open the the mysql installer so we're going to select the developer default yeah this actually installs all products needed for my sql development purposes right so we click on the nest so here as you can see the selected path already exists so i mean let me see i've actually installed it previously so i'm just going to leave it right there click next to see what actually happens yeah you still have one and with the selected but are you sure you want to continue yes so here this is all the the stuff that is that is needed to to download so as you can see here if we look we've got mysql for visual studio selected as well so you select whatever is applicable to you right so what i'm going to do is just click on execute so this will actually start the download so as you can see here we've got all the necessary downloads going on so i'm just i'm just going to pause the video while the whole thing completes yeah so you can click on here just to show more details okay so we've got all the all the components that i've actually selected downloaded so what i'm gonna do is just gonna close the visual studio so now what we do is we click on the nest so here here we can we're going to store whatever products that we actually um whatever product that is ready to install so we click on execute so just wait for all the messages all the selected products to install so i'm just going to post it while the whole installation completes okay so we've got this um the installation completed so we click on the nest yeah so here we can click on the finish right so we get this shell so as you can see here now we've got the workbench open now so the workbench like i said is official graphical user interface too for mysql it allows you to design create and browse your database schemas right so as you can see here now you can add connections here i've already got one here so it's actually say no connection established so i'm just gonna close this bit here close this one so what we're going to do is just open the mysql installer again so mysql installer community we open this s1 so on the mysql server side here we click reconfigure so here we leave the configure type as a development computer and we leave the port and the whole all the information is pretty much the same they will click on the nest yeah here we're just gonna leave it next so we just here i've already created a password but if you don't have a password obviously you'll be prompted to create a new password password and confirm it so i'm just going to put the password that i created with yeah so i'm just going to check so as you can see yeah it's it's okay so i'm just gonna go next so here you can create a custom user uh just a standard system account yeah so which is actually recommended in most most cases areas right so there is a service name so start the mysql server at system startup so you can do that but i'm not gonna look too much into that so we're just gonna wait for the whole thing to we're just gonna click on this bit to execute so now we've got this server started now so we click on finish so now we can come here and up in there the mysql work page so we just type workbench so we open the workbench so now you can click on this and then you enter your server password and as you can see here now we've got the service open now so what we do next is go inside the visual studio so once we click on continue with our code so we open the server explorer and add new connection so as you can see the first time after the installation you get this mysql for visual studio configuration update so this is actually a change in the installation of connector.net has been identified you won't execute the configuration update so you click on the nest so you accept so as you can see and now you can you can actually you can see that the changes is being taken effect so we just wait for a while i'm just gonna post it while the whole thing completes so now as you can see we're gonna have to restart the visual studio for the changes to take effect so i'm just gonna close it and restart it so reopen it so now i'm just gonna continue with our code so come inside of server explorer again and add new connection so here now once if we go here as you can see we can now see that mysql database so we can select it from the data's also so this use use this selection to connect to mysql server using the net framework data provider for mysql yeah so we click on ok so we we enter our server name which in this case is localhost and the username which is the root so there's one more thing that we need to do here explicitly is to go inside this part here and actually sets our our port number our port number which is 3306 if i may recall so we're just going to open the workbench to check that yeah so it's three three zero six so you click okay so you enter your password and here you can enter the database if you've created one or in this case i don't so i'm just gonna th 300 just for anything so i will just test the connection so it's not connected so we click on okay so the database c300 does not exist or you do not have permission to see it so we just click yes to create it click ok so as you can see here we've got the database created now we can up expand it so as you can see we don't have any tables store or store procedures or stored functions inside them but this is actually how you can actually get started so i'll leave the video here for now but on the next video on this topic yeah we'll look at actually building database project inside the visual studio for mysql right so once again if you haven't subscribed to the channel please make sure you do because i've got loads of videos coming up and i hope you have a lovely morning evening afternoon wherever you are peace

Channel: Hacked

Views: 51,121

Keywords: mysql, visual studio, learn mysql, mysql tutorial, mysql tutorial for beginners, mysql for visual studio, mysql workbench, sql, mysql project, mysql visual studio 2019, mysql visual studio code, mysql php, sql server, mysql server, mysql client tutorial, mysql windows installation, database, mysql database, mysql vs code, sql database, mysql database visual studio 2019, mysql for visual studio 2019, mysql for visual studio code, mysql vs 2019, php

Id: 4jtFW2cvELI

Length: 12min 52sec (772 seconds)

Published: Sun Feb 07 2021