[documentation] [Documentation task] Discrepancy With Install Instructions.

[JimPhlew]

Issue status update for 
http://drupal.org/node/74929
Post a follow up: 
http://drupal.org/project/comments/add/74929

 Project:      Documentation
 Version:      <none>
 Component:    Installation
 Category:     tasks
 Priority:     minor
 Assigned to:  Anonymous
 Reported by:  JimPhlew
 Updated by:   JimPhlew
 Status:       patch (code needs review)
 Attachment:   http://drupal.org/files/issues/INSTALL.mysql.txt.patch (700 bytes)

Patch attached.




JimPhlew



Previous comments:
------------------------------------------------------------------------

Fri, 21 Jul 2006 23:18:22 +0000 : JimPhlew

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 at 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