Discrepancy With Install Instructions.

Hello,

I am just going through a clean install of Drupal 4.7.2 and have noticed a small difference in wording between the INSTALL.mysql.txt and what is listed at http://drupal.org/node/43807. Specifically, this is regarding the GRANT statement when adding the user. The .txt file lists:

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

while the web document states:

GRANT ALL PRIVILEGES ON drupal.*
        TO nobody@localhost IDENTIFIED BY 'password';

While installing on mysql Ver 11.18 Distrib 3.23.58, for redhat-linux-gnu (i386) (The current mysql-server RPM in RedHat's RHEL WS3.0 Channel) I found that the CREATE TEMPORARY TABLES and LOCK TABLES permissions were not added until MySQL 4.0.2 according to http://dev.mysql.com/doc/refman/4.1/en/grant.html and therefore the more exact GRANT statement will not work in this instance. One must use the second GRANT.

Why RedHat is on this version, I cannot say.

Thought this may help someone.
Regards,
Jim.

$ diff -u INSTALL.mysql.txt INSTALL.mysql.txt.new

--- INSTALL.mysql.txt   2006-07-21 23:09:26.000000000 +0000
+++ INSTALL.mysql.txt.new       2006-07-21 23:16:36.000000000 +0000
@@ -1,4 +1,4 @@
-// $Id: INSTALL.mysql.txt,v 1.6 2006/04/17 20:48:25 dries Exp $
+// $Id: INSTALL.mysql.txt,v 1.6.1 2006/07/21 23:16:01 $

 CONTENTS OF THIS FILE
 ---------------------
@@ -55,6 +55,11 @@
    Note: Unless your database user has all of the privileges listed
    above, you will not be able to run Drupal.

+   Note2: For MySQL < 4.0.2, it will be necessary to use the following:
+     GRANT ALL PRIVILEGES
+     ON databasename.*
+     TO 'username'@'localhost' IDENTIFIED BY 'password';
+
    If successful, MySQL will reply with:

      Query OK, 0 rows affected