Author: paul
Date: 2005-11-03 06:24:57 +0100 (Thu, 03 Nov 2005)
New Revision: 232
Log:
r3336@frost: paul | 2005-11-02 23:24:37 -0600
Emphasize little-appreciated fact about SHOW DATABASES privilege.
Modified:
trunk/
trunk/refman-4.1/database-administration.xml
trunk/refman-5.0/database-administration.xml
trunk/refman-5.1/database-administration.xml
Property changes on: trunk
___________________________________________________________________
Name: svk:merge
- b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:3331
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:269
+ b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:3336
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:269
Modified: trunk/refman-4.1/database-administration.xml
===================================================================
--- trunk/refman-4.1/database-administration.xml 2005-11-03 01:11:50 UTC (rev 231)
+++ trunk/refman-4.1/database-administration.xml 2005-11-03 05:24:57 UTC (rev 232)
@@ -3353,7 +3353,8 @@
option, <literal>SHOW DATABASES</literal> is allowed to
all users, but displays each database name only if the
user has the <literal>SHOW DATABASES</literal> privilege
- or some privilege for the database.
+ or some privilege for the database. Note that any global
+ privilege is a privilege for the database.
</para>
</listitem>
@@ -6916,7 +6917,8 @@
<literal>OFF</literal>, <literal>SHOW DATABASES</literal>
is allowed to all users, but displays each database name
only if the user has the <literal>SHOW DATABASES</literal>
- privilege or some privilege for the database.
+ privilege or some privilege for the database. Note that
+ any global privilege is a privilege for the database.
</para>
</listitem>
@@ -10259,7 +10261,8 @@
<literal>SHOW DATABASES</literal> is allowed to all users,
but displays each database name only if the user has the
<literal>SHOW DATABASES</literal> privilege or some
- privilege for the database.
+ privilege for the database. Note that any global privilege
+ is a privilege for the database.
</para>
</listitem>
@@ -11513,7 +11516,8 @@
privilege see only databases for which they have some
privileges, and cannot use the statement at all if the server
was started with the <option>--skip-show-database</option>
- option.
+ option. Note that any global privilege is a privilege for the
+ database.
</para>
<para>
@@ -16892,9 +16896,9 @@
<para>
If a MySQL server has the binary log enabled, you can use the
<command>mysqlbinlog</command> utility to recover data starting
- from a specified point in time (for example, since your last backup)
- until the present or another specified point in time. For
- information on enabling the binary log, see
+ from a specified point in time (for example, since your last
+ backup) until the present or another specified point in time.
+ For information on enabling the binary log, see
<xref linkend="binary-log"/>. For more information on the
<command>mysqlbinlog</command>, see
<xref linkend="mysqlbinlog"/>.
Modified: trunk/refman-5.0/database-administration.xml
===================================================================
--- trunk/refman-5.0/database-administration.xml 2005-11-03 01:11:50 UTC (rev 231)
+++ trunk/refman-5.0/database-administration.xml 2005-11-03 05:24:57 UTC (rev 232)
@@ -4062,7 +4062,8 @@
option, <literal>SHOW DATABASES</literal> is allowed to
all users, but displays each database name only if the
user has the <literal>SHOW DATABASES</literal> privilege
- or some privilege for the database.
+ or some privilege for the database. Note that any global
+ privilege is a privilege for the database.
</para>
</listitem>
@@ -4497,14 +4498,13 @@
Produce an error in strict mode (otherwise a warning) when
we encounter a division by zero (or
<literal>MOD(X,0)</literal>) during an
- <literal>INSERT</literal> or <literal>UPDATE</literal>.
- If this mode is not given, MySQL
- instead returns <literal>NULL</literal> for divisions by
- zero. If used in <literal>INSERT IGNORE</literal> or
- <literal>UPDATE IGNORE</literal>, MySQL generates a
- warning for divisions by zero, but the result of the
- operation is <literal>NULL</literal>. (Implemented in MySQL
- 5.0.2)
+ <literal>INSERT</literal> or <literal>UPDATE</literal>. If
+ this mode is not given, MySQL instead returns
+ <literal>NULL</literal> for divisions by zero. If used in
+ <literal>INSERT IGNORE</literal> or <literal>UPDATE
+ IGNORE</literal>, MySQL generates a warning for divisions
+ by zero, but the result of the operation is
+ <literal>NULL</literal>. (Implemented in MySQL 5.0.2)
</para>
</listitem>
@@ -10642,7 +10642,7 @@
<literal>Last_query_cost</literal> was changed to session
rather than global.
</para>
-
+
<para>
Prior to MySQL 5.0.16, this variable was not updated for
queries served from the query cache.
@@ -12166,7 +12166,8 @@
<literal>SHOW DATABASES</literal> is allowed to all users,
but displays each database name only if the user has the
<literal>SHOW DATABASES</literal> privilege or some
- privilege for the database.
+ privilege for the database. Note that any global privilege
+ is a privilege for the database.
</para>
</listitem>
@@ -13557,7 +13558,8 @@
privilege see only databases for which they have some
privileges, and cannot use the statement at all if the server
was started with the <option>--skip-show-database</option>
- option.
+ option. Note that any global privilege is a privilege for the
+ database.
</para>
<para>
@@ -19025,9 +19027,9 @@
<para>
If a MySQL server has the binary log enabled, you can use the
<command>mysqlbinlog</command> utility to recover data starting
- from a specified point in time (for example, since your last backup)
- until the present or another specified point in time. For
- information on enabling the binary log, see
+ from a specified point in time (for example, since your last
+ backup) until the present or another specified point in time.
+ For information on enabling the binary log, see
<xref linkend="binary-log"/>. For more information on the
<command>mysqlbinlog</command>, see
<xref linkend="mysqlbinlog"/>.
Modified: trunk/refman-5.1/database-administration.xml
===================================================================
--- trunk/refman-5.1/database-administration.xml 2005-11-03 01:11:50 UTC (rev 231)
+++ trunk/refman-5.1/database-administration.xml 2005-11-03 05:24:57 UTC (rev 232)
@@ -4026,7 +4026,8 @@
option, <literal>SHOW DATABASES</literal> is allowed to
all users, but displays each database name only if the
user has the <literal>SHOW DATABASES</literal> privilege
- or some privilege for the database.
+ or some privilege for the database. Note that any global
+ privilege is a privilege for the database.
</para>
</listitem>
@@ -12068,7 +12069,8 @@
<literal>SHOW DATABASES</literal> is allowed to all users,
but displays each database name only if the user has the
<literal>SHOW DATABASES</literal> privilege or some
- privilege for the database.
+ privilege for the database. Note that any global privilege
+ is a privilege for the database.
</para>
</listitem>
@@ -13438,7 +13440,8 @@
privilege see only databases for which they have some
privileges, and cannot use the statement at all if the server
was started with the <option>--skip-show-database</option>
- option.
+ option. Note that any global privilege is a privilege for the
+ database.
</para>
<para>
@@ -18903,9 +18906,9 @@
<para>
If a MySQL server has the binary log enabled, you can use the
<command>mysqlbinlog</command> utility to recover data starting
- from a specified point in time (for example, since your last backup)
- until the present or another specified point in time. For
- information on enabling the binary log, see
+ from a specified point in time (for example, since your last
+ backup) until the present or another specified point in time.
+ For information on enabling the binary log, see
<xref linkend="binary-log"/>. For more information on the
<command>mysqlbinlog</command>, see
<xref linkend="mysqlbinlog"/>.
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r232 - in trunk: . refman-4.1 refman-5.0 refman-5.1 | paul | 3 Nov |
