TΩИΨ: Ubuntu 12.04 - Install ownCloud 6.x

ownCloud (http://owncloud.org/) provides universal access to your files via the web, your computer or your mobile devices — wherever you are.
It also provides a platform to easily view & sync your contacts, calendars and bookmarks across all your devices and enables basic editing right on the web.

ownCloud's installation manual is way too simple, here is a complete guide for how to install ownCloud.

Add ownCloud's repository into source list:

# sh -c "echo 'deb http://download.opensuse.org/repositories/isv:/ownCloud:/community/xUbuntu_12.04/ /' >> /etc/apt/sources.list.d/owncloud.list"
# apt-get update

Install ownCloud:

# apt-get install owncloud

You can add the repository key to apt. Keep in mind that the owner of the key may distribute updates, packages and repositories that your system will trust (more information). To add the key, run:

# wget http://download.opensuse.org/repositories/isv:ownCloud:community/xUbuntu_12.04/Release.key
# apt-key add - < Release.key

Install and configure MySQL:
We will be configuring ownCloud server to take advantage of more robust MySQL DB instead of SQLite.

# apt-get install mysql-server

You will have to enter the administration password you selected during the MySQL installation. You will then be prompted for security settings. Press "Enter" to select yes for all of the settings except the first (about changing the root password again).

Now, sign into MySQL as the root user by typing:

# mysql -u root -p

Create a database with this command:

mysql> CREATE DATABASE owncloud;
Query OK, 1 row affected (0.00 sec)

# Create and assign privileges to a new MySQL user to handle database operations for ownCloud:
mysql > GRANT ALL ON owncloud.* to 'owncloud'@'localhost' IDENTIFIED BY 'j8PEkata';
mysql> select user from mysql.db where db='owncloud';
+----------+
| user     |
+----------+
| owncloud |
+----------+
1 row in set (0.00 sec)
mysql > exit;

Now go to http://yourdomain.com/owncloud, as you will see in the following picture: