diff options
| author | Cecil Hugh Watson <knoppmyth@gmail.com> | 2010-01-23 09:52:38 (GMT) |
|---|---|---|
| committer | Cecil Hugh Watson <knoppmyth@gmail.com> | 2010-01-23 09:52:38 (GMT) |
| commit | 332702fe9eaf2db10c7bc2fdf840460e9c119623 (patch) | |
| tree | cdb7e4f3c0f61f7c2d1b278abb47ca952703e2cf /abs/core-testing/mythdb-initial/permissions.sql | |
| parent | 2cb896aaa2e7143dacb9fcee9952fc572dbff3a7 (diff) | |
| download | linhes_pkgbuild-332702fe9eaf2db10c7bc2fdf840460e9c119623.zip linhes_pkgbuild-332702fe9eaf2db10c7bc2fdf840460e9c119623.tar.gz linhes_pkgbuild-332702fe9eaf2db10c7bc2fdf840460e9c119623.tar.bz2 | |
mythvantage for 0.22, latest mythtv
Diffstat (limited to 'abs/core-testing/mythdb-initial/permissions.sql')
| -rwxr-xr-x | abs/core-testing/mythdb-initial/permissions.sql | 11 |
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; |