$ mysql -u shrine -pdemouser


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


$ 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:

$ mysql -u root
MariaDB [(none)]> GRANT ALL privileges ON *.* TO 'shrine'@'localhost';
  • No labels