sysadmin global mediawiki_db 06102011

Table of Contents Infos Comments Logs Session Commands Files

Infos

Made by : olbat

Date: 06/10/2011

Currently applied on : papilusion

Comments

Configuring mediawiki mysql db and users

Logs

Session

• user : root
• host : ns304832.ovh.net
• date : 06/10/11 12:49
• curpath : /root

Commands

• Creating mysql db and user with password: PASSWORD

 [email protected]# tmp=`tempfile`

• Editing tmpfile $tmp (shlog edit $tmp)
• Edit /tmp/fileyUx3UI, see [1]

 [email protected]# mysql -p < $tmp

 [email protected]# rm $tmp

Files

• [1] Edit /tmp/fileyUx3UI

 --- old	2011-10-06 12:50:29.000000000 +0200
 +++ new	2011-10-06 12:52:15.000000000 +0200
 @@ -0,0 +1,2 @@
 +CREATE DATABASE wikidb;
 +GRANT INDEX, CREATE, SELECT, INSERT, UPDATE, DELETE, ALTER, LOCK TABLES ON wikidb.* TO 'wikiuser'@'localhost' IDENTIFIED BY 'PASSWORD';