To teach yourself how to write MySQL queries, check out MySQL Tutorial section.

Step #1: Download MySQL 8.0.1 for Windows

MySQL Community Edition is a freely downloadable version of the world's most popular database server. For latest version, visit MySQL download page and use the recommended download.

The version I downloaded was MSI Installer for Windows (x86, 32-bit), 8.0.15, 16.4M

Filename:
mysql-installer-web-community-8.0.15.0.msi

Step #2: Check MD5 checksum of the downloaded file before installing

This step is to make sure the downloaded file has not been tampered by anything such as virus, I used HashCalc to do the verification.

Below is the MD5 value showing on MySQL downloaded page.

Below is the MD5 calculated by HashCalc which matched with the MD5 checksum shown on MySQL download page.

Step #3: Install MySQL

Double click the MSI installer to start installing MySQL. You will go through a setup wizard so it's fairly simple. Just follow the installation instructions step by step below.

3.1 The first thing popped up is an optional installer upgrade, always click Yes to apply the upgrade to avoid getting the "Invalid server template" error later.

This step is crucial even though it's optional because, if you click No, it always causes error "Invalid server template" later in the installation process when it comes to configure MySQL. This may be caused by a bug in the installer.

The actual error message is:

3.2 Tick the box on the license agreement and click Next to continue

3.3 Choose a Setup Type - Developer Default, Server only, Client only, Full, Custom

Select the type that best suits your need. In this article, I selected 'Server only'.

3.4 Address any path conflict warning for the installation folder

If you have installed MySQL before, the installer may suggest you some path conflict, you may want to keep it or change it. If you want a clean installation, delete the existing folders to avoid any confusion.

The Install Directory is where MySQL is going to be installed.

The Data Directory is where data for your databases and tables are stored. It's always a good practice to store data in a different folder or drive that can be easily backed up. If you can't see the path in conflict suggested by the installer in Windows Explorer, that is because the folder is a system folder and was made hidden by Windows.

3.5 Download components

MySQL Server 8.0.15 is ready to be downloaded.

3.7 Group Replication

Choose Standard MySQL Server / Classic MySQL Replication, click Next to continue.

3.8 Networking

Accept the default values and continue to next.

3.9 Authentication

Accept the default values and continue to next.

3.10 Accounts and Roles

Create Root account password. You can skip the User Accounts at this stage if you want.

3.11 Windows service configuration

Accept the default values and continue.

3.12 Apply configuration

Error you might come across

Some people experience "Invalid server template" error at this configuration step. If this happens to you, make sure you have clicked Yes in step 3.1 above. (Note that if you can't resolve this error, you may consider downloading an older MySQL version, here is the download page of all archived MySQL versions)

The MySQL configuration file is my.ini file. For some reason, the installer can't seem to create this file.

Here is what you see in the configuration log.

Happy Installing!


Copyright© GeeksEngine.com