maintenance/users.sql

   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.
   5 --
   6
   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}';
  13
  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}';
  20
  21 GRANT SELECT (user_id,user_name,user_options) ON `{$wgDBname}`.user
  22  TO {$wgDBsqluser}@'%' IDENTIFIED BY '{$wgDBsqlpassword}';
  23 GRANT SELECT ON `{$wgDBname}`.user_rights
  24  TO {$wgDBsqluser}@'%' IDENTIFIED BY '{$wgDBsqlpassword}';
  25 GRANT SELECT ON `{$wgDBname}`.cur
  26  TO {$wgDBsqluser}@'%' IDENTIFIED BY '{$wgDBsqlpassword}';
  27 GRANT SELECT ON `{$wgDBname}`.old
  28  TO {$wgDBsqluser}@'%' IDENTIFIED BY '{$wgDBsqlpassword}';
  29 GRANT SELECT ON `{$wgDBname}`.archive
  30  TO {$wgDBsqluser}@'%' IDENTIFIED BY '{$wgDBsqlpassword}';
  31 GRANT SELECT ON `{$wgDBname}`.links
  32  TO {$wgDBsqluser}@'%' IDENTIFIED BY '{$wgDBsqlpassword}';
  33 GRANT SELECT ON `{$wgDBname}`.brokenlinks
  34  TO {$wgDBsqluser}@'%' IDENTIFIED BY '{$wgDBsqlpassword}';
  35 GRANT SELECT ON `{$wgDBname}`.imagelinks
  36  TO {$wgDBsqluser}@'%' IDENTIFIED BY '{$wgDBsqlpassword}';
  37 GRANT SELECT ON `{$wgDBname}`.site_stats
  38  TO {$wgDBsqluser}@'%' IDENTIFIED BY '{$wgDBsqlpassword}';
  39 GRANT SELECT ON `{$wgDBname}`.ipblocks
  40  TO {$wgDBsqluser}@'%' IDENTIFIED BY '{$wgDBsqlpassword}';
  41 GRANT SELECT ON `{$wgDBname}`.image
  42  TO {$wgDBsqluser}@'%' IDENTIFIED BY '{$wgDBsqlpassword}';
  43 GRANT SELECT ON `{$wgDBname}`.oldimage
  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}';
  51
  52 GRANT SELECT (user_id,user_name,user_options)
  53  ON `{$wgDBname}`.user
  54  TO {$wgDBsqluser}@localhost IDENTIFIED BY '{$wgDBsqlpassword}';
  55 GRANT SELECT ON `{$wgDBname}`.user_rights
  56  TO {$wgDBsqluser}@localhost IDENTIFIED BY '{$wgDBsqlpassword}';
  57 GRANT SELECT ON `{$wgDBname}`.cur
  58  TO {$wgDBsqluser}@localhost IDENTIFIED BY '{$wgDBsqlpassword}';
  59 GRANT SELECT ON `{$wgDBname}`.old
  60  TO {$wgDBsqluser}@localhost IDENTIFIED BY '{$wgDBsqlpassword}';
  61 GRANT SELECT ON `{$wgDBname}`.archive
  62  TO {$wgDBsqluser}@localhost IDENTIFIED BY '{$wgDBsqlpassword}';
  63 GRANT SELECT ON `{$wgDBname}`.links
  64  TO {$wgDBsqluser}@localhost IDENTIFIED BY '{$wgDBsqlpassword}';
  65 GRANT SELECT ON `{$wgDBname}`.brokenlinks
  66  TO {$wgDBsqluser}@localhost IDENTIFIED BY '{$wgDBsqlpassword}';
  67 GRANT SELECT ON `{$wgDBname}`.imagelinks
  68  TO {$wgDBsqluser}@localhost IDENTIFIED BY '{$wgDBsqlpassword}';
  69 GRANT SELECT ON `{$wgDBname}`.site_stats
  70  TO {$wgDBsqluser}@localhost IDENTIFIED BY '{$wgDBsqlpassword}';
  71 GRANT SELECT ON `{$wgDBname}`.ipblocks
  72  TO {$wgDBsqluser}@localhost IDENTIFIED BY '{$wgDBsqlpassword}';
  73 GRANT SELECT ON `{$wgDBname}`.image
  74  TO {$wgDBsqluser}@localhost IDENTIFIED BY '{$wgDBsqlpassword}';
  75 GRANT SELECT ON `{$wgDBname}`.oldimage
  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}';
  83
  84 GRANT SELECT (user_id,user_name,user_options)
  85  ON `{$wgDBname}`.user
  86  TO {$wgDBsqluser}@localhost.localdomain IDENTIFIED BY '{$wgDBsqlpassword}';
  87 GRANT SELECT ON `{$wgDBname}`.user_rights
  88  TO {$wgDBsqluser}@localhost.localdomain IDENTIFIED BY '{$wgDBsqlpassword}';
  89 GRANT SELECT ON `{$wgDBname}`.cur
  90  TO {$wgDBsqluser}@localhost.localdomain IDENTIFIED BY '{$wgDBsqlpassword}';
  91 GRANT SELECT ON `{$wgDBname}`.old
  92  TO {$wgDBsqluser}@localhost.localdomain IDENTIFIED BY '{$wgDBsqlpassword}';
  93 GRANT SELECT ON `{$wgDBname}`.archive
  94  TO {$wgDBsqluser}@localhost.localdomain IDENTIFIED BY '{$wgDBsqlpassword}';
  95 GRANT SELECT ON `{$wgDBname}`.links
  96  TO {$wgDBsqluser}@localhost.localdomain IDENTIFIED BY '{$wgDBsqlpassword}';
  97 GRANT SELECT ON `{$wgDBname}`.brokenlinks
  98  TO {$wgDBsqluser}@localhost.localdomain IDENTIFIED BY '{$wgDBsqlpassword}';
  99 GRANT SELECT ON `{$wgDBname}`.imagelinks
 100  TO {$wgDBsqluser}@localhost.localdomain IDENTIFIED BY '{$wgDBsqlpassword}';
 101 GRANT SELECT ON `{$wgDBname}`.site_stats
 102  TO {$wgDBsqluser}@localhost.localdomain IDENTIFIED BY '{$wgDBsqlpassword}';
 103 GRANT SELECT ON `{$wgDBname}`.ipblocks
 104  TO {$wgDBsqluser}@localhost.localdomain IDENTIFIED BY '{$wgDBsqlpassword}';
 105 GRANT SELECT ON `{$wgDBname}`.image
 106  TO {$wgDBsqluser}@localhost.localdomain IDENTIFIED BY '{$wgDBsqlpassword}';
 107 GRANT SELECT ON `{$wgDBname}`.oldimage
 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}';
 115