Install wiki on win server

Prepare

Python

1. Install Python

PHP

1. Download PHP archive
   1. Extract all files from archive to C:\PHP\
   2. 
   3. Click Add Module Mapping
   4. 
   5. Add default document:

MYSQL

1. Install MYSQL
   1. Select Custom
   2. Install Server
   3. Install WorkBench
   4. Install MYSQL shell

Media WIKI

1. mediawiki from archive

Setup MySQL

1. install with legacy password
2. remove .NET connector

create: mysql -uroot -ppassword CREATE DATABASE fieldprowiki;

backup: mysqldump.exe -uroot -ppassword fieldprowiki > e:\fieldprowiki.sql

restore: mysql -uroot -ppassword fieldprowiki < e:\fieldprowiki.sql

if 'caching_sha2_password' error - then:

1. C:\ProgramData\MySQL\MySQL Server 8.0\my.ini - update 'caching_sha2_password' to 'mysql_native_password'

and then update mysql:

1. login in mysql: mysql -uroot -ppassword
2. ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';

Setup IIS:

1. add application pool (with 32bit)
2. add default document: index.php
3. FastCGI Settings: add application: C:\php\php=cgi.exe