Hi, folks.

Now let's try to see and understand how MySQL, which is a database that we will
use extensively, how we can use it to. We will be using MySQL going forward as a default
database because it's an open source and free database that we can install and use. So first,
before we install and use it, we got to download it. The easiest way to download it is to go to
the MySQL website. Just type in mysql or mysql.com. It'll take you to the home page. Once
you go to the home page, you just go to downloads here, right? So if you click on downloads
here, it'll take you to this page. It will take you to this page. This is the downloads page. In
the downloads page, there are some commercial versions of MySQL which are sold by
Oracle. So we don't want an enterprise or a commercial edition, we want a free edition. So
there is something called as a community edition. This is the edition that we will get it
because it's free of cost. Also open source which is under GPL license. So just go click on this.
Click on this community GPL downloads, right? So this will take you to the community
edition which is free of cost to download. So once you click on that, what you will get next is
this page, right? So here again, you have multiple options here. You can either download the
server, the MySQL cluster, or the router shell, whatever you want. We will go with the
default option, which is the MySQL community server. Because this gives you a server, it
gives you MySQL with all the stuff that we need as a developer to understand SQL and learn
it, right? So just click on this. Once you click on this, we'll go to this page. So we are on
downloads. Okay, so once we go to this downloads page, you'll get two options here for
MySQL community server. In the MySQL community server, once you click download mysql
community server. If you just come down, there are two versions for this. So, okay, before
we go there, it's better to use the MySQL installer for Windows. If you're using a Windows
laptop or desktop, just click to the, this will install both the 32 bit and the 64 bit, whatever
your computer is. So this is the easier version for you to play with, right? So just go click on
this, go to download page. Click on this go to download page. It will take you to the
download page. Here you have two options to download. You can either download the 16
MB version or the 318 MB version. I recommend you do the 313 MB version because this
gives you all the software in a single package. So if you download the 16 MB version, once
the installer starts, it'll keep downloading from the Internet. So it's best to first download
everything, especially if you have a slow Internet connection. You might want to download
this and you might want to start the download at night and then continue, right? So we
recommend that you use this. Right. We'll give you all the links here. So once you go there,
it'll take you here. It'll say begin your download. You want to log in? Sign up. If you don't
want to log in, just go and click on this. Just go and click on this. No thanks, just start my
download, right? This will give you the MySql download, and we'll give you all of these URL
links in the description section of this video so that you can directly go here and download it
without any worries, right? So once you click on this, it will take some time to download.
Based on your Internet connection, it might take you anywhere from two minutes to a few
hours because we have 313 MB of data to be downloaded. Right. Once you download, what
you will get in your download folder is this installer. This is mysql installer community 8.0
point. You might get a slightly different version. So what we are using here is a MySQL
community version installer. So at the time of recording of this video, we are at version 8.13.
That version might change, but that's okay, you can just continue with this. So now to install
mysql, just go and click on this, double click on it. It'll take a couple of seconds for the
installer to start running and okay, it'll say, do you want this app to make changes to your
device? Yes. Right, it'll start the community version of MySQL installer to start with. Okay?
Yes, simple. Okay, this is the installer coming up. Then you accept the terms here. As you see
here, you accept the license terms and then you say there are multiple versions here. What
we will go for is the default developer version, which is the easiest thing for us to learn.
Mysql. Continue here. Just ignore this. Don't worry about this. This connector with Python is
not mandatory, so we'll just continue. Next it'll say, not been satisfied. Do you want to
continue? Just press yes, no problem. These are all the stuff that will get installed. You'll
have a Microsoft, sorry. You'll get a mySql server. You'll get some workbench, some visual
studio. All these are stuff that you'll get with examples and samples, everything. Just click on
execute. So once you click on execute, it will take some time to install. Right. So for example,
the MySQL server is being installed here. Each of these need to get installed and that could
take a few minutes. So just be patient here and I'll pause this video and I'll restart again
when all of them are completed. When the installation of all of these pieces of software is
completed. Okay, now if you notice, the status of all of these packages is complete. Right? So
we waited for a few minutes for all of them to be completed. Now since all of them are
completed, let's go to the next step here, right. So I'll just click next again. Click next. So here
I can again do a cluster setup or a simple setup. We'll just go with a standalone server type
of setup. So let's just go continue with that. Okay. Some basic stuff. What is the TCP port? All
of that stuff. We don't have to worry about it right now. Just continue with whatever is the
default here. Okay, so again we will have to set up an admin password for oursql server.
Sorry. For our mySql database. So we'll just continue with this. Okay. Use a strong password.
Continue here. So here it asks for a root password. A root password is nothing, but it's an
admin password. Right? So whatever password you give here, please don't forget it. If you
forget it, you can't use your MySQl instance or MySQl database. So root in most Linux or
Unix systems means the admin or the most powerful user. Right? So give a password of your
choice, whatever password you want. So it says password is weak. I've just given a very
simple password, but it's okay. You can give a weak or a strong password. It's always
suggested that you give a hard or a strong password. Okay, so now let's continue. Okay,
everything is there. This is the mysql. Blah blah blah. Just keep pressing. Next. Okay, just say
execute. Okay, it'll write all of these. It's basically coming up and running some of these or
executing some of these steps. Setting up the configuration files, initializing the databases,
starting the server, all of those stuff. We don't have to worry. It'll take care of itself.
Installing this on Windows is extremely easy and so is the installation in Linux or Mac if you
have those boxes, right? So we'll just say finish. Right? So again, just click next. Finish next.
Okay. I don't have to worry about it. Okay, let me just give the admin password that I gave a
while back. Check this. Okay, so this is basically checking if the connection to my mysql
server is working or not. The password that I entered here, the username is root. The
password is the root password that I set up a while ago. I'll just say check and then I'll keep
going. Execute. It's just doing some configuration scripts, running some scripts, et cetera.
That's it. We're almost close to being done. Okay, that's it. Okay. Product, configuration,
finish, installation is done. So as soon as you finish, you get your mysql prompt here, right?
This is some workbench. We don't have to worry. Let's just close all of them. Okay. Because
we have installed now to start your MySql, you go here, right? You just say mysql. You get
something called as Mysql 8.0 command line client. This is the command line client that we
will use. This is like a terminal. So when I click on this right, it says what is your password
here? I need to enter my root password. I just enter, that's it. Once I do that, I get my MySql
command prompt. So everything that I do here is going to be a MySql command, right? We
will see when we learn lot of SQl queries going forward in this chapter, we will keep seeing
this command prompt, right. Whatever SQl commands you want to type and execute will be
written here and executed here. That's it. This is a simple check that everything is working.
So all the commands, everything we run will be in the mysql command line client. Extremely
simple, right? Installing mysql on Windows is literally trivial. It's also fairly easy in Linux or
Mac. It's very similar to what we've done here in Windows. Right? Okay, so next, since we
have seen how to install mysql in this video, in next video we'll see how to load our
database, the IMDb database that we want to use.