MySQL create a new account

mysql> CREATE USER 'monty'@'localhost' IDENTIFIED BY 'some_pass';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost'
-> WITH GRANT OPTION;
mysql> CREATE USER 'monty'@'%' IDENTIFIED BY 'some_pass';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'%'
-> WITH GRANT OPTION;
mysql> CREATE USER 'admin'@'localhost';
mysql> GRANT RELOAD,PROCESS ON *.* TO 'admin'@'localhost';
mysql> CREATE USER 'dummy'@'localhost';

wiki under Ubuntu

First of all, get web server ready.

Use Synaptic Package Manager to install the essential packages into the system. You need MySQL, PHP and Apache2.

Create an account for wiki under Ubuntu.

Enable the public_html folder for website by "sudo a2enmod userdir".

Change the setting in config directory of wiki and put the right username and password for wiki to access MySQL database.

Now the wiki is ready by typing 'localhost/~wiki' and you can see the site.

Add a new hard drive in Ubuntu

There is a very good guide from Ubuntu community. (https://help.ubuntu.com/community/InstallingANewHardDrive)

1. Get the drive information; (sudo lshw -C disk)
2. Install GParted; (sudo apt-get install gparted)
3. Partition and format the hard drive;
4. Create a mounting point; (sudo mkdir /media/mynewdrive)
5. Automatic mount at boot; (Edit fstab and put line '/dev/sdb1 /media/mynewdrive ext3 defaults 0 2' at the end)
6. Allow the specific group user to access;
sudo chgrp plugdev /media/mynewdrive
sudo chmod g+w /media/mynewdrive
sudo chmod +t /media/mynewdrive