diff options
| author | jocuri%softhome.net <> | 2008-04-04 13:47:02 +0200 |
|---|---|---|
| committer | jocuri%softhome.net <> | 2008-04-04 13:47:02 +0200 |
| commit | 2e7e04b360412acf628ef5d27f933b0d0c23dc39 (patch) | |
| tree | bf87c40673c43acdb4fecd59dbfc325ebed5280a | |
| parent | 5b38103bce29e0d777182fbc12f9e702cedc9b85 (diff) | |
| download | bugzilla-2e7e04b360412acf628ef5d27f933b0d0c23dc39.tar.gz bugzilla-2e7e04b360412acf628ef5d27f933b0d0c23dc39.tar.xz | |
Documentation XML patch for bug 249802: Make the SQL example for granting SQL privs to the DB user suitable for MySQL 4.
| -rw-r--r-- | docs/en/xml/installation.xml | 29 |
1 files changed, 17 insertions, 12 deletions
diff --git a/docs/en/xml/installation.xml b/docs/en/xml/installation.xml index fab350e08..77ee3fc49 100644 --- a/docs/en/xml/installation.xml +++ b/docs/en/xml/installation.xml @@ -1,5 +1,5 @@ <!-- <!DOCTYPE chapter PUBLIC "-//OASIS//DTD DocBook XML V4.1.2//EN"> --> -<!-- $Id: installation.xml,v 1.71 2008/04/04 06:47:01 jocuri%softhome.net Exp $ --> +<!-- $Id: installation.xml,v 1.72 2008/04/04 06:47:02 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></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></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></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></prompt> GRANT SELECT, INSERT, + UPDATE, DELETE, INDEX, ALTER, CREATE, DROP, + REFERENCES ON bugs.* TO bugs@localhost IDENTIFIED BY + '<replaceable>$db_pass</replaceable>'; + <prompt>mysql></prompt> FLUSH PRIVILEGES;</screen> </section> </section> |