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…
CREATE DATABASE ardi; CREATE USER 'ardiuser'@'localhost' IDENTIFIED BY '123qwe'; GRANT ALL PRIVILEGES ON ardi.* TO 'ardiuser'@'localhost';
Step 4: Copy the Empty Database
Now we copy an 'empty' ARDI database in. To do this, type…
SOURCE /opt/ardi/web/sites/blankdb.sql
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.