Installing WordPress on Ubuntu

Install wordpress package:
$ sudo apt-get install wordpress

Enter in mysql prompt:
$ mysql -u root -p

Create a wordpress user:
mysql> grant all privileges on *.* to wordpress_user@localhost;

Set a password:
mysql> set password for wordpress_user@localhost = PASSWORD(‘yourpass’);

Create your database:
mysql> create database wordpress_mad;

Flush it:
mysql> flush privileges;

Add to /etc/apache2/apache2.conf :

# wordpress
Alias /blog /usr/share/wordpress
<Directory /usr/share/wordpress>
Options FollowSymLinks
AllowOverride Limit Options FileInfo
DirectoryIndex index.php

Remove wp-config.php link:
# rm /usr/share/wordpress/wp-config.php

Move config sample to original wp-config:
# mv /usr/share/wordpress/wp-config-sample.php /usr/share/wordpress/wp-config.php

Edit /usr/share/wordpress/wp-config.php and replace database variables with these ones you created.

In your web-browser access:

Just choose a name and go on!