In this video we will look at how to install mysql workbench on windows system , let’s
get started.
So first we will download mysql workbench , so for that let me open my chrome browser,
and here in search bar, search for my sql, so once you search for mysql , in first search
result , you will see this official website of mysql, so just click on it, so here in
mysql official website , just scroll down,and at the bottom, you will see the link for downloads,
and inside that you can see this mysql workbench , so just click on it, so once you click on
this one , in this download page, you can see the support for , different operating
system, so I can see support for windows , linux, Ubuntu , macos all these different operating
system , so let’s select windows, and in windows, by default it provides this, exe
for 64 bit, incase if you have 32 bit windows, so here you have this, go to download page,
just click on it, once you click on this one,in the next page you will see download file for
windows 32 bit system, so let’s go back, and here, we goanna install on windows 64
bit, so just click download, and here it will ask you to login into oracle account, or even
you can signup for oracle account as well , but, sometime you have option to skip that,
so here I have this, no thanks, just start my download, so just click on it, so which
will start download for me, which will take a while, and we will wait till download is
completed, so its look like our download is completed, so let’s minimize this , and
lets go to download folder, so here you can see mysql workbench exe file, so for installation,
double click on it, and here click on next, so here it is goanna install under ,c program
files,than mysql , mysql workbench 8.0 CE, so if you want to change the location, just
click on change , and you can give your location, but I go with default, so click on cancel,
and say next, and here lets go with complete , and click on next, and say install, so my
installation is started which will take a while, so its copying the new files, so our
setup is completed, so here in the last page, you have this option, launch mysql workbench
now, so which is check, so which will launch workbench for me, and just click on finish,
so this is the homepage of mysql workbench , which says , welcome to mysql workbench,
and here in the connection you can see by default, it has created this mysql80 connection,
now lets create new connection, so for new connection , just click on plus sign, so which
will open this wizard , so here lets give the name of this connection , so I say probably,
mysql local, and connection method , standard , and host name, lets say local host, and
port one is, 3306, which is the default port for mysql, so in your case if the port name
is changed , so probably you can change here your port number , and here user name, lets
change the user name as well, and default schema, will not put any schema name, and
click on this test connection , and lets put the password , and say ok, so it says, successfully
made the mysql connection , and click on ok, and for saving this connection, click on ok,so
here you can see this mysql local connection is created for me, so for ,connection you
just double click on it and you can connect to mysql, now lets explore some other options,
so just click on file, and you go to new model, so here , you can create the data model or
physical model, for your mysql database, so here you can add your table, views, routines
, all these database objects, and which will create this physical diagram for mysql database,
now this is about mysql model, now lets go back to homepage , and lets go to scripting,
so here you have this scripting shell , and just click new script , so here you so this
python script, so lets go with python script, now, here lets give the script name, so I
say sample.py and say create, so here, I can see this one, let me maximize this one, and
here ,lets write some simple program, so I say print, and say , welcome to python, so
now lets save it, and for execution , you have this bar, so click on this execute script,
so here you can this welcome to python output, now let go back to this sql bench, so now
lets this connect , so right click on this one, and say open connection, and here, enter
the password, so I connected to my local mysql database, so where I can see this schema , so
the first schema is sakila , where I can see these tables, and other is sys schema, and
in world, I see some table, city, country all these, so now lets connect to this schema,
so for connecting to this world schema , just double click on it, so when it is converted
into bold, means you are connected to this schema , so now , in the city , lets say select
star from city, so this is my select statement, lets select this, and for execution , so just
click on this bar, execute the selected portion of the script or everything, so here you can
see this , id, name the country code district and population of the city, ya that’s all
for this mysql workbench installation process, hope this video will help you to install mysql
workbench and give some idea about mysql work bench functionality , and thank you for watching
this video, and see you in the next video.