Installation Guide for MySQL on Windows
YouTube Playlist for installation of MySQL: Link
Step 1: Download the MySQL installer from the given link :Download MySQL Installer . There are
two download options. One is a web community version(2.3M) which will download only the
server and you can add the other applications you want to install on it. The Second one is a
Community version(470.2M) which is a full installer and will download the server along with all
the recommended applications.
You have to install the community version (470.2M) of My SQL.
Step 2: Click on the download button and it will pop up a page asking to login or signup. but you
skip this part by scrolling down to the bottom and clicking No thanks, just start my download.
After clicking on this, your download will start which will take around 1 min.
Step 3: Run the installer that you have downloaded from its location on your server by right clicking
and open or by double clicking.
Step 4: The MySQL installer screen will open and you have to determine the MySQL installation type
in the Choosing a setup Type section.
There are 4 options given:
Server Only: if you only need MySQL Server installed for use with a CMS or other application and
will not be managing the database directly, you can install just the server
Client Only: It will install only the client products of MySQL and will not install the server for
running that.
Full: It will install all the products and features of MySQL.
Custom: this setup type will allow you to customize every part of the installation from the server
version to whichever additional tools you select.
You need to Choose Custom to install MySQL server and other MySQL tools related to MySQL
development, helpful tools like MySQL Workbench.
Step 5: After you click on Next, A download page will open which consists of all the applications
that need to be installed on the MySQL Server. Click on the execute button to start the download.
The download will take some time and you can see the progress of the downloads on the same tab.
Step 6: After all the applications get installed, click on the next button which will appear in place of
execute after successful installation. Now, a new tab will open which contains other applications, Click
on the execute button.
Step 7: After all the products are installed, click on the next button. The product configuration page
will open. Click on the next button.
Step 8: Once the products are downloaded, we have to click the next button. After clicking next, the
status gets converted to ready to install and then click the execute button.
Step 9: After clicking execute the status will be converted to ready to configure and then we have to
click the next button to configure.
Step 10: Now, Keep Clicking on the next button for the given pages until the Accounts and Role Page
appear.
Step 11: In the Accounts and Role ,you need to set up a password for your SQL. Set up the Password.
After setting up the password, Click on the next button.
Step 12: Click on the next button for the Windows Service page. In the Windows service page
click next for the Server File Permissions page.
Step 13: On the Server File Permission page, Click on the next button.After you click next, it
will go to the apply configuration page.
Step 14: Once you click execute in the Apply Configuration page, all the boxes in the configuration
steps will get green tick and then click finish.
Step 15: After clicking finish, Product Configuration page opens, Click next in that page and then
Installation Complete page opens up. Check the Workbench and Shell boxes are ticked and then click
finish.
Step 16: Once you click the Finish button you will be automatically directed to MySQL Shell and
MySQL Workbench where you will have to enter the password that you have set and the Workbench
will start working.
You have successfully installed MySQL on your device.
To use MySQL Shell:
Search ‘MySQL Shell’ on your system and click on Open.
To use MySQL Workbench:
Search ‘MySQL Workbench’ on your system and click on Open
