That bug (20634)is about having privilege to create tables. During my 1.16.0 installation
tables were successfully created. It was granting the wiki database user "ALL"
privilege that was the problem because my database user does not have privilege to do
that. I believe in previous versions it granted only [select,insert,update,delete].
Also, I have successfully upgraded a 1.15.1 wiki I've had for a while to 1.16.0 with
no problems. The update.php and refreshlinks.php ran ok. So, it would seem I could
install a new wiki using 1.15.1 with my current database user's privilege, then update
to 1.16.0. Since I could do this, why is the installation requiring a higher privilege
for the new wiki's database user? New installs will have users with higher privilege
than those who upgraded from older versions. I assume both new and upgraded wikis at
version 1.16.0 will run fine, so why the change for new installations?
From: Benjamin Lees [mailto:firstname.lastname@example.org]
Sent: Wednesday, August 04, 2010 5:39 PM
To: MediaWiki announcements and site admin list
Subject: Re: [Mediawiki-l] installation issue with 1.16.0 - mysql user privilege
On Wed, Aug 4, 2010 at 4:40 PM, Sullivan, James (NIH/CIT) [C]
Have the privilege requirements for the database user
privileges changed from 1.15 to 1.16 for installing mediawiki? I did not see any mention
of this in the release notes.
Yes, it's in the release notes (though it's buried pretty deep):
(bug 20634) The installer-created database user will now have all
rights on the database so that upgrades will go more smoothly.
MediaWiki-l mailing list