diff options
| author | James Meyer <james.meyer@operamail.com> | 2008-11-09 02:33:06 (GMT) |
|---|---|---|
| committer | James Meyer <james.meyer@operamail.com> | 2008-11-09 02:33:06 (GMT) |
| commit | 1ba69cc033dfbd0a6c4c29c6d877c7e753f96e8e (patch) | |
| tree | f336ee91ce16c6591fff50340562e07e15aa1a55 /abs/mv-core/mythdb-initial/permissions.sql | |
| parent | 75b1bceb21faab32d8f519d6f7f7062a226f9047 (diff) | |
| download | linhes_pkgbuild-1ba69cc033dfbd0a6c4c29c6d877c7e753f96e8e.zip linhes_pkgbuild-1ba69cc033dfbd0a6c4c29c6d877c7e753f96e8e.tar.gz linhes_pkgbuild-1ba69cc033dfbd0a6c4c29c6d877c7e753f96e8e.tar.bz2 | |
MythVantage specific pkgs
Diffstat (limited to 'abs/mv-core/mythdb-initial/permissions.sql')
| -rwxr-xr-x | abs/mv-core/mythdb-initial/permissions.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/abs/mv-core/mythdb-initial/permissions.sql b/abs/mv-core/mythdb-initial/permissions.sql new file mode 100755 index 0000000..acb4673 --- /dev/null +++ b/abs/mv-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; |