[development] Can someone confirm -- Minimum MySQL Privileges?

[Angie Byron]

Kieran Lal wrote:
> We should
> investigate why many cheap hosting companies do not allow lock table
> permissions, and find out how widely this will effect Drupal upgrading
> to 4.7.

One reason might be because the MySQL manual has LOCK TABLES permissions
classified as a "server administration" permission, alongside stuff like
SHUTDOWN and SUPER which you would never want to give a "peon" user:

http://dev.mysql.com/doc/refman/4.1/en/privileges-provided.html

CREATE TEMPORARY TABLES has this classification as well, although it seems like
most support requests for 4.7 have been about hosts not providing LOCK TABLES
permission.

-Angie