Page History
...
SHRINE
...
uses four databases to log its operations: qepAuditDB, adapterAuditDB, stewardDB, and shrine_
...
query_history. When creating these databases, it is assumed that you have already installed MySQL.
...
You will need to sign into MySQL as the 'shrine' user that you have created to perform these commands:
Code Block | ||||
---|---|---|---|---|
| ||||
$ mysql -u shrine -pdemouser |
To create the 4 SHRINE databases, you will need to run these commands within the MySQL prompt:
Code Block | ||||
---|---|---|---|---|
| ||||
CREATE DATABASE adapterAuditDB;
CREATE DATABASE qepAuditDB;
CREATE DATABASE stewardDB;
CREATE DATABASE |
...
shrine_query_history |
...
Loading tables into DBs
adapter.sql → adapterAuditDB
; |
After creating these databases, you will then run each of the following scripts within their respective databases to load the schema. The command you will use is:
Code Block | ||||
---|---|---|---|---|
| ||||
$ mysql -u shrine -pdemouser database_name < filename.sql |
...
- qepAuditDB - qepAudit.sql
- adapterAuditDB - adapter.sql
- stewardDB - steward.sql
- shrine_query_history
...
...
...
Ontology scripts
ontology_create_tables.sql - Creates shrine_ont, creates SHRINE, TABLE_ACCESS, and SCHEMES tables, and sets up schemas within tables.
Sign into MySQL as root and grant the shrine user full access again to all of these databases and their tables:
Code Block | ||||
---|---|---|---|---|
| ||||
$ mysql -u root
MariaDB [(none)]> GRANT ALL privileges ON *.* TO 'shrine'@'localhost'; |
...