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
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.