1 -- SQL script to create required database users with proper
2 -- access rights. This is run from the installation script
3 -- which replaces the password variables with their values
4 -- from local settings.
7 GRANT ALL ON {$wgDBname
}.
*
8 TO {$wgDBadminuser
}@
'%' IDENTIFIED
BY '{$wgDBadminpassword}';
9 GRANT ALL ON {$wgDBname
}.
*
10 TO {$wgDBadminuser
}@localhost IDENTIFIED
BY '{$wgDBadminpassword}';
11 GRANT ALL ON {$wgDBname
}.
*
12 TO {$wgDBadminuser
}@localhost.localdomain IDENTIFIED
BY '{$wgDBadminpassword}';
14 GRANT DELETE,INSERT,SELECT,UPDATE ON {$wgDBname
}.
*
15 TO {$wgDBuser
}@
'%' IDENTIFIED
BY '{$wgDBpassword}';
16 GRANT DELETE,INSERT,SELECT,UPDATE ON {$wgDBname
}.
*
17 TO {$wgDBuser
}@localhost IDENTIFIED
BY '{$wgDBpassword}';
18 GRANT DELETE,INSERT,SELECT,UPDATE ON {$wgDBname
}.
*
19 TO {$wgDBuser
}@localhost.localdomain IDENTIFIED
BY '{$wgDBpassword}';
21 GRANT SELECT (user_id
,user_name
,user_rights
,user_options
) ON {$wgDBname
}.
user
22 TO {$wgDBsqluser
}@
'%' IDENTIFIED
BY '{$wgDBsqlpassword}';
23 GRANT SELECT ON {$wgDBname
}.cur
24 TO {$wgDBsqluser
}@
'%' IDENTIFIED
BY '{$wgDBsqlpassword}';
25 GRANT SELECT ON {$wgDBname
}.
old
26 TO {$wgDBsqluser
}@
'%' IDENTIFIED
BY '{$wgDBsqlpassword}';
27 GRANT SELECT ON {$wgDBname
}.archive
28 TO {$wgDBsqluser
}@
'%' IDENTIFIED
BY '{$wgDBsqlpassword}';
29 GRANT SELECT ON {$wgDBname
}.links
30 TO {$wgDBsqluser
}@
'%' IDENTIFIED
BY '{$wgDBsqlpassword}';
31 GRANT SELECT ON {$wgDBname
}.brokenlinks
32 TO {$wgDBsqluser
}@
'%' IDENTIFIED
BY '{$wgDBsqlpassword}';
33 GRANT SELECT ON {$wgDBname
}.imagelinks
34 TO {$wgDBsqluser
}@
'%' IDENTIFIED
BY '{$wgDBsqlpassword}';
35 GRANT SELECT ON {$wgDBname
}.site_stats
36 TO {$wgDBsqluser
}@
'%' IDENTIFIED
BY '{$wgDBsqlpassword}';
37 GRANT SELECT ON {$wgDBname
}.ipblocks
38 TO {$wgDBsqluser
}@
'%' IDENTIFIED
BY '{$wgDBsqlpassword}';
39 GRANT SELECT ON {$wgDBname
}.image
40 TO {$wgDBsqluser
}@
'%' IDENTIFIED
BY '{$wgDBsqlpassword}';
41 GRANT SELECT ON {$wgDBname
}.oldimage
42 TO {$wgDBsqluser
}@
'%' IDENTIFIED
BY '{$wgDBsqlpassword}';
43 GRANT SELECT ON {$wgDBname
}.recentchanges
44 TO {$wgDBsqluser
}@
'%' IDENTIFIED
BY '{$wgDBsqlpassword}';
45 GRANT SELECT ON {$wgDBname
}.watchlist
46 TO {$wgDBsqluser
}@
'%' IDENTIFIED
BY '{$wgDBsqlpassword}';
47 GRANT SELECT ON {$wgDBname
}.math
48 TO {$wgDBsqluser
}@
'%' IDENTIFIED
BY '{$wgDBsqlpassword}';
50 GRANT SELECT (user_id
,user_name
,user_rights
,user_options
)
52 TO {$wgDBsqluser
}@localhost IDENTIFIED
BY '{$wgDBsqlpassword}';
53 GRANT SELECT ON {$wgDBname
}.cur
54 TO {$wgDBsqluser
}@localhost IDENTIFIED
BY '{$wgDBsqlpassword}';
55 GRANT SELECT ON {$wgDBname
}.
old
56 TO {$wgDBsqluser
}@localhost IDENTIFIED
BY '{$wgDBsqlpassword}';
57 GRANT SELECT ON {$wgDBname
}.archive
58 TO {$wgDBsqluser
}@localhost IDENTIFIED
BY '{$wgDBsqlpassword}';
59 GRANT SELECT ON {$wgDBname
}.links
60 TO {$wgDBsqluser
}@localhost IDENTIFIED
BY '{$wgDBsqlpassword}';
61 GRANT SELECT ON {$wgDBname
}.brokenlinks
62 TO {$wgDBsqluser
}@localhost IDENTIFIED
BY '{$wgDBsqlpassword}';
63 GRANT SELECT ON {$wgDBname
}.imagelinks
64 TO {$wgDBsqluser
}@localhost IDENTIFIED
BY '{$wgDBsqlpassword}';
65 GRANT SELECT ON {$wgDBname
}.site_stats
66 TO {$wgDBsqluser
}@localhost IDENTIFIED
BY '{$wgDBsqlpassword}';
67 GRANT SELECT ON {$wgDBname
}.ipblocks
68 TO {$wgDBsqluser
}@localhost IDENTIFIED
BY '{$wgDBsqlpassword}';
69 GRANT SELECT ON {$wgDBname
}.image
70 TO {$wgDBsqluser
}@localhost IDENTIFIED
BY '{$wgDBsqlpassword}';
71 GRANT SELECT ON {$wgDBname
}.oldimage
72 TO {$wgDBsqluser
}@localhost IDENTIFIED
BY '{$wgDBsqlpassword}';
73 GRANT SELECT ON {$wgDBname
}.recentchanges
74 TO {$wgDBsqluser
}@localhost IDENTIFIED
BY '{$wgDBsqlpassword}';
75 GRANT SELECT ON {$wgDBname
}.watchlist
76 TO {$wgDBsqluser
}@localhost IDENTIFIED
BY '{$wgDBsqlpassword}';
77 GRANT SELECT ON {$wgDBname
}.math
78 TO {$wgDBsqluser
}@localhost IDENTIFIED
BY '{$wgDBsqlpassword}';
80 GRANT SELECT (user_id
,user_name
,user_rights
,user_options
)
82 TO {$wgDBsqluser
}@localhost.localdomain IDENTIFIED
BY '{$wgDBsqlpassword}';
83 GRANT SELECT ON {$wgDBname
}.cur
84 TO {$wgDBsqluser
}@localhost.localdomain IDENTIFIED
BY '{$wgDBsqlpassword}';
85 GRANT SELECT ON {$wgDBname
}.
old
86 TO {$wgDBsqluser
}@localhost.localdomain IDENTIFIED
BY '{$wgDBsqlpassword}';
87 GRANT SELECT ON {$wgDBname
}.archive
88 TO {$wgDBsqluser
}@localhost.localdomain IDENTIFIED
BY '{$wgDBsqlpassword}';
89 GRANT SELECT ON {$wgDBname
}.links
90 TO {$wgDBsqluser
}@localhost.localdomain IDENTIFIED
BY '{$wgDBsqlpassword}';
91 GRANT SELECT ON {$wgDBname
}.brokenlinks
92 TO {$wgDBsqluser
}@localhost.localdomain IDENTIFIED
BY '{$wgDBsqlpassword}';
93 GRANT SELECT ON {$wgDBname
}.imagelinks
94 TO {$wgDBsqluser
}@localhost.localdomain IDENTIFIED
BY '{$wgDBsqlpassword}';
95 GRANT SELECT ON {$wgDBname
}.site_stats
96 TO {$wgDBsqluser
}@localhost.localdomain IDENTIFIED
BY '{$wgDBsqlpassword}';
97 GRANT SELECT ON {$wgDBname
}.ipblocks
98 TO {$wgDBsqluser
}@localhost.localdomain IDENTIFIED
BY '{$wgDBsqlpassword}';
99 GRANT SELECT ON {$wgDBname
}.image
100 TO {$wgDBsqluser
}@localhost.localdomain IDENTIFIED
BY '{$wgDBsqlpassword}';
101 GRANT SELECT ON {$wgDBname
}.oldimage
102 TO {$wgDBsqluser
}@localhost.localdomain IDENTIFIED
BY '{$wgDBsqlpassword}';
103 GRANT SELECT ON {$wgDBname
}.recentchanges
104 TO {$wgDBsqluser
}@localhost.localdomain IDENTIFIED
BY '{$wgDBsqlpassword}';
105 GRANT SELECT ON {$wgDBname
}.watchlist
106 TO {$wgDBsqluser
}@localhost.localdomain IDENTIFIED
BY '{$wgDBsqlpassword}';
107 GRANT SELECT ON {$wgDBname
}.math
108 TO {$wgDBsqluser
}@localhost.localdomain IDENTIFIED
BY '{$wgDBsqlpassword}';