Hey, in this video, I'll show you how to install my SQL on Windows, Mac and Linux users.
Please watch the other videos.
So let's install my SQL on Windows.
My SQL technically comes as the MySQL community server, so you want to search on Google for that.
My my school community server.
And then the first result on my school dot com slash download slash MySQL should be the page where you
can download the MySQL community server software.
And this dropdown list.
You may want to select the Microsoft Windows Operating system.
And on the recommended download you'll see this big poster here.
So you might want to click somewhere in here or go to download page.
So that's the recommended download.
And here you'll find the installer.
So either choose the first one or the second one.
Basically the first one we'll install will download something else.
When you are installing the file.
But basically feel free to pick any of them.
Then in the next page you may be asked to log in or sign up for an account.
That's not necessary.
So you may want to just click on No thanks, just all my download and that should start to download
that file.
Then press on that file.
Prison?
Yes.
Again.
And my school will be installing in your computer.
Then this will show up.
I do suggest you to select on server only, which means you want to install the MySQL community server.
This developer default does have a lot of other tools which we don't need and which you can install
later if you want.
So server only is better to have.
It occupies less space on your computer.
So that is what we're installing and press on execute to download.
Once this is downloaded, the status here will go to download it and then you go to next and then execute
to install that.
So this installer is downloading and installing my SQL server.
Now it says complete.
So I'll go to next.
Next.
And you want to leave these settings as they are.
So you want to select on development computer.
Don't change these and press on next.
Here, you want to select the first option.
It's more secure and press on next.
Now, in this box, you want to specify the password of the root user.
You know, when I compared as your lite with my SQL, I mentioned that with my SQL, you can have multiple
database users.
So when you are installing MySQL, MySQL is creating a default user and the username will be root.
So like this root and here you want to specify the password for the root user.
I just suggested to use the same password as me, which is python course and repeat its python course.
So that will make sure that you are not forgetting this password.
Press on next.
Press on next, don't change these settings and then next again.
And you want to execute.
Then perhaps I'll finish.
Next and finish.
And we are done with the installation.
Now let's see if it works.
So you want to go to the search button and search for Windows PowerShell.
You can also use the command prompt, but I do suggest you to use the Windows PowerShell.
So press on Windows PowerShell.
And so my SQL, the server can be accessed through a command line.
That's how you can interact with your databases through a command line, but you can also access those
databases through Python, as you'll see in the next videos.
But through the command line, the way you access my SQL is by running, running my SQL minus OU root,
minus P.
I'll explain what this does, but first execute it with enter and you'll probably get this error.
The term my school is not recognized.
That's because my SQL has not been added to the system path.
So to do that you want to go to search again, search for environment variables, so added the system
environment variables and you want to go to this button environment variables, and then you want to
go to the system environment variables section.
You want to click on Path.
This environment variable, click on edit and then here you want to add a new environment variable.
So press on new.
And this now will be the path pointing to the my SQL installation To find the path in your system.
You want to go to the file system, to the Windows Explorer.
Go to the C Drive program files.
Search for my SQL.
So my SQL, my SQL Server 8.0 or 9.0 wherever you're using.
And then you want to click on bin, Enter inside bin.
And now this is the path we want to copy and paste in that environment variable window so you can select
on this address and select all the path.
Right click copy.
Alternatively, you can also right click over the bin folder and go to copy as path.
So either way is fine.
And then go to this window.
So, yeah, we want to add new.
And paste that path there.
Present oc oc again and OC in this window as well.
Close the Windows PowerShell.
Open it again.
So you need to restart it and then do my SQL minus OU root minus P.
Press enter.
You'll be asked to enter the password this time.
This is the password you created when you were installing my SQL.
So I entered Python course in my case.
That's the password for the user route.
So this command starts my SQL.
Now, if I press enter, my SQL will start.
So if you see this, that means you are inside the my SQL Server.
Now you can interact with the server.
And so this minus U was to specify the user.
So that's a flag.
It says the user is root and the password is whatever you enter here.
So then in here now in the command line, you can write SQL queries, for example, show data bases,
and then you want to enter a semicolon there to end the query, press enter, and that will show you
the databases that are available now in your my SQL Server.
And you can create more databases, but for a complete tutorial, you have to see the next lecture on
how to use MySQL.
So this was about how to install my SQL on Windows.
You can close this window and I'll see you in the next lectures.
Thanks.