Page History

...

$ mysql -u shrine -pdemouser

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

MariaDB [(none)]> CREATE DATABASE adapterAuditDB;
MariaDB [(none)]> CREATE DATABASE qepAuditDB;
MariaDB [(none)]> CREATE DATABASE stewardDB;
MariaDB [(none)]> CREATE DATABASE shrine_query_history;

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:

$ mysql -u shrine -pdemouser database_name < filename.sql

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

...

Sign into MySQL as root and grant the shrine user full access again to all of these databases and their tables:

...