Tips : Howto - Drupal Install on Debian or Ubuntu

This is a how-to guide to install drupal (drupal runs this site) on Debian or Ubuntu.

Background:
I am running apache2 and mysql. All of my software packages were initially installed with apt-get. But when I did a "apt-get install drupal" I would always get a failure communicating with the mysql server. After getting stuck, and getting advice from 1 person I trust, and another person on a forum who sounded intelligent - you're better off installing drupal from source rather than apt-get. So I did. I downloaded "drupal-4.6.3.tar.gz" untarred it and followed "INSTALL.txt". This howto is intended to be followed along with the INSTALL.txt .

If I to leave details or if you are stuck on something I've left out, please add a comment or contact me for help. I'd be happy to further explain anything I did.

Step 0 - Prereqs

My system is currently using apache2 mysql5 and php5. You can install drupal with apache1, but unless you have a good reason to install apache1, you should use apache2. You could also install drupal with a postgres backend if you wish. If you need any of these programs, just do a:

apt-get install [package]
Where package can be any/all of the following:
apache2
php5
php5-mysql
php5-gd
libapache2-mod-php5
mysql-server-5.0
mysql-client-5.0

Step 1 - Get the Code

Go to the drupal site and download the latest drupal. For my original install, the latest drupal was: drupal-4.6.3 . Simply do this:
tar -zxvf drupal-x.y.z.tar.gz
mv drupal-x.y.z  /your/full/path/to/site/www.mydrupal.com

Step 2 - Set up mysql

I got stuck on step 2 of INSTALL.txt . I did a "mysqladmin -u debian-sys-maint -p create drupal" and that worked fine. Then I got into the mysql database with this: "mysql -u debian-sys-maint -p" Note: "debian-sys-maint" is the user automatically created when you install mysql on a debian system. It is basically the admin account of mysql.

In MySQL you should create a seperate user for most databases, so you're going to create a new user like "drupaluser" or something else - and makeup or generate a new password. Your system's "root" mysql username (debian-sys-maint) and password are stored in /etc/mysql/debian.cnf . You'll make a new user with the MySQL GRANT command.

| Read more..

Courtesy : Dimmeria.com