Warning.
This video may contain extremely frustrating installation instructions and is for experienced developers
only.
It's advised that you install using Cloud nine to avoid needless pain and anger.
All right.
If you're still here after the stern warning, I'll talk about how to install MySQL on Windows.
Of course.
Remember, you will probably run into some sort of issue depending on your computer and what you have
installed already.
It can be difficult.
So that's why I really, really, really recommend that you use cloud nine skip windows until the end
of the course.
That's enough of a broken record.
Let's get started.
So to install MySQL on a PC, we need to go to MySQL and then click on the download section and then
click on community and other community.
You can actually click on any of these.
If you click on download, what it's going to suggest for you if you're a Windows user, is that you
actually use the MySQL installer rather than downloading things individually.
Basically, it's a package that will help install a bunch of MySQL things all at once that you may or
may not use.
You may or may not need.
Make sure that you have the correct version selected depending on your architecture.
Then click download and it looks like it starts downloading, but it actually doesn't.
You have to click another button at the bottom.
No thanks.
Just start my download and then I'll fast forward through.
This takes a little bit to download depending on your internet, but then once it's done, all we want
to do is open it up, run the installer.
So then we have a couple of options.
We're going to select developer default and then click next and then depending on what you have installed
on your computer, you may need to actually install some other requirements.
So I did here.
So I basically had to go through a couple of times double click, click execute, wait for something
else to go install in this case, Visual C++.
And then I had to repeat that a couple of different times.
Now that will probably be different for you and your machine, but then once that finishes, click on
Execute Again and this will actually start the installation process.
So there's a bunch of components installing, but once they're complete, click next and then we move
on to configuration and all we really care about is configuring the server.
So we'll click next again, basically click next another time.
We don't need to change anything.
And further, another time click next.
Okay.
So we're now at the point where we need to decide on a root password for my SQL so you can decide on
whatever you like.
I just chose password, the word password.
It's not a good password, but I wanted to make it simple, easy to remember.
So you type it in twice, tells me that it's weak.
And then I'm also going to add a user here, you don't have to do this.
I'm just going to make one with the name Colt.
And also the password will be password and then confirm the password also tells me that it's weak and
I'll click, okay, so really all that you need to do is remember whatever password you type for the
root and then click next and then we'll click next one more time.
And then finally again we'll click Execute and it will start to apply the configuration and it may take
a moment or two, but then once it finishes, everything should be installed.
So we'll click finish and then get out of here.
So that's how we install.
The next important thing is starting up the command line client, which you can find just under my SQL
Command Line client.
Click on it and then you'll need to enter your root password, which in my case was password.
And now we're able to actually type some code, something like show databases, which we haven't talked
about, but you can type code in there.
You can also try typing things that aren't SQL and you'll see you get error messages.
But all that we really need to care about is that we have the command line client up and running and
we can type stuff into it.