Installing WordPress on Windows: Part1

Installing WordPress on Windows: Part2

Installing WordPress on Windows: Part3

Installing WordPress on Windows: Part4

 

I think that is necessary to write, how to install WordPress on Windows, using IIS. In fact, that is not so easy task to do it in the right way. We have to take care of security, performance and stability.

 

If we want to install WordPress on Windows, we need MySQL Community Server, PHP for Windows and IIS installation and configuration. WordPress can be installed on Windows 10/11 or any version of Windows Server. In our case, we will install WordPress on Windows Server 2022.

 

In the first part we will cover MySQL Community Server installation and configuration.

 

On a fresh Windows Server 2022 installation, we download the latest MySQL Installer MSI (8.0.27) from Official Oracle Web page (mysql-installer-community-8.0.27.1.msi).

Now, we need to run MySQL Installer MSI.

 

On the Choosing a Setup Type screen, we select the Custom option.

 

MySQL WordPress 1

 

On the Select Products screen, we select  MySQL Server 8.0.27 – X64, MySQL Workbench 8.0.27 – X64 and MySQL Documentation 8.0.27 – X86.

 

MySQL WordPress 2

 

On the Check Requirements screen, we have to install Microsoft Visual C++ 2015-2019 Redistributable (x64). We can do it by selecting Execute button below.

 

MySQL WordPress 3

 

We have to agree to the license terms and conditions.

 

MySQL WordPress 4

 

After, that we can see the confirmation, that requirements are fulfilled.

 

MySQL WordPress 5

 

On the Installation screen, we are ready to install selected products by selecting the Execute button below.

 

MySQL-WordPress 6

 

We can see that Products are installed successfully.

 

MySQL WordPress 7

 

On the Product Configuration screen, we are ready to configure MySQL Server.

 

MySQL WordPress 8

 

On the Type and Networking screen, we choose the appropriate Config Type option. For the production use, we choose Server Computer.

 

MySQL WordPress 9

 

On the Authentication Method screen, we choose the recommended Use Strong Password Encryption for Authentication option.

 

MySQL WordPress 10

 

On the Accounts and Roles screen, we enter the strong MySQL Root Password.

 

MySQL WordPress 11

 

On the Windows Service screen, we can use the default options. If we want, we can edit the Windows Service Name.

 

MySQL WordPress 12

 

On the Apply Configuration screen, we are ready to apply the selected configuration settings by selecting the Execute button below.

 

MySQL WordPress 13

 

We can see that everything is configured successfully.

 

MySQL WordPress 14

 

On the Installation Complete screen we see, that the MySQL installation and configuration has been completed.

 

MySQL WordPress 15

 

We need an empty database which is needed for WordPress.

We can create it by using MySQL Workbench, but we can do it easier by using the installed MySQL 8.0 Command Line Client. After we start it, we have to enter our MySQL Root password.

 

MySQL WordPress 16

 

Firstly, we have to create an empty database, named wordpress:

create database wordpress;

Then, we have to use the created database wordpress:

use wordpress;

We create the user, named wpadmin with wpadmin_password (the wpadmin password should be different, then the password for the root user).

create user ‘wpadmin’@’%’ identified by ‘wpadmin_password’;

wpadmin user must have all rights on the wordpress database:

grant all on wordpress.* to ‘wpadmin’@’%’;

 

MySQL WordPress 17

 

We have successfully created an empty database, named wordpress and the user wpadmin that will be used for the WordPress.

 

Next, we have to install and configure PHP.

 

Written by Simon Abolnar
I am a lecturer of Informatics subjects at Higher Vocational College at the School Center Nova Gorica, located in Slovenia-EU. I have been a System Administrator of Microsoft Servers at SCNG for over 20 years.