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

Angie Byron drupal-devel at webchick.net
Mon Mar 13 23:10:18 UTC 2006

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:


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


More information about the development mailing list