On Thu, Aug 5, 2010 at 11:32 AM, Sullivan, James (NIH/CIT) [C]
<sullivan(a)mail.nih.gov> 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?