Xserver VPSでDebianサーバ構築/Wikiサーバ設定

概要

Wikiサーバ

MediaWiki

• 参考

https://www.mediawiki.org/wiki/Manual:Running_MediaWiki_on_Debian_or_Ubuntu/ja

設定

DB

create a NEW mysql user (new_mysql_user):

$ sudo mysql -u root -p
Enter password: Enter password of mysql root user (if you have not configured password it will be blank, so just press enter)
mysql> CREATE USER 'new_mysql_user'@'localhost' IDENTIFIED BY 'THISpasswordSHOULDbeCHANGED';

create a NEW mysql database my_wiki:

$ sudo mysql -u root -p
mysql> CREATE DATABASE my_wiki;
mysql> use my_wiki;
Database changed

GRANT the NEW mysql user access to the NEW created mysql database my_wiki:

mysql> GRANT ALL ON my_wiki.* TO 'new_mysql_user'@'localhost';
Query OK, 0 rows affected (0.01 sec)
mysql> quit;