Mediawiki/Installing/Ubuntu

Revision as of 20:11, 11 October 2014

Installing | Multiple Instances | Ubuntu Installation

Installation Overview

All of the instructions below were done on Ubuntu 14.04 LTS

Install required packages

Below is a list of all the packages required by Mediawiki for installation on Ubuntu.

~$ sudo apt-get update && sudo apt-get install apache2 mysql-server php5 php5-mysql libapache2-mod-php5 ImageMagick

Alternatively, if you think you have already installed some of the packages, you can quickly check

~$ dpkg -s [package name] | grep Status
ie. ~$ dpkg -s imagemagick | grep Status
     Status: install ok installed

setup mysql

make sure mysql is started

~$ sudo service mysqld status
or
~$ sudo service mysqld start

setup the basics

~$ sudo mysql_secure_installation
Set root password? [Y/n] y
Remove anonymous users? [Y/n] y
Disallow root login remotely? [Y/n] y
Remove test database and access to it? [Y/n] y
Reload privilege tables now? [Y/n] y

login to db

~$ mysql -u root -p

Create mysql wiki user

~$ mysql> CREATE USER 'wiki'@'localhost' IDENTIFIED BY 'THISpasswordSHOULDbeCHANGED';
~$ mysql> exit

login as new user to verify account works

~$ mysql -u wiki -p
~$ mysql> exit

create DB

~$ mysql -u root -p
~$ mysql> CREATE DATABASE sewikidatabase;

verify DB creation

~$ mysql> SHOW DATABASES;

assign rights to wiki user for new database created

~$ mysql> GRANT ALL PRIVILEGES ON sewikidatabase.* TO 'wiki'@'localhost' IDENTIFIED BY 'wikiuserpassword' WITH GRANT OPTION;
~$ mysql> exit

verify permissions have been granted

~$ mysql -u wiki -p
~$ mysql> SHOW GRANTS;
+---------------------------------------------------------------------------------------------------------------+
| Grants for wiki@localhost                                                                                   |
+---------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'wiki'@'localhost' IDENTIFIED BY PASSWORD '*2K21458K438UYE85A38B9Y7Y78DAEBF4T8689YK4' |
| GRANT ALL PRIVILEGES ON `sewikidatabase`.* TO 'wiki'@'localhost' WITH GRANT OPTION                          |
+---------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)