Page History
...
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 | ||||
---|---|---|---|---|
| ||||
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:
Code Block | ||||
---|---|---|---|---|
| ||||
$ 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:
...
Overview
Content Tools