summaryrefslogtreecommitdiffstats
path: root/abs/core-testing/mythdb-initial/permissions.sql
blob: 5a36e1590920cb4c9edfe2935b0c042de8f3fb07 (plain)
1
2
3
4
5
6
7
8
9
10
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;