Install wiki on win server

From MPSWiki
Revision as of 10:39, 27 February 2019 by 192.168.0.3 (talk)
Jump to: navigation, search

install:

  1. pyton 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)

create: mysql -uroot -pprosuite CREATE DATABASE fieldprowiki;

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

restore: mysql -uroot -pprosuite 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 login in mysql: mysql -uroot -pprosuite

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'prosuite';