Sullivan, James (NIH/CIT) [C] wrote:
Yes, I think this is the problem, that my superuser is
missing a privilege or two. Since the error is trying to add "ALL" privilege to
the database_user, you would pretty much have to use the mysql root account to do the
installation, which is likely the way most if not all installers do it. I have a security
conscious mysql admin so the superuser account I have does not have ALL privilege.
But it seems strange that the 1.16.0 installation wants to give ALL privilege to the
database_user it creates when it does not need ALL privilege, as proved by my ability to
run update.php to upgrade from 1.15.1 to 1.16.0. I'm guessing they are planning for
the future since it is not necessary now.
That's what bug 20634. In some cases there were problems in updates due
to not being able to CREATE/ALTER tables, thus what r56285 does.
Give the installer-created database user CREATE TABLE
and ALTER TABLE rights so that upgrades will go more smoothly