summaryrefslogtreecommitdiffstats
path: root/abs/core/mythtv/stable/mythdb-initial/permissions.sql
blob: acb467345451ef9047d554286ff506e453cff652 (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;