Overview

This section describes the steps required in order to properly install and configure the Etics DB (MySQL).

Schema Creation and Data population

In order to create the Etics database and populate the Etics data you have to perform the following steps:

• Log in into MySQL and create the Etics DB user that will be used by the WebService to access the DB:

1. mysql -u root -p
2. GRANT ALL PRIVILEGES ON * .* TO 'etics'@'localhost';

• Load the Etics DB Schema (can be downloaded from the org.etics.data-model.schema-db-mysql CVS module) and populate the default Etics data

1. mysql -u etics < eticsDBSchema.sql;
2. mysql -u etics etics < eticsDBDefaults.sql
3. mysql -u etics etics < eticsDBData.sql

• Grant access to the etics DB (from the MySQL prompt)

1. grant ALL PRIVILEGES on etics.* to 'etics'@'hostname' identified by "password";
2. grant ALL PRIVILEGES on etics.* to etics identified by "pass";
3. grant ALL PRIVILEGES on etics.* to etics@localhost identified by "pass";

-- MarianZUREK - 08 Nov 2006