From bbe9f7e5fad53a28d9609f0a69a21ee99443a64b Mon Sep 17 00:00:00 2001 From: Benjamin Lees Date: Mon, 14 Sep 2009 18:40:45 +0000 Subject: [PATCH] Follow up to r56285: just grant all rights to the installer-created database user. --- RELEASE-NOTES | 4 ++-- maintenance/users.sql | 6 +++--- 2 files changed, 5 insertions(+), 5 deletions(-) diff --git a/RELEASE-NOTES b/RELEASE-NOTES index 74617376c5..ee3d4ca289 100644 --- a/RELEASE-NOTES +++ b/RELEASE-NOTES @@ -497,8 +497,8 @@ it from source control: http://www.mediawiki.org/wiki/Download_from_SVN * (bug 482) Don't include TOC in the printable version if it has been hidden * Adjust the time according to the user configuration on Special:Revisiondelete * (bug 20624) Installation no longer allows "qqq" as the chosen language -* (bug 20634) The installer-created database user will now have CREATE TABLE - and ALTER TABLE rights so that upgrades will go more smoothly. +* (bug 20634) The installer-created database user will now have all rights on + the database so that upgrades will go more smoothly. * (bug 18180) Special:Export ignores limit, dir, offset parameters == API changes in 1.16 == diff --git a/maintenance/users.sql b/maintenance/users.sql index e9d02b6527..9e78b6ad38 100644 --- a/maintenance/users.sql +++ b/maintenance/users.sql @@ -4,9 +4,9 @@ -- from local settings. -- -GRANT DELETE,INSERT,SELECT,UPDATE,CREATE TEMPORARY TABLES,CREATE TABLE,ALTER TABLE ON `{$wgDBname}`.* +GRANT * ON `{$wgDBname}`.* TO '{$wgDBuser}'@'%' IDENTIFIED BY '{$wgDBpassword}'; -GRANT DELETE,INSERT,SELECT,UPDATE,CREATE TEMPORARY TABLES,CREATE TABLE,ALTER TABLE ON `{$wgDBname}`.* +GRANT * ON `{$wgDBname}`.* TO '{$wgDBuser}'@localhost IDENTIFIED BY '{$wgDBpassword}'; -GRANT DELETE,INSERT,SELECT,UPDATE,CREATE TEMPORARY TABLES,CREATE TABLE,ALTER TABLE ON `{$wgDBname}`.* +GRANT * ON `{$wgDBname}`.* TO '{$wgDBuser}'@localhost.localdomain IDENTIFIED BY '{$wgDBpassword}'; -- 2.20.1