How to install MySQL on Windows Server

(Last Updated On: 2019-10-14)

I recently found a piece of software that I am exploring to help me manage our current IT environment. To install this I require two applications setup. A PHP web server and a MySQL database.
Following below is an example of how to:
Install MySQL on a Windows 2019 Server.

Prerequisite

Before choosing a version of MySQL to use make sure that the software you are intending to use supports the current version. Alternatively, download the correct version. As an Example ITOP does not Support certain versions:

MySQL Software Requirements

Secondly, check the recommended hardware requirements. Again using ITOP as an example depending on what you intend to do there are minimum hardware requirements. My suggestion would be is to make sure you have this available over the current application running on the server:

MySQL Hardware Requirments

The Download link for MySQL is HERE

Installing

For the installation, we are going to use Version 8 as this will be used later to set up a New WordPress site.

On the Installation Start, there are the default License Agreements that has to be accepted.

MySQL License Agreement

Next, we choose custom as we don’t require all the features

MySQL Setup

Everything on the right will be install, you can choose:
MySQL Server
MySQL Workbench

MySQL Setup
MySQL Server
MySQL Workbench

Once done choose install and wait for the progress to complete

MySQL Setup

MySQL will then start configuring the Server

MySQL Setup

Choose Stand Alone we won’t be working with the advanced sections.

MySQL Setup

For the Type and Networking, you can leave as-is unless you have different security restrictions setup

MySQL Setup

When it comes to passwords I always recommend a Strong password.
Using something like LastPass to generate and Store Passwords

MySQL Setup
Password

Enter your incredibly hard password that nobody can ever guess.
Leave the Additional MySQL User Accounts blank as we will create the users in the Workbench.

MySQL Setup
Password

Leave the service page as default and go next

MySQL Setup

Once you execute the software will configure the system as per configs chose.

MySQL Setup

All configs will be confirmed once on the completion page.

MySQL Setup

If you liked what you read Please Share.

I’d love it if you followed me on Twitter and Facebook.

Also, feel free to subscribe to my posts by email. Thanks for reading.

Spread the love

Leave a Reply

Your email address will not be published. Required fields are marked *