Database Setup

Database

Kereru requires MySQL or MariaDB to be installed and running.

The database and database user must be created manually before use.

Setup

From a MySQL shell

# mysql -u root -p

The following SQL will a database called kereru, a databse user called twitter with a password of insecure:

CREATE DATABASE IF NOT EXISTS kereru;
CREATE USER IF NOT EXISTS 'twitter'@'localhost' IDENTIFIED BY 'insecure';
GRANT ALL PRIVILEGES ON kereru . * TO 'twitter'@'localhost';
FLUSH PRIVILEGES;

The example above is a guide to setting up the database in one particular way, and assumes a default configuration for a new database server. You may want to read the official MariaDB or MySQL documentation for more detail.