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
}.random
44 TO {$wgDBsqluser
}@
'%' IDENTIFIED
BY '{$wgDBsqlpassword}';
45 GRANT SELECT ON {$wgDBname
}.recentchanges
46 TO {$wgDBsqluser
}@
'%' IDENTIFIED
BY '{$wgDBsqlpassword}';
47 GRANT SELECT ON {$wgDBname
}.watchlist
48 TO {$wgDBsqluser
}@
'%' IDENTIFIED
BY '{$wgDBsqlpassword}';
49 GRANT SELECT ON {$wgDBname
}.math
50 TO {$wgDBsqluser
}@
'%' IDENTIFIED
BY '{$wgDBsqlpassword}';
52 GRANT SELECT (user_id
,user_name
,user_rights
,user_options
)
54 TO {$wgDBsqluser
}@localhost IDENTIFIED
BY '{$wgDBsqlpassword}';
55 GRANT SELECT ON {$wgDBname
}.cur
56 TO {$wgDBsqluser
}@localhost IDENTIFIED
BY '{$wgDBsqlpassword}';
57 GRANT SELECT ON {$wgDBname
}.
old
58 TO {$wgDBsqluser
}@localhost IDENTIFIED
BY '{$wgDBsqlpassword}';
59 GRANT SELECT ON {$wgDBname
}.archive
60 TO {$wgDBsqluser
}@localhost IDENTIFIED
BY '{$wgDBsqlpassword}';
61 GRANT SELECT ON {$wgDBname
}.links
62 TO {$wgDBsqluser
}@localhost IDENTIFIED
BY '{$wgDBsqlpassword}';
63 GRANT SELECT ON {$wgDBname
}.brokenlinks
64 TO {$wgDBsqluser
}@localhost IDENTIFIED
BY '{$wgDBsqlpassword}';
65 GRANT SELECT ON {$wgDBname
}.imagelinks
66 TO {$wgDBsqluser
}@localhost IDENTIFIED
BY '{$wgDBsqlpassword}';
67 GRANT SELECT ON {$wgDBname
}.site_stats
68 TO {$wgDBsqluser
}@localhost IDENTIFIED
BY '{$wgDBsqlpassword}';
69 GRANT SELECT ON {$wgDBname
}.ipblocks
70 TO {$wgDBsqluser
}@localhost IDENTIFIED
BY '{$wgDBsqlpassword}';
71 GRANT SELECT ON {$wgDBname
}.image
72 TO {$wgDBsqluser
}@localhost IDENTIFIED
BY '{$wgDBsqlpassword}';
73 GRANT SELECT ON {$wgDBname
}.oldimage
74 TO {$wgDBsqluser
}@localhost IDENTIFIED
BY '{$wgDBsqlpassword}';
75 GRANT SELECT ON {$wgDBname
}.random
76 TO {$wgDBsqluser
}@localhost IDENTIFIED
BY '{$wgDBsqlpassword}';
77 GRANT SELECT ON {$wgDBname
}.recentchanges
78 TO {$wgDBsqluser
}@localhost IDENTIFIED
BY '{$wgDBsqlpassword}';
79 GRANT SELECT ON {$wgDBname
}.watchlist
80 TO {$wgDBsqluser
}@localhost IDENTIFIED
BY '{$wgDBsqlpassword}';
81 GRANT SELECT ON {$wgDBname
}.math
82 TO {$wgDBsqluser
}@localhost IDENTIFIED
BY '{$wgDBsqlpassword}';
84 GRANT SELECT (user_id
,user_name
,user_rights
,user_options
)
86 TO {$wgDBsqluser
}@localhost.localdomain IDENTIFIED
BY '{$wgDBsqlpassword}';
87 GRANT SELECT ON {$wgDBname
}.cur
88 TO {$wgDBsqluser
}@localhost.localdomain IDENTIFIED
BY '{$wgDBsqlpassword}';
89 GRANT SELECT ON {$wgDBname
}.
old
90 TO {$wgDBsqluser
}@localhost.localdomain IDENTIFIED
BY '{$wgDBsqlpassword}';
91 GRANT SELECT ON {$wgDBname
}.archive
92 TO {$wgDBsqluser
}@localhost.localdomain IDENTIFIED
BY '{$wgDBsqlpassword}';
93 GRANT SELECT ON {$wgDBname
}.links
94 TO {$wgDBsqluser
}@localhost.localdomain IDENTIFIED
BY '{$wgDBsqlpassword}';
95 GRANT SELECT ON {$wgDBname
}.brokenlinks
96 TO {$wgDBsqluser
}@localhost.localdomain IDENTIFIED
BY '{$wgDBsqlpassword}';
97 GRANT SELECT ON {$wgDBname
}.imagelinks
98 TO {$wgDBsqluser
}@localhost.localdomain IDENTIFIED
BY '{$wgDBsqlpassword}';
99 GRANT SELECT ON {$wgDBname
}.site_stats
100 TO {$wgDBsqluser
}@localhost.localdomain IDENTIFIED
BY '{$wgDBsqlpassword}';
101 GRANT SELECT ON {$wgDBname
}.ipblocks
102 TO {$wgDBsqluser
}@localhost.localdomain IDENTIFIED
BY '{$wgDBsqlpassword}';
103 GRANT SELECT ON {$wgDBname
}.image
104 TO {$wgDBsqluser
}@localhost.localdomain IDENTIFIED
BY '{$wgDBsqlpassword}';
105 GRANT SELECT ON {$wgDBname
}.oldimage
106 TO {$wgDBsqluser
}@localhost.localdomain IDENTIFIED
BY '{$wgDBsqlpassword}';
107 GRANT SELECT ON {$wgDBname
}.random
108 TO {$wgDBsqluser
}@localhost.localdomain IDENTIFIED
BY '{$wgDBsqlpassword}';
109 GRANT SELECT ON {$wgDBname
}.recentchanges
110 TO {$wgDBsqluser
}@localhost.localdomain IDENTIFIED
BY '{$wgDBsqlpassword}';
111 GRANT SELECT ON {$wgDBname
}.watchlist
112 TO {$wgDBsqluser
}@localhost.localdomain IDENTIFIED
BY '{$wgDBsqlpassword}';
113 GRANT SELECT ON {$wgDBname
}.math
114 TO {$wgDBsqluser
}@localhost.localdomain IDENTIFIED
BY '{$wgDBsqlpassword}';