summaryrefslogtreecommitdiffstats
path: root/docs/xml
diff options
context:
space:
mode:
authorjocuri%softhome.net <>2004-07-07 08:30:03 +0200
committerjocuri%softhome.net <>2004-07-07 08:30:03 +0200
commit2021015b8110d606e695038ec6fdcda5eb152a53 (patch)
tree1974c2602df47151b6e246f9cf2532bebbc22b70 /docs/xml
parent6c0b6e11bf1e302320bebe0ce9545eff924ab124 (diff)
downloadbugzilla-2021015b8110d606e695038ec6fdcda5eb152a53.tar.gz
bugzilla-2021015b8110d606e695038ec6fdcda5eb152a53.tar.xz
Documentation XML patch for bug 249802: Make the SQL example for granting SQL privs to the DB user suitable for MySQL 4.
Diffstat (limited to 'docs/xml')
-rw-r--r--docs/xml/installation.xml29
1 files changed, 17 insertions, 12 deletions
diff --git a/docs/xml/installation.xml b/docs/xml/installation.xml
index 4b5600752..cafdc0462 100644
--- a/docs/xml/installation.xml
+++ b/docs/xml/installation.xml
@@ -1,5 +1,5 @@
<!-- <!DOCTYPE chapter PUBLIC "-//OASIS//DTD DocBook XML V4.1.2//EN"> -->
-<!-- $Id: installation.xml,v 1.71 2004/04/03 18:12:08 jocuri%softhome.net Exp $ -->
+<!-- $Id: installation.xml,v 1.72 2004/07/06 23:30:03 jocuri%softhome.net Exp $ -->
<chapter id="installing-bugzilla">
<title>Installing Bugzilla</title>
@@ -672,21 +672,26 @@
Modify it to reflect your setup if you will be connecting from
another machine or as a different user.</para>
- <para>Run the <filename>mysql</filename> command-line client and
- enter:</para>
+ <para>Run the <filename>mysql</filename> command-line client.</para>
+ <para>If you are using MySQL 4.0 or newer, enter:</para>
- <screen> <prompt>mysql&gt;</prompt> GRANT SELECT,INSERT,UPDATE,DELETE,INDEX,ALTER,CREATE,
- DROP,REFERENCES ON bugs.* TO bugs@localhost
- IDENTIFIED BY '<replaceable>$db_pass</replaceable>';
+ <screen> <prompt>mysql&gt;</prompt> GRANT SELECT, INSERT,
+ UPDATE, DELETE, INDEX, ALTER, CREATE, LOCK TABLES,
+ CREATE TEMPORARY TABLES, DROP, REFERENCES ON bugs.*
+ TO bugs@localhost IDENTIFIED BY '<replaceable>$db_pass</replaceable>';
<prompt>mysql&gt;</prompt> FLUSH PRIVILEGES;</screen>
- <note>
- <para>If you are using MySQL 4, you need to add
+ <para>If you are using an older version of MySQL,
the <computeroutput>LOCK TABLES</computeroutput> and
- <computeroutput>CREATE TEMPORARY TABLES</computeroutput> permissions
- to the list.
- </para>
- </note>
+ <computeroutput>CREATE TEMPORARY TABLES</computeroutput>
+ permissions will be unavailable and should be removed from the permissions
+ list. In this case, the following command line can be used:</para>
+
+ <screen> <prompt>mysql&gt;</prompt> GRANT SELECT, INSERT,
+ UPDATE, DELETE, INDEX, ALTER, CREATE, DROP,
+ REFERENCES ON bugs.* TO bugs@localhost IDENTIFIED BY
+ '<replaceable>$db_pass</replaceable>';
+ <prompt>mysql&gt;</prompt> FLUSH PRIVILEGES;</screen>
</section>
</section>