“The world’s most popular open source database” MySQL Community Server
MySQL has significantly improved the front side of its product by providing user-friendly interfaces for easy control and administration. This is clearly demonstrated in Workbench CD 5.238 which is included in MySQL Community Edition, a free downloadable version. In this tutorial, we are going to cover the basic installation of MySQL on Windows platform.
If you find this tutorial helpful or if you have enquiries, please write in the comment section.
1. Download the MySQL Community Server from the link above.
2. Double click on the mysql-installer-126.96.36.199.msi Windows Installer Package.
3. You will see the first Welcome screen. Click on Install MySQL Products:
4. Accept License Agreement and click on Next:
5. If you have access to the internet, then click on Execute to check if there are newer versions of the products:
6. Choose the type of the setup. I am selecting Full as I want all features to be included:
7. Requirements is checked and in this case, Microsoft Visual C++ runtime is missing. Click Execute to download the missing requirement:
8. Accept the License Terms and click on Install:
9. A final requirement check. Click on Next to proceed:
10. List of products to be installed is displayed. Click on Execute to proceed:
11. Progress Summary is displayed:
12. When all products are installed successfully, click on Next:
13. Products which require configuration is displayed. Click Next to proceed:
14. Choose the type of the configuration which you require for the MySQL server. Read the description for each type to learn about the differences. I am choosing Developer Machine since I am going to use it with other products and I want the minimal memory. Click Next to proceed:
15. Default Network and Security settings are displayed. Enter root account password and click Next to continue:
16. Confirm the configuration overview and click Next:
17. Products are going to be installed and a completion message is displayed in the end. Click on Start MySQL Workbench to start working with MySQL. Click Finish:
18. MySQL Workbench will start. As this is the first time, click on New Connection to create a connection to the database so that we can query:
19. Type in the connection name: MydbConnection and click on OK:
20. You will be prompted with root account password. Enter and click OK:
21. Now you can see your database objects on the left side and you can write your SQL query in the middle box.