MYSQL Installation Guide
1. Open the MySQL website on a browser. Click on the following
link: https://www.mysql.com/downloads/
2. Select the Downloads option.
3. Select MySQL Installer for Windows.
4. Choose the desired installer and click on download.
5. After the download, open the installer.
6. It will ask for permission; when it does, click Yes. The installer will then open.
Now, it will ask to choose the setup type. Here, select Custom.
7. Click on Next. With this, you will install MySQL server, MySQL Workbench,
and MySQL shell.
8. Open MySQL Servers, select the server you want to install, and move it to
the Products/Features to be installed window section. Now, expand
Applications, choose MySQL Workbench and MySQL shell. Move both of them
to ‘Products/Features to be installed’.
9. Click on the Next button. Now, click on the Execute button to download and
install the MySQL server, MySQL Workbench, and the MySQL shell.
10. Once the product is ready to configure, click on Next. Under Type and
Networking, go with the default settings and select Next.
11. For authentication, use the recommended strong password encryption.
12. Set your MySQL Root password and click on next.
13. Go for the default windows service settings and under apply configuration,
click on execute. Once the configuration is complete, click on finish.
14. Complete the installation. This will now launch the MySQL Workbench and
the MySQL Shell.
Once MySQL Workbench is installed, select the Local instance and enter the
password.
Now, you can use the MySQL query tab to write your SQL queries.
Follow in details;
https://www.youtube.com/watch?v=YSOY_NyOg40&t=481s