====Manual ARDI Database Installation====

The automated installation script may fail if you already had MySQL installed on your system and had changed your password away from the default blank one.

To install an ARDI database, follow the steps below...

===Step 1: Login to your ARDI Server===

Make sure you are logged into your ARDI server, either directly or via a remote (ie. SSH) session.

===Step 2: Start the MySQL client===

Start **mysql**. In linux, you simply need to write 'mysql' in a terminal window. In Windows, you'll need to determine where it is installed before you can run it.

===Step 3: Create the Database & User===

Create a new database with the following command...

<code sql>
CREATE DATABASE ardi;
CREATE USER 'ardiuser'@'localhost' IDENTIFIED BY '123qwe';
GRANT ALL PRIVILEGES ON ardi.* TO 'ardiuser'@'localhost';
</code>

===Step 4: Copy the Empty Database===

Now we copy an 'empty' ARDI database in. To do this, type...

<code>
SOURCE /opt/ardi/web/sites/blankdb.sql
</code>

Where **/opt/ardi/web/sites/blankdb.sql** is the file name of the 'blankdb.sql' file included with your ARDI installation. 

===Complete===

This should create a new ARDI database and have you up and running where manual DB installation is required.