Activity 1
Aim - Installing MySQL on windows
Learning outcome: Able to install MySQL.
Duration: 1 hour
List of Hardware/Software requirements:
1. Laptop/Computer with windows OS
Procedure-
Step 1: Go to the official website of MySQL and download the community server edition
software. Here, you will see the option to
choose the Operating System, such as
Windows.
Step 2: Next, there are two options available
to download the setup. Choose the version
number for the MySQL community server,
which you want. If you have good internet
connectivity, then choose the mysql-installer-
web-community. Otherwise, choose the other
one.
Installing MySQL on Windows
Step 1: After downloading the setup,
unzip it anywhere and double click the
MSI installer .exe file. It will give the
following screen:
Step 2: In the next wizard, choose
the Setup Type. There are several types available, and you need to choose the
appropriate option to install MySQL product and features. Here, we are going to select
the Full option and click on the Next button.
This option will install the following things: MySQL Server, MySQL Shell, MySQL
Router, MySQL Workbench,
MySQL Connectors,
documentation, samples and
examples, and many more.
Step 3: Once we click on the Next
button, it may give information
about some features that may fail
to install on your system due to a
lack of requirements. We can
resolve them by clicking on
the Execute button that will
install all requirements
automatically or can skip them.
Now, click on the Next button.
Step 4: In the next wizard, we will see a
dialog box that asks for our confirmation of
a few products not getting installed. Here,
we have to click on the Yes button.
After clicking on the Yes button, we will see
the list of the products which are going to
be installed. So, if we need all products,
click on the Execute button.
Step 5: Once we click on the Execute button, it will download and install all the
products. After completing the installation, click on the Next button.
Step 6: In the next wizard, we need to configure the MySQL Server and Router. Here, I
am not going to configure the Router because there is no need to use it with MySQL.
We are going to show you how to configure the server only. Now, click on the Next
button.
Step 7: As soon as you will click on the Next button, you can see the screen below.
Here, we have to configure the MySQL Server. Now, choose the Standalone MySQL
Server/Classic MySQL Replication option and click on Next. Here, you can also choose
the InnoDB Cluster based on your needs.
Step 8: In the next screen, the system will ask you to choose the Config Type and other
connectivity options. Here, we are going to select the Config Type as 'Development
Machine' and Connectivity as TCP/IP, and Port Number is 3306, then click on Next.
Step 9: Now, select the Authentication Method and click on Next. Here, I am going to
select the first option.
Step 10: The next screen will ask you to mention the MySQL Root Password. After filling
the password details, click on the Next button.
Step 11: The next screen will ask you to configure the Windows Service to start the
server. Keep the default setup and click on the Next button.
Step 12: In the next wizard, the system will ask you to apply the Server Configuration. If
you agree with this configuration, click on the Execute button.
Step 13: Once the configuration has completed, you will get the screen below. Now,
click on the Finish button to continue.
Step 14: In the next screen, you can see that the Product Configuration is completed.
Keep the default setting and click on the Next-> Finish button to complete the MySQL
package installation.
Step 15: In the next wizard, we can choose to configure the Router. So click on Next-
>Finish and then click the Next button.
Step 16: In the next wizard, we will see the Connect to Server option. Here, we have to
mention the root password, which we had set in the previous steps.
In this screen, it is also required to check about the connection is successful or not by
clicking on the Check button. If the connection is successful, click on the Execute button.
Now, the configuration is complete, click on Next.
Step 17: In the next wizard, select the applied configurations and click on the Execute
button.
Step 18: After completing the
above step, we will get the following
screen. Here, click on the Finish
button.
Step 19: Now, the MySQL
installation is complete. Click on the
Finish button.
