Below is the list of changes that have just been committed into a local
mysqldoc repository of paul. When paul does a push these changes will
be propagated to the main repository and, within 24 hours after the
push, to the public repository.
For information on how to access the public repository
see http://www.mysql.com/doc/I/n/Installing_source_tree.html
ChangeSet
1.3207 05/08/08 14:39:27 paul@stripped +4 -0
Replace tags.
refman/mysql-database-administration.xml
1.44 05/08/08 14:39:25 paul@stripped +179 -180
Replace tags.
refman-5.1/mysql-database-administration.xml
1.3 05/08/08 14:39:25 paul@stripped +150 -149
Replace tags.
refman-5.0/mysql-database-administration.xml
1.4 05/08/08 14:39:25 paul@stripped +251 -222
Replace tags.
refman-4.1/mysql-database-administration.xml
1.35 05/08/08 14:39:25 paul@stripped +30 -29
Replace tags.
# This is a BitKeeper patch. What follows are the unified diffs for the
# set of deltas contained in the patch. The rest of the patch, the part
# that BitKeeper cares about, is below these diffs.
# User: paul
# Host: kite-hub.kitebird.com
# Root: /src/extern/MySQL/bk/mysqldoc
--- 1.2/refman-5.1/mysql-database-administration.xml 2005-08-08 13:40:18 -05:00
+++ 1.3/refman-5.1/mysql-database-administration.xml 2005-08-08 14:39:25 -05:00
@@ -2520,19 +2520,19 @@
<listitem>
<para>
- <literal>--help, -?</literal>
+ <option>--help</option>, <option>-?</option>
</para>
<para>
Display a short help message and exit. Use both the
- <literal>--verbose</literal> and <literal>--help</literal>
+ <option>--verbose</option> and <option>--help</option>
options to see the full message.
</para>
</listitem>
<listitem>
<para>
- <literal>--allow-suspicious-udfs</literal>
+ <option>--allow-suspicious-udfs</option>
</para>
<para>
@@ -2549,21 +2549,21 @@
<listitem>
<para>
- <literal>--ansi</literal>
+ <option>--ansi</option>
</para>
<para>
Use standard (ANSI) SQL syntax instead of MySQL syntax. See
<xref linkend="ansi-mode"/>. For more precise control over
- the server SQL mode, use the <literal>--sql-mode</literal>
+ the server SQL mode, use the <option>--sql-mode</option>
option instead.
</para>
</listitem>
<listitem>
<para>
- <literal>--basedir=<replaceable>path</replaceable>, -b
- <replaceable>path</replaceable></literal>
+ <option>--basedir=<replaceable>path</replaceable>, -b
+ <replaceable>path</replaceable></option>
</para>
<para>
@@ -2594,7 +2594,7 @@
<listitem>
<para>
- <literal>--bind-address=<replaceable>IP</replaceable></literal>
+ <option>--bind-address=<replaceable>IP</replaceable></option>
</para>
<para>
@@ -2604,13 +2604,13 @@
<listitem>
<para>
- <literal>--console</literal>
+ <option>--console</option>
</para>
<para>
Write error log messages to <literal>stderr</literal> and
<literal>stdout</literal> even if
- <literal>--log-error</literal> is specified. On Windows,
+ <option>--log-error</option> is specified. On Windows,
<command>mysqld</command> does not close the console screen
if this option is used.
</para>
@@ -2618,7 +2618,7 @@
<listitem>
<para>
- <literal>--character-sets-dir=<replaceable>path</replaceable></literal>
+ <option>--character-sets-dir=<replaceable>path</replaceable></option>
</para>
<para>
@@ -2629,7 +2629,7 @@
<listitem>
<para>
- <literal>--chroot=<replaceable>path</replaceable></literal>
+ <option>--chroot=<replaceable>path</replaceable></option>
</para>
<para>
@@ -2644,7 +2644,7 @@
<listitem>
<para>
- <literal>--character-set-server=<replaceable>charset</replaceable></literal>
+ <option>--character-set-server=<replaceable>charset</replaceable></option>
</para>
<para>
@@ -2655,23 +2655,23 @@
<listitem>
<para>
- <literal>--core-file</literal>
+ <option>--core-file</option>
</para>
<para>
Write a core file if <command>mysqld</command> dies. For
some systems, you must also specify the
- <literal>--core-file-size</literal> option to
+ <option>--core-file-size</option> option to
<command>mysqld_safe</command>. See
<xref linkend="mysqld-safe"/>. Note that on some systems,
such as Solaris, you do not get a core file if you are also
- using the <literal>--user</literal> option.
+ using the <option>--user</option> option.
</para>
</listitem>
<listitem>
<para>
- <literal>--collation-server=<replaceable>collation</replaceable></literal>
+ <option>--collation-server=<replaceable>collation</replaceable></option>
</para>
<para>
@@ -2682,8 +2682,8 @@
<listitem>
<para>
- <literal>--datadir=<replaceable>path</replaceable>, -h
- <replaceable>path</replaceable></literal>
+ <option>--datadir=<replaceable>path</replaceable>, -h
+ <replaceable>path</replaceable></option>
</para>
<para>
@@ -2693,12 +2693,13 @@
<listitem>
<para>
- <literal>--debug[=<replaceable>debug_options</replaceable>],
- -# [<replaceable>debug_options</replaceable>]</literal>
+ <option>--debug[=<replaceable>debug_options</replaceable>]</option>,
+ <option>-#
+ [<replaceable>debug_options</replaceable>]</option>
</para>
<para>
- If MySQL is configured with <literal>--with-debug</literal>,
+ If MySQL is configured with <option>--with-debug</option>,
you can use this option to get a trace file of what
<command>mysqld</command> is doing. The
<replaceable>debug_options</replaceable> string often is
@@ -2710,44 +2711,44 @@
<listitem>
<para>
(<emphasis>DEPRECATED</emphasis>)
- <literal>--default-character-set=<replaceable>charset</replaceable></literal>
+ <option>--default-character-set=<replaceable>charset</replaceable></option>
</para>
<para>
Use <replaceable>charset</replaceable> as the default
character set. This option is deprecated in favor of
- <literal>--character-set-server</literal>. See
+ <option>--character-set-server</option>. See
<xref linkend="character-sets"/>.
</para>
</listitem>
<listitem>
<para>
- <literal>--default-collation=<replaceable>collation</replaceable></literal>
+ <option>--default-collation=<replaceable>collation</replaceable></option>
</para>
<para>
Use <replaceable>collation</replaceable> as the default
collation. This option is deprecated in favor of
- <literal>--collation-server</literal>. See
+ <option>--collation-server</option>. See
<xref linkend="character-sets"/>.
</para>
</listitem>
<listitem>
<para>
- <literal>--default-storage-engine=<replaceable>type</replaceable></literal>
+ <option>--default-storage-engine=<replaceable>type</replaceable></option>
</para>
<para>
This option is a synonym for
- <literal>--default-table-type</literal>.
+ <option>--default-table-type</option>.
</para>
</listitem>
<listitem>
<para>
- <literal>--default-table-type=<replaceable>type</replaceable></literal>
+ <option>--default-table-type=<replaceable>type</replaceable></option>
</para>
<para>
@@ -2758,7 +2759,7 @@
<listitem>
<para>
- <literal>--default-time-zone=<replaceable>type</replaceable></literal>
+ <option>--default-time-zone=<replaceable>type</replaceable></option>
</para>
<para>
@@ -2772,7 +2773,7 @@
<listitem>
<para>
- <literal>--delay-key-write[= OFF | ON | ALL]</literal>
+ <option>--delay-key-write[= OFF | ON | ALL]</option>
</para>
<para>
@@ -2800,7 +2801,7 @@
<listitem>
<para>
- <literal>--des-key-file=<replaceable>file_name</replaceable></literal>
+ <option>--des-key-file=<replaceable>file_name</replaceable></option>
</para>
<para>
@@ -2812,7 +2813,7 @@
<listitem>
<para>
- <literal>--enable-named-pipe</literal>
+ <option>--enable-named-pipe</option>
</para>
<para>
@@ -2826,8 +2827,8 @@
<listitem>
<para>
- <literal>--exit-info[=<replaceable>flags</replaceable>], -T
- [<replaceable>flags</replaceable>]</literal>
+ <option>--exit-info[=<replaceable>flags</replaceable>]</option>,
+ <option>-T [<replaceable>flags</replaceable>]</option>
</para>
<para>
@@ -2840,7 +2841,7 @@
<listitem>
<para>
- <literal>--external-locking</literal>
+ <option>--external-locking</option>
</para>
<para>
@@ -2848,7 +2849,7 @@
system on which <literal>lockd</literal> does not fully work
(as on Linux), it is easy for <command>mysqld</command> to
deadlock. This option previously was named
- <literal>--enable-locking</literal>.
+ <option>--enable-locking</option>.
</para>
<para>
@@ -2870,7 +2871,7 @@
<listitem>
<para>
You should not use
- <literal>--delay-key-write=ALL</literal> or
+ <option>--delay-key-write=ALL</option> or
<literal>DELAY_KEY_WRITE=1</literal> on any shared
tables.
</para>
@@ -2880,9 +2881,8 @@
<para>
The easiest way to ensure this is to always use
- <literal>--external-locking</literal> together with
- <literal>--delay-key-write=OFF
- --query-cache-size=0</literal>.
+ <option>--external-locking</option> together with
+ <option>--delay-key-write=OFF --query-cache-size=0</option>.
</para>
<para>
@@ -2893,7 +2893,7 @@
<listitem>
<para>
- <literal>--flush</literal>
+ <option>--flush</option>
</para>
<para>
@@ -2906,7 +2906,7 @@
<listitem>
<para>
- <literal>--init-file=<replaceable>file</replaceable></literal>
+ <option>--init-file=<replaceable>file</replaceable></option>
</para>
<para>
@@ -2918,7 +2918,7 @@
<listitem>
<para>
- <literal>--innodb-safe-binlog</literal>
+ <option>--innodb-safe-binlog</option>
</para>
<para>
@@ -2930,8 +2930,8 @@
<listitem>
<para>
- <literal>--language=<replaceable>lang_name</replaceable>, -L
- <replaceable>lang_name</replaceable></literal>
+ <option>--language=<replaceable>lang_name</replaceable>, -L
+ <replaceable>lang_name</replaceable></option>
</para>
<para>
@@ -2945,7 +2945,7 @@
<listitem>
<para>
- <literal>--large-pages</literal>
+ <option>--large-pages</option>
</para>
<para>
@@ -2980,8 +2980,8 @@
<listitem>
<para>
- <literal>--log[=<replaceable>file</replaceable>], -l
- [<replaceable>file</replaceable>]</literal>
+ <option>--log[=<replaceable>file</replaceable>]</option>,
+ <option>-l [<replaceable>file</replaceable>]</option>
</para>
<para>
@@ -2995,7 +2995,7 @@
<listitem>
<para>
- <literal>--log-bin=[<replaceable>file</replaceable>]</literal>
+ <option>--log-bin=[<replaceable>file</replaceable>]</option>
</para>
<para>
@@ -3011,14 +3011,14 @@
<listitem>
<para>
- <literal>--log-bin-index[=<replaceable>file</replaceable>]</literal>
+ <option>--log-bin-index[=<replaceable>file</replaceable>]</option>
</para>
<para>
The index file for binary log filenames. See
<xref linkend="binary-log"/>. If you don't specify a
filename, and if you didn't specify one in
- <literal>--log-bin</literal>, MySQL uses
+ <option>--log-bin</option>, MySQL uses
<filename><replaceable>host_name</replaceable>-bin.index</filename>
as the filename.
</para>
@@ -3046,7 +3046,7 @@
<listitem>
<para>
- <literal>--log-error[=<replaceable>file</replaceable>]</literal>
+ <option>--log-error[=<replaceable>file</replaceable>]</option>
</para>
<para>
@@ -3061,7 +3061,7 @@
<listitem>
<para>
- <literal>--log-isam[=<replaceable>file</replaceable>]</literal>
+ <option>--log-isam[=<replaceable>file</replaceable>]</option>
</para>
<para>
@@ -3074,7 +3074,7 @@
<listitem>
<para>
(<emphasis>DEPRECATED</emphasis>)
- <literal>--log-long-format</literal>
+ <option>--log-long-format</option>
</para>
<para>
@@ -3083,8 +3083,8 @@
For example, username and timestamp are logged for all
queries. This option is deprecated in MySQL 5.0, as it now
represents the default logging behaviour. (See the
- description for <literal>--log-short-format</literal>.) The
- <literal>--log-queries-not-using-indexes</literal> option is
+ description for <option>--log-short-format</option>.) The
+ <option>--log-queries-not-using-indexes</option> option is
available for the purpose of logging queries that do not use
indexes to the slow query log.
</para>
@@ -3092,12 +3092,12 @@
<listitem>
<para>
- <literal>--log-queries-not-using-indexes</literal>
+ <option>--log-queries-not-using-indexes</option>
</para>
<para>
If you are using this option with
- <literal>--log-slow-queries</literal>, then queries that are
+ <option>--log-slow-queries</option>, then queries that are
not using indexes also are logged to the slow query log. See
<xref linkend="slow-query-log"/>.
</para>
@@ -3105,7 +3105,7 @@
<listitem>
<para>
- <literal>--log-short-format</literal>
+ <option>--log-short-format</option>
</para>
<para>
@@ -3118,7 +3118,7 @@
<listitem>
<para>
- <literal>--log-slow-admin-statements</literal>
+ <option>--log-slow-admin-statements</option>
</para>
<para>
@@ -3130,21 +3130,21 @@
<listitem>
<para>
- <literal>--log-slow-queries[=<replaceable>file</replaceable>]</literal>
+ <option>--log-slow-queries[=<replaceable>file</replaceable>]</option>
</para>
<para>
Log all queries that have taken more than
<literal>long_query_time</literal> seconds to execute to
this file. See <xref linkend="slow-query-log"/>. See the
- descriptions of the <literal>--log-long-format</literal> and
- <literal>--log-short-format</literal> options for details.
+ descriptions of the <option>--log-long-format</option> and
+ <option>--log-short-format</option> options for details.
</para>
</listitem>
<listitem>
<para>
- <literal>--log-warnings, -W</literal>
+ <option>--log-warnings</option>, <option>-W</option>
</para>
<para>
@@ -3154,7 +3154,7 @@
(you get more information about what is happening, such as
messages about network failures and reconnections). This
option is enabled by default in MySQL 5.0; to disable it,
- use <literal>--skip-log-warnings</literal>. Aborted
+ use <option>--skip-log-warnings</option>. Aborted
connections are not logged to the error log unless the value
is greater than 1. See
<xref linkend="communication-errors"/>.
@@ -3163,7 +3163,7 @@
<listitem>
<para>
- <literal>--low-priority-updates</literal>
+ <option>--low-priority-updates</option>
</para>
<para>
@@ -3180,7 +3180,7 @@
<listitem>
<para>
- <literal>--memlock</literal>
+ <option>--memlock</option>
</para>
<para>
@@ -3197,8 +3197,8 @@
<listitem>
<para>
- <literal>--myisam-recover
- [=<replaceable>option</replaceable>[,<replaceable>option</replaceable>...]]]</literal>
+ <option>--myisam-recover
+ [=<replaceable>option</replaceable>[,<replaceable>option</replaceable>...]]]</option>
</para>
<para>
@@ -3213,7 +3213,7 @@
<literal>MyISAM</literal> table, checks whether the table is
marked as crashed or wasn't closed properly. (The last
option works only if you are running with
- <literal>--skip-external-locking</literal>.) If this is the
+ <option>--skip-external-locking</option>.) If this is the
case, <command>mysqld</command> runs a check on the table.
If the table was corrupted, <command>mysqld</command>
attempts to repair it.
@@ -3234,8 +3234,7 @@
</row>
<row>
<entry><literal>DEFAULT</literal></entry>
- <entry>The same as not giving any option to
- <literal>--myisam-recover</literal>.</entry>
+ <entry>The same as not giving any option to <option>--myisam-recover</option>.</entry>
</row>
<row>
<entry><literal>BACKUP</literal></entry>
@@ -3270,7 +3269,7 @@
<listitem>
<para>
- <literal>--ndb-connectstring=<replaceable>connect_string</replaceable></literal>
+ <option>--ndb-connectstring=<replaceable>connect_string</replaceable></option>
</para>
<para>
@@ -3284,7 +3283,7 @@
<listitem>
<para>
- <literal>--ndbcluster</literal>
+ <option>--ndbcluster</option>
</para>
<para>
@@ -3297,7 +3296,7 @@
<listitem>
<para>
- <literal>--old-passwords</literal>
+ <option>--old-passwords</option>
</para>
<para>
@@ -3326,7 +3325,7 @@
<listitem>
<para>
- <literal>--one-thread</literal>
+ <option>--one-thread</option>
</para>
<para>
@@ -3338,7 +3337,7 @@
<listitem>
<para>
- <literal>--open-files-limit=<replaceable>count</replaceable></literal>
+ <option>--open-files-limit=<replaceable>count</replaceable></option>
</para>
<para>
@@ -3357,7 +3356,7 @@
<listitem>
<para>
- <literal>--pid-file=<replaceable>path</replaceable></literal>
+ <option>--pid-file=<replaceable>path</replaceable></option>
</para>
<para>
@@ -3368,8 +3367,8 @@
<listitem>
<para>
- <literal>--port=<replaceable>port_num</replaceable>, -P
- <replaceable>port_num</replaceable></literal>
+ <option>--port=<replaceable>port_num</replaceable>, -P
+ <replaceable>port_num</replaceable></option>
</para>
<para>
@@ -3380,7 +3379,7 @@
<listitem>
<para>
- <literal>--safe-mode</literal>
+ <option>--safe-mode</option>
</para>
<para>
@@ -3391,7 +3390,7 @@
<listitem>
<para>
(<emphasis>DEPRECATED</emphasis>)
- <literal>--safe-show-database</literal>
+ <option>--safe-show-database</option>
</para>
<para>
@@ -3401,7 +3400,7 @@
<listitem>
<para>
- <literal>--safe-user-create</literal>
+ <option>--safe-user-create</option>
</para>
<para>
@@ -3415,7 +3414,7 @@
<listitem>
<para>
- <literal>--secure-auth</literal>
+ <option>--secure-auth</option>
</para>
<para>
@@ -3426,7 +3425,7 @@
<listitem>
<para>
- <literal>--shared-memory</literal>
+ <option>--shared-memory</option>
</para>
<para>
@@ -3437,7 +3436,7 @@
<listitem>
<para>
- <literal>--shared-memory-base-name=<replaceable>name</replaceable></literal>
+ <option>--shared-memory-base-name=<replaceable>name</replaceable></option>
</para>
<para>
@@ -3448,7 +3447,7 @@
<listitem>
<para>
- <literal>--skip-bdb</literal>
+ <option>--skip-bdb</option>
</para>
<para>
@@ -3460,7 +3459,7 @@
<listitem>
<para>
- <literal>--skip-concurrent-insert</literal>
+ <option>--skip-concurrent-insert</option>
</para>
<para>
@@ -3472,7 +3471,7 @@
<listitem>
<para>
- <literal>--skip-external-locking</literal>
+ <option>--skip-external-locking</option>
</para>
<para>
@@ -3487,7 +3486,7 @@
<listitem>
<para>
- <literal>--skip-grant-tables</literal>
+ <option>--skip-grant-tables</option>
</para>
<para>
@@ -3505,7 +3504,7 @@
<listitem>
<para>
- <literal>--skip-host-cache</literal>
+ <option>--skip-host-cache</option>
</para>
<para>
@@ -3517,7 +3516,7 @@
<listitem>
<para>
- <literal>--skip-innodb</literal>
+ <option>--skip-innodb</option>
</para>
<para>
@@ -3530,7 +3529,7 @@
<listitem>
<para>
- <literal>--skip-name-resolve</literal>
+ <option>--skip-name-resolve</option>
</para>
<para>
@@ -3544,7 +3543,7 @@
<listitem>
<para>
- <literal>--skip-ndbcluster</literal>
+ <option>--skip-ndbcluster</option>
</para>
<para>
@@ -3553,16 +3552,16 @@
<literal>NDB Cluster</literal> storage engine support, this
means that the system allocates memory and other resources
for this storage engine only if
- <literal>--skip-ndbcluster</literal> is explicitly
- overridden using the <literal>--ndbcluster</literal> option.
- See <xref linkend="mysql-cluster-quick"/> for an example of
+ <option>--skip-ndbcluster</option> is explicitly overridden
+ using the <option>--ndbcluster</option> option. See
+ <xref linkend="mysql-cluster-quick"/> for an example of
usage.
</para>
</listitem>
<listitem>
<para>
- <literal>--skip-networking</literal>
+ <option>--skip-networking</option>
</para>
<para>
@@ -3576,7 +3575,7 @@
<listitem>
<para>
- <literal>--standalone</literal>
+ <option>--standalone</option>
</para>
<para>
@@ -3587,7 +3586,8 @@
<listitem>
<para>
- <literal>--symbolic-links, --skip-symbolic-links</literal>
+ <option>--symbolic-links</option>,
+ <option>--skip-symbolic-links</option>
</para>
<para>
@@ -3625,22 +3625,22 @@
<listitem>
<para>
- <literal>--skip-safemalloc</literal>
+ <option>--skip-safemalloc</option>
</para>
<para>
If MySQL is configured with
- <literal>--with-debug=full</literal>, all MySQL programs
- check for memory overruns during each memory allocation and
- memory freeing operation. This checking is very slow, so for
- the server you can avoid it when you don't need it by using
- the <literal>--skip-safemalloc</literal> option.
+ <option>--with-debug=full</option>, all MySQL programs check
+ for memory overruns during each memory allocation and memory
+ freeing operation. This checking is very slow, so for the
+ server you can avoid it when you don't need it by using the
+ <option>--skip-safemalloc</option> option.
</para>
</listitem>
<listitem>
<para>
- <literal>--skip-show-database</literal>
+ <option>--skip-show-database</option>
</para>
<para>
@@ -3657,7 +3657,7 @@
<listitem>
<para>
- <literal>--skip-stack-trace</literal>
+ <option>--skip-stack-trace</option>
</para>
<para>
@@ -3670,7 +3670,7 @@
<listitem>
<para>
- <literal>--skip-thread-priority</literal>
+ <option>--skip-thread-priority</option>
</para>
<para>
@@ -3680,7 +3680,7 @@
<listitem>
<para>
- <literal>--socket=<replaceable>path</replaceable></literal>
+ <option>--socket=<replaceable>path</replaceable></option>
</para>
<!--
@@ -3706,7 +3706,7 @@
<listitem>
<para>
- <literal>--sql-mode=<replaceable>value</replaceable>[,<replaceable>value</replaceable>[,<replaceable>value</replaceable>...]]</literal>
+ <option>--sql-mode=<replaceable>value</replaceable>[,<replaceable>value</replaceable>[,<replaceable>value</replaceable>...]]</option>
</para>
<para>
@@ -3717,7 +3717,7 @@
<listitem>
<para>
- <literal>--temp-pool</literal>
+ <option>--temp-pool</option>
</para>
<para>
@@ -3733,7 +3733,7 @@
<listitem>
<para>
- <literal>--transaction-isolation=<replaceable>level</replaceable></literal>
+ <option>--transaction-isolation=<replaceable>level</replaceable></option>
</para>
<para>
@@ -3748,8 +3748,8 @@
<listitem>
<para>
- <literal>--tmpdir=<replaceable>path</replaceable>, -t
- <replaceable>path</replaceable></literal>
+ <option>--tmpdir=<replaceable>path</replaceable>, -t
+ <replaceable>path</replaceable></option>
</para>
<para>
@@ -3762,7 +3762,7 @@
characters ('<literal>:</literal>') on Unix and semicolon
characters ('<literal>;</literal>') on Windows, NetWare, and
OS/2. If the MySQL server is acting as a replication slave,
- you should not set <literal>--tmpdir</literal> to point to a
+ you should not set <option>--tmpdir</option> to point to a
directory on a memory-based filesystem or to a directory
that is cleared when the server host restarts. A replication
slave needs some of its temporary files to survive a machine
@@ -3775,10 +3775,10 @@
<listitem>
<para>
- <literal>--user={<replaceable>user_name</replaceable> |
+ <option>--user={<replaceable>user_name</replaceable> |
<replaceable>user_id</replaceable>}, -u
{<replaceable>user_name</replaceable> |
- <replaceable>user_id</replaceable>}</literal>
+ <replaceable>user_id</replaceable>}</option>
</para>
<para>
@@ -3800,29 +3800,29 @@
<para>
To avoid a possible security hole where a user adds a
- <literal>--user=root</literal> option to a
+ <option>--user=root</option> option to a
<filename>my.cnf</filename> file (thus causing the server to
run as <literal>root</literal>), <command>mysqld</command>
- uses only the first <literal>--user</literal> option
- specified and produces a warning if there are multiple
- <literal>--user</literal> options. Options in
+ uses only the first <option>--user</option> option specified
+ and produces a warning if there are multiple
+ <option>--user</option> options. Options in
<filename>/etc/my.cnf</filename> and
<filename>$MYSQL_HOME/my.cnf</filename> are processed before
command-line options, so it is recommended that you put a
- <literal>--user</literal> option in
+ <option>--user</option> option in
<filename>/etc/my.cnf</filename> and specify a value other
than <literal>root</literal>. The option in
<filename>/etc/my.cnf</filename> is found before any other
- <literal>--user</literal> options, which ensures that the
+ <option>--user</option> options, which ensures that the
server runs as a user other than <literal>root</literal>,
and that a warning results if any other
- <literal>--user</literal> option is found.
+ <option>--user</option> option is found.
</para>
</listitem>
<listitem>
<para>
- <literal>--version, -V</literal>
+ <option>--version</option>, <option>-V</option>
</para>
<para>
@@ -3835,8 +3835,8 @@
<para>
In MySQL 5.0, you can assign a value to a server system variable
by using an option of the form
- <literal>--<replaceable>var_name</replaceable>=<replaceable>value</replaceable></literal>.
- For example, <literal>--key_buffer_size=32M</literal> sets the
+ <option>--<replaceable>var_name</replaceable>=<replaceable>value</replaceable></option>.
+ For example, <option>--key_buffer_size=32M</option> sets the
<literal>key_buffer_size</literal> variable to a value of 32MB.
</para>
@@ -3851,7 +3851,7 @@
<para>
It is also possible to set variables by using
- <literal>--set-variable=<replaceable>var_name</replaceable>=<replaceable>value</replaceable></literal>
+ <option>--set-variable=<replaceable>var_name</replaceable>=<replaceable>value</replaceable></option>
or <literal>-O
<replaceable>var_name</replaceable>=<replaceable>value</replaceable></literal>
syntax. However, this syntax is now deprecated.
@@ -3874,7 +3874,7 @@
If you want to restrict the maximum value that a startup option
can be set to with <literal>SET</literal>, you can define this
by using the
- <literal>--maximum-<replaceable>var_name</replaceable></literal>
+ <option>--maximum-<replaceable>var_name</replaceable></option>
command-line option.
</para>
@@ -3901,9 +3901,9 @@
<para>
You can set the default SQL mode by starting
<command>mysqld</command> with the
- <literal>--sql-mode="<replaceable>modes</replaceable>"</literal>
+ <option>--sql-mode="<replaceable>modes</replaceable>"</option>
option. The value also can be empty
- (<literal>--sql-mode=""</literal>) if you want to reset it.
+ (<option>--sql-mode=""</option>) if you want to reset it.
</para>
<para>
@@ -23584,13 +23584,14 @@
<listitem>
<para>
Start the client with
- <literal>--host=<replaceable>host_name</replaceable>
- --port=<replaceable>port_number</replaceable></literal> to
+ <option>--host=<replaceable>host_name</replaceable>
+ --port=<replaceable>port_number</replaceable></option> to
connect via TCP/IP to a remote server, with
- <literal>--host=127.0.0.1 --port=port_number</literal> to
+ <option>--host=127.0.0.1
+ --port=<replaceable>port_number</replaceable></option> to
connect via TCP/IP to a local server, or with
- <literal>--host=localhost
- --socket=<replaceable>file_name</replaceable></literal> to
+ <option>--host=localhost
+ --socket=<replaceable>file_name</replaceable></option> to
connect to a local server via a Unix socket file or a
Windows named pipe.
</para>
@@ -23599,19 +23600,19 @@
<listitem>
<para>
As of MySQL 4.1, start the client with
- <literal>--protocol=tcp</literal> to connect via TCP/IP,
- <literal>--protocol=socket</literal> to connect via a Unix
- socket file, <literal>--protocol=pipe</literal> to connect
- via a named pipe, or <literal>--protocol=memory</literal> to
+ <option>--protocol=tcp</option> to connect via TCP/IP,
+ <option>--protocol=socket</option> to connect via a Unix
+ socket file, <option>--protocol=pipe</option> to connect via
+ a named pipe, or <option>--protocol=memory</option> to
connect via shared memory. For TCP/IP connections, you may
- also need to specify <literal>--host</literal> and
- <literal>--port</literal> options. For the other types of
+ also need to specify <option>--host</option> and
+ <option>--port</option> options. For the other types of
connections, you may need to specify a
- <literal>--socket</literal> option to specify a Unix socket
+ <option>--socket</option> option to specify a Unix socket
file or named pipe name, or a
- <literal>--shared-memory-base-name</literal> option to
- specify the shared memory name. Shared memory connections
- are supported only on Windows.
+ <option>--shared-memory-base-name</option> option to specify
+ the shared memory name. Shared memory connections are
+ supported only on Windows.
</para>
<indexterm type="type">
@@ -23792,7 +23793,7 @@
<literal>query_cache_size</literal> system variable to 0. By
disabling the query cache code, there is no noticeable overhead.
Query cache capabilities can be excluded from the server entirely
- by using the <literal>--without-query-cache</literal> option to
+ by using the <option>--without-query-cache</option> option to
<command>configure</command> when compiling MySQL.
</para>
--- 1.34/refman-4.1/mysql-database-administration.xml 2005-08-08 13:40:18 -05:00
+++ 1.35/refman-4.1/mysql-database-administration.xml 2005-08-08 14:39:25 -05:00
@@ -2008,8 +2008,8 @@
<listitem>
<para>
- <literal>--datadir=<replaceable>path</replaceable>, -h
- <replaceable>path</replaceable></literal>
+ <option>--datadir=<replaceable>path</replaceable>, -h
+ <replaceable>path</replaceable></option>
</para>
<para>
@@ -2019,8 +2019,9 @@
<listitem>
<para>
- <literal>--debug[=<replaceable>debug_options</replaceable>],
- -# [<replaceable>debug_options</replaceable>]</literal>
+ <option>--debug[=<replaceable>debug_options</replaceable>]</option>,
+ <option>-#
+ [<replaceable>debug_options</replaceable>]</option>
</para>
<para>
@@ -2165,8 +2166,8 @@
<listitem>
<para>
- <literal>--exit-info[=<replaceable>flags</replaceable>], -T
- [<replaceable>flags</replaceable>]</literal>
+ <option>--exit-info[=<replaceable>flags</replaceable>]</option>,
+ <option>-T [<replaceable>flags</replaceable>]</option>
</para>
<para>
@@ -2222,8 +2223,7 @@
<para>
The easiest way to ensure this is to always use
<option>--external-locking</option> together with
- <literal>--delay-key-write=OFF
- --query-cache-size=0</literal>.
+ <option>--delay-key-write=OFF --query-cache-size=0</option>.
</para>
<para>
@@ -2271,8 +2271,8 @@
<listitem>
<para>
- <literal>--language=<replaceable>lang_name</replaceable>, -L
- <replaceable>lang_name</replaceable></literal>
+ <option>--language=<replaceable>lang_name</replaceable>, -L
+ <replaceable>lang_name</replaceable></option>
</para>
<para>
@@ -2286,8 +2286,8 @@
<listitem>
<para>
- <literal>--log[=<replaceable>file</replaceable>], -l
- [<replaceable>file</replaceable>]</literal>
+ <option>--log[=<replaceable>file</replaceable>]</option>,
+ <option>-l [<replaceable>file</replaceable>]</option>
</para>
<para>
@@ -2515,8 +2515,8 @@
<listitem>
<para>
- <literal>--myisam-recover
- [=<replaceable>option</replaceable>[,<replaceable>option</replaceable>...]]]</literal>
+ <option>--myisam-recover
+ [=<replaceable>option</replaceable>[,<replaceable>option</replaceable>...]]]</option>
</para>
<para>
@@ -2729,8 +2729,8 @@
<listitem>
<para>
- <literal>--port=<replaceable>port_num</replaceable>, -P
- <replaceable>port_num</replaceable></literal>
+ <option>--port=<replaceable>port_num</replaceable>, -P
+ <replaceable>port_num</replaceable></option>
</para>
<para>
@@ -3168,8 +3168,8 @@
<listitem>
<para>
- <literal>--tmpdir=<replaceable>path</replaceable>, -t
- <replaceable>path</replaceable></literal>
+ <option>--tmpdir=<replaceable>path</replaceable>, -t
+ <replaceable>path</replaceable></option>
</para>
<para>
@@ -3195,10 +3195,10 @@
<listitem>
<para>
- <literal>--user={<replaceable>user_name</replaceable> |
+ <option>--user={<replaceable>user_name</replaceable> |
<replaceable>user_id</replaceable>}, -u
{<replaceable>user_name</replaceable> |
- <replaceable>user_id</replaceable>}</literal>
+ <replaceable>user_id</replaceable>}</option>
</para>
<para>
@@ -17179,8 +17179,8 @@
<listitem>
<para>
- <literal>--data-file-length=<replaceable>#</replaceable>,
- -D <replaceable>#</replaceable></literal>
+ <option>--data-file-length=<replaceable>#</replaceable>,
+ -D <replaceable>#</replaceable></option>
</para>
<para>
@@ -19138,9 +19138,9 @@
<option>--default-character-set</option> option when you start
the server. The character sets available depend on the
<option>--with-charset=<replaceable>charset</replaceable></option>
- and <literal>--with-extra-charsets=
+ and <option>--with-extra-charsets=
<replaceable>list-of-charsets</replaceable> | complex | all |
- none</literal> options to <command>configure</command>, and the
+ none</option> options to <command>configure</command>, and the
character set configuration files listed in
<filename>SHAREDIR/charsets/Index</filename>. See
<xref linkend="configure-options"/>.
@@ -21818,13 +21818,14 @@
<listitem>
<para>
Start the client with
- <literal>--host=<replaceable>host_name</replaceable>
- --port=<replaceable>port_number</replaceable></literal> to
+ <option>--host=<replaceable>host_name</replaceable>
+ --port=<replaceable>port_number</replaceable></option> to
connect via TCP/IP to a remote server, with
- <option>--host=127.0.0.1 --port=port_number</option> to
+ <option>--host=127.0.0.1
+ --port=<replaceable>port_number</replaceable></option> to
connect via TCP/IP to a local server, or with
- <literal>--host=localhost
- --socket=<replaceable>file_name</replaceable></literal> to
+ <option>--host=localhost
+ --socket=<replaceable>file_name</replaceable></option> to
connect to a local server via a Unix socket file or a
Windows named pipe.
</para>
--- 1.43/refman/mysql-database-administration.xml 2005-08-08 13:40:18 -05:00
+++ 1.44/refman/mysql-database-administration.xml 2005-08-08 14:39:25 -05:00
@@ -2521,9 +2521,9 @@
<para>
<command>mysqld</command> accepts many command-line options. For
a list, execute <command>mysqld --help</command>. Before MySQL
- 4.1.1, <literal>--help</literal> prints the full help message.
- As of 4.1.1, it prints a brief message; to see the full list,
- use <command>mysqld --verbose --help</command>.
+ 4.1.1, <option>--help</option> prints the full help message. As
+ of 4.1.1, it prints a brief message; to see the full list, use
+ <command>mysqld --verbose --help</command>.
</para>
<para>
@@ -2580,21 +2580,21 @@
<listitem>
<para>
- <literal>--help, -?</literal>
+ <option>--help</option>, <option>-?</option>
</para>
<para>
Display a short help message and exit. Before MySQL 4.1.1,
- <literal>--help</literal> displays the full help message. As
+ <option>--help</option> displays the full help message. As
of 4.1.1, it displays an abbreviated message only. Use both
- the <literal>--verbose</literal> and
- <literal>--help</literal> options to see the full message.
+ the <option>--verbose</option> and <option>--help</option>
+ options to see the full message.
</para>
</listitem>
<listitem>
<para>
- <literal>--allow-suspicious-udfs</literal>
+ <option>--allow-suspicious-udfs</option>
</para>
<para>
@@ -2611,21 +2611,21 @@
<listitem>
<para>
- <literal>--ansi</literal>
+ <option>--ansi</option>
</para>
<para>
Use standard SQL syntax instead of MySQL syntax. See
<xref linkend="ansi-mode"/>. For more precise control over
- the server SQL mode, use the <literal>--sql-mode</literal>
+ the server SQL mode, use the <option>--sql-mode</option>
option instead.
</para>
</listitem>
<listitem>
<para>
- <literal>--basedir=<replaceable>path</replaceable>, -b
- <replaceable>path</replaceable></literal>
+ <option>--basedir=<replaceable>path</replaceable>, -b
+ <replaceable>path</replaceable></option>
</para>
<para>
@@ -2636,7 +2636,7 @@
<listitem>
<para>
- <literal>--big-tables</literal>
+ <option>--big-tables</option>
</para>
<para>
@@ -2652,7 +2652,7 @@
<listitem>
<para>
- <literal>--bind-address=<replaceable>IP</replaceable></literal>
+ <option>--bind-address=<replaceable>IP</replaceable></option>
</para>
<para>
@@ -2662,12 +2662,12 @@
<listitem>
<para>
- <literal>--console</literal>
+ <option>--console</option>
</para>
<para>
Write the error log messages to stderr/stdout even if
- <literal>--log-error</literal> is specified. On Windows,
+ <option>--log-error</option> is specified. On Windows,
<command>mysqld</command> does not close the console screen
if this option is used.
</para>
@@ -2675,7 +2675,7 @@
<listitem>
<para>
- <literal>--character-sets-dir=<replaceable>path</replaceable></literal>
+ <option>--character-sets-dir=<replaceable>path</replaceable></option>
</para>
<para>
@@ -2686,7 +2686,7 @@
<listitem>
<para>
- <literal>--chroot=<replaceable>path</replaceable></literal>
+ <option>--chroot=<replaceable>path</replaceable></option>
</para>
<para>
@@ -2703,7 +2703,7 @@
<listitem>
<para>
- <literal>--character-set-server=<replaceable>charset</replaceable></literal>
+ <option>--character-set-server=<replaceable>charset</replaceable></option>
</para>
<para>
@@ -2715,23 +2715,23 @@
<listitem>
<para>
- <literal>--core-file</literal>
+ <option>--core-file</option>
</para>
<para>
Write a core file if <command>mysqld</command> dies. For
some systems, you must also specify the
- <literal>--core-file-size</literal> option to
+ <option>--core-file-size</option> option to
<command>mysqld_safe</command>. See
<xref linkend="mysqld-safe"/>. Note that on some systems,
such as Solaris, you do not get a core file if you are also
- using the <literal>--user</literal> option.
+ using the <option>--user</option> option.
</para>
</listitem>
<listitem>
<para>
- <literal>--collation-server=<replaceable>collation</replaceable></literal>
+ <option>--collation-server=<replaceable>collation</replaceable></option>
</para>
<para>
@@ -2743,8 +2743,8 @@
<listitem>
<para>
- <literal>--datadir=<replaceable>path</replaceable>, -h
- <replaceable>path</replaceable></literal>
+ <option>--datadir=<replaceable>path</replaceable>, -h
+ <replaceable>path</replaceable></option>
</para>
<para>
@@ -2754,12 +2754,13 @@
<listitem>
<para>
- <literal>--debug[=<replaceable>debug_options</replaceable>],
- -# [<replaceable>debug_options</replaceable>]</literal>
+ <option>--debug[=<replaceable>debug_options</replaceable>]</option>,
+ <option>-#
+ [<replaceable>debug_options</replaceable>]</option>
</para>
<para>
- If MySQL is configured with <literal>--with-debug</literal>,
+ If MySQL is configured with <option>--with-debug</option>,
you can use this option to get a trace file of what
<command>mysqld</command> is doing. The
<replaceable>debug_options</replaceable> string often is
@@ -2770,45 +2771,45 @@
<listitem>
<para>
- <literal>--default-character-set=<replaceable>charset</replaceable></literal>
+ <option>--default-character-set=<replaceable>charset</replaceable></option>
</para>
<para>
Use <replaceable>charset</replaceable> as the default
character set. This option is deprecated in favor of
- <literal>--character-set-server</literal> as of MySQL 4.1.3.
+ <option>--character-set-server</option> as of MySQL 4.1.3.
See <xref linkend="character-sets"/>.
</para>
</listitem>
<listitem>
<para>
- <literal>--default-collation=<replaceable>collation</replaceable></literal>
+ <option>--default-collation=<replaceable>collation</replaceable></option>
</para>
<para>
Use <replaceable>collation</replaceable> as the default
collation. This option is deprecated in favor of
- <literal>--collation-server</literal> as of MySQL 4.1.3. See
+ <option>--collation-server</option> as of MySQL 4.1.3. See
<xref linkend="character-sets"/>.
</para>
</listitem>
<listitem>
<para>
- <literal>--default-storage-engine=<replaceable>type</replaceable></literal>
+ <option>--default-storage-engine=<replaceable>type</replaceable></option>
</para>
<para>
This option is a synonym for
- <literal>--default-table-type</literal>. It is available as
- of MySQL 4.1.2.
+ <option>--default-table-type</option>. It is available as of
+ MySQL 4.1.2.
</para>
</listitem>
<listitem>
<para>
- <literal>--default-table-type=<replaceable>type</replaceable></literal>
+ <option>--default-table-type=<replaceable>type</replaceable></option>
</para>
<para>
@@ -2819,7 +2820,7 @@
<listitem>
<para>
- <literal>--default-time-zone=<replaceable>type</replaceable></literal>
+ <option>--default-time-zone=<replaceable>type</replaceable></option>
</para>
<para>
@@ -2834,7 +2835,7 @@
<listitem>
<para>
- <literal>--delay-key-write[= OFF | ON | ALL]</literal>
+ <option>--delay-key-write[= OFF | ON | ALL]</option>
</para>
<para>
@@ -2862,19 +2863,19 @@
<listitem>
<para>
- <literal>--delay-key-write-for-all-tables</literal>
+ <option>--delay-key-write-for-all-tables</option>
</para>
<para>
- Old form of <literal>--delay-key-write=ALL</literal> for use
+ Old form of <option>--delay-key-write=ALL</option> for use
prior to MySQL 4.0.3. As of 4.0.3, use
- <literal>--delay-key-write</literal> instead.
+ <option>--delay-key-write</option> instead.
</para>
</listitem>
<listitem>
<para>
- <literal>--des-key-file=<replaceable>file_name</replaceable></literal>
+ <option>--des-key-file=<replaceable>file_name</replaceable></option>
</para>
<para>
@@ -2886,7 +2887,7 @@
<listitem>
<para>
- <literal>--enable-named-pipe</literal>
+ <option>--enable-named-pipe</option>
</para>
<para>
@@ -2900,8 +2901,8 @@
<listitem>
<para>
- <literal>--exit-info[=<replaceable>flags</replaceable>], -T
- [<replaceable>flags</replaceable>]</literal>
+ <option>--exit-info[=<replaceable>flags</replaceable>]</option>,
+ <option>-T [<replaceable>flags</replaceable>]</option>
</para>
<para>
@@ -2913,7 +2914,7 @@
<listitem>
<para>
- <literal>--external-locking</literal>
+ <option>--external-locking</option>
</para>
<para>
@@ -2921,7 +2922,7 @@
system on which <literal>lockd</literal> does not fully work
(as on Linux), it is easy for <command>mysqld</command> to
deadlock. This option previously was named
- <literal>--enable-locking</literal>.
+ <option>--enable-locking</option>.
</para>
<para>
@@ -2943,7 +2944,7 @@
<listitem>
<para>
You should not use
- <literal>--delay-key-write=ALL</literal> or
+ <option>--delay-key-write=ALL</option> or
<literal>DELAY_KEY_WRITE=1</literal> on any shared
tables.
</para>
@@ -2953,9 +2954,8 @@
<para>
The easiest way to ensure this is to always use
- <literal>--external-locking</literal> together with
- <literal>--delay-key-write=OFF
- --query-cache-size=0</literal>.
+ <option>--external-locking</option> together with
+ <option>--delay-key-write=OFF --query-cache-size=0</option>.
</para>
<para>
@@ -2966,7 +2966,7 @@
<listitem>
<para>
- <literal>--flush</literal>
+ <option>--flush</option>
</para>
<para>
@@ -2979,7 +2979,7 @@
<listitem>
<para>
- <literal>--init-file=<replaceable>file</replaceable></literal>
+ <option>--init-file=<replaceable>file</replaceable></option>
</para>
<para>
@@ -2991,7 +2991,7 @@
<listitem>
<para>
- <literal>--innodb-safe-binlog</literal>
+ <option>--innodb-safe-binlog</option>
</para>
<para>
@@ -3003,8 +3003,8 @@
<listitem>
<para>
- <literal>--language=<replaceable>lang_name</replaceable>, -L
- <replaceable>lang_name</replaceable></literal>
+ <option>--language=<replaceable>lang_name</replaceable>, -L
+ <replaceable>lang_name</replaceable></option>
</para>
<para>
@@ -3018,7 +3018,7 @@
<listitem>
<para>
- <literal>--large-pages</literal>
+ <option>--large-pages</option>
</para>
<para>
@@ -3053,8 +3053,8 @@
<listitem>
<para>
- <literal>--log[=<replaceable>file</replaceable>], -l
- [<replaceable>file</replaceable>]</literal>
+ <option>--log[=<replaceable>file</replaceable>]</option>,
+ <option>-l [<replaceable>file</replaceable>]</option>
</para>
<para>
@@ -3068,7 +3068,7 @@
<listitem>
<para>
- <literal>--log-bin=[<replaceable>file</replaceable>]</literal>
+ <option>--log-bin=[<replaceable>file</replaceable>]</option>
</para>
<para>
@@ -3084,14 +3084,14 @@
<listitem>
<para>
- <literal>--log-bin-index[=<replaceable>file</replaceable>]</literal>
+ <option>--log-bin-index[=<replaceable>file</replaceable>]</option>
</para>
<para>
The index file for binary log filenames. See
<xref linkend="binary-log"/>. If you don't specify a
filename, and if you didn't specify one in
- <literal>--log-bin</literal>, MySQL uses
+ <option>--log-bin</option>, MySQL uses
<filename><replaceable>host_name</replaceable>-bin.index</filename>
as the filename.
</para>
@@ -3119,7 +3119,7 @@
<listitem>
<para>
- <literal>--log-error[=<replaceable>file</replaceable>]</literal>
+ <option>--log-error[=<replaceable>file</replaceable>]</option>
</para>
<para>
@@ -3134,7 +3134,7 @@
<listitem>
<para>
- <literal>--log-isam[=<replaceable>file</replaceable>]</literal>
+ <option>--log-isam[=<replaceable>file</replaceable>]</option>
</para>
<para>
@@ -3146,7 +3146,7 @@
<listitem>
<para>
- <literal>--log-long-format</literal>
+ <option>--log-long-format</option>
</para>
<para>
@@ -3154,15 +3154,14 @@
binary update log, and slow queries log, whatever log has
been activated). For example, username and timestamp are
logged for queries. Before MySQL 4.1, if you are using
- <literal>--log-slow-queries</literal> and
- <literal>--log-long-format</literal>, queries that are not
+ <option>--log-slow-queries</option> and
+ <option>--log-long-format</option>, queries that are not
using indexes also are logged to the slow query log.
- <literal>--log-long-format</literal> is deprecated as of
- MySQL version 4.1, when
- <literal>--log-short-format</literal> was introduced. (Long
- log format is the default setting since version 4.1.) Also
- note that starting with MySQL 4.1, the
- <literal>--log-queries-not-using-indexes</literal> option is
+ <option>--log-long-format</option> is deprecated as of MySQL
+ version 4.1, when <option>--log-short-format</option> was
+ introduced. (Long log format is the default setting since
+ version 4.1.) Also note that starting with MySQL 4.1, the
+ <option>--log-queries-not-using-indexes</option> option is
available for the purpose of logging queries that do not use
indexes to the slow query log.
</para>
@@ -3170,12 +3169,12 @@
<listitem>
<para>
- <literal>--log-queries-not-using-indexes</literal>
+ <option>--log-queries-not-using-indexes</option>
</para>
<para>
If you are using this option with
- <literal>--log-slow-queries</literal>, then queries that are
+ <option>--log-slow-queries</option>, then queries that are
not using indexes also are logged to the slow query log.
This option is available as of MySQL 4.1. See
<xref linkend="slow-query-log"/>.
@@ -3184,7 +3183,7 @@
<listitem>
<para>
- <literal>--log-short-format</literal>
+ <option>--log-short-format</option>
</para>
<para>
@@ -3197,7 +3196,7 @@
<listitem>
<para>
- <literal>--log-slow-admin-statements</literal>
+ <option>--log-slow-admin-statements</option>
</para>
<para>
@@ -3215,7 +3214,7 @@
<listitem>
<para>
- <literal>--log-slow-queries[=<replaceable>file</replaceable>]</literal>
+ <option>--log-slow-queries[=<replaceable>file</replaceable>]</option>
</para>
<para>
@@ -3223,15 +3222,14 @@
<literal>long_query_time</literal> seconds to execute to
this file. See <xref linkend="slow-query-log"/>. Note that
the default for the amount of information logged has changed
- in MySQL 4.1. See the <literal>--log-long-format</literal>
- and <literal>--log-short-format</literal> options for
- details.
+ in MySQL 4.1. See the <option>--log-long-format</option> and
+ <option>--log-short-format</option> options for details.
</para>
</listitem>
<listitem>
<para>
- <literal>--log-update[=<replaceable>file</replaceable>]</literal>
+ <option>--log-update[=<replaceable>file</replaceable>]</option>
</para>
<para>
@@ -3239,16 +3237,16 @@
<replaceable>#</replaceable> is a unique number if not
given. See <xref linkend="update-log"/>. The update log is
deprecated and is removed in MySQL 5.0.0; you should use the
- binary log instead (<literal>--log-bin</literal>). See
+ binary log instead (<option>--log-bin</option>). See
<xref linkend="binary-log"/>. Starting from version 5.0.0,
- using <literal>--log-update</literal> turns on the binary
- log instead (see <xref linkend="news-5-0-0"/>).
+ using <option>--log-update</option> turns on the binary log
+ instead (see <xref linkend="news-5-0-0"/>).
</para>
</listitem>
<listitem>
<para>
- <literal>--log-warnings, -W</literal>
+ <option>--log-warnings</option>, <option>-W</option>
</para>
<para>
@@ -3258,21 +3256,21 @@
(you get more information about what is happening, such as
messages about network failures and reconnections). This
option is enabled by default as of MySQL 4.0.19 and 4.1.2;
- to disable it, use <literal>--skip-log-warnings</literal>.
- As of MySQL 4.0.21 and 4.1.3, aborted connections are not
+ to disable it, use <option>--skip-log-warnings</option>. As
+ of MySQL 4.0.21 and 4.1.3, aborted connections are not
logged to the error log unless the value is greater than 1.
See <xref linkend="communication-errors"/>.
</para>
<para>
- This option was named <literal>--warnings</literal> before
+ This option was named <option>--warnings</option> before
MySQL 4.0.
</para>
</listitem>
<listitem>
<para>
- <literal>--low-priority-updates</literal>
+ <option>--low-priority-updates</option>
</para>
<para>
@@ -3289,7 +3287,7 @@
<listitem>
<para>
- <literal>--memlock</literal>
+ <option>--memlock</option>
</para>
<para>
@@ -3306,8 +3304,8 @@
<listitem>
<para>
- <literal>--myisam-recover
- [=<replaceable>option</replaceable>[,<replaceable>option</replaceable>...]]]</literal>
+ <option>--myisam-recover
+ [=<replaceable>option</replaceable>[,<replaceable>option</replaceable>...]]]</option>
</para>
<para>
@@ -3322,7 +3320,7 @@
<literal>MyISAM</literal> table, checks whether the table is
marked as crashed or wasn't closed properly. (The last
option works only if you are running with
- <literal>--skip-external-locking</literal>.) If this is the
+ <option>--skip-external-locking</option>.) If this is the
case, <command>mysqld</command> runs a check on the table.
If the table was corrupted, <command>mysqld</command>
attempts to repair it.
@@ -3343,8 +3341,7 @@
</row>
<row>
<entry><literal>DEFAULT</literal></entry>
- <entry>The same as not giving any option to
- <literal>--myisam-recover</literal>.</entry>
+ <entry>The same as not giving any option to <option>--myisam-recover</option>.</entry>
</row>
<row>
<entry><literal>BACKUP</literal></entry>
@@ -3383,7 +3380,7 @@
<listitem>
<para>
- <literal>--ndb-connectstring=<replaceable>connect_string</replaceable></literal>
+ <option>--ndb-connectstring=<replaceable>connect_string</replaceable></option>
</para>
<para>
@@ -3397,7 +3394,7 @@
<listitem>
<para>
- <literal>--ndbcluster</literal>
+ <option>--ndbcluster</option>
</para>
<para>
@@ -3414,11 +3411,11 @@
<listitem>
<para>
- <literal>--new</literal>
+ <option>--new</option>
</para>
<para>
- The <literal>--new</literal> option can be used to make the
+ The <option>--new</option> option can be used to make the
server behave as 4.1 in certain respects, easing a 4.0 to
4.1 upgrade:
@@ -3453,7 +3450,7 @@
<listitem>
<para>
- <literal>--old-passwords</literal>
+ <option>--old-passwords</option>
</para>
<para>
@@ -3466,7 +3463,7 @@
<listitem>
<para>
- <literal>--old-protocol, -o</literal>
+ <option>--old-protocol</option>, <option>-o</option>
</para>
<para>
@@ -3477,7 +3474,7 @@
<listitem>
<para>
- <literal>--one-thread</literal>
+ <option>--one-thread</option>
</para>
<para>
@@ -3489,7 +3486,7 @@
<listitem>
<para>
- <literal>--open-files-limit=<replaceable>count</replaceable></literal>
+ <option>--open-files-limit=<replaceable>count</replaceable></option>
</para>
<para>
@@ -3508,7 +3505,7 @@
<listitem>
<para>
- <literal>--pid-file=<replaceable>path</replaceable></literal>
+ <option>--pid-file=<replaceable>path</replaceable></option>
</para>
<para>
@@ -3519,8 +3516,8 @@
<listitem>
<para>
- <literal>--port=<replaceable>port_num</replaceable>, -P
- <replaceable>port_num</replaceable></literal>
+ <option>--port=<replaceable>port_num</replaceable>, -P
+ <replaceable>port_num</replaceable></option>
</para>
<para>
@@ -3531,7 +3528,7 @@
<listitem>
<para>
- <literal>--safe-mode</literal>
+ <option>--safe-mode</option>
</para>
<para>
@@ -3541,7 +3538,7 @@
<listitem>
<para>
- <literal>--safe-show-database</literal>
+ <option>--safe-show-database</option>
</para>
<para>
@@ -3558,7 +3555,7 @@
<listitem>
<para>
- <literal>--safe-user-create</literal>
+ <option>--safe-user-create</option>
</para>
<para>
@@ -3572,7 +3569,7 @@
<listitem>
<para>
- <literal>--secure-auth</literal>
+ <option>--secure-auth</option>
</para>
<para>
@@ -3583,7 +3580,7 @@
<listitem>
<para>
- <literal>--shared-memory</literal>
+ <option>--shared-memory</option>
</para>
<para>
@@ -3595,7 +3592,7 @@
<listitem>
<para>
- <literal>--shared-memory-base-name=<replaceable>name</replaceable></literal>
+ <option>--shared-memory-base-name=<replaceable>name</replaceable></option>
</para>
<para>
@@ -3606,7 +3603,7 @@
<listitem>
<para>
- <literal>--skip-bdb</literal>
+ <option>--skip-bdb</option>
</para>
<para>
@@ -3618,7 +3615,7 @@
<listitem>
<para>
- <literal>--skip-concurrent-insert</literal>
+ <option>--skip-concurrent-insert</option>
</para>
<para>
@@ -3630,20 +3627,20 @@
<listitem>
<para>
- <literal>--skip-delay-key-write</literal>
+ <option>--skip-delay-key-write</option>
</para>
<para>
Ignore the <literal>DELAY_KEY_WRITE</literal> option for all
tables. As of MySQL 4.0.3, you should use
- <literal>--delay-key-write=OFF</literal> instead. See
+ <option>--delay-key-write=OFF</option> instead. See
<xref linkend="server-parameters"/>.
</para>
</listitem>
<listitem>
<para>
- <literal>--skip-external-locking</literal>
+ <option>--skip-external-locking</option>
</para>
<para>
@@ -3653,13 +3650,13 @@
can use <literal>CHECK TABLE</literal> and <literal>REPAIR
TABLE</literal> to check and repair
<literal>MyISAM</literal> tables. This option previously was
- named <literal>--skip-locking</literal>.
+ named <option>--skip-locking</option>.
</para>
</listitem>
<listitem>
<para>
- <literal>--skip-grant-tables</literal>
+ <option>--skip-grant-tables</option>
</para>
<para>
@@ -3675,7 +3672,7 @@
<listitem>
<para>
- <literal>--skip-host-cache</literal>
+ <option>--skip-host-cache</option>
</para>
<para>
@@ -3687,7 +3684,7 @@
<listitem>
<para>
- <literal>--skip-innodb</literal>
+ <option>--skip-innodb</option>
</para>
<para>
@@ -3700,7 +3697,7 @@
<listitem>
<para>
- <literal>--skip-isam</literal>
+ <option>--skip-isam</option>
</para>
<para>
@@ -3714,7 +3711,7 @@
<listitem>
<para>
- <literal>--skip-name-resolve</literal>
+ <option>--skip-name-resolve</option>
</para>
<para>
@@ -3728,7 +3725,7 @@
<listitem>
<para>
- <literal>--skip-ndbcluster</literal>
+ <option>--skip-ndbcluster</option>
</para>
<para>
@@ -3743,7 +3740,7 @@
<listitem>
<para>
- <literal>--skip-networking</literal>
+ <option>--skip-networking</option>
</para>
<para>
@@ -3757,7 +3754,7 @@
<listitem>
<para>
- <literal>--skip-new</literal>
+ <option>--skip-new</option>
</para>
<para>
@@ -3767,19 +3764,19 @@
<listitem>
<para>
- <literal>--skip-symlink</literal>
+ <option>--skip-symlink</option>
</para>
<para>
This is the old form of
- <literal>--skip-symbolic-links</literal>, for use before
- MySQL 4.0.13.
+ <option>--skip-symbolic-links</option>, for use before MySQL
+ 4.0.13.
</para>
</listitem>
<listitem>
<para>
- <literal>--standalone</literal>
+ <option>--standalone</option>
</para>
<para>
@@ -3790,7 +3787,8 @@
<listitem>
<para>
- <literal>--symbolic-links, --skip-symbolic-links</literal>
+ <option>--symbolic-links</option>,
+ <option>--skip-symbolic-links</option>
</para>
<para>
@@ -3832,22 +3830,22 @@
<listitem>
<para>
- <literal>--skip-safemalloc</literal>
+ <option>--skip-safemalloc</option>
</para>
<para>
If MySQL is configured with
- <literal>--with-debug=full</literal>, all MySQL programs
- check for memory overruns during each memory allocation and
- memory freeing operation. This checking is very slow, so for
- the server you can avoid it when you don't need it by using
- the <literal>--skip-safemalloc</literal> option.
+ <option>--with-debug=full</option>, all MySQL programs check
+ for memory overruns during each memory allocation and memory
+ freeing operation. This checking is very slow, so for the
+ server you can avoid it when you don't need it by using the
+ <option>--skip-safemalloc</option> option.
</para>
</listitem>
<listitem>
<para>
- <literal>--skip-show-database</literal>
+ <option>--skip-show-database</option>
</para>
<para>
@@ -3864,7 +3862,7 @@
<listitem>
<para>
- <literal>--skip-stack-trace</literal>
+ <option>--skip-stack-trace</option>
</para>
<para>
@@ -3877,7 +3875,7 @@
<listitem>
<para>
- <literal>--skip-thread-priority</literal>
+ <option>--skip-thread-priority</option>
</para>
<para>
@@ -3887,7 +3885,7 @@
<listitem>
<para>
- <literal>--socket=<replaceable>path</replaceable></literal>
+ <option>--socket=<replaceable>path</replaceable></option>
<!-- Put the Unix description first, because the option name relates directly -->
</para>
@@ -3920,7 +3918,7 @@
<listitem>
<para>
- <literal>--sql-mode=<replaceable>value</replaceable>[,<replaceable>value</replaceable>[,<replaceable>value</replaceable>...]]</literal>
+ <option>--sql-mode=<replaceable>value</replaceable>[,<replaceable>value</replaceable>[,<replaceable>value</replaceable>...]]</option>
</para>
<para>
@@ -3932,7 +3930,7 @@
<listitem>
<para>
- <literal>--temp-pool</literal>
+ <option>--temp-pool</option>
</para>
<para>
@@ -3948,7 +3946,7 @@
<listitem>
<para>
- <literal>--transaction-isolation=<replaceable>level</replaceable></literal>
+ <option>--transaction-isolation=<replaceable>level</replaceable></option>
</para>
<para>
@@ -3963,8 +3961,8 @@
<listitem>
<para>
- <literal>--tmpdir=<replaceable>path</replaceable>, -t
- <replaceable>path</replaceable></literal>
+ <option>--tmpdir=<replaceable>path</replaceable>, -t
+ <replaceable>path</replaceable></option>
</para>
<para>
@@ -3977,7 +3975,7 @@
characters ('<literal>:</literal>') on Unix and semicolon
characters ('<literal>;</literal>') on Windows, NetWare, and
OS/2. If the MySQL server is acting as a replication slave,
- you should not set <literal>--tmpdir</literal> to point to a
+ you should not set <option>--tmpdir</option> to point to a
directory on a memory-based filesystem or to a directory
that is cleared when the server host restarts. A replication
slave needs some of its temporary files to survive a machine
@@ -3990,10 +3988,10 @@
<listitem>
<para>
- <literal>--user={<replaceable>user_name</replaceable> |
+ <option>--user={<replaceable>user_name</replaceable> |
<replaceable>user_id</replaceable>}, -u
{<replaceable>user_name</replaceable> |
- <replaceable>user_id</replaceable>}</literal>
+ <replaceable>user_id</replaceable>}</option>
</para>
<para>
@@ -4016,29 +4014,29 @@
<para>
Starting from MySQL 3.23.56 and 4.0.12: To avoid a possible
security hole where a user adds a
- <literal>--user=root</literal> option to some
+ <option>--user=root</option> option to some
<filename>my.cnf</filename> file (thus causing the server to
run as <literal>root</literal>), <command>mysqld</command>
- uses only the first <literal>--user</literal> option
- specified and produces a warning if there are multiple
- <literal>--user</literal> options. Options in
+ uses only the first <option>--user</option> option specified
+ and produces a warning if there are multiple
+ <option>--user</option> options. Options in
<filename>/etc/my.cnf</filename> and
<filename>$MYSQL_HOME/my.cnf</filename> are processed before
command-line options, so it is recommended that you put a
- <literal>--user</literal> option in
+ <option>--user</option> option in
<filename>/etc/my.cnf</filename> and specify a value other
than <literal>root</literal>. The option in
<filename>/etc/my.cnf</filename> is found before any other
- <literal>--user</literal> options, which ensures that the
+ <option>--user</option> options, which ensures that the
server runs as a user other than <literal>root</literal>,
and that a warning results if any other
- <literal>--user</literal> option is found.
+ <option>--user</option> option is found.
</para>
</listitem>
<listitem>
<para>
- <literal>--version, -V</literal>
+ <option>--version</option>, <option>-V</option>
</para>
<para>
@@ -4051,8 +4049,8 @@
<para>
As of MySQL 4.0, you can assign a value to a server system
variable by using an option of the form
- <literal>--<replaceable>var_name</replaceable>=<replaceable>value</replaceable></literal>.
- For example, <literal>--key_buffer_size=32M</literal> sets the
+ <option>--<replaceable>var_name</replaceable>=<replaceable>value</replaceable></option>.
+ For example, <option>--key_buffer_size=32M</option> sets the
<literal>key_buffer_size</literal> variable to a value of 32MB.
</para>
@@ -4065,7 +4063,7 @@
<para>
It is also possible to set variables by using
- <literal>--set-variable=<replaceable>var_name</replaceable>=<replaceable>value</replaceable></literal>
+ <option>--set-variable=<replaceable>var_name</replaceable>=<replaceable>value</replaceable></option>
or <literal>-O
<replaceable>var_name</replaceable>=<replaceable>value</replaceable></literal>
syntax. However, this syntax is deprecated as of MySQL 4.0.
@@ -4088,7 +4086,7 @@
If you want to restrict the maximum value that a startup option
can be set to with <literal>SET</literal>, you can define this
by using the
- <literal>--maximum-<replaceable>var_name</replaceable></literal>
+ <option>--maximum-<replaceable>var_name</replaceable></option>
command-line option.
</para>
@@ -4115,9 +4113,9 @@
<para>
You can set the default SQL mode by starting
<command>mysqld</command> with the
- <literal>--sql-mode="<replaceable>modes</replaceable>"</literal>
+ <option>--sql-mode="<replaceable>modes</replaceable>"</option>
option. The value also can be empty
- (<literal>--sql-mode=""</literal>) if you want to reset it.
+ (<option>--sql-mode=""</option>) if you want to reset it.
</para>
<para>
@@ -24323,13 +24321,14 @@
<listitem>
<para>
Start the client with
- <literal>--host=<replaceable>host_name</replaceable>
- --port=<replaceable>port_number</replaceable></literal> to
+ <option>--host=<replaceable>host_name</replaceable>
+ --port=<replaceable>port_number</replaceable></option> to
connect via TCP/IP to a remote server, with
- <literal>--host=127.0.0.1 --port=port_number</literal> to
+ <option>--host=127.0.0.1
+ --port=<replaceable>port_number</replaceable></option> to
connect via TCP/IP to a local server, or with
- <literal>--host=localhost
- --socket=<replaceable>file_name</replaceable></literal> to
+ <option>--host=localhost
+ --socket=<replaceable>file_name</replaceable></option> to
connect to a local server via a Unix socket file or a
Windows named pipe.
</para>
@@ -24338,19 +24337,19 @@
<listitem>
<para>
As of MySQL 4.1, start the client with
- <literal>--protocol=tcp</literal> to connect via TCP/IP,
- <literal>--protocol=socket</literal> to connect via a Unix
- socket file, <literal>--protocol=pipe</literal> to connect
- via a named pipe, or <literal>--protocol=memory</literal> to
+ <option>--protocol=tcp</option> to connect via TCP/IP,
+ <option>--protocol=socket</option> to connect via a Unix
+ socket file, <option>--protocol=pipe</option> to connect via
+ a named pipe, or <option>--protocol=memory</option> to
connect via shared memory. For TCP/IP connections, you may
- also need to specify <literal>--host</literal> and
- <literal>--port</literal> options. For the other types of
+ also need to specify <option>--host</option> and
+ <option>--port</option> options. For the other types of
connections, you may need to specify a
- <literal>--socket</literal> option to specify a Unix socket
+ <option>--socket</option> option to specify a Unix socket
file or named pipe name, or a
- <literal>--shared-memory-base-name</literal> option to
- specify the shared memory name. Shared memory connections
- are supported only on Windows.
+ <option>--shared-memory-base-name</option> option to specify
+ the shared memory name. Shared memory connections are
+ supported only on Windows.
</para>
<indexterm type="type">
@@ -24531,7 +24530,7 @@
<literal>query_cache_size</literal> system variable to 0. By
disabling the query cache code, there is no noticeable overhead.
Query cache capabilities can be excluded from the server entirely
- by using the <literal>--without-query-cache</literal> option to
+ by using the <option>--without-query-cache</option> option to
<command>configure</command> when compiling MySQL.
</para>
--- 1.3/refman-5.0/mysql-database-administration.xml 2005-08-08 13:40:18 -05:00
+++ 1.4/refman-5.0/mysql-database-administration.xml 2005-08-08 14:39:25 -05:00
@@ -49,8 +49,8 @@
<para>
All MySQL programs take many different options. However, every
- MySQL program provides a <option>--help</option> option that
- you can use to get a description of the program's options. For
+ MySQL program provides a <option>--help</option> option that you
+ can use to get a description of the program's options. For
example, try <command>mysqld --help</command>.
</para>
@@ -614,8 +614,8 @@
<literal>InnoDB</literal>, <literal>BDB</literal>, or
<literal>ISAM</literal> storage engines if the server was
compiled to support them, but was started with the
- <option>--skip-innodb</option>, <option>--skip-bdb</option>,
- or <option>--skip-isam</option> options at runtime.
+ <option>--skip-innodb</option>, <option>--skip-bdb</option>, or
+ <option>--skip-isam</option> options at runtime.
</para>
<para>
@@ -1025,9 +1025,9 @@
<para>
If <command>mysqld_safe</command> fails, even when invoked from
the MySQL installation directory, you can specify the
- <option>--ledir</option> and <option>--datadir</option>
- options to indicate the directories in which the server and
- databases are located on your system.
+ <option>--ledir</option> and <option>--datadir</option> options
+ to indicate the directories in which the server and databases
+ are located on your system.
</para>
<para>
@@ -1180,10 +1180,10 @@
<para>
The program searches for groups named
<literal>[mysqld#]</literal> in <filename>my.cnf</filename> (or
- in the file named by the <option>--config-file</option>
- option). <literal>#</literal> can be any positive integer. This
- number is referred to in the following discussion as the option
- group number, or <replaceable>GNR</replaceable>. Group numbers
+ in the file named by the <option>--config-file</option> option).
+ <literal>#</literal> can be any positive integer. This number is
+ referred to in the following discussion as the option group
+ number, or <replaceable>GNR</replaceable>. Group numbers
distinguish option groups from one another and are used as
arguments to <command>mysqld_multi</command> to specify which
servers you want to start, stop, or obtain a status report for.
@@ -1531,8 +1531,8 @@
<listitem>
<para>
- The <option>--pid-file</option> option is very important
- if you are using <command>mysqld_safe</command> to start
+ The <option>--pid-file</option> option is very important if
+ you are using <command>mysqld_safe</command> to start
<command>mysqld</command> (for example,
<option>--mysqld=mysqld_safe</option>) Every
<command>mysqld</command> should have its own process ID
@@ -1576,12 +1576,12 @@
<listitem>
<para>
- You might want to use the <option>--user</option> option
- for <command>mysqld</command>, but in order to do this you
- need to run the <command>mysqld_multi</command> script as
- the Unix <literal>root</literal> user. Having the option in
- the option file doesn't matter; you just get a warning if
- you are not the superuser and the <command>mysqld</command>
+ You might want to use the <option>--user</option> option for
+ <command>mysqld</command>, but in order to do this you need
+ to run the <command>mysqld_multi</command> script as the
+ Unix <literal>root</literal> user. Having the option in the
+ option file doesn't matter; you just get a warning if you
+ are not the superuser and the <command>mysqld</command>
processes are started under your own Unix account.
</para>
</listitem>
@@ -2520,19 +2520,19 @@
<listitem>
<para>
- <literal>--help, -?</literal>
+ <option>--help</option>, <option>-?</option>
</para>
<para>
Display a short help message and exit. Use both the
- <literal>--verbose</literal> and <literal>--help</literal>
+ <option>--verbose</option> and <option>--help</option>
options to see the full message.
</para>
</listitem>
<listitem>
<para>
- <literal>--allow-suspicious-udfs</literal>
+ <option>--allow-suspicious-udfs</option>
</para>
<para>
@@ -2549,21 +2549,21 @@
<listitem>
<para>
- <literal>--ansi</literal>
+ <option>--ansi</option>
</para>
<para>
Use standard (ANSI) SQL syntax instead of MySQL syntax. See
<xref linkend="ansi-mode"/>. For more precise control over
- the server SQL mode, use the <literal>--sql-mode</literal>
+ the server SQL mode, use the <option>--sql-mode</option>
option instead.
</para>
</listitem>
<listitem>
<para>
- <literal>--basedir=<replaceable>path</replaceable>, -b
- <replaceable>path</replaceable></literal>
+ <option>--basedir=<replaceable>path</replaceable>, -b
+ <replaceable>path</replaceable></option>
</para>
<para>
@@ -2594,7 +2594,7 @@
<listitem>
<para>
- <literal>--bind-address=<replaceable>IP</replaceable></literal>
+ <option>--bind-address=<replaceable>IP</replaceable></option>
</para>
<para>
@@ -2604,13 +2604,13 @@
<listitem>
<para>
- <literal>--console</literal>
+ <option>--console</option>
</para>
<para>
Write error log messages to <literal>stderr</literal> and
<literal>stdout</literal> even if
- <literal>--log-error</literal> is specified. On Windows,
+ <option>--log-error</option> is specified. On Windows,
<command>mysqld</command> does not close the console screen
if this option is used.
</para>
@@ -2618,7 +2618,7 @@
<listitem>
<para>
- <literal>--character-sets-dir=<replaceable>path</replaceable></literal>
+ <option>--character-sets-dir=<replaceable>path</replaceable></option>
</para>
<para>
@@ -2629,7 +2629,7 @@
<listitem>
<para>
- <literal>--chroot=<replaceable>path</replaceable></literal>
+ <option>--chroot=<replaceable>path</replaceable></option>
</para>
<para>
@@ -2644,7 +2644,7 @@
<listitem>
<para>
- <literal>--character-set-server=<replaceable>charset</replaceable></literal>
+ <option>--character-set-server=<replaceable>charset</replaceable></option>
</para>
<para>
@@ -2655,23 +2655,23 @@
<listitem>
<para>
- <literal>--core-file</literal>
+ <option>--core-file</option>
</para>
<para>
Write a core file if <command>mysqld</command> dies. For
some systems, you must also specify the
- <literal>--core-file-size</literal> option to
+ <option>--core-file-size</option> option to
<command>mysqld_safe</command>. See
<xref linkend="mysqld-safe"/>. Note that on some systems,
such as Solaris, you do not get a core file if you are also
- using the <literal>--user</literal> option.
+ using the <option>--user</option> option.
</para>
</listitem>
<listitem>
<para>
- <literal>--collation-server=<replaceable>collation</replaceable></literal>
+ <option>--collation-server=<replaceable>collation</replaceable></option>
</para>
<para>
@@ -2682,8 +2682,8 @@
<listitem>
<para>
- <literal>--datadir=<replaceable>path</replaceable>, -h
- <replaceable>path</replaceable></literal>
+ <option>--datadir=<replaceable>path</replaceable>, -h
+ <replaceable>path</replaceable></option>
</para>
<para>
@@ -2693,12 +2693,13 @@
<listitem>
<para>
- <literal>--debug[=<replaceable>debug_options</replaceable>],
- -# [<replaceable>debug_options</replaceable>]</literal>
+ <option>--debug[=<replaceable>debug_options</replaceable>]</option>,
+ <option>-#
+ [<replaceable>debug_options</replaceable>]</option>
</para>
<para>
- If MySQL is configured with <literal>--with-debug</literal>,
+ If MySQL is configured with <option>--with-debug</option>,
you can use this option to get a trace file of what
<command>mysqld</command> is doing. The
<replaceable>debug_options</replaceable> string often is
@@ -2710,44 +2711,44 @@
<listitem>
<para>
(<emphasis>DEPRECATED</emphasis>)
- <literal>--default-character-set=<replaceable>charset</replaceable></literal>
+ <option>--default-character-set=<replaceable>charset</replaceable></option>
</para>
<para>
Use <replaceable>charset</replaceable> as the default
character set. This option is deprecated in favor of
- <literal>--character-set-server</literal>. See
+ <option>--character-set-server</option>. See
<xref linkend="character-sets"/>.
</para>
</listitem>
<listitem>
<para>
- <literal>--default-collation=<replaceable>collation</replaceable></literal>
+ <option>--default-collation=<replaceable>collation</replaceable></option>
</para>
<para>
Use <replaceable>collation</replaceable> as the default
collation. This option is deprecated in favor of
- <literal>--collation-server</literal>. See
+ <option>--collation-server</option>. See
<xref linkend="character-sets"/>.
</para>
</listitem>
<listitem>
<para>
- <literal>--default-storage-engine=<replaceable>type</replaceable></literal>
+ <option>--default-storage-engine=<replaceable>type</replaceable></option>
</para>
<para>
This option is a synonym for
- <literal>--default-table-type</literal>.
+ <option>--default-table-type</option>.
</para>
</listitem>
<listitem>
<para>
- <literal>--default-table-type=<replaceable>type</replaceable></literal>
+ <option>--default-table-type=<replaceable>type</replaceable></option>
</para>
<para>
@@ -2758,7 +2759,7 @@
<listitem>
<para>
- <literal>--default-time-zone=<replaceable>type</replaceable></literal>
+ <option>--default-time-zone=<replaceable>type</replaceable></option>
</para>
<para>
@@ -2772,7 +2773,7 @@
<listitem>
<para>
- <literal>--delay-key-write[= OFF | ON | ALL]</literal>
+ <option>--delay-key-write[= OFF | ON | ALL]</option>
</para>
<para>
@@ -2800,7 +2801,7 @@
<listitem>
<para>
- <literal>--des-key-file=<replaceable>file_name</replaceable></literal>
+ <option>--des-key-file=<replaceable>file_name</replaceable></option>
</para>
<para>
@@ -2812,7 +2813,7 @@
<listitem>
<para>
- <literal>--enable-named-pipe</literal>
+ <option>--enable-named-pipe</option>
</para>
<para>
@@ -2826,8 +2827,8 @@
<listitem>
<para>
- <literal>--exit-info[=<replaceable>flags</replaceable>], -T
- [<replaceable>flags</replaceable>]</literal>
+ <option>--exit-info[=<replaceable>flags</replaceable>]</option>,
+ <option>-T [<replaceable>flags</replaceable>]</option>
</para>
<para>
@@ -2840,7 +2841,7 @@
<listitem>
<para>
- <literal>--external-locking</literal>
+ <option>--external-locking</option>
</para>
<para>
@@ -2848,7 +2849,7 @@
system on which <literal>lockd</literal> does not fully work
(as on Linux), it is easy for <command>mysqld</command> to
deadlock. This option previously was named
- <literal>--enable-locking</literal>.
+ <option>--enable-locking</option>.
</para>
<para>
@@ -2870,7 +2871,7 @@
<listitem>
<para>
You should not use
- <literal>--delay-key-write=ALL</literal> or
+ <option>--delay-key-write=ALL</option> or
<literal>DELAY_KEY_WRITE=1</literal> on any shared
tables.
</para>
@@ -2880,9 +2881,8 @@
<para>
The easiest way to ensure this is to always use
- <literal>--external-locking</literal> together with
- <literal>--delay-key-write=OFF
- --query-cache-size=0</literal>.
+ <option>--external-locking</option> together with
+ <option>--delay-key-write=OFF --query-cache-size=0</option>.
</para>
<para>
@@ -2893,7 +2893,7 @@
<listitem>
<para>
- <literal>--flush</literal>
+ <option>--flush</option>
</para>
<para>
@@ -2906,7 +2906,7 @@
<listitem>
<para>
- <literal>--init-file=<replaceable>file</replaceable></literal>
+ <option>--init-file=<replaceable>file</replaceable></option>
</para>
<para>
@@ -2918,7 +2918,7 @@
<listitem>
<para>
- <literal>--innodb-safe-binlog</literal>
+ <option>--innodb-safe-binlog</option>
</para>
<para>
@@ -2930,8 +2930,8 @@
<listitem>
<para>
- <literal>--language=<replaceable>lang_name</replaceable>, -L
- <replaceable>lang_name</replaceable></literal>
+ <option>--language=<replaceable>lang_name</replaceable>, -L
+ <replaceable>lang_name</replaceable></option>
</para>
<para>
@@ -2945,7 +2945,7 @@
<listitem>
<para>
- <literal>--large-pages</literal>
+ <option>--large-pages</option>
</para>
<para>
@@ -2980,8 +2980,8 @@
<listitem>
<para>
- <literal>--log[=<replaceable>file</replaceable>], -l
- [<replaceable>file</replaceable>]</literal>
+ <option>--log[=<replaceable>file</replaceable>]</option>,
+ <option>-l [<replaceable>file</replaceable>]</option>
</para>
<para>
@@ -2995,7 +2995,7 @@
<listitem>
<para>
- <literal>--log-bin=[<replaceable>file</replaceable>]</literal>
+ <option>--log-bin=[<replaceable>file</replaceable>]</option>
</para>
<para>
@@ -3011,14 +3011,14 @@
<listitem>
<para>
- <literal>--log-bin-index[=<replaceable>file</replaceable>]</literal>
+ <option>--log-bin-index[=<replaceable>file</replaceable>]</option>
</para>
<para>
The index file for binary log filenames. See
<xref linkend="binary-log"/>. If you don't specify a
filename, and if you didn't specify one in
- <literal>--log-bin</literal>, MySQL uses
+ <option>--log-bin</option>, MySQL uses
<filename><replaceable>host_name</replaceable>-bin.index</filename>
as the filename.
</para>
@@ -3046,7 +3046,7 @@
<listitem>
<para>
- <literal>--log-error[=<replaceable>file</replaceable>]</literal>
+ <option>--log-error[=<replaceable>file</replaceable>]</option>
</para>
<para>
@@ -3061,7 +3061,7 @@
<listitem>
<para>
- <literal>--log-isam[=<replaceable>file</replaceable>]</literal>
+ <option>--log-isam[=<replaceable>file</replaceable>]</option>
</para>
<para>
@@ -3074,7 +3074,7 @@
<listitem>
<para>
(<emphasis>DEPRECATED</emphasis>)
- <literal>--log-long-format</literal>
+ <option>--log-long-format</option>
</para>
<para>
@@ -3083,8 +3083,8 @@
For example, username and timestamp are logged for all
queries. This option is deprecated in MySQL 5.0, as it now
represents the default logging behaviour. (See the
- description for <literal>--log-short-format</literal>.) The
- <literal>--log-queries-not-using-indexes</literal> option is
+ description for <option>--log-short-format</option>.) The
+ <option>--log-queries-not-using-indexes</option> option is
available for the purpose of logging queries that do not use
indexes to the slow query log.
</para>
@@ -3092,12 +3092,12 @@
<listitem>
<para>
- <literal>--log-queries-not-using-indexes</literal>
+ <option>--log-queries-not-using-indexes</option>
</para>
<para>
If you are using this option with
- <literal>--log-slow-queries</literal>, then queries that are
+ <option>--log-slow-queries</option>, then queries that are
not using indexes also are logged to the slow query log. See
<xref linkend="slow-query-log"/>.
</para>
@@ -3105,7 +3105,7 @@
<listitem>
<para>
- <literal>--log-short-format</literal>
+ <option>--log-short-format</option>
</para>
<para>
@@ -3118,7 +3118,7 @@
<listitem>
<para>
- <literal>--log-slow-admin-statements</literal>
+ <option>--log-slow-admin-statements</option>
</para>
<para>
@@ -3130,21 +3130,21 @@
<listitem>
<para>
- <literal>--log-slow-queries[=<replaceable>file</replaceable>]</literal>
+ <option>--log-slow-queries[=<replaceable>file</replaceable>]</option>
</para>
<para>
Log all queries that have taken more than
<literal>long_query_time</literal> seconds to execute to
this file. See <xref linkend="slow-query-log"/>. See the
- descriptions of the <literal>--log-long-format</literal> and
- <literal>--log-short-format</literal> options for details.
+ descriptions of the <option>--log-long-format</option> and
+ <option>--log-short-format</option> options for details.
</para>
</listitem>
<listitem>
<para>
- <literal>--log-warnings, -W</literal>
+ <option>--log-warnings</option>, <option>-W</option>
</para>
<para>
@@ -3154,7 +3154,7 @@
(you get more information about what is happening, such as
messages about network failures and reconnections). This
option is enabled by default in MySQL 5.0; to disable it,
- use <literal>--skip-log-warnings</literal>. Aborted
+ use <option>--skip-log-warnings</option>. Aborted
connections are not logged to the error log unless the value
is greater than 1. See
<xref linkend="communication-errors"/>.
@@ -3163,7 +3163,7 @@
<listitem>
<para>
- <literal>--low-priority-updates</literal>
+ <option>--low-priority-updates</option>
</para>
<para>
@@ -3180,7 +3180,7 @@
<listitem>
<para>
- <literal>--memlock</literal>
+ <option>--memlock</option>
</para>
<para>
@@ -3197,8 +3197,8 @@
<listitem>
<para>
- <literal>--myisam-recover
- [=<replaceable>option</replaceable>[,<replaceable>option</replaceable>...]]]</literal>
+ <option>--myisam-recover
+ [=<replaceable>option</replaceable>[,<replaceable>option</replaceable>...]]]</option>
</para>
<para>
@@ -3213,7 +3213,7 @@
<literal>MyISAM</literal> table, checks whether the table is
marked as crashed or wasn't closed properly. (The last
option works only if you are running with
- <literal>--skip-external-locking</literal>.) If this is the
+ <option>--skip-external-locking</option>.) If this is the
case, <command>mysqld</command> runs a check on the table.
If the table was corrupted, <command>mysqld</command>
attempts to repair it.
@@ -3234,8 +3234,7 @@
</row>
<row>
<entry><literal>DEFAULT</literal></entry>
- <entry>The same as not giving any option to
- <literal>--myisam-recover</literal>.</entry>
+ <entry>The same as not giving any option to <option>--myisam-recover</option>.</entry>
</row>
<row>
<entry><literal>BACKUP</literal></entry>
@@ -3270,7 +3269,7 @@
<listitem>
<para>
- <literal>--ndb-connectstring=<replaceable>connect_string</replaceable></literal>
+ <option>--ndb-connectstring=<replaceable>connect_string</replaceable></option>
</para>
<para>
@@ -3284,7 +3283,7 @@
<listitem>
<para>
- <literal>--ndbcluster</literal>
+ <option>--ndbcluster</option>
</para>
<para>
@@ -3297,7 +3296,7 @@
<listitem>
<para>
- <literal>--old-passwords</literal>
+ <option>--old-passwords</option>
</para>
<para>
@@ -3326,7 +3325,7 @@
<listitem>
<para>
- <literal>--one-thread</literal>
+ <option>--one-thread</option>
</para>
<para>
@@ -3338,7 +3337,7 @@
<listitem>
<para>
- <literal>--open-files-limit=<replaceable>count</replaceable></literal>
+ <option>--open-files-limit=<replaceable>count</replaceable></option>
</para>
<para>
@@ -3357,7 +3356,7 @@
<listitem>
<para>
- <literal>--pid-file=<replaceable>path</replaceable></literal>
+ <option>--pid-file=<replaceable>path</replaceable></option>
</para>
<para>
@@ -3368,8 +3367,8 @@
<listitem>
<para>
- <literal>--port=<replaceable>port_num</replaceable>, -P
- <replaceable>port_num</replaceable></literal>
+ <option>--port=<replaceable>port_num</replaceable>, -P
+ <replaceable>port_num</replaceable></option>
</para>
<para>
@@ -3380,7 +3379,7 @@
<listitem>
<para>
- <literal>--safe-mode</literal>
+ <option>--safe-mode</option>
</para>
<para>
@@ -3391,7 +3390,7 @@
<listitem>
<para>
(<emphasis>DEPRECATED</emphasis>)
- <literal>--safe-show-database</literal>
+ <option>--safe-show-database</option>
</para>
<para>
@@ -3401,7 +3400,7 @@
<listitem>
<para>
- <literal>--safe-user-create</literal>
+ <option>--safe-user-create</option>
</para>
<para>
@@ -3415,7 +3414,7 @@
<listitem>
<para>
- <literal>--secure-auth</literal>
+ <option>--secure-auth</option>
</para>
<para>
@@ -3426,7 +3425,7 @@
<listitem>
<para>
- <literal>--shared-memory</literal>
+ <option>--shared-memory</option>
</para>
<para>
@@ -3437,7 +3436,7 @@
<listitem>
<para>
- <literal>--shared-memory-base-name=<replaceable>name</replaceable></literal>
+ <option>--shared-memory-base-name=<replaceable>name</replaceable></option>
</para>
<para>
@@ -3448,7 +3447,7 @@
<listitem>
<para>
- <literal>--skip-bdb</literal>
+ <option>--skip-bdb</option>
</para>
<para>
@@ -3460,7 +3459,7 @@
<listitem>
<para>
- <literal>--skip-concurrent-insert</literal>
+ <option>--skip-concurrent-insert</option>
</para>
<para>
@@ -3472,7 +3471,7 @@
<listitem>
<para>
- <literal>--skip-external-locking</literal>
+ <option>--skip-external-locking</option>
</para>
<para>
@@ -3487,7 +3486,7 @@
<listitem>
<para>
- <literal>--skip-grant-tables</literal>
+ <option>--skip-grant-tables</option>
</para>
<para>
@@ -3505,7 +3504,7 @@
<listitem>
<para>
- <literal>--skip-host-cache</literal>
+ <option>--skip-host-cache</option>
</para>
<para>
@@ -3517,7 +3516,7 @@
<listitem>
<para>
- <literal>--skip-innodb</literal>
+ <option>--skip-innodb</option>
</para>
<para>
@@ -3530,7 +3529,7 @@
<listitem>
<para>
- <literal>--skip-name-resolve</literal>
+ <option>--skip-name-resolve</option>
</para>
<para>
@@ -3544,7 +3543,7 @@
<listitem>
<para>
- <literal>--skip-ndbcluster</literal>
+ <option>--skip-ndbcluster</option>
</para>
<para>
@@ -3553,16 +3552,16 @@
<literal>NDB Cluster</literal> storage engine support, this
means that the system allocates memory and other resources
for this storage engine only if
- <literal>--skip-ndbcluster</literal> is explicitly
- overridden using the <literal>--ndbcluster</literal> option.
- See <xref linkend="mysql-cluster-quick"/> for an example of
+ <option>--skip-ndbcluster</option> is explicitly overridden
+ using the <option>--ndbcluster</option> option. See
+ <xref linkend="mysql-cluster-quick"/> for an example of
usage.
</para>
</listitem>
<listitem>
<para>
- <literal>--skip-networking</literal>
+ <option>--skip-networking</option>
</para>
<para>
@@ -3576,7 +3575,7 @@
<listitem>
<para>
- <literal>--standalone</literal>
+ <option>--standalone</option>
</para>
<para>
@@ -3587,7 +3586,8 @@
<listitem>
<para>
- <literal>--symbolic-links, --skip-symbolic-links</literal>
+ <option>--symbolic-links</option>,
+ <option>--skip-symbolic-links</option>
</para>
<para>
@@ -3625,22 +3625,22 @@
<listitem>
<para>
- <literal>--skip-safemalloc</literal>
+ <option>--skip-safemalloc</option>
</para>
<para>
If MySQL is configured with
- <literal>--with-debug=full</literal>, all MySQL programs
- check for memory overruns during each memory allocation and
- memory freeing operation. This checking is very slow, so for
- the server you can avoid it when you don't need it by using
- the <literal>--skip-safemalloc</literal> option.
+ <option>--with-debug=full</option>, all MySQL programs check
+ for memory overruns during each memory allocation and memory
+ freeing operation. This checking is very slow, so for the
+ server you can avoid it when you don't need it by using the
+ <option>--skip-safemalloc</option> option.
</para>
</listitem>
<listitem>
<para>
- <literal>--skip-show-database</literal>
+ <option>--skip-show-database</option>
</para>
<para>
@@ -3657,7 +3657,7 @@
<listitem>
<para>
- <literal>--skip-stack-trace</literal>
+ <option>--skip-stack-trace</option>
</para>
<para>
@@ -3670,7 +3670,7 @@
<listitem>
<para>
- <literal>--skip-thread-priority</literal>
+ <option>--skip-thread-priority</option>
</para>
<para>
@@ -3680,7 +3680,7 @@
<listitem>
<para>
- <literal>--socket=<replaceable>path</replaceable></literal>
+ <option>--socket=<replaceable>path</replaceable></option>
</para>
<!--
@@ -3706,7 +3706,7 @@
<listitem>
<para>
- <literal>--sql-mode=<replaceable>value</replaceable>[,<replaceable>value</replaceable>[,<replaceable>value</replaceable>...]]</literal>
+ <option>--sql-mode=<replaceable>value</replaceable>[,<replaceable>value</replaceable>[,<replaceable>value</replaceable>...]]</option>
</para>
<para>
@@ -3717,7 +3717,7 @@
<listitem>
<para>
- <literal>--temp-pool</literal>
+ <option>--temp-pool</option>
</para>
<para>
@@ -3733,7 +3733,7 @@
<listitem>
<para>
- <literal>--transaction-isolation=<replaceable>level</replaceable></literal>
+ <option>--transaction-isolation=<replaceable>level</replaceable></option>
</para>
<para>
@@ -3748,8 +3748,8 @@
<listitem>
<para>
- <literal>--tmpdir=<replaceable>path</replaceable>, -t
- <replaceable>path</replaceable></literal>
+ <option>--tmpdir=<replaceable>path</replaceable>, -t
+ <replaceable>path</replaceable></option>
</para>
<para>
@@ -3762,7 +3762,7 @@
characters ('<literal>:</literal>') on Unix and semicolon
characters ('<literal>;</literal>') on Windows, NetWare, and
OS/2. If the MySQL server is acting as a replication slave,
- you should not set <literal>--tmpdir</literal> to point to a
+ you should not set <option>--tmpdir</option> to point to a
directory on a memory-based filesystem or to a directory
that is cleared when the server host restarts. A replication
slave needs some of its temporary files to survive a machine
@@ -3775,10 +3775,10 @@
<listitem>
<para>
- <literal>--user={<replaceable>user_name</replaceable> |
+ <option>--user={<replaceable>user_name</replaceable> |
<replaceable>user_id</replaceable>}, -u
{<replaceable>user_name</replaceable> |
- <replaceable>user_id</replaceable>}</literal>
+ <replaceable>user_id</replaceable>}</option>
</para>
<para>
@@ -3800,29 +3800,29 @@
<para>
To avoid a possible security hole where a user adds a
- <literal>--user=root</literal> option to a
+ <option>--user=root</option> option to a
<filename>my.cnf</filename> file (thus causing the server to
run as <literal>root</literal>), <command>mysqld</command>
- uses only the first <literal>--user</literal> option
- specified and produces a warning if there are multiple
- <literal>--user</literal> options. Options in
+ uses only the first <option>--user</option> option specified
+ and produces a warning if there are multiple
+ <option>--user</option> options. Options in
<filename>/etc/my.cnf</filename> and
<filename>$MYSQL_HOME/my.cnf</filename> are processed before
command-line options, so it is recommended that you put a
- <literal>--user</literal> option in
+ <option>--user</option> option in
<filename>/etc/my.cnf</filename> and specify a value other
than <literal>root</literal>. The option in
<filename>/etc/my.cnf</filename> is found before any other
- <literal>--user</literal> options, which ensures that the
+ <option>--user</option> options, which ensures that the
server runs as a user other than <literal>root</literal>,
and that a warning results if any other
- <literal>--user</literal> option is found.
+ <option>--user</option> option is found.
</para>
</listitem>
<listitem>
<para>
- <literal>--version, -V</literal>
+ <option>--version</option>, <option>-V</option>
</para>
<para>
@@ -3835,8 +3835,8 @@
<para>
In MySQL 5.0, you can assign a value to a server system variable
by using an option of the form
- <literal>--<replaceable>var_name</replaceable>=<replaceable>value</replaceable></literal>.
- For example, <literal>--key_buffer_size=32M</literal> sets the
+ <option>--<replaceable>var_name</replaceable>=<replaceable>value</replaceable></option>.
+ For example, <option>--key_buffer_size=32M</option> sets the
<literal>key_buffer_size</literal> variable to a value of 32MB.
</para>
@@ -3851,7 +3851,7 @@
<para>
It is also possible to set variables by using
- <literal>--set-variable=<replaceable>var_name</replaceable>=<replaceable>value</replaceable></literal>
+ <option>--set-variable=<replaceable>var_name</replaceable>=<replaceable>value</replaceable></option>
or <literal>-O
<replaceable>var_name</replaceable>=<replaceable>value</replaceable></literal>
syntax. However, this syntax is now deprecated.
@@ -3874,7 +3874,7 @@
If you want to restrict the maximum value that a startup option
can be set to with <literal>SET</literal>, you can define this
by using the
- <literal>--maximum-<replaceable>var_name</replaceable></literal>
+ <option>--maximum-<replaceable>var_name</replaceable></option>
command-line option.
</para>
@@ -3901,9 +3901,9 @@
<para>
You can set the default SQL mode by starting
<command>mysqld</command> with the
- <literal>--sql-mode="<replaceable>modes</replaceable>"</literal>
+ <option>--sql-mode="<replaceable>modes</replaceable>"</option>
option. The value also can be empty
- (<literal>--sql-mode=""</literal>) if you want to reset it.
+ (<option>--sql-mode=""</option>) if you want to reset it.
</para>
<para>
@@ -8080,13 +8080,12 @@
that it can replicate temporary tables or <literal>LOAD DATA
INFILE</literal> operations. If files in the temporary file
directory are lost when the server restarts, replication
- fails.
- However, if you're using MySQL 4.0.0 or later, you may set
- the slave's temporary directory using the
- <literal>slave_load_tmpdir</literal> variable. In that case,
- the slave won't use the general <literal>tmpdir</literal>
- any more, which means you can set
- <literal>tmpdir</literal> to a non-permanent location then.
+ fails. However, if you're using MySQL 4.0.0 or later, you
+ may set the slave's temporary directory using the
+ <literal>slave_load_tmpdir</literal> variable. In that case,
+ the slave won't use the general <literal>tmpdir</literal>
+ any more, which means you can set <literal>tmpdir</literal>
+ to a non-permanent location then.
</para>
</listitem>
@@ -14443,7 +14442,7 @@
combination of client hostname and username that you are
using when trying to connect.
</para>
-
+
<!--
NOTE: I changed the instructions to restart the server using -log
because it's not necessary since 3.22.11 when the output
@@ -14454,13 +14453,13 @@
If you do not know the IP number or hostname of the machine
from which you are connecting, you should put a row with
<literal>'%'</literal> as the <literal>Host</literal> column
- value in the <literal>user</literal> table. After trying to
- connect from the client machine, use a <literal>SELECT
- USER()</literal> query to see how you really did connect.
- (Then change the <literal>'%'</literal> in the
- <literal>user</literal> table row to the actual hostname
- that shows up in the log. Otherwise, your system is left
- insecure because it allows connections from any host for the
+ value in the <literal>user</literal> table. After trying to
+ connect from the client machine, use a <literal>SELECT
+ USER()</literal> query to see how you really did connect.
+ (Then change the <literal>'%'</literal> in the
+ <literal>user</literal> table row to the actual hostname
+ that shows up in the log. Otherwise, your system is left
+ insecure because it allows connections from any host for the
given username.)
</para>
@@ -16748,9 +16747,9 @@
<para>
To use SSL connections between the MySQL server and client
programs, your system must be able to support OpenSSL and your
- version of MySQL must be 4.0.0 or newer.
- If you're using a MySQL version with built-in yaSSL support
- (as of version 5.0.10), don't read this section, but rather
+ version of MySQL must be 4.0.0 or newer. If you're using a
+ MySQL version with built-in yaSSL support (as of version
+ 5.0.10), don't read this section, but rather
<xref linkend="secure-using-yassl"/>.
</para>
@@ -16833,73 +16832,102 @@
<para>
Currently, yaSSL support is available for these platforms:
+
<itemizedlist>
- <listitem><para>
- Linux/x86-64 Red Hat Enterprise 3.0
- </para></listitem>
- <listitem><para>
- Linux RHAS21 Itanium-2 with gcc, statically linked
- </para></listitem>
- <listitem><para>
- Linux Itanium-2 with gcc
- </para></listitem>
- <listitem><para>
- Windows (all builds)
- </para></listitem>
+
+ <listitem>
+ <para>
+ Linux/x86-64 Red Hat Enterprise 3.0
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Linux RHAS21 Itanium-2 with gcc, statically linked
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Linux Itanium-2 with gcc
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Windows (all builds)
+ </para>
+ </listitem>
+
</itemizedlist>
</para>
<para>
If you want to enable yaSSL when building MySQL from source,
you should configure MySQL like this:
- <programlisting>
+
+<programlisting>
./configure --with-yassl=yes
</programlisting>
</para>
<para>
- To start the MySQL server with yaSSL support, use the same
- options as with OpenSSL support and identify the certificates
+ To start the MySQL server with yaSSL support, use the same
+ options as with OpenSSL support and identify the certificates
needed to establish a secure connection:
- <programlisting>
+
+<programlisting>
shell> <userinput>mysqld --ssl-ca=<replaceable>cacert.pem</replaceable> \
--ssl-cert=<replaceable>server-cert.pem</replaceable> \
--ssl-key=<replaceable>server-key.pem</replaceable></userinput>
</programlisting>
+
<itemizedlist>
- <listitem><para>
- <literal>--ssl-ca</literal> identifies the
- Certificate Authority certificate.
- </para></listitem>
- <listitem><para>
- <literal>--ssl-cert</literal> identifies the server
- certificate.
- </para></listitem>
- <listitem><para>
- <literal>--ssl-key</literal> identifies the client
- certificate.
- </para></listitem>
+
+ <listitem>
+ <para>
+ <literal>--ssl-ca</literal> identifies the Certificate
+ Authority certificate.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>--ssl-cert</literal> identifies the server
+ certificate.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>--ssl-key</literal> identifies the client
+ certificate.
+ </para>
+ </listitem>
+
</itemizedlist>
</para>
<para>
To establish a secure connection to a MySQL server with yaSSL
support, start a client like this:
- <programlisting>
+
+<programlisting>
shell> <userinput>mysql --ssl-ca=<replaceable>cacert.pem</replaceable> \
--ssl-cert=<replaceable>server-cert.pem</replaceable> \
--ssl-key=<replaceable>server-key.pem</replaceable></userinput>
</programlisting>
+
In other words, the options are the same as for the server,
and the Certificate Authority certificate has to be the same.
</para>
<para>
To establish a secure connection from an application program,
- use the <literal>mysql_ssl_set()</literal> API function to
- set the appropriate certificate options, before calling
- <literal>mysql_real_connect()</literal>.
- See <xref linkend="mysql-ssl-set"/>.
+ use the <literal>mysql_ssl_set()</literal> API function to set
+ the appropriate certificate options, before calling
+ <literal>mysql_real_connect()</literal>. See
+ <xref linkend="mysql-ssl-set"/>.
</para>
</section>
@@ -21039,9 +21067,9 @@
</indexterm>
<para>
- By default, MySQL uses the cp1252 (Latin1) character set
- with sorting according to Swedish/Finnish rules. These defaults
- are suitable for the United States and most of Western Europe.
+ By default, MySQL uses the cp1252 (Latin1) character set with
+ sorting according to Swedish/Finnish rules. These defaults are
+ suitable for the United States and most of Western Europe.
</para>
<para>
@@ -23556,13 +23584,14 @@
<listitem>
<para>
Start the client with
- <literal>--host=<replaceable>host_name</replaceable>
- --port=<replaceable>port_number</replaceable></literal> to
+ <option>--host=<replaceable>host_name</replaceable>
+ --port=<replaceable>port_number</replaceable></option> to
connect via TCP/IP to a remote server, with
- <literal>--host=127.0.0.1 --port=port_number</literal> to
+ <option>--host=127.0.0.1
+ --port=<replaceable>port_number</replaceable></option> to
connect via TCP/IP to a local server, or with
- <literal>--host=localhost
- --socket=<replaceable>file_name</replaceable></literal> to
+ <option>--host=localhost
+ --socket=<replaceable>file_name</replaceable></option> to
connect to a local server via a Unix socket file or a
Windows named pipe.
</para>
@@ -23571,19 +23600,19 @@
<listitem>
<para>
As of MySQL 4.1, start the client with
- <literal>--protocol=tcp</literal> to connect via TCP/IP,
- <literal>--protocol=socket</literal> to connect via a Unix
- socket file, <literal>--protocol=pipe</literal> to connect
- via a named pipe, or <literal>--protocol=memory</literal> to
+ <option>--protocol=tcp</option> to connect via TCP/IP,
+ <option>--protocol=socket</option> to connect via a Unix
+ socket file, <option>--protocol=pipe</option> to connect via
+ a named pipe, or <option>--protocol=memory</option> to
connect via shared memory. For TCP/IP connections, you may
- also need to specify <literal>--host</literal> and
- <literal>--port</literal> options. For the other types of
+ also need to specify <option>--host</option> and
+ <option>--port</option> options. For the other types of
connections, you may need to specify a
- <literal>--socket</literal> option to specify a Unix socket
+ <option>--socket</option> option to specify a Unix socket
file or named pipe name, or a
- <literal>--shared-memory-base-name</literal> option to
- specify the shared memory name. Shared memory connections
- are supported only on Windows.
+ <option>--shared-memory-base-name</option> option to specify
+ the shared memory name. Shared memory connections are
+ supported only on Windows.
</para>
<indexterm type="type">
@@ -23764,7 +23793,7 @@
<literal>query_cache_size</literal> system variable to 0. By
disabling the query cache code, there is no noticeable overhead.
Query cache capabilities can be excluded from the server entirely
- by using the <literal>--without-query-cache</literal> option to
+ by using the <option>--without-query-cache</option> option to
<command>configure</command> when compiling MySQL.
</para>
| Thread |
|---|
| • bk commit - mysqldoc@docsrva tree (paul:1.3207) | paul | 8 Aug |
