From 55b4468a3fda4f41e64fdee01a8e9c5290436c3c Mon Sep 17 00:00:00 2001 From: "jake%bugzilla.org" <> Date: Tue, 23 Nov 2004 18:55:01 +0000 Subject: [PATCH] Bug 264227: The MySQL statement for granting permission to the 'bugs' user was being truncated in the PDF version of the 2.16 documentation. Patch by GavinS r=jake --- docs/xml/installation.xml | 65 ++++++++++++--------------------------- 1 file changed, 19 insertions(+), 46 deletions(-) diff --git a/docs/xml/installation.xml b/docs/xml/installation.xml index f9e1efd7d4..7a5ec30ca4 100644 --- a/docs/xml/installation.xml +++ b/docs/xml/installation.xml @@ -670,52 +670,25 @@ AllowOverride Limit Remember to set <bugs_password> to some unique password. - If you are using MySQL 4.0 or newer, enter: - - - - mysql> - - GRANT SELECT,INSERT,UPDATE,DELETE,INDEX, - ALTER,CREATE,DROP,LOCK TABLES,CREATE TEMPORARY - TABLES,REFERENCES ON bugs.* TO bugs@localhost - IDENTIFIED BY '<bugs_password>'; - - - - - - mysql> - - FLUSH PRIVILEGES; - - - - - - If you are using an older version of MySQL, - the LOCK TABLES and CREATE TEMPORARY TABLES permissions - need to be removed from the list: - - - - mysql> - - GRANT SELECT,INSERT,UPDATE,DELETE,INDEX, - ALTER,CREATE,DROP,REFERENCES ON bugs.* TO bugs@localhost - IDENTIFIED BY '<bugs_password>'; - - - - - - mysql> - - FLUSH PRIVILEGES; - - - - + If you are using MySQL 4.0 or newer, enter: + + mysql> GRANT SELECT, INSERT, + UPDATE, DELETE, INDEX, ALTER, CREATE, LOCK TABLES, + CREATE TEMPORARY TABLES, DROP, REFERENCES ON bugs.* + TO bugs@localhost IDENTIFIED BY '$db_pass'; + mysql> FLUSH PRIVILEGES; + + If you are using an older version of MySQL, + the LOCK TABLES and + CREATE TEMPORARY TABLES + permissions will be unavailable and should be removed from the permissions + list. In this case, the following command line can be used: + + mysql> GRANT SELECT, INSERT, + UPDATE, DELETE, INDEX, ALTER, CREATE, DROP, + REFERENCES ON bugs.* TO bugs@localhost IDENTIFIED BY + '$db_pass'; + mysql> FLUSH PRIVILEGES;
-- 2.47.2