diff options
Diffstat (limited to 'abs/core/mythdb-initial/permissions.sql')
| -rwxr-xr-x | abs/core/mythdb-initial/permissions.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/abs/core/mythdb-initial/permissions.sql b/abs/core/mythdb-initial/permissions.sql new file mode 100755 index 0000000..5a36e15 --- /dev/null +++ b/abs/core/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; |