Difference between revisions of "Install wiki on win server"
| (28 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
| − | + | =Prepare= | |
| − | # | + | ==Python== |
| − | # | + | #Install [https://drive.google.com/u/0/uc?id=1tHvZMHZxkApbz0WQP1ALtZS_IxHXn_u0&export=download Python] |
| − | # | + | ==PHP== |
| + | #[https://drive.google.com/u/0/uc?export=download&confirm=Zt0E&id=12bQS-caoryip0wIn78IMoAV4AiNo4O-6 Download PHP archive] | ||
| + | ##Extract all files from archive to C:\PHP\ | ||
| + | ##[[File:Php-mapping.png]] | ||
| + | ##Click '''Add Module Mapping''' | ||
| + | ##[[File:Php-edit-mapping.png]] | ||
| + | ##Add default document: [[File:Php-default.png]] | ||
| + | ==MYSQL== | ||
| + | #[https://drive.google.com/u/0/uc?id=1ByVELx1RIdFGKO3DYPwP_DoK2bNZBdlH&export=download Install MYSQL] | ||
| + | ##Select Custom | ||
| + | ##Install Server | ||
| + | ##Install WorkBench | ||
| + | ##Install MYSQL shell | ||
| − | create: | + | ==Media WIKI== |
| − | mysql -uroot - | + | # mediawiki from archive |
| + | |||
| + | =Setup MySQL= | ||
| + | |||
| + | # install with legacy password | ||
| + | # remove .NET connector | ||
| + | |||
| + | |||
| + | ''create:'' | ||
| + | mysql -uroot -ppassword | ||
CREATE DATABASE fieldprowiki; | CREATE DATABASE fieldprowiki; | ||
| − | backup: | + | ''backup:'' |
| − | mysqldump.exe -uroot - | + | mysqldump.exe -uroot -ppassword fieldprowiki > e:\fieldprowiki.sql |
| − | restore: | + | ''restore:'' |
| − | mysql -uroot - | + | mysql -uroot -ppassword fieldprowiki < e:\fieldprowiki.sql |
| − | if 'caching_sha2_password' error - then: | + | ''if 'caching_sha2_password' error - then:'' |
# C:\ProgramData\MySQL\MySQL Server 8.0\my.ini - update 'caching_sha2_password' to 'mysql_native_password' | # C:\ProgramData\MySQL\MySQL Server 8.0\my.ini - update 'caching_sha2_password' to 'mysql_native_password' | ||
| − | and then login in mysql: | + | ''and then update mysql:'' |
| − | + | # login in mysql: mysql -uroot -ppassword | |
| − | # ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY ' | + | # ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'; |
| + | |||
| + | |||
| + | '''Setup IIS:''' | ||
| + | # add application pool (with 32bit) | ||
| + | # add default document: index.php | ||
| + | # FastCGI Settings: add application: C:\php\php=cgi.exe | ||
Latest revision as of 10:19, 10 January 2021
Prepare
Python
- Install Python
PHP
- Download PHP archive
- Extract all files from archive to C:\PHP\
- Click Add Module Mapping
- Add default document:
MYSQL
- Install MYSQL
- Select Custom
- Install Server
- Install WorkBench
- Install MYSQL shell
Media WIKI
- mediawiki from archive
Setup MySQL
- install with legacy password
- 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:
- C:\ProgramData\MySQL\MySQL Server 8.0\my.ini - update 'caching_sha2_password' to 'mysql_native_password'
and then update mysql:
- login in mysql: mysql -uroot -ppassword
- ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
Setup IIS:
- add application pool (with 32bit)
- add default document: index.php
- FastCGI Settings: add application: C:\php\php=cgi.exe
