Nisarg Upadhyay
Query editor window

How to install MySQL database server 8.0.19 on Windows 10

March 19, 2020 by

In this article, I am going to explain the step by step installation process of MySQL database server 8.0.19. MySQL is open-source, cross-platform relational database management server developed by Swedish company “MySQL AB” and later acquired by Oracle corporation. MySQL is offered as an open-source MySQL community server edition and enterprise server edition. In this article, I am going to install the MySQL Community server edition.

Download and install MySQL database server

You can download the MySQL community server from this location. Once the installer has been downloaded, double-click the setup file to start the installation process. On the Choosing a Setup Type page, you can see four installation options.

  1. Developer default: If you want to create a development machine, you can use this option. It installs the components which are required for application development, e.g., MySQL Server, MySQL Shell, MySQL connectors, MySQL
  2. Server Only: If you want to create a standalone database server with specific components, you can use this option
  3. Full: If you want to install MySQL Server with its all components, then you can use this option
  4. Custom: If your requirements are limited to the few components, you can use this option

We are going to install MySQL Server with all components; hence, choose “Full” and click on Next.

Choose the setup type for MySQL Database server

Before installation begins, the installer checks all the prerequisites that are required to install all the components of the MySQL database server. If any software prerequisites are missing, then you can see the details of failing requirements on the “Check Requirements” screen. It shows the name of the product, required component/software, and its status. As you can see, to install the MySQL database server for visual studio, we must install visual studio 2015 or above. Similarly, to install Python connector, we must install python on the work station. Click on Next.

Check requirement to install the MySQL Database server

An installer gives us a warning. We can continue our installation without installing the visual studio and python. Click on Yes.

Product requirements are not satisfied.

On the Installation screen, you can see the list of the MySQL products/software that are going to be installed on my workstation. Review the list and click on Execute.

Product list

The installer downloads all the products/software. After that, it installs all the products.

Downloading MySQL Database server and its components

Wait for a few mins. Once the installation process completes, we are ready to configure the MySQL database server and other components. Click on Next.

Download completed

On the Product configuration screen, you can see the list of the products that need to be configured. First, let us configure the MySQL Server. Click on Next.

Configure MySQL Database server

On the High availability screen, we can choose to install the InnoDB cluster or Standalone MySQL Server. InnoDB cluster is the High availability solution of MySQL. It uses group replication. I will explain more about it in my future series of articles. We are going to perform a standalone installation of MySQL Server hence choose “Standalone MySQL Server / Classic MySQL Replication”.

Choose High availability option

On Type and Networking screen, we can configure the following:

The type of MySQL configuration.

The type of MySQL configuration is a predefined set of configuration parameter that determines how much resources should be allocated to the MySQL Services. You have three configuration options:

  1. Development Computer: This configuration uses a minimal amount of the resources to MySQL Service
  2. Server Computer: This configuration uses a minimal amount of resources. This option is suitable when we are installing database servers and web servers on the same machine. The configuration allocates an average amount of resources to MySQL Service
  3. Dedicated Computer: This option is used when we have created a dedicated MySQL Server. The configuration allocates a high amount of resources to MySQL Service

We would configure the server with minimal resources hence select “Development computer” from the Config Type drop-down box.

Choose Database Server type

Network Connectivity

In this section, we can control how clients can connect to MySQL databases. We can use TCP/IP protocol or Named Pipe or Shared Memory. If you want to configure Named Pipe / Shared Memory, we must provide the Pipe Name and Memory Name. You can also specify the default port to connect to the database server. You can also choose to allow the port number specified in Port textbox in the firewall. See the following image:

Configure Network

In MySQL 8.0 version, we can use SHA256 based strong passwords. On the Authentication Method screen, choose the option to use the Legacy authentication method or Strong password for authentication. Note: If you are using Strong Password Encryption for Authentication, then make sure that all the connectors must be updated to the latest version. We are going to use Strong password Encryption for Authentication.

Enable Strong password encryption

On Accounts and Roles screen, you can specify the MySQL root account password. MySQL Root account is a default sysadmin account, and it must be disabled.

Specify root password and create a MySQL User account

You can also create other users to do that click on Add user. On MySQL User account dialog box, provide a username, hostname, Role of the User, type of authentication, and password. Once the user is created, click on Next. See the following image:

Add new user

On the Windows Service screen, you can configure the MySQL server to run as a windows service. You can provide the desired name and configure it to auto-start the service when the system reboots. Moreover, you can provide the credentials under which the MySQL Service will run. You can choose the standard system account or provide a specific user. See the following image:

Configure MySQL Database server as a windows service

On the Apply Configuration screen, you can see the list of confirmation steps. Once all the configuration settings are verified, click on Execute.

Apply configuration

The MySQL installation process starts. You can view the installation process in the “Log” tab. Once installation completes successfully, click on “Finish” to close the installer.

MySQL Database server is configured

Install the sample database

If you have chosen to install all the components of MySQL Server (Full Setup Type), MySQL installer moves to Sample and Example screen. On this screen, provide username and password of the user that has root/sysadmin privileges and click on Check. If the connection establishes successfully, click on next. See the following image:

Connect the server to install sample database

On the Apply Configuration Screen, click on Execute to start the installation of the Sample database. See the following:

Installing Sample database

Once the sample database has been installed, click on the Finish button.

Sample database has been installed

The installer continues to the Product Configuration screen. On this screen, you can see that the installation of the MySQL Server 8.0.19 and Sample and Example 8.0.19 has been completed successfully. See the following image:

Examples and sample database has been installed

Once the installation completes, you can copy the installation logs on the clipboard to review it later. Moreover, if you want to start exploring MySQL straight away, then you can select “Start MySQL workbench after Setup” and “Start MySQL Shell after Setup” and click on Finish. See the following image:

Finish the Community installer

Connect to MySQL Server

Once the installation completes, let us connect to the server and execute the first MySQL Query. Open MySQL workbench. Just like SQL Server management studio, MySQL workbench is the development tool which is used to querying the database and create database objects.

On MySQL workbench welcome screen, you can see the list of MySQL connections. We have not configured multiple connections; hence you can see “Local instance MySQL80.” Click on it to open the new query editor window.

Welcome screen of MySQL Workbench

When you click on the connection, you must enter the credentials to connect the database server. Enter the password and click on OK.

Login to MySQL Workbench

First, let’s create a simple database on MySQL Server. Write the following query in the query editor window and click on execute. See the following image:

Query editor window

Once the query executes successfully, you can see the new database in the “SCHEMAS” pan. See the following image:

Database has been created

Summary

In this article, we learned the step by step installation process of the MySQL Database server 8.0.19 on Windows 10. If you have any questions, feel free to ask in the comments section below.

Nisarg Upadhyay
Installation, setup and configuration, MySQL

About Nisarg Upadhyay

Nisarg Upadhyay is a SQL Server Database Administrator and Microsoft certified professional who has more than 8 years of experience with SQL Server administration and 2 years with Oracle 10g database administration. He has expertise in database design, performance tuning, backup and recovery, HA and DR setup, database migrations and upgrades. He has completed the B.Tech from Ganpat University. He can be reached on nisargupadhyay87@outlook.com

426 Views