Databases

From Griffith

SQLite database is created and used by default. If you want to use external database, you have to prepare them by yourself (root privileges are needed). You can use below code to generate all needed structures. Remember to replace gRiFiTh with your password.

MySQL

CREATE DATABASE `griffith` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE USER 'griffith'@'localhost' IDENTIFIED BY 'gRiFiTh';
CREATE USER 'griffith'@'%' IDENTIFIED BY 'gRiFiTh';
GRANT ALL ON `griffith` . * TO 'griffith'@'localhost';
GRANT ALL ON `griffith` . * TO 'griffith'@'%';

PostgreSQL

CREATE USER griffith UNENCRYPTED PASSWORD 'gRiFiTh' NOCREATEDB NOCREATEUSER;
CREATE DATABASE griffith WITH OWNER = griffith ENCODING = 'UNICODE';
GRANT ALL ON DATABASE griffith TO griffith;