From 53d17214e4e9e1e630d625a51d05484c3770fad1 Mon Sep 17 00:00:00 2001 From: xengineering Date: Fri, 11 Nov 2022 16:40:32 +0100 Subject: Remove user setup from initial migration The initial migration used to add the Ceres database and user. This works well for the production use case but is not that suitable for the development / debugging use case where the default user of the developer should be used. With this commit the generic user setup is explained in the README which can be applied to the developers Linux user aswell as a system user for the production use case. --- sql/0001_migration.sql | 11 ++--------- 1 file changed, 2 insertions(+), 9 deletions(-) (limited to 'sql') diff --git a/sql/0001_migration.sql b/sql/0001_migration.sql index b04a754..9502e6c 100644 --- a/sql/0001_migration.sql +++ b/sql/0001_migration.sql @@ -1,18 +1,11 @@ -------------------------------------------------------------------------------- --- This migration script adds the ceres database and user and sets --- permissions. - --- Run this migration via `sudo mariadb -u root < 0001_migration.sql`. Mind --- that you also have to create the ceres Linux user. This is possibly done --- by the systemd *.sysusers file. +-- This migration script adds the initial version of the Ceres database. +-- Run this migration via `sudo mariadb -u root < 0001_migration.sql`. -- create database for ceres, add ceres user and set privileges CREATE DATABASE IF NOT EXISTS ceres; -CREATE USER IF NOT EXISTS 'ceres'@'localhost' IDENTIFIED VIA unix_socket; -GRANT ALL PRIVILEGES on ceres.* to 'ceres'@'localhost'; -FLUSH PRIVILEGES; -- select correct database for the rest of this script USE ceres; -- cgit v1.2.3-70-g09d2