Page History

SHRINE uses four databases to log its operations: qepAuditDB, adapterAuditDB, stewardDB, and shrine_query_history. To create these databases, we are going to assume that you have already installed MySQL. You will need to sign into MySQL as the shrine user that you have created and then execute these sql scriptsto perform these commands:

$ mysql -u shrine -pdemouser

To create the 4 SHRINE databases, you will need to run these commands within the MySQL prompt:

CREATE DATABASE adapterAuditDB;
CREATE DATABASE qepAuditDB;
CREATE DATABASE stewardDB;
CREATE DATABASE shrine_query_history;

After creating these databases, you will then run each of the following scripts within there respective databases:

• qepAuditDB - qepAudit.sql
  
  
• adapterAuditDB - adapter.sql
  
  
• stewardDB - steward.sql
  
  
• shrine_query_history - shrine_query_history.sql

And finally, just to be safe, let's grant the shrine user full access again to all of these databases and their tables:

GRANT ALL privileges ON *.* TO 'shrine'@localhost;