summaryrefslogtreecommitdiff
path: root/scripts/createdb.mysql
diff options
context:
space:
mode:
authorwr61 <wr61@e10066b5-e1e2-0310-b819-94efdf66514b>2005-02-21 13:29:47 +0000
committerwr61 <wr61@e10066b5-e1e2-0310-b819-94efdf66514b>2005-02-21 13:29:47 +0000
commitd30fd8db8384ffe6c86a5c177798d60e581e8a17 (patch)
treefb940ac1ab11a68b2c01f9188c5351554b418901 /scripts/createdb.mysql
parentaf1c206e1611651e5b0f714e38c5451a00efbbd8 (diff)
parent3472518951059dd1b81330f54152534488c0d3c2 (diff)
downloadvdr-plugin-muggle-d30fd8db8384ffe6c86a5c177798d60e581e8a17.tar.gz
vdr-plugin-muggle-d30fd8db8384ffe6c86a5c177798d60e581e8a17.tar.bz2
git-svn-id: https://vdr-muggle.svn.sourceforge.net/svnroot/vdr-muggle/branches/0.1.3-wr@506 e10066b5-e1e2-0310-b819-94efdf66514b
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;
+