16 lines
683 B
SQL
16 lines
683 B
SQL
-- create databases
|
|
CREATE DATABASE IF NOT EXISTS `gitea`;
|
|
CREATE DATABASE IF NOT EXISTS `flask`;
|
|
CREATE DATABASE IF NOT EXISTS `nextcloud`;
|
|
|
|
-- create root user and grant rights
|
|
CREATE USER IF NOT EXISTS 'gitea'@'gitea.backnet' IDENTIFIED BY 'giteap';
|
|
CREATE USER IF NOT EXISTS 'flasku'@'backend.backnet' IDENTIFIED BY 'flaskp';
|
|
CREATE USER IF NOT EXISTS 'nextcloud'@'nextcloud.backnet' IDENTIFIED BY 'nextcloudp';
|
|
--CREATE USER 'gitea'@'localhost' IDENTIFIED BY 'gitea';
|
|
--GRANT ALL ON `gitea` TO 'gitea'@'localhost';
|
|
GRANT ALL ON gitea.* TO 'gitea'@'gitea.backnet';
|
|
GRANT ALL ON flask.* TO 'flasku'@'backend.backnet';
|
|
GRANT ALL ON nextcloud.* TO 'nextcloud'@'nextcloud.backnet';
|
|
|