So go over to your browser and type in MySQL on your browser.
And once you do that, go ahead and hit enter.
And that is going to bring you to this awesome page right in here.
So you can see the very first link here.
You can scroll down and see some of the things right in there.
But what I need is the very first link right in here that is MySQL.
Go ahead and hit on that.
And it's going to bring us to this awesome page MySQL Enterprise Edition.
So it has other things right here.
So we are not interested in anything here.
What do we need right now is to go ahead and hit on downloads.
So once you hit on downloads is going to get us to this awesome page.
So now we need to download the MySQL community edition.
So move down and you can see MySQL community downloads.
So go ahead and hit on this.
And that is going to bring us to this awesome page.
So if you get to this page, go ahead and look for MySQL installer for windows.
In case you're working on windows PC, because that is what I'm using for this course.
So go ahead and hit on install for this window.
And that is going to bring us to this awesome page.
So MySQL Community Edition.
And this is where we have.
So right now go ahead and hit on downloads.
So the very first one right here warhead.
And hit on that.
So it can be able to download the installer.
And if you do that it's going to pop up this.
It says no thanks.
Just start my download.
So if wants to log in or sign up you can go ahead and do that.
But for the sake of this course go ahead and hit on no thanks.
And just start my downloads and your download will start immediately.
So now I have downloaded this and it's already on my system.
And the way I'm taking all these steps is to show us the step by step guide on how to download this
and get started.
So now let me go ahead and start the installation of this.
So I have this on my computer right here, which I have just downloaded right now.
Go ahead and double click on this so you can be able to start.
Go ahead and hit on.
Yes and it will start the download process immediately.
So whenever I go ahead and hit on yes.
And that we go to start off immediately and I can see the installer 1.6 and it's going on.
And right now that is coming up.
So you have some set of options to choose.
You can choose the setup type you need.
But for this course we go ahead and choose on Custom Setup.
Now go ahead and hit on next.
And right in here we need two things.
That is the server and the workbench.
Because we are going to use the workbench for this.
So go ahead and hit on this and open up the server.
And right in here I'm going to choose the latest server edition which is the very first one here.
So go ahead and select this.
So it moves over to this point.
so we can discuss.
It might have been updated.
So always choose the latest version because it is more secure.
Now go ahead and choose applications.
And you can see I have MySQL workbench, MySQL shell and MySQL router.
So go ahead and open up the MySQL workbench and then go ahead and open it again.
And I'm going to choose the latest version right in here.
So go ahead and put that right in here.
So at this point I am ready to go.
Go ahead and hit on next.
And then go ahead and execute this.
So once you click on execute you can see that it will begin to download.
And the download process will just take a short while and everything will be downloaded for us.
So everything is already downloaded.
You can see that.
Then we go ahead and hit on next and are ready to install.
Go ahead and hit on execute and it will begin installation.
And that will take most of our time.
We go ahead and get everything set.
So it is a story MySQL server.
And that is um, was done.
And after the server is installed, if you move over to installing the workbench and that is what is
going on right now.
So very soon that will be done for us.
So now we have completed the installation of our MySQL server and MySQL workbench.
Go ahead and hit on next and we are ready to configure.
Go ahead and hit on next.
And uh right here I have some other applications running on my system.
And you can see that port 306 is already in use.
So if you are installing this you're going to have port 3063.
So go ahead and continue.
Your installation is in port 3063306.
So I mean this is port 3306 is already in use because I have other applications running on my computers.
So we can go ahead and change that for my own system alone.
So I'm using port 33068.
But on your case go ahead and maintain port 3306.
All right.
So don't ever change that if you are not using that at the moment.
So it's going to be free for you.
You go ahead and continue.
Don't ever change it.
But if you have something that's not being used, all you need to do is to go ahead and change your
port and continue.
Or you go ahead and uninstall some things that you have installed on your computer previously.
Now let's go ahead, because I don't want to uninstall anything on my computer.
I'll go ahead and continue on next.
So go ahead and follow me with port 3306 on your own computer.
Go ahead.
I hit on next and it says use strong password encryption for authentication.
So go ahead and hit on next.
And I'm going to enter the password.
So I'm going to enter a strong password.
So I had an anti strong password though it will say weak because my password is not as strong as it's
supposed to be.
So go ahead and ensure you have a strong password so that someone cannot penetrate your database.
Now I can add a user, but that is beyond the scope of this.
We are not going to do that at the moment.
I don't want to add any user, I just want to continue because I'm using this laptop just by myself
alone.
So I'm the one using this account and I'm not sharing with anybody.
Now go ahead and hit on next.
And uh, we'll go ahead and hit on next and hit I hit on next and then it will be gone to apply the
configuration step by step.
So what I need to do now is to go ahead and click on execute for the configuration to start applying.
And it will always much of a time everything will be applied.
And then we go ahead and continue immediately.
So the configuration has been applied successfully.
You can see below here the configuration from MySQL server 8.0.39 was successful.
Click on finish to continue.
So go ahead and click on finish.
And uh we'll go ahead and hit on next.
And that is such a procedure has been completed.
Start MySQL workbench after set up.
Go ahead and hit on finish.
And the MySQL workbench bench is going to start immediately, so it can be able to see that and then
continue in the as soon as possible.
Alright, so this is what we have right in here.
I'll go ahead and make sure everything is in order.
So we have this local instance MySQL.
If you go ahead you can go ahead and click on this.
If you click on this it's going to require you to input the password which is the root password.
But I'm going to close this.
I will show you how to be able to open up this in case if you have an issue in future ahead and delete
this connection, I'll go ahead and delete the connection.
They want to delete connection local instance.
Yes.
Now if you want to create your own connection from scratch, go ahead and go over to MySQL connections
and hit on this plus button right in here.
And you can go ahead and name this to be local hosts.
So I'll name that to local host and connection method is a tcp IP and the host name is equal to this.
Then the port I'm going to change this to port 2.13308 because there was a pot I put in when I was doing
the installation.
But you are on pot 3306.
I will ask you to remain there if that is what it imputes.
When we are doing the installation and that is the default.
So go ahead and maintain that and continue with this.
But if you change that previously or had an input that the pot which you entered and then go ahead and
hit on okay.
And we have Lucas right in here.
So go ahead and hit on this and it's going to come up.
So go back and put in your password and then go ahead.
You can set the password or go ahead and click on okay.
And that is going to open up the MySQL workbench for us.
So we have the MySQL workbench right in here.
And I hope that looks so beautiful and so awesome.
So I can go ahead and close some of these windows.
If I click on this this is off.
So this is where I clicked and that went off.
So you want to close the action output I'll go ahead and hit on this.
The action output is off.
And if I click on that it comes back.
So the sidebar which is this, I can go ahead and close that, and they can see that there's no sidebar.
All right.
You can do this without any sidebar.
So go ahead and click on that.
You can see that whenever it is on blue it's going to always show whatever I click on the sidebar.
There are actual outputs.
Or maybe this one right in the automatic context helps disable.
So I can always close this one because I don't actually need that.
Now, if I want to change the look and feel of this place, go over to edit and go over to preferences
and it's going to open up.
So go over to Font and Colors and I'm going to move over to defaults.
And I'll go ahead and hit on Windows 7 and click okay.
And you can see that look and feel is now very sweet.
I hope that is cool.
So now let's go over to the next video lecture and create a database using MySQL workbench.
Thank you.
And I'm going to see you in the next video lecture.