Instructor: Hey!
In this video, we're going to learn how to install MySQL
on Microsoft Windows.
So as far as the topics here,
the first thing we're going to do is download MySQL,
then we'll install MySQL,
and then finally we'll verify our installation.
Alright, so a lot of good stuff.
Let's go ahead and jump in and get started.
Alright, so what we need to do is open up a web browser
and visit the MySQL website.
So here my browser I'll type in dev.mysql.com/downloads
and this will take me to the MySQL downloads site.
Alright, once I'm at the page
I want to download the MySQL community server
and on the community server page,
they have an option here for downloading it
for Microsoft Windows.
I'll go ahead and select that option for downloading.
This will take me to the download page
and I'll select the option here
for downloading the Microsoft Windows MSI installer
and I'll chose the web version.
It's a small, light weight version.
Now normally they want you to log in,
but in this case I'll say no thanks,
just go ahead and start my download.
Alright, so your browser will prompt you to save the file.
I'll go ahead and save the file.
And it will start downloading it to my file system.
Okay, great.
So it's downloaded.
We can open up our windows explorer,
move into the downloads folder.
And now what I want to do is simply the start the installer.
So this will start up
a normal Microsoft Windows install wizard.
Alright, so the standard thing here, right?
License agreement, go ahead and check the box
I accept the agreement.
Go ahead and click next.
Here we want to keep the developer defaults,
so just make no changes there. Developer default.
Next they're going to check some of the requirements
of your system.
So the first product listed here is the MySQL work bench.
We need to install the Microsoft Visual C++ runtime
but the installer will actually do this for you.
So we'll simply select that and hit execute
and it will go out to the web
and it will download the appropriate dependencies
that you need.
So I'll just click, click, click, accept all the defaults
as it goes through this example.
And it's at that point that we have everything available
for MySQL workbench.
It will prompt us about some of the other products.
You can just go ahead and just click past that.
And then just hit execute
and it will start downloading all the dependencies
that you need.
So this will take a while.
I'll kind of step away
and I'll come back once everything is downloaded.
Okay, great.
So we've downloaded everything.
Note here we have all green checks here
and the status is complete for everything.
So we're in good shape.
So we can go ahead and click next.
Click next one more time.
Here we'll set up some of the networking.
We'll just keep all of the defaults.
Click next.
At this point we'll need to define our root password.
So you can give whatever you want for your root password.
You can call it FUBAR, whatever.
I'm going to give a long password
just so it comes out as a strong password.
But you can give whatever you want.
You can give a four letter password if you like.
The key item here
is that you need to remember that password.
Make sure you write it down (laughs).
Alright, I'll go ahead and click next.
I'll keep the defaults here.
It's going to run MySQL as a windows service.
I'll click execute,
and it will go off and it will start applying
our server configurations.
I'll hit finish, I'll hit next.
And now we're going to do a simple test
to connect to our server.
Click the check button, connection successful.
We're okay.
And then we hit next, and finished, and next one more time.
And at this point,
we hit finish and it will actually start up
the MySQL server.
So now what we're going to do is verify our installation.
So I'm going to use this MySQL workbench.
It's simply a web gooey tool,
I'm sorry it's simply just a gooey tool,
that allows you to connect to your MySQL database.
So here I just enter that same password
I did during installation.
And at this point I have a gooey open
and I can actually query some of the tables.
So MySQL always starts off with some sample tables for you.
I'm going to access this one table called city
and I'll just do this little,
I'll right click, say select rows.
And this will give me all the rows from the sample table.
So, again, really here,
we're just verifying that we can connect to the database
and do a basic query.
So this all looks really really good.
So our server's up and running and we can query it.
Alright, so this kind of wraps up the video.
So we went through the process of downloading MySQL,
installing it, and then finally you ran the MySQL workbench
just to verify our installation.
And at this point, MySQL is up and running,
we're in good shape,
and now we can use it later on in our jsf videos.
Good job.