MySQL is one of the popular open-source relational database management systems (RDBMS) available today. A relational database management system is simply a software application that you can use to create and manage various databases. Other Popular examples of RDBMS are MS SQL Server, Oracle Database, Maria DB, PostgreSQL, Sybase, IBM DB2, etc. Some of these databases are proprietary systems and are out of the scope of this write-up.
In this blog post, we shall only focus on MySQL database server 5.7. You will learn how to install the database on your Windows personal computer (laptop and desktop). I will show you a pictorial representation of the installation steps. If you like, you can call it, “MySQL Database Server 5.7 Installation Manual or Setup Instructions”.
How to Download MySQL 5.7
To complete the installation successfully, there are two things we need to do. We need to download MySQL – an RDBMS and set up the MySQL database server. Here are the steps to download MySQL:
1. On the web browser of your computer, type: “MySQL Community Server” and hit the enter button. This will open a new web page as shown in step 2 below.
2. Click the first link as indicated below. Alternatively, you can visit dev.mysql.com on your web browser to access the same web page.
General Availability (GA) Releases
The current general availability (GA) Releases will be displayed. As at the time of this write-up, MySQL Community Server 8.0.18 is the latest version. It is recommended for intermediate to advanced database users. We recommend MySQL Community Server 5.7.28 for beginners. So, we will install that version instead.
3. To download MySQL Community Server 5.7.28, click the “Looking for previous GA versions?” above the MySQL Icon. See the picture below.
4. Click on “Go to Download Page >” button.
5. Select the Windows MSI Installer to download and click Download. You may choose to download from “Windows (x86, 64-bit), ZIP Archive option if you want.
6. When prompted to log in using your oracle web account or sign for an oracle web account, scroll down and click “No thanks, just start my download” link. The MySQL installer will begin to download automatically.
7. Click on the installation file to start the installation process.
8. Select “Yes” under Windows user account control prompts
9. Choose “Yes” for Installer updates. This will download the installer updates
10. Select the Setup type that suits your use. You can select Developer Default if want to install a whole bunch of stuff. There are other options like Server only, Client only, Full, and Custom.
11. Choose the Custom option because it allows you to manually select which products you would to install on the system.
12. Click Next to continue.
13. Select the products and features you would like to install on your system by expanding the Available Products using the + sign. Just tap the + sign against MySQL Server to expand it.
14. Then, tap the + sign against MySQL Server 5.7 to expand it.
15. From the drop-down, select MySQL Server 5.7.28 – X64 for a 64-bit system and tap the green forward arrow to move it to Products/Features To Be Installed window.
16. Repeat step 15 above to select MySQL Shell 1.0.11 – X64. These two products are what you need to be able to run a database application successfully.
17. Click Next followed by Execute to start the download.
18. Tap Next when the download is complete and select Next again to allow the wizard to configure the product.
19. For High Availability, select Standalone MySQL Server/Classic Replication and then, click Next to continue.
20. Accept default values under Type and Networking by clicking Next.
21. Set the Database Root Account Password. Note that there’s a default admin user – “root”. Don’t forget to store the password in a secure place. You will need it to connect to your database later on. If you lose the password, you’ll not be able to access your newly setup database engine.
22. Then, click Next multiple times to apply the configuration.
Click Finish and select Next. Congratulations! Your Database Server 5.7 is successfully installed.
You can start your newly installed MySQL database server 5.7 by clicking on your Windows start button and selecting MySQL 5.7 Command Line Client. When prompted, enter the root password you set earlier on to connect to the database server. As soon as you connect to the database server, you can begin to create databases.