Download Installing MySQL: A Step-by-Step Guide for Beginners and more Lecture notes Computer Science in PDF only on Docsity!
Experiment 2: Installation of MYSQL
MySQL is one of the most popular relational database management software that is widely used in today's industry. It provides multi-user access support with various storage engines. It is backed by Oracle Company. In this section, we are going to learn how we can download and install MySQL for beginners. Prerequisites The following requirements should be available in the system to work with MySQL : MySQL Setup Software o Microsoft .NET Framework 4.5. o Microsoft Visual C++ Redistributable for Visual Studio 2019 o RAM 4 GB (6 GB recommended) 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. o
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: o 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.
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 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 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.
