summaryrefslogtreecommitdiff
path: root/maintenance/users.sql
diff options
context:
space:
mode:
Diffstat (limited to 'maintenance/users.sql')
-rw-r--r--maintenance/users.sql12
1 files changed, 12 insertions, 0 deletions
diff --git a/maintenance/users.sql b/maintenance/users.sql
new file mode 100644
index 00000000..755bf9f7
--- /dev/null
+++ b/maintenance/users.sql
@@ -0,0 +1,12 @@
+-- SQL script to create required database users with proper
+-- access rights. This is run from the installation script
+-- which replaces the password variables with their values
+-- from local settings.
+--
+
+GRANT DELETE,INSERT,SELECT,UPDATE,CREATE TEMPORARY TABLES ON `{$wgDBname}`.*
+ TO '{$wgDBuser}'@'%' IDENTIFIED BY '{$wgDBpassword}';
+GRANT DELETE,INSERT,SELECT,UPDATE,CREATE TEMPORARY TABLES ON `{$wgDBname}`.*
+ TO '{$wgDBuser}'@localhost IDENTIFIED BY '{$wgDBpassword}';
+GRANT DELETE,INSERT,SELECT,UPDATE,CREATE TEMPORARY TABLES ON `{$wgDBname}`.*
+ TO '{$wgDBuser}'@localhost.localdomain IDENTIFIED BY '{$wgDBpassword}';