Pursuant to the thread on the developer's list started here: http://lists.drupal.org/pipermail/development/2006-March/014732.html I'd like to make a change to the install docs to mention the MySQL permission requirements. A lot of people seem to get tripped up by the LOCK TABLES requirement in particular, and this would give a concrete list of permissions to ask a prospective web host about. Additionally, this is much more secure than the GRANT ALL privileges currently recommended which, let's face it, is a little silly. ;)

Note: There might be a similar patch needed for INSTALL.pgsql.txt, but a) I couldn't find anything from a brief look-over of the document about permissions, and b) I've never used PostgreSQL so wouldn't feel comfortable writing it.

CommentFileSizeAuthor
INSTALL-mysql.patch1.87 KBwebchick
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

greggles’s picture

Aside from this work which seems to have been abandoned (http://drupal.org/node/55516) this list seems good to me. I agree that this would be useful to have in the documentation. Support forums and issue queues get a few bugs related to these problems every couple of days...

greggles’s picture

I just realized that my first sentence only half explains itself - sorry.

Aside from some work to remove the requirement for locks that was abandoned which might necessitate updates to this...

Angie's work looks good to me and would be very useful. If we can get rid of requirements for some permission levels in the future then that's great, but until that day in the far future this looks good to me.

killes@www.drop.org’s picture

Status: Needs review » Fixed

applied

Anonymous’s picture

Status: Fixed » Closed (fixed)