in this video we look at how you can install MySQL server and MySQL workbench on Windows system
MySQL workbench is the client which is used to connect to your MySQL server
so here for this demo we are using Windows 10 but you can follow the same process
for any version of Windows like Windows 10 Windows 11 Windows 7 or for Windows 8 as well
let's get started so first we'll download our MySQL so for that let's open our browsers so
here I'm gonna use a Chrome browser and here in the browser let's search for MySQL download
so when you search for MySQL download in the search result you wanna see the
official website of MySQL so now let's go ahead and click on this link
so when you click on that you will redirect to the official website of MySQL so here in the
home page you you will have some detail about MySQL and if you scroll down at the bottom
you will see my SQL Community Link so now let's go ahead and click on that
so here for MySQL download we have this my Yum repository API repository cluster router
cell all different options here we're gonna use the last one that's the MySQL installer
for Windows because we are using Windows so now let's go ahead and click on that
so once you click on that you will see the the latest version of MySQL
Community version available for download so here right now we have 8.0.32 version
as a latest version for download so we will download this 8.0.32 and for downloading there
are two option one is the web base which is 2.4 MB and second with second is the
full version which is close to 400 in 37 MB now will download the full version which is
437 MB so for downloading that so here you have this download button just so just click on that
and here in the next page it will ask you to login into Oracle account and if even if you
don't want to login into that you you have this link no thanks just start my download
so just click on that so once you click on that it will start the download for your MySQL installer
so we'll wait till our download is completed and we'll start the
installation process once this download is completed
so it's look like our download is completed so now let's minimize this and go to our download folder
so here you will see the MySQL installer for your Windows
system so for installation just double click on it
so now your installation is started yeah I think this process will take some time so we'll wait
till our installer is ready to start this is the first page of our MySQL installer so here we have
different options like developer default server only client-only full and Custom so here we'll
go with the last one called custom so now let's select this custom and click on next so here in
the custom we have to select the required software for our MySQL installation so first we'll select
the server so expand this MySQL server and select this 8.0.32 and just click on this Arrow so will
be added to the right inside now I will check the application and here in the application we
first we have MySQL workbench so we will expand that and we add this work page as well [Music]
along with that you have Visual Studio cell and router we we are not going to install those
products and now let's see the documentation and the documentation we have the simple and example
so we'll install the sample data for our MySQL so expand that and add the sample an example
to the right side so before you click on next you make sure you edit this MySQL server MySQL work
page in simple an example for your MySQL installation and now let's click on next
so here in the next page is you can see we have selected This Server workplace and
examples so all these three suits are ready to install now here let's click on execute
so it will start the installation for our server first and then it goes to work page
and then Sim sample and examples so our server is installed now it's installing work page
so now this work page is also installed along with the sample and example so over
all three suits are installed now let's go ahead and click on next
so in the next page it's gonna configure your MySQL server and simple an example
so here just click on next
so here you have to select the type and network so here first one is drop down
so you have different options so here we are using for our local purpose so here we'll go
with the first one called Development Center uh sorry development computer
and then we have TCP and enforced and protocol pod so we'll go with the default will not make
any changes to that and we'll go with the default setting and click on next
so here there are some warnings about setting up your route
password and now let's go ahead and click on next
so here you have to set up the password for your root one so I will select the password
so it says V but that's fine and click on next so here you have some settings about your windows
services so here I set this Windows server name so that is the default MySQL 80. so if you want
to change it you can give the name for your MySQL I will go with the default one and in the next one
you have this run Windows services so I will go with the standard system account and click on next
so here it is asking to Grant access to your program data which will be stored
uh using MySQL server so you just select the default first option and click on next
so here you have different options for configuration so it will apply all this
configuration to your MySQL server so here you just have to click on execute
so it's gonna execute all this configuration configuration on top of your MySQL server
so now all this database configuration are applied and now let's go ahead and click on finish
so here it will give you some information
about the configuration so now let's go ahead and click on next
so here for our Windows Server we have this MySQL server 8.0.32 this is our port number
and it says it's running and you have user called root and now let's check the password
and click on check so it says connection succeeded so overall the configuration
is set up correctly and our server is up and running now let's go ahead and click on next
so here it is gonna apply the next set of
configuration so here let's go ahead and click on execute
so yes look like our second set of configuration is applied you can check log as well
now let's go ahead and click on finish so here it says the configuration is
complete for MySQL server and simple and example so let's go ahead and click on next
so this is the our last page of MySQL installation so here we have the message about the completion
of our installation process even if you want to check the log you can copy this log into
your clipboard and can save into file but I think everything went well so I will not look
at this log of this MySQL installer but while installation if you face any issues you can
check the log of installation and here we have checkbook which says start my SQL
workway chapter setup so I'm gonna start MySQL so I will I will check that and click on finish
so it's gonna launch your MySQL workbench
so now let's maximize this and here you can see our MySQL 80 server which we just configure
during the installation now let's connect to that for that just double click on it
and in the next step it will ask for the password which we set while installation so please make
sure you you make a note of your password which you set for the root so I will enter my password
and if you want to save that you can check that and click on OK
so now we connect it to our mySQL database using MySQL work page so here we have two tab one is
administrator Administration and second is schema so in administration you have likes
server status so if you go go to that server status it will give you the status about your
server then you have this client configuration then you can check your user and its Privileges
and then you have system status and variables and you can play around this data export import
and also you can shut down and and start up your instance of your database you
can check your server logs and other options files and also you can check
the performance of your database here you have the dashboard for your database and
other report you can run on your top of your MySQL server now let's close this
and here in the next tab you have schema so here you can see we have two schemas which I've already
installed one is sakila and second is world LS minimize this and first let's expand this world
so just double click on that so it will the schema will be activated so now World schema is activated
and you expand the stable you will see this table called City Country language
now let's expand the CT so here you have this columns it's called ID name country
code and restrict and if you want to query this table you just say select
star from
City so you just select this query and you execute it say here you will see the the records for your
city table yeah that's all for this MySQL server and MySQL workbench installation process hope
this video will help you to install MySQL on your system and running some command on top
of top of your mySQL database and thank you for watching this video and see you in the next video