diff options
| author | James Meyer <James.meyer@operamail.com> | 2008-10-02 03:19:12 (GMT) |
|---|---|---|
| committer | James Meyer <James.meyer@operamail.com> | 2008-10-02 03:19:12 (GMT) |
| commit | 0e2532d4e8f4eed5e047f1db54d5c03ba849ec0a (patch) | |
| tree | c0aa2c0b53c317be87eacfcb77b63f53f1f415e7 /abs/core/mythtv/stable/mythdb-initial/permissions.sql | |
| download | linhes_pkgbuild-0e2532d4e8f4eed5e047f1db54d5c03ba849ec0a.zip linhes_pkgbuild-0e2532d4e8f4eed5e047f1db54d5c03ba849ec0a.tar.gz linhes_pkgbuild-0e2532d4e8f4eed5e047f1db54d5c03ba849ec0a.tar.bz2 | |
initial import
Diffstat (limited to 'abs/core/mythtv/stable/mythdb-initial/permissions.sql')
| -rwxr-xr-x | abs/core/mythtv/stable/mythdb-initial/permissions.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/abs/core/mythtv/stable/mythdb-initial/permissions.sql b/abs/core/mythtv/stable/mythdb-initial/permissions.sql new file mode 100755 index 0000000..acb4673 --- /dev/null +++ b/abs/core/mythtv/stable/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; |