MySQL Server Installation on Windows

This post will describe how to install the latest version of MySQL Server on Windows platform.

Download:

1. Go to https://dev.mysql.com/downloads/mysql/

2. Click Go to Download Page in MySQL Installer for Windows (Recommended Download part)
    You will be taken to https://dev.mysql.com/downloads/windows/installer/8.0.html

3. Download the second file mysql-installer-community-8.0.19.0.msi 

Installation:

MySQL provides a single installer for windows with multiple set up options.

1. Double-click the msi installer file.

2. After installation of MySQL Installer - Community, a pop-up shows up as below:

3. Choose Server only set up type. We are going to work with mysql terminal window. Click Next.

4. Click Execute

5. Once the status is complete, click Next

6. Click Next to get inside Product configuration

7. Choose Standalone MySQL Server and click Next

8. Make sure the Config Type is Development Computer and see to that the port numbers are free from use. Click Next

9. Choose Use Strong Password Encryption for Authentication and Click Next

10. Provide a password for the root account. (I have provided root, that is why it shows weak). Click Next.

11. Let the Default stay. Click Next

12. Click Execute

13. Click Finish once all steps are done.

14. The product configuration is over and we are back to the parent window. Click Next

15. The installation is now complete. Click Finish to exit the installer.

Once the installer is closed, you have to start MySQL server.

Starting MySQL Server:

1. Search for MySQL 8.0 Command Line Client and run the same.

2. It will ask for the password of the root account. Provide it. Your window will look as below:

You are now ready to create and work with database. Remember, you are the root user!