diff options
| author | Cecil Hugh Watson <knoppmyth@gmail.com> | 2010-09-05 06:13:57 (GMT) |
|---|---|---|
| committer | Cecil Hugh Watson <knoppmyth@gmail.com> | 2010-09-05 06:13:57 (GMT) |
| commit | b172f79fadb565ecfbcec9508f9377d8618a4f4c (patch) | |
| tree | bf8823b07e3313c3afa000a9b31e4f9a735cb818 /abs/core/mythdb-initial/permissions.sql | |
| parent | f9d54ab7c3853208484e304bc6cf40ab0f79d400 (diff) | |
| parent | 5e7027c6194237ca1dc5fcbb3648483a970fb500 (diff) | |
| download | linhes_pkgbuild-b172f79fadb565ecfbcec9508f9377d8618a4f4c.zip linhes_pkgbuild-b172f79fadb565ecfbcec9508f9377d8618a4f4c.tar.gz linhes_pkgbuild-b172f79fadb565ecfbcec9508f9377d8618a4f4c.tar.bz2 | |
Merge branch 'HEAD' of ssh://cesman@knoppmyth.net/mount/repository/LinHES-PKGBUILD
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; |