summaryrefslogtreecommitdiffstats
path: root/abs/mv-core/ncid/ncidpermissions.sql
diff options
context:
space:
mode:
Diffstat (limited to 'abs/mv-core/ncid/ncidpermissions.sql')
-rwxr-xr-xabs/mv-core/ncid/ncidpermissions.sql8
1 files changed, 8 insertions, 0 deletions
diff --git a/abs/mv-core/ncid/ncidpermissions.sql b/abs/mv-core/ncid/ncidpermissions.sql
new file mode 100755
index 0000000..eb660fa
--- /dev/null
+++ b/abs/mv-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;