diff options
Diffstat (limited to 'linhes/linhes-templates/templates/db/permissions.sql')
-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; |