diff options
| author | Britney Fransen <brfransen@gmail.com> | 2022-12-07 21:41:59 (GMT) |
|---|---|---|
| committer | Britney Fransen <brfransen@gmail.com> | 2022-12-07 21:41:59 (GMT) |
| commit | dfd71a19b63b0784bff6ac79ccdf368650ec72ad (patch) | |
| tree | a5fd2272782b6b3311e078be1d56f17e78f958c0 /linhes/linhes-templates/templates/db | |
| parent | 6991e62328389fbbfd9b4d62041ab55af02901c4 (diff) | |
| download | linhes_pkgbuild-dfd71a19b63b0784bff6ac79ccdf368650ec72ad.zip linhes_pkgbuild-dfd71a19b63b0784bff6ac79ccdf368650ec72ad.tar.gz linhes_pkgbuild-dfd71a19b63b0784bff6ac79ccdf368650ec72ad.tar.bz2 | |
linhes-templates: add permissions.sql
Diffstat (limited to 'linhes/linhes-templates/templates/db')
| -rw-r--r-- | linhes/linhes-templates/templates/db/permissions.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/linhes/linhes-templates/templates/db/permissions.sql b/linhes/linhes-templates/templates/db/permissions.sql new file mode 100644 index 0000000..108a1ab --- /dev/null +++ b/linhes/linhes-templates/templates/db/permissions.sql @@ -0,0 +1,9 @@ +CREATE DATABASE IF NOT EXISTS mythconverg; +GRANT ALL ON mythconverg.* TO 'mythtv'@localhost IDENTIFIED BY 'mythtv'; +GRANT ALL ON mythconverg.* TO 'mythtv'@'%' 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'; +FLUSH PRIVILEGES; +ALTER DATABASE mythconverg DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; |