From 232d9d427c7592ff12a267c40fc90fb17ec1dd25 Mon Sep 17 00:00:00 2001 From: Benjamin Lees Date: Mon, 14 Sep 2009 01:26:21 +0000 Subject: [PATCH] (Bug 20634) Give the installer-created database user CREATE TABLE and ALTER TABLE rights so that upgrades will go more smoothly. --- RELEASE-NOTES | 2 ++ maintenance/users.sql | 6 +++--- 2 files changed, 5 insertions(+), 3 deletions(-) diff --git a/RELEASE-NOTES b/RELEASE-NOTES index fa013eb7b0..6cebc5d8c9 100644 --- a/RELEASE-NOTES +++ b/RELEASE-NOTES @@ -496,6 +496,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. == API changes in 1.16 == diff --git a/maintenance/users.sql b/maintenance/users.sql index 755bf9f700..e9d02b6527 100644 --- a/maintenance/users.sql +++ b/maintenance/users.sql @@ -4,9 +4,9 @@ -- from local settings. -- -GRANT DELETE,INSERT,SELECT,UPDATE,CREATE TEMPORARY TABLES ON `{$wgDBname}`.* +GRANT DELETE,INSERT,SELECT,UPDATE,CREATE TEMPORARY TABLES,CREATE TABLE,ALTER TABLE ON `{$wgDBname}`.* TO '{$wgDBuser}'@'%' IDENTIFIED BY '{$wgDBpassword}'; -GRANT DELETE,INSERT,SELECT,UPDATE,CREATE TEMPORARY TABLES ON `{$wgDBname}`.* +GRANT DELETE,INSERT,SELECT,UPDATE,CREATE TEMPORARY TABLES,CREATE TABLE,ALTER TABLE ON `{$wgDBname}`.* TO '{$wgDBuser}'@localhost IDENTIFIED BY '{$wgDBpassword}'; -GRANT DELETE,INSERT,SELECT,UPDATE,CREATE TEMPORARY TABLES ON `{$wgDBname}`.* +GRANT DELETE,INSERT,SELECT,UPDATE,CREATE TEMPORARY TABLES,CREATE TABLE,ALTER TABLE ON `{$wgDBname}`.* TO '{$wgDBuser}'@localhost.localdomain IDENTIFIED BY '{$wgDBpassword}'; -- 2.20.1