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_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}';
  51
  52 GRANT SELECT (user_id,user_name,user_rights,user_options)
  53  ON {$wgDBname}.user
  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}';
  83
  84 GRANT SELECT (user_id,user_name,user_rights,user_options)
  85  ON {$wgDBname}.user
  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}';
 115