12 lines
413 B
SQL
12 lines
413 B
SQL
-- Shinobi will create the database framework on start.
|
|
-- Be certain the database exists and Shinobi can access it.
|
|
|
|
-- Create Database
|
|
CREATE DATABASE IF NOT EXISTS `ccio`;
|
|
-- Create User for Database
|
|
CREATE USER 'majesticflame'@'127.0.0.1' IDENTIFIED BY '';
|
|
-- Grant Permissions to User for Database
|
|
GRANT ALL PRIVILEGES ON ccio.* TO 'majesticflame'@'127.0.0.1';
|
|
-- Refresh SQL Authorization
|
|
FLUSH PRIVILEGES;
|