summaryrefslogtreecommitdiffstats
path: root/abs/core-testing/mythdb-initial/permissions.sql
diff options
context:
space:
mode:
Diffstat (limited to 'abs/core-testing/mythdb-initial/permissions.sql')
-rwxr-xr-xabs/core-testing/mythdb-initial/permissions.sql11
1 files changed, 11 insertions, 0 deletions
diff --git a/abs/core-testing/mythdb-initial/permissions.sql b/abs/core-testing/mythdb-initial/permissions.sql
new file mode 100755
index 0000000..5a36e15
--- /dev/null
+++ b/abs/core-testing/mythdb-initial/permissions.sql
@@ -0,0 +1,11 @@
+
+GRANT ALL ON mythconverg.* TO mythtv@localhost IDENTIFIED BY "mythtv";
+GRANT ALL ON mythconverg.* TO mythtv@'%' IDENTIFIED BY "mythtv";
+GRANT ALL ON mythconverg.* TO mythtv@myhost IDENTIFIED BY "mythtv";
+GRANT FILE ON *.* TO 'mythtv'@'%';
+FLUSH PRIVILEGES;
+GRANT CREATE TEMPORARY TABLES ON mythconverg.* TO mythtv@localhost IDENTIFIED BY "mythtv";
+GRANT CREATE TEMPORARY TABLES ON mythconverg.* TO mythtv@'%' IDENTIFIED BY "mythtv";
+GRANT CREATE TEMPORARY TABLES ON mythconverg.* TO mythtv@myhost IDENTIFIED BY "mythtv";
+FLUSH PRIVILEGES;
+ALTER DATABASE mythconverg DEFAULT CHARACTER SET latin1;