summaryrefslogtreecommitdiff
path: root/scripts/createdb.mysql
diff options
context:
space:
mode:
Diffstat (limited to 'scripts/createdb.mysql')
-rwxr-xr-xscripts/createdb.mysql14
1 files changed, 14 insertions, 0 deletions
diff --git a/scripts/createdb.mysql b/scripts/createdb.mysql
new file mode 100755
index 0000000..7ccdc89
--- /dev/null
+++ b/scripts/createdb.mysql
@@ -0,0 +1,14 @@
+/* Creates DB and opens it to any user */
+/* Run this mysql macro as root! */
+
+DROP DATABASE IF EXISTS GiantDisc;
+CREATE DATABASE GiantDisc;
+
+use GiantDisc;
+
+/* The first line is useful for granting access to user vdr on all computers in a network. */
+/* grant all privileges on GiantDisc.* to vdr@'%'; */
+
+/* Grant access to user vdr on the local machine */
+grant all privileges on GiantDisc.* to vdr@localhost;
+