svn commit - mysqldoc@docsrva: r1195 - in trunk: refman-4.1 refman-5.0 refman-5.1

[stefan]

Author: shinz
Date: 2006-02-02 23:16:42 +0100 (Thu, 02 Feb 2006)
New Revision: 1195

Log:
Clarifiy how to make slave NOT monkey privilege-related SQL statements (thanks, Guilhem.
This closes bug #16486)

Modified:
   trunk/refman-4.1/replication.xml
   trunk/refman-5.0/replication.xml
   trunk/refman-5.1/replication.xml

Modified: trunk/refman-4.1/replication.xml
===================================================================
--- trunk/refman-4.1/replication.xml	2006-02-02 21:13:45 UTC (rev 1194)
+++ trunk/refman-4.1/replication.xml	2006-02-02 22:16:42 UTC (rev 1195)
@@ -1690,31 +1690,29 @@
           avoid 4.1.0 in a replication scenario.)
         </para>
       </listitem>
-<!-- closes bug #16486 - remove after Guilhem OK - copy to 5.0 and 5.1 - adapt
-  for 4.1/5.0/5.1      
-<listitem>
-  <para>
-    User privileges are replicated only if the <literal>mysql</literal>
-    database is replicated. That is, the <literal>GRANT</literal>,
-    <literal>REVOKE</literal>, <literal>SET PASSWORD</literal>,
-    <literal>CREATE USER</literal>, and <literal>DROP
USER</literal>
-    statements take effect on the slave only if the replication setup
-    includes the <literal>mysql</literal> database.
-  </para>
-  <para>
-    If you're replicating all databases, but don't want statements
-    that affect user privileges to be replicated, there's no way to
-    instruct a slave to not replicate privilege-related statements. A
-    simple workaround, however, is to set up the slave to not replicate
-    the <literal>mysql</literal> database, using the
-    <option>- -replicate-wild-ignore-table=mysql.%</option> option. That
-    option is available as of MySQL 4.0.13. The slave will still issue
-    privilege-related SQL statements, but they won't take effect.
-  </para>
-</listitem>
--->
+      
       <listitem>
         <para>
+          User privileges are replicated only if the <literal>mysql</literal>
+          database is replicated. That is, the <literal>GRANT</literal>,
+          <literal>REVOKE</literal>, <literal>SET
PASSWORD</literal>,
+          and <literal>DROP USER</literal> (available as of MySQL 4.1.1)
+          statements take effect on the slave only if the replication setup
+          includes the <literal>mysql</literal> database.
+        </para>
+        <para>
+          If you're replicating all databases, but don't want statements
+          that affect user privileges to be replicated, set up the slave to not
+          replicate the <literal>mysql</literal> database, using the
+          <option>--replicate-wild-ignore-table=mysql.%</option> option. That
+          option is available as of MySQL 4.0.13. The slave will recognize that
+          issuing privilege-related SQL statements won't have an effect, and thus not
+          execute those statements.
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
           The <literal>GET_LOCK()</literal>,
           <literal>RELEASE_LOCK()</literal>,
           <literal>IS_FREE_LOCK()</literal>, and

Modified: trunk/refman-5.0/replication.xml
===================================================================
--- trunk/refman-5.0/replication.xml	2006-02-02 21:13:45 UTC (rev 1194)
+++ trunk/refman-5.0/replication.xml	2006-02-02 22:16:42 UTC (rev 1195)
@@ -1629,6 +1629,25 @@
 
       <listitem>
         <para>
+          User privileges are replicated only if the <literal>mysql</literal>
+          database is replicated. That is, the <literal>GRANT</literal>,
+          <literal>REVOKE</literal>, <literal>SET
PASSWORD</literal>,
+          <literal>CREATE USER</literal>, and <literal>DROP
USER</literal>
+          statements take effect on the slave only if the replication setup
+          includes the <literal>mysql</literal> database.
+        </para>
+        <para>
+          If you're replicating all databases, but don't want statements
+          that affect user privileges to be replicated, set up the slave to not
+          replicate the <literal>mysql</literal> database, using the
+          <option>--replicate-wild-ignore-table=mysql.%</option> option. The
+          slave will recognize that issuing privilege-related SQL statements
+          won't have an effect, and thus not execute those statements.
+        </para>
+      </listitem>
+      
+      <listitem>
+        <para>
           The <literal>GET_LOCK()</literal>,
           <literal>RELEASE_LOCK()</literal>,
           <literal>IS_FREE_LOCK()</literal>, and

Modified: trunk/refman-5.1/replication.xml
===================================================================
--- trunk/refman-5.1/replication.xml	2006-02-02 21:13:45 UTC (rev 1194)
+++ trunk/refman-5.1/replication.xml	2006-02-02 22:16:42 UTC (rev 1195)
@@ -1791,6 +1791,25 @@
 
       <listitem>
         <para>
+          User privileges are replicated only if the <literal>mysql</literal>
+          database is replicated. That is, the <literal>GRANT</literal>,
+          <literal>REVOKE</literal>, <literal>SET
PASSWORD</literal>,
+          <literal>CREATE USER</literal>, and <literal>DROP
USER</literal>
+          statements take effect on the slave only if the replication setup
+          includes the <literal>mysql</literal> database.
+        </para>
+        <para>
+          If you're replicating all databases, but don't want statements
+          that affect user privileges to be replicated, set up the slave to not
+          replicate the <literal>mysql</literal> database, using the
+          <option>--replicate-wild-ignore-table=mysql.%</option> option. The
+          slave will recognize that issuing privilege-related SQL statements
+          won't have an effect, and thus not execute those statements.
+        </para>
+      </listitem>
+      
+      <listitem>
+        <para>
           <emphasis>The following restriction applies to statement-based
           replication only, not to row-based replication.</emphasis> The
           <literal>GET_LOCK()</literal>,