Difference between revisions of "Install wiki on win server"

From MPSWiki
Jump to: navigation, search
Line 23: Line 23:
 
''and then update mysql:''
 
''and then update mysql:''
 
# login in mysql: mysql -uroot -ppassword
 
# login in mysql: mysql -uroot -ppassword
−
# ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'prosuite';
+
# ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
  
  

Revision as of 10:50, 27 February 2019

install:

  1. python need 2.7.xx 32bit version (python-2.7.12.msi)
  2. php from archive (latest php (64bit threads safe) (php-7.3.2-Win32-VC15-x64.zip))
  3. latest mysql (mysql-installer-community-8.0.11.0.msi)
  4. mediawiki from archive


Setup MySQL:

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
Retrieved from "https://mps.resnet.com/MPSWiki/index.php?title=Install_wiki_on_win_server&oldid=291"