Adding a virtual Drupal site to a fully segregated Drupal Farm

The Drupal is a Content Management System (CMS). One of its distinguishing features is the ease of managing a number of sites from one codebase - the much vaunted Drupal Farm.

This instructable will be aimed at helping you create a fully segregated site within a drupal farm using commonly available tools such as phpMyAdmin to manage the SQL portion. It is assumed that the reader has basic knowledge of Drupal and Linux, as well as shell access with sufficient privileges.

Step 1 Creating an SQL database and user

The first step will be to create an SQL database and user. To do this, go to your phpMyAdmin instance and login.

Next, create the user and database by going to Privileges and selecting Add a new user from the bottom of your user list.

In this window, be careful to select the right settings so you can keep your SQL server secure! Hover over the fields in the image to get an idea of what the right settings should be. To re-iterate them here, select "local" for the host, and generate a password (Do not choose your own, as random passwords are always better).

Once the password is generated, copy it to your clipboard for later use.

Lastly, select "Create database with same name, and grant all privileges" to create the database.