summaryrefslogtreecommitdiffstats
path: root/abs/core/ncid/ncidpermissions.sql
diff options
context:
space:
mode:
Diffstat (limited to 'abs/core/ncid/ncidpermissions.sql')
-rw-r--r--abs/core/ncid/ncidpermissions.sql8
1 files changed, 8 insertions, 0 deletions
diff --git a/abs/core/ncid/ncidpermissions.sql b/abs/core/ncid/ncidpermissions.sql
new file mode 100644
index 0000000..eb660fa
--- /dev/null
+++ b/abs/core/ncid/ncidpermissions.sql
@@ -0,0 +1,8 @@
+
+GRANT ALL ON ncid.* TO mythtv@localhost IDENTIFIED BY "mythtv";
+GRANT ALL ON ncid.* TO mythtv@"%" IDENTIFIED BY "mythtv";
+GRANT FILE ON *.* TO 'mythtv'@'%';
+FLUSH PRIVILEGES;
+
+FLUSH PRIVILEGES;
+ALTER DATABASE ncid DEFAULT CHARACTER SET latin1;