On Thu, Aug 5, 2010 at 11:32 AM, Sullivan, James (NIH/CIT) [C] <[email protected]> wrote: > 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].
Right. Users created through the installer pre-1.16 only had DELETE,INSERT,SELECT,UPDATE,CREATE TEMPORARY TABLES for the database. This meant that if an update involved the creation of new tables, the update would fail. If you're able to upgrade from 1.15 to 1.16 without any problems, you either already ran into this and granted the rest of the privileges to the user, or else you originally created the database/user before running the install script (or I'm misunderstanding what you're doing). I assume you're putting your existing user in the "Superuser name" field (I'm pretty sure users.sql is only used if you've checked the "Use superuser account" box). Users can only grant permissions they have; if your existing user doesn't have all rights on the new database, it won't be able to grant them to the new user it's creating. Of course, if it has the necessary rights to create a new database, surely it ought to have all rights on that database: does someone know if there's a quirk in MySQL's behavior here? _______________________________________________ MediaWiki-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
