[documentation] [Documentation task] Discrepancy With Install
Instructions.
JimPhlew
drupal-docs at drupal.org
Fri Jul 21 23:18:23 UTC 2006
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: active
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
JimPhlew
More information about the documentation
mailing list