summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
Diffstat (limited to 'www-apps/openca/files/mysql-setup.sql.in')
-rwxr-xr-xwww-apps/openca/files/mysql-setup.sql.in5
1 files changed, 5 insertions, 0 deletions
diff --git a/www-apps/openca/files/mysql-setup.sql.in b/www-apps/openca/files/mysql-setup.sql.in
new file mode 100755
index 0000000..07b1705
--- /dev/null
+++ b/www-apps/openca/files/mysql-setup.sql.in
@@ -0,0 +1,5 @@
+GRANT USAGE ON openca.* TO 'openca'@'localhost' IDENTIFIED BY '@dbpass@';
+
+GRANT SELECT, INSERT, UPDATE, DELETE ON openca.* TO 'openca'@'localhost';
+
+CREATE DATABASE IF NOT EXISTS openca;