summaryrefslogtreecommitdiff
path: root/scripts/createdb.mysql
diff options
context:
space:
mode:
Diffstat (limited to 'scripts/createdb.mysql')
-rwxr-xr-xscripts/createdb.mysql10
1 files changed, 10 insertions, 0 deletions
diff --git a/scripts/createdb.mysql b/scripts/createdb.mysql
new file mode 100755
index 0000000..8b9ea42
--- /dev/null
+++ b/scripts/createdb.mysql
@@ -0,0 +1,10 @@
+/* Creates DB and opens it to any user */
+/* Run this mysql macro as root! */
+
+DROP DATABASE IF EXISTS GiantDisc;
+CREATE DATABASE GiantDisc;
+use GiantDisc;
+grant all privileges on GiantDisc.* to music@'%';
+grant all privileges on GiantDisc.* to music@localhost;
+grant all privileges on GiantDisc.* to apache@localhost with grant option;
+