Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Code Block
languagebash
themerdark
$ mysql -u shrine -pdemouser


Code Block
languagesql
themerdark
CREATE DATABASE adapterAuditDB;
CREATE DATABASE qepAuditDB;
CREATE DATABASE stewardDB;
CREATE DATABASE shrine_query_history;


Code Block
languagesql
themerdark
$ mysql -u shrine -pdemouser database_name < filename.sql


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

Code Block
languagebash
themerdark
$ mysql -u root
MariaDB [(none)]> GRANT ALL privileges ON *.* TO 'shrine'@'localhost';