THe INSTALL.mysql.txt file that comes with the Drupal 6.12 core package states:

.
Again, you will be asked for the 'username' database password. At the MySQL
prompt, enter following command:

  GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER
  ON databasename.*
  TO 'username'@'localhost' IDENTIFIED BY 'password';

Note: Unless your database user has all of the privileges listed above, you will
not be able to run Drupal.

However, http://drupal.org/requirements states:

Some contributed modules, and also Drupal core 5.x, additionally require the following rights:
CREATE TEMPORARY TABLES, LOCK TABLES.

IMHO, these two sources of information are confusing to anyone installing Drupal for the first time, due to:

http://drupal.org/requirements states that "Drupal core 5.x requires CREATE TEMPORARY TABLES, LOCK TABLES."

This begs the obvious question: "What about Drupal core 6.x? Does it require CREATE TEMPORARY TABLES, LOCK TABLES.?"

If Drupal core 6.x does require it then both INSTALL.mysql.txt and http://drupal.org/requirements should be updated.

Comments

vm’s picture

vm commented

Drupal core 6.x and above does not require those extra permissions on the datasbase that Drupal 5.x did which is why they are not mentioned in the INSTALL.txt and why drupal 5.x is specifically noted to need them.

I don't see the confusion here, but if you would prefer a rewording of the documentation page or the install.txt please offer that rewrording.

jhodgdon’s picture

jhodgdon
she/her
Primary language English
commented
Status: Active » Fixed

I agree that the text could lead to confusion. So I added a parenthetical note to http://drupal.org/requirements to say those rights are not needed by core 6.x.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

MakeOnlineShop’s picture

MakeOnlineShop commented

Hello,

Sorry to interfere but as you seem good at Mysql I dare to ask :-)

I have many users who have never logged in and I would like to set them as having logged once at least.

The reason is that I would like inactive users to be deleted but Inactive users module does not delete users who have never logged in (the only option is DELETE USERS WHO HAVEN'T LOGGED IN since...).
http://drupal.org/project/inactive_user

I want to use this module because it will send a last Email to users on deletion.

Thank you for your help.

leehunter’s picture

leehunter commented
Project: Documentation » Inactive User
Version: » 7.x-1.x-dev
Component: Correction/Clarification » Miscellaneous
Category: feature » support
Status: Closed (fixed) » Active

Moving to the right issue queue and changing to support request

leehunter’s picture

leehunter commented
Project: Inactive User » Documentation
Version: 7.x-1.x-dev »
Component: Miscellaneous » Correction/Clarification
Category: support » task
Status: Active » Fixed

Sorry. Putting back into documentation queue and marking as fixed.

make-online-shop you need to open a new issue in the Active User module issue queue

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.