Database Configuration

Creating the Database

MySQL or MariaDB must be installed and a root or admin-level user credential must be created before continuing. (This is not the same as a unix root credential.)

After running the install script, you will be prompted to visit the installdb.php page at the canonical domain of your LORIS instance.

Completing the form on this page will create a new database and user account that will be used to execute transactions coming from LORIS's PHP code.

Administrative Account

We recommend creating a separate administrative database account for sensitive transactions. In practice, this means creating and deleting new tables in the database. You'll need to do this when installing an instrument, for example.

After creating this account, you can run the command below to give the administrative user the correct privileges.

e.g. For a user named lorisDBadmin with password newpassword:

GRANT ALTER, DROP, CREATE, UPDATE, INSERT, SELECT, DELETE, CREATE TEMPORARY TABLES, LOCK TABLES  on $dbname.* to 'lorisDBadmin'@'$dbhost' IDENTIFIED BY 'newpassword' WITH GRANT OPTION;

This user's credentials should now be entered into your project's configuration file, config.xml within the adminUser and adminPassword tags.