Install MySQL on Windows

Share This:

If you like my work show support on my Patreon
Yes MySQL is extremely easy to install on Windows as well. It may not be quite as easy as it was to install >Apache. But it still is easy. First you go to the MySQL downloads page. Then you pick the MySQL server version you want. For example 32-bit or 64-bit. Once you have picked it. You will be directed to the mirror site.

The mirror site is list of different servers around the world that you download MySQL from. It is prefered most of the times to try and pick a server that is closest to you. This way it will download faster. However in some cases depending on how big a file is that I’m downloading I will pick a server that is further away from me, if I feel that it has less traffic going to it. So it really is up to you.

Once the MySQL installer has been downloaded. You will get your usual installation wizard. Just follow the instructions and MySQL will install.

After the installation the installer will ask you if you want to run the configuration program. I usually choose to run it. Once you choose to run it you will be asked several questions.

Here the configuration wizard is simply telling us that it is ready to run. So we will click the Next button.

Now we are asked what type of configuration we will want to do. I chose Detailed Configuration. So tick the radio button next to Detailed Configuration and click Next.

Now we are being asked what type of SQL Database we are setting up. Since I’m using MySQL for my WAMP Server I will tick the option that says Server Machine. Then I will click Next.

Now we choose the MySQL server instance. I usually just leave the default setting for this. In this case the default setting is Multifunctional Database. Now we will click Next.

Now we choose where we want our Data Bases to be stored on our server. I usually choose Installation Path for this one. Then we will click Next.

Now we need to think about how many connections to the database we will be expecting to have. I usually choose the Online Transaction Processing (OLTP) option. Then we will click Next.

If you remember earlier when we installed MySQL on Linux. We needed to manually open port 3306. By accessing the Firewall. Well we need to do the same here. However the MySQL configuration wizard does that for us. Simply make sure that you tick the Enable TCP/IP Networking option. And the Port Number 3306. You will also want to tick the option that says Add firewall exception for this port. You may also want to tick the Enable Strict Mode option.

After that we will click Next.

Now we will need to decide what type of keyboard people will most likely use for the Database. If your located in the US, and you expect most of the users to be located in the US and also expect them to use a QWERTY keyboard then the option that says Standard Character Set will be just fine. So then we will click the Next button.

Now we choose weather we want to make it a command line based service or a GUI based Service. GUI takes up more resources. So our server may be kind of sluggish. However it is also the easier option. So we will select it by ticking the option that says Install As Windows Service. Then we will click the Next button.

We will need to setup a Root password for the MySQL server. This way if anything goes wrong on any of our databases we can just use our root password. Choose a strong one. And renenter it. Make sure that Enable Root access from remote machines is not checked before continuing. Also make sure that Created Anonymous Account is not checked. Then click the Next button.

This part always seems to confuse people. The dots on this window are not radio buttons. You can not select any of these. In fact on this page the only thing you can do is click the Execute button.   Once we click the Execute button we should be all set.

If you like my work show support on my Patreon