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}';