What is MySQL Installer?
Without question, MySQL is one of the most widely used relational database systems. Every database industry makes significant use of the database management system MySQL. It is run by Oracle Corporation and offers multi-user access to support multiple storage engines.
Here, we’ll use MySQL Installer to set up MySQL on Windows. Before starting with MySQL Installer, you need to know what MySQL installer is.
The wizard in the MySQL Installer makes it simple to install MySQL. Several other features, including MySQL Server, MySQL Workbench, MySQL Shell, and others, will be installed after you have finished installing MySQL.
Preparing for the SQL interviews? Check out these SQL Server Interview Questions.
Prerequisites to Install MySQL on Windows
Before you start installing MySQL Server, you need to make sure your computer has essential requirements like enough space and memory. There are also some technical things like setting up your computer’s firewall, making sure your internet is working, and choosing the right MySQL version. Once you’ve done these things, installing MySQL on Windows becomes much easier, and your computer is all set to handle databases effectively.
Prerequisites:
The following requirements should be available in your system to work with MySQL:
- MySQL Setup Software
- Microsoft .NET Framework 4.5.2
- Microsoft Visual C++ Redistributable for Visual Studio 2019
- RAM 4 GB (6 GB recommended)
Installation of MySQL – MySQL Installer
Step 1: At first you need to go to the official website of MySQL(mysql.com) and scroll down. You will see an option to select Operating System.
You need to choose Microsoft Windows.
Step 2: Then you will see two options to download. You can select one of them or you can take a reference from the below image.
Master SQL concepts in depth from this SQL Tutorial now!
Step 3: Once you click on the download option, you will be redirected to the next page and you will have to click on the “No thanks, just start my download” option.
After that, you will see that MySQL Installer is getting downloaded.
Step 4: Once, MySQL Installer gets downloaded, you need to open that and you will see that the MySQL installer Community is getting installed.
Then you will see the following screen. Next, all you need to do is to click on the radio button which is asking for the acceptance of the license terms. After that, click on Next.
Step 5: In the next process, you have to choose the setup type.
This means that you have to choose which features you wish to install. So, choose the Full button and click on Next.
This process installs all of the products that are available in this catalog including MySQL Server, MySQL Shell, MySQL Router, MySQL Workbench, MySQL Connectors, documentation, samples and examples, and much more.
Step 6: In the next step, you will see that some of the features may fail to install due to a lack of requirements.
So, either you can fix them, or can skip them, by clicking on Next as it willn’t interrupt the installation process.
So, click on Next.
Next, you will see a dialog box asking for your confirmation of a few products not getting installed.
So, you can just click on Yes.
Next, you will see the list of the products which will get installed.
So you can go ahead and click on the Execute option, which we highlighted in the below image.
After clicking on the Execute option, you will see that the products are getting installed.
Once the installation process shows complete, click on Next.
Next, you have to configure the Server and Router. After that click on Next.
Preparing for job interviews? Have a look at our SQL Server interview questions and answers now!
Step 7: Based on your requirement, you can either choose the Standalone MySQL Server/ Classic MySQL Replication or the InnoDB Cluster.
We clicked on the Standalone MySQL Server/ Classic MySQL Replication option and then click on Next.
Reach out to our course advisors and enroll in Intellipaat’s MS SQL course.
Step 8: Once, you click on Next, you will get the Type and Networking page where you have to mention the Server Configuration Type.
We left it as it is and then click on Next, you can take reference from the below image.
Step 9: Now, you will get to the Authentication Method page where you have to choose the authentication mode.
Here, you can choose the first option as given in the below image, and click on Next.
Step 10: Next, you have to make the MySQL Root Password and then repeat the same password and then click on Next.
- Remember the password that you have mentioned or you can take note of that password for the future.
Step 11: After that, you will get the Windows Service page where you have to choose whether you want to start the MySQL Server at system startup or not. Here, we are keeping it as it is and has not changed anything.
Click on Next.
After clicking on Next, you will get the Apply Configuration page where you will get a list of the configurations that you want to execute to apply the changes from the list of these configurations.
So, if you agree with these configurations click on Execute.
After the execution is done, click on Finish. This will finish the configuration of the Server.
Step 12: On the next page you can choose to configure the Router.
So click on click on Finish.
Step 13: Once, you click on Finish, you will see the Connect to Server page.
Here you have to give the root password, which you set earlier.
Now, you have to check if the connection is successful, by clicking on the Check button.
Then after the configuration is completed, click on Next.
Step 14: After clicking on Next, you will get the Apply Configuration page, where you can choose the configurations that are applied and then click on Execute.
Step 15: In the next step, you will see the screen which is given below.
After the configurations are applied, click on Finish.
Here, you can check on the page that the installation procedure has been completed.
Step 16: After completing all of the above steps and procedures, you can finally check if MySQL has been installed or not.
Now you just have to open MySQL Shell and fill in your root password.
The above output shows that MySQL has been installed in your system.
Read on:- MySQL Constrains to enhance your knowledge!