Option Index

-

Section 12.1.1, “ALTER DATABASE Syntax”
Section 12.5.1.3, “GRANT Syntax”
Section 11.8.2, “Boolean Full-Text Searches”
Section 10.6, “Choosing the Right Type for a Column”
Section 11.6, “Date and Time Functions”
Section 4.2.1, “Invoking MySQL Programs”
Section 8.1.2, “Numbers”
Section 10.1.1, “Overview of Numeric Types”
Section 11.4.2, “Regular Expressions”
Section 5.1.2, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 5.4.3, “Specifying Account Names”
Section 4.2.3.1, “Using Options on the Command Line”

-#

Section 21.5.3, “The DBUG Package”

-# [debug_options]

Section 4.5.1.1, “mysql Options”
Description
Description
Description
Description
Description
Description
Description
Description

-# [debug_options]

Section 5.1.2, “Server Command Options”

-# debug_options

Description

-#...

Section 21.5.3, “The DBUG Package”

-#D,20

Section 21.5.3, “The DBUG Package”

-#debug_options

Description

--

Section 1.7.5.6, “'--' as the Start of a Comment”
Section 8.5, “Comment Syntax”
Description
Section 4.2.1, “Invoking MySQL Programs”

--HELP

Section 4.6.3.1, “myisamchk General Options”

--abort-slave-event-count

Section 16.1.3.3, “Replication Slave Options and Variables”

--add-drop-database

Description

--add-drop-table

Description

--add-locks

Description

--addtodest

Description

--all-databases

Description
Description
Section 2.11.2.1, “Downgrading to MySQL 5.0”
Section 8.2.3, “Mapping of Identifiers to File Names”
Section 2.11.4, “Rebuilding or Repairing Tables or Indexes”

--all-in-1

Description

--all-tablespaces

Description
Section 1.4.1, “What Is New in MySQL 6.0”

--allow-keywords

Description

--allow-suspicious-udfs

Section 5.3.3, “Security-Related mysqld Options”
Section 5.1.2, “Server Command Options”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 6.0”
Section 21.3.2.6, “User-Defined Function Security Precautions”

--allowold

Description

--analyze

Section 4.6.3.1, “myisamchk General Options”
Description
Section 4.6.3.4, “Other myisamchk Options”
Section 6.5.4, “Table Optimization”

--ansi

Section 1.7.3, “Running MySQL in ANSI Mode”
Section 5.1.2, “Server Command Options”

--auto-generate-sql

Description

--auto-generate-sql-add-autoincrement

Description

--auto-generate-sql-execute-number=N

Description

--auto-generate-sql-guid-primary

Description

--auto-generate-sql-load-type=type

Description

--auto-generate-sql-secondary-indexes=N

Description

--auto-generate-sql-unique-query-number=N

Description

--auto-generate-sql-unique-write-number=N

Description

--auto-generate-sql-write-number

Description

--auto-generate-sql-write-number=N

Description

--auto-rehash

Section 4.5.1.2, “mysql Commands”
Section 4.5.1.1, “mysql Options”

--auto-repair

Description

--autoclose

Description
Section 2.7, “Installing MySQL on NetWare”

--back_log=50

Section 2.12.3, “Solaris Notes”

--backup

Section 4.6.3.3, “myisamchk Repair Options”
Description

--backup_history_log

Section 5.1.2, “Server Command Options”

--backup_progress_log

Section 5.1.2, “Server Command Options”

--base64-output

Description

--base64-output=DECODE-ROWS

Section 4.6.8.2, “mysqlbinlog Row Event Display”

--base64-output=NEVER

Section 4.6.8.2, “mysqlbinlog Row Event Display”

--base64-output[=value]

Description

--basedir

Section 2.9.6.1, “Building MySQL from Source Using CMake and Visual Studio”
Section 5.6, “Running Multiple MySQL Servers on the Same Machine”
Section 5.1.4, “Server System Variables”
Section 2.10.2.3, “Starting and Troubleshooting the MySQL Server”
Section 2.9.2, “Typical configure Options”
Section 2.10.2, “Unix Post-Installation Procedures”

--basedir=path

Description
Description
Section 5.6, “Running Multiple MySQL Servers on the Same Machine”
Section 5.1.2, “Server Command Options”

--batch

Section 4.5.1.1, “mysql Options”

--bdb-no-recover

Section 2.10.2.3, “Starting and Troubleshooting the MySQL Server”

--big-tables

Section 7.5.8, “How MySQL Uses Memory”
Section 5.1.2, “Server Command Options”

--bind-address

Description
Section 5.6, “Running Multiple MySQL Servers on the Same Machine”

--bind-address=127.0.0.1

Section B.1.2.2, “Can't connect to [local] MySQL server
Section 5.4.7, “Causes of Access-Denied Errors”

--bind-address=IP

Section 5.1.2, “Server Command Options”

--binlog-do-db

Section 16.1.3.4, “Binary Log Options and Variables”
Section 16.4.3, “How Servers Evaluate Replication Filtering Rules”
Section 16.1.3.3, “Replication Slave Options and Variables”
Section 5.2.4, “The Binary Log”

--binlog-do-db=db1

Section 16.1.3.4, “Binary Log Options and Variables”

--binlog-do-db=db_name

Section 16.1.3.4, “Binary Log Options and Variables”

--binlog-do-db=sales

Section 16.1.3.4, “Binary Log Options and Variables”
Section 5.2.4, “The Binary Log”

--binlog-format

Section 16.1.3.4, “Binary Log Options and Variables”

--binlog-format=MIXED

Section 5.2.4.1, “Binary Logging Formats”

--binlog-format=ROW

Section 5.2.4.1, “Binary Logging Formats”

--binlog-format=STATEMENT

Section 5.2.4.1, “Binary Logging Formats”

--binlog-format=mixed

Section A.4, “MySQL 6.0 FAQ — Stored Procedures and Functions”

--binlog-format=type

Section 5.2.4.2, “Setting The Binary Log Format”

--binlog-format={ROW|STATEMENT|MIXED}

Section 5.1.2, “Server Command Options”

--binlog-ignore-db

Section 16.1.3.4, “Binary Log Options and Variables”
Section 16.4.3, “How Servers Evaluate Replication Filtering Rules”
Section 16.1.3.3, “Replication Slave Options and Variables”
Section 5.2.4, “The Binary Log”

--binlog-ignore-db=db_name

Section 16.1.3.4, “Binary Log Options and Variables”

--binlog-ignore-db=sales

Section 16.1.3.4, “Binary Log Options and Variables”

--binlog-row-event-max-size

Section 5.2.4.2, “Setting The Binary Log Format”

--binlog-row-event-max-size=N

Section 16.1.3.4, “Binary Log Options and Variables”

--block-search=offset

Section 4.6.3.4, “Other myisamchk Options”

--bootstrap

Section 2.9.6.1, “Building MySQL from Source Using CMake and Visual Studio”
Section 5.1.2, “Server Command Options”
Section 2.9.2, “Typical configure Options”

--brief

Description

--build=x86_64-pc-solaris2.10

Section 2.9, “MySQL Installation Using a Source Distribution”

--cflags

Description

--character-set-client-handshake

Section A.11, “MySQL 6.0 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”
Section 5.1.2, “Server Command Options”
Section 9.1.13.7.1, “The cp932 Character Set”

--character-set-filesystem=charset_name

Section 5.1.2, “Server Command Options”

--character-set-server

Section 9.1.5, “Configuring the Character Set and Collation for Applications”
Section 16.3.1.2, “Replication and Character Sets”
Section 9.1.3.1, “Server Character Set and Collation”
Section 5.1.2, “Server Command Options”
Section 9.2, “The Character Set Used for Data and Sorting”
Section 8.4, “User-Defined Variables”

--character-set-server=charset_name

Section 5.1.2, “Server Command Options”

--character-set-server=latin1

Section 9.1.3.1, “Server Character Set and Collation”
Section 9.2.1, “Using the German Character Set”

--character-set-server=utf8

Section A.11, “MySQL 6.0 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”

--character-sets-dir

Section B.1.2.17, “Can't initialize character set
Section 9.6, “Problems With Character Sets”
Section 9.2, “The Character Set Used for Data and Sorting”

--character-sets-dir=path

Section 4.6.3.3, “myisamchk Repair Options”
Section 4.5.1.1, “mysql Options”
Description
Description
Description
Description
Description
Description
Description
Section 5.1.2, “Server Command Options”

--charset=path, -C path

Description

--check

Section 4.6.3.2, “myisamchk Check Options”
Description

--check-only-changed

Section 4.6.3.2, “myisamchk Check Options”
Description

--check-upgrade

Description

--checkpoint

Description

--checkpoint=db_name.tbl_name

Description

--chroot

Description

--chroot=path

Description
Section 5.1.2, “Server Command Options”

--collation-server

Section 9.1.5, “Configuring the Character Set and Collation for Applications”
Section 16.3.1.2, “Replication and Character Sets”
Section 9.1.3.1, “Server Character Set and Collation”
Section 5.1.2, “Server Command Options”
Section 9.2, “The Character Set Used for Data and Sorting”

--collation-server=collation_name

Section 5.1.2, “Server Command Options”

--collation-server=latin1_german1_ci

Section 9.2.1, “Using the German Character Set”

--collation-server=latin1_swedish_ci

Section 9.1.3.1, “Server Character Set and Collation”

--column-names

Section 4.5.1.1, “mysql Options”
Section 4.2.3.2, “Program Option Modifiers”

--column-type-info

Section 4.5.1.1, “mysql Options”

--columns=column_list

Description

--comments

Section 4.5.1.1, “mysql Options”
Description

--commit

Description

--commit=N

Description

--comp

Section 4.2.3, “Specifying Program Options”

--compact

Description

--compatible

Description

--compatible=name

Description

--compatible=oracle

Description

--complete-insert

Description

--compr

Section 4.2.3, “Specifying Program Options”

--compress

Section 4.5.1.1, “mysql Options”
Section 12.2.6, “LOAD DATA INFILE Syntax”
Section 5.5.7.1, “Basic SSL Concepts”
Description
Description
Description
Description
Description
Description
Section 4.2.3, “Specifying Program Options”

--concurrency=N

Description

--config-file

Description
Section A.10, “MySQL 6.0 FAQ — MySQL Cluster”

--config-file=file_name

Description
Description

--connect-string

Section A.10, “MySQL 6.0 FAQ — MySQL Cluster”

--console

Section 13.7.13.3, “InnoDB General Troubleshooting”
Section 13.7.13.2, “SHOW ENGINE INNODB STATUS and the InnoDB Monitors”
Section 13.7.2.3, “Creating the InnoDB Tablespace”
Section B.1.4.1.1, “Resetting the Root Password on Windows Systems”
Section 5.1.2, “Server Command Options”
Section 2.3.9, “Starting the Server for the First Time”
Section 5.2.2, “The Error Log”

--copy

Description

--core-file

Section 21.5.1.4, “Debugging mysqld under gdb
Section 2.12.1.4, “Linux Post-Installation Notes”
Section 5.1.2, “Server Command Options”

--core-file-size

Section 5.1.2, “Server Command Options”

--core-file-size=1000000

Section 2.12.1.4, “Linux Post-Installation Notes”

--core-file-size=size

Description

--correct-checksum

Section 4.6.3.3, “myisamchk Repair Options”

--count

Description
Description
Description

--count=N

Description

--create

Description

--create-options

Description

--create-schema=value

Description

--create=value

Description

--csv[=file_name]

Description

--data-file-length=len, -D len

Section 4.6.3.3, “myisamchk Repair Options”

--database

Description

--database=db_name

Section 4.5.1.1, “mysql Options”
Description

--databases

Description
Description

--datadir

Section 2.9.6.1, “Building MySQL from Source Using CMake and Visual Studio”
Section 2.3.7, “Creating an Option File”
Description
Section 5.1.4, “Server System Variables”
Section 2.10.2.3, “Starting and Troubleshooting the MySQL Server”
Section 2.9.2, “Typical configure Options”
Section 2.10.2, “Unix Post-Installation Procedures”
Section 4.2.3.3, “Using Option Files”

--datadir=path

Description
Description
Section 5.6, “Running Multiple MySQL Servers on the Same Machine”
Section 5.6.2, “Running Multiple Servers on Unix”
Section 5.1.2, “Server Command Options”

--db=db_name

Description

--debug

Section 21.5.1.1, “Compiling MySQL for Debugging”
Description
Description
Description
Section 5.1.4, “Server System Variables”
Section 2.3.10, “Starting MySQL from the Windows Command Line”
Section 2.10.2.3, “Starting and Troubleshooting the MySQL Server”
Section 21.5.3, “The DBUG Package”

--debug-check

Section 4.5.1.1, “mysql Options”
Description
Description
Description
Description
Description
Description
Description

--debug-info

Section 4.5.1.1, “mysql Options”
Description
Description
Description
Description
Description
Description
Description
Description

--debug-sync-timeout=N

Section 5.1.4, “Server System Variables”
Section 2.9.2, “Typical configure Options”

--debug-sync-timeout[=N]

Section 5.1.2, “Server Command Options”

--debug="..."

Section 21.5.3, “The DBUG Package”

--debug="d,parser_debug"

Section 5.1.2, “Server Command Options”
Section 2.9.2, “Typical configure Options”

--debug=+P

Section 5.1.2, “Server Command Options”

--debug=N

Description

--debug=T

Section 5.1.2, “Server Command Options”

--debug=d,general,query

Section 5.4.7, “Causes of Access-Denied Errors”

--debug=debug_options, -# debug_options

Section 4.6.3.1, “myisamchk General Options”
Description
Description

--debug[=debug_options]

Section 4.5.1.1, “mysql Options”
Description
Description
Description
Description
Description
Description
Description
Description
Section 5.1.2, “Server Command Options”

--default-character-set

Section 12.2.6, “LOAD DATA INFILE Syntax”
Section 9.1.4, “Connection Character Sets and Collations”
Description
Section 5.1.4, “Server System Variables”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 6.0”

--default-character-set=charset_name

Section 4.5.1.1, “mysql Options”
Description
Description
Description
Description
Description
Section 5.1.2, “Server Command Options”

--default-character-set=utf8

Section 9.1.5, “Configuring the Character Set and Collation for Applications”
Section 4.5.1.4, “Executing SQL Statements from a Text File”

--default-collation=collation_name

Section 5.1.2, “Server Command Options”

--default-storage-engine

Section 5.1.2, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 13.3, “Setting the Storage Engine”
Chapter 13, Storage Engines

--default-storage-engine=type

Section 5.1.2, “Server Command Options”

--default-table-type

Section 13.3, “Setting the Storage Engine”
Chapter 13, Storage Engines

--default-table-type=InnoDB

Section 12.5.6.17, “SHOW ENGINES Syntax”

--default-table-type=type

Section 5.1.2, “Server Command Options”

--default-time-zone

Section 16.3.1.24, “Replication and Time Zones”
Section 5.1.4, “Server System Variables”

--default-time-zone=timezone

Section 9.7, “MySQL Server Time Zone Support”
Section 5.1.2, “Server Command Options”

--default.key_buffer_size=256K

Section 5.1.6.1, “Structured System Variables”

--defaults-extra-file

Section 4.2.3.3.1, “Command-Line Options that Affect Option-File Handling”
Description
Description

--defaults-extra-file=file_name

Section 4.2.3.3.1, “Command-Line Options that Affect Option-File Handling”
Description
Description

--defaults-extra-file=path

Description
Section 4.2.3.3, “Using Option Files”

--defaults-file

Section 13.7.2, “InnoDB Configuration”
Section 4.2.3.3.1, “Command-Line Options that Affect Option-File Handling”
Description
Section 20.9.3, “Options with the Embedded Server”
Section B.1.4.1.1, “Resetting the Root Password on Windows Systems”
Section 5.6, “Running Multiple MySQL Servers on the Same Machine”
Section 5.6.1.2, “Starting Multiple Windows Servers as Services”
Section 5.6.1.1, “Starting Multiple Windows Servers at the Command Line”
Section 2.3.11, “Starting MySQL as a Windows Service”

--defaults-file=file_name

Section 4.2.3.3.1, “Command-Line Options that Affect Option-File Handling”
Description
Description
Description
Section 2.3.11, “Starting MySQL as a Windows Service”

--defaults-file=option_file_name

Section 2.11.1.1, “Upgrading from MySQL 5.1 to 6.0”

--defaults-group-suffix

Section 2.13, “Environment Variables”

--defaults-group-suffix=_other

Section 4.2.3.3.1, “Command-Line Options that Affect Option-File Handling”

--defaults-group-suffix=str

Section 4.2.3.3.1, “Command-Line Options that Affect Option-File Handling”

--defaults-group-suffix=suffix

Description

--delay-key-write

Section B.1.4.2, “What to Do If MySQL Keeps Crashing”

--delay-key-write=ALL

Section 13.5.1, “MyISAM Startup Options”
Section 7.3.5, “External Locking”
Section 16.3.4, “Replication FAQ”

--delay-key-write=OFF

Section 7.3.5, “External Locking”

--delay-key-write[={OFF|ON|ALL}]

Section 5.1.2, “Server Command Options”

--delay_key_write=1

Section 5.1.4, “Server System Variables”
Section 5.1.6, “Using System Variables”

--delay_key_write=ON

Section 5.1.4, “Server System Variables”
Section 5.1.6, “Using System Variables”

--delayed-insert

Description

--delete

Description

--delete-master-logs

Description

--delimiter

Description

--delimiter=str

Section 4.5.1.1, “mysql Options”
Description

--demangle

Section 21.5.1.5, “Using a Stack Trace”

--des-key-file

Section 12.5.7.3, “FLUSH Syntax”
Section 11.11.2, “Encryption and Compression Functions”

--des-key-file=file_name

Section 5.1.2, “Server Command Options”

--description

Section 4.6.3.4, “Other myisamchk Options”

--detach=N

Description

--disable

Section 4.2.3.2, “Program Option Modifiers”

--disable-auto-rehash

Section 4.5.1.1, “mysql Options”

--disable-community-features

Section 2.9.2, “Typical configure Options”

--disable-debug-sync

Section 2.9.2, “Typical configure Options”

--disable-dtrace

Section 2.9.2, “Typical configure Options”

--disable-grant-options

Section 5.1.2, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 2.9.2, “Typical configure Options”

--disable-keys

Description

--disable-log-bin

Description

--disable-named-commands

Section 4.5.1.1, “mysql Options”

--disable-plugin_name

Section 5.1.3, “Server Options for Loading Plugins”

--disable-profiling

Section 2.9.2, “Typical configure Options”

--disable-shared

Section 2.12.4.6, “BSD/OS Version 4.x Notes”
Section 2.9.2, “Typical configure Options”

--disconnect-slave-event-count

Section 16.1.3.3, “Replication Slave Options and Variables”

--dryrun

Description

--dump

Description

--dump-date

Description

--embedded

Description
Description

--enable-assembler

Section 2.12.3, “Solaris Notes”

--enable-community-features

Section 2.9.2, “Typical configure Options”

--enable-debug-sync

Section 5.1.2, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 2.9.2, “Typical configure Options”

--enable-dtrace

Section 2.9.2, “Typical configure Options”

--enable-local-infile

Section 5.3.4, “Security Issues with LOAD DATA LOCAL

--enable-locking

Section 7.3.5, “External Locking”
Section 5.1.2, “Server Command Options”

--enable-named-pipe

Section B.1.2.2, “Can't connect to [local] MySQL server
Section 4.2.2, “Connecting to the MySQL Server”
Section 2.3.8, “Selecting a MySQL Server Type”
Section 5.1.2, “Server Command Options”

--enable-plugin_name

Section 5.1.3, “Server Options for Loading Plugins”

--enable-profiling

Section 2.9.2, “Typical configure Options”

--enable-pstack

Section 5.1.2, “Server Command Options”

--enable-thread-safe-client

Section 2.9.2, “Typical configure Options”

--engine-condition-pushdown

Section 7.2.7, “Condition Pushdown Optimization”

--engine=engine_name

Description

--err-log=file_name

Description

--event-scheduler[=value]

Section 5.1.2, “Server Command Options”

--events

Description

--example

Description

--exe-suffix=suffix

Description

--execute

Section 4.2.3.1, “Using Options on the Command Line”

--execute=statement

Section 4.5.1.1, “mysql Options”

--exit-info[=flags]

Section 5.1.2, “Server Command Options”

--extend-check

Section 4.6.3.2, “myisamchk Check Options”
Section 4.6.3.1, “myisamchk General Options”
Section 4.6.3.3, “myisamchk Repair Options”

--extended

Description

--extended-insert

Description

--external-locking

Section 13.5.1, “MyISAM Startup Options”
Section 7.3.5, “External Locking”
Section 2.9.5, “MIT-pthreads Notes”
Section 5.1.2, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 7.5.2, “System Factors and Startup Parameter Tuning”

--extra-file=file_name

Description

--fast

Section 4.6.3.2, “myisamchk Check Options”
Description

--federated

Section 13.13, “The FEDERATED Storage Engine”

--fields-enclosed-by=...

Description
Description

--fields-escaped-by=...

Description
Description

--fields-optionally-enclosed-by=...

Description
Description

--fields-terminated-by=...

Description
Description

--fields-xxx

Description

--first-slave

Description

--fix-db-names

Description

--fix-table-names

Description

--flush

Section 5.1.2, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section B.1.4.2, “What to Do If MySQL Keeps Crashing”

--flush-logs

Description

--flush-privileges

Description

--flush_time=val

Section 21.1.1, “MySQL Threads”

--flushlog

Description

--force

Section 4.6.3.2, “myisamchk Check Options”
Section 4.6.3.3, “myisamchk Repair Options”
Section 4.5.1.1, “mysql Options”
Description
Description
Description
Description
Description
Section 2.12.1.2, “Linux Binary Distribution Notes”
Section 21.1.2, “MySQL Test Suite”
Section 3.5, “Using mysql in Batch Mode”

--force-read

Description

--gdb

Section 21.5.1.4, “Debugging mysqld under gdb
Section 5.1.2, “Server Command Options”

--general-log

Section 5.1.2, “Server Command Options”

--general-log[={0|1}]

Section 5.1.2, “Server Command Options”

--general_log

Section 5.6, “Running Multiple MySQL Servers on the Same Machine”
Section 5.2.1, “Selecting General Query and Slow Query Log Output Destinations”
Section 5.1.2, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 5.2.3, “The General Query Log”

--general_log_file

Section 5.1.2, “Server Command Options”
Section 5.1.4, “Server System Variables”

--general_log_file=file_name

Section 5.2.1, “Selecting General Query and Slow Query Log Output Destinations”
Section 5.1.2, “Server Command Options”
Section 5.2.3, “The General Query Log”

--header_file=file_name, -H file_name

Description

--help

Section 4.6.3.1, “myisamchk General Options”
Section 4.5.1.1, “mysql Options”
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Section 4.1, “Overview of MySQL Programs”
Section 5.1.2, “Server Command Options”
Section 2.10.2.3, “Starting and Troubleshooting the MySQL Server”
Section 7.5.3, “Tuning Server Parameters”
Chapter 3, Tutorial
Section 2.10.2, “Unix Post-Installation Procedures”
Section 4.2.3.3, “Using Option Files”
Section 4.2.3.1, “Using Options on the Command Line”

--hex-blob

Description

--hexdump

Section 4.6.8.1, “mysqlbinlog Hex Dump Format”
Description

--host

Section 5.4.7, “Causes of Access-Denied Errors”
Section 4.2.2, “Connecting to the MySQL Server”
Description
Section 4.2.1, “Invoking MySQL Programs”
Section 2.9.5, “MIT-pthreads Notes”
Section 4.2.3.5, “Option Defaults, Options Expecting Values, and the = Sign”
Section 5.6.3, “Using Client Programs in a Multiple-Server Environment”

--host=--user

Section 4.2.3.5, “Option Defaults, Options Expecting Values, and the = Sign”

--host=127.0.0.1

Section 5.4.7, “Causes of Access-Denied Errors”
Section 5.6.3, “Using Client Programs in a Multiple-Server Environment”

--host=host_name

Section 4.5.1.1, “mysql Options”
Section 4.2.2, “Connecting to the MySQL Server”
Description
Description
Description
Description
Description
Description
Description
Description
Description
Section 5.6.3, “Using Client Programs in a Multiple-Server Environment”

--host=localhost

Section 5.6.3, “Using Client Programs in a Multiple-Server Environment”
Section 4.2.3.3, “Using Option Files”
Section 4.2.3.1, “Using Options on the Command Line”

--howto

Description

--html

Section 4.5.1.1, “mysql Options”

--i-am-a-dummy

Section 4.5.1.1, “mysql Options”
Section 4.5.1.5.2, “Using the --safe-updates Option”

--ignore

Description

--ignore-builtin-innodb

Section 13.7.3, “InnoDB Startup Options and System Variables”

--ignore-lines=N

Description

--ignore-spaces

Section 4.5.1.1, “mysql Options”

--ignore-table=db_name.tbl_name

Description

--in_file=file_name, -F file_name

Description

--include

Description

--info

Description
Description

--information

Section 4.6.3.2, “myisamchk Check Options”

--init-file

Section 2.9.6.1, “Building MySQL from Source Using CMake and Visual Studio”
Section B.1.4.1.2, “Resetting the Root Password on Unix Systems”
Section B.1.4.1.1, “Resetting the Root Password on Windows Systems”
Section 5.1.4, “Server System Variables”
Section 13.11, “The MEMORY (HEAP) Storage Engine”
Section 2.9.2, “Typical configure Options”

--init-file=file_name

Section 5.1.2, “Server Command Options”

--init_connect="SET NAMES 'utf8'"

Section 9.1.5, “Configuring the Character Set and Collation for Applications”

--innodb

Section 13.7.3, “InnoDB Startup Options and System Variables”

--innodb-autoinc-lock-mode

Section 13.7.4.3.2, “Configurable InnoDB Auto-Increment Locking”

--innodb-xxx

Section 5.1.2, “Server Command Options”

--innodb[=value]

Section 13.7.3, “InnoDB Startup Options and System Variables”

--innodb_checksums

Section 13.7.3, “InnoDB Startup Options and System Variables”

--innodb_file_per_table

Section 13.7.2.1, “Using Per-Table Tablespaces”
Section 7.6.1.3, “Using Symbolic Links for Databases on Windows”

--innodb_locks_unsafe_for_binlog

Section 16.1.3.4, “Binary Log Options and Variables”

--innodb_rollback_on_timeout

Section 13.7.12, “InnoDB Error Handling”
Section 13.7.3, “InnoDB Startup Options and System Variables”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 6.0”

--innodb_status_file

Section 13.7.3, “InnoDB Startup Options and System Variables”

--innodb_status_file=1

Section 13.7.3, “InnoDB Startup Options and System Variables”

--innodb_support_xa

Section 5.2.4, “The Binary Log”

--insert-ignore

Description

--install

Section 5.6.1.2, “Starting Multiple Windows Servers as Services”
Section 2.3.11, “Starting MySQL as a Windows Service”

--install-manual

Section 5.6.1.2, “Starting Multiple Windows Servers as Services”
Section 2.3.11, “Starting MySQL as a Windows Service”

--iterations=N

Description

--join=big_tbl_name

Description

--keep_files_on_create

Section 12.1.14, “CREATE TABLE Syntax”

--keepold

Description

--key_buffer_size=32M

Section 5.1.2, “Server Command Options”

--keys

Description

--keys-used=val

Section 4.6.3.3, “myisamchk Repair Options”

--language

Section 9.3, “Setting the Error Message Language”

--language=lang_name, -L lang_name

Section 5.1.2, “Server Command Options”

--large-pages

Section 7.5.9, “Enabling Large Page Support”
Section 5.1.2, “Server Command Options”
Section 5.1.4, “Server System Variables”

--ledir

Description

--ledir=path

Description

--length

Description

--libmysqld-libs

Description

--libs

Description

--libs_r

Description

--line-numbers

Section 4.5.1.1, “mysql Options”

--lines-terminated-by

Description

--lines-terminated-by="\r\n"

Description

--lines-terminated-by=...

Description
Description

--local

Section 12.2.6, “LOAD DATA INFILE Syntax”
Description
Section 5.3.4, “Security Issues with LOAD DATA LOCAL

--local-infile

Section 5.3.4, “Security Issues with LOAD DATA LOCAL

--local-infile=0

Section 4.5.1.1, “mysql Options”
Section 12.2.6, “LOAD DATA INFILE Syntax”
Section 12.2.7, “LOAD XML Syntax”
Section 5.3.4, “Security Issues with LOAD DATA LOCAL
Section 5.3.3, “Security-Related mysqld Options”

--local-infile=1

Section 4.5.1.1, “mysql Options”

--local-infile=OFF

Section 12.2.7, “LOAD XML Syntax”

--local-infile[=1]

Section 5.3.4, “Security Issues with LOAD DATA LOCAL

--local-infile[={0|1}]

Section 4.5.1.1, “mysql Options”
Section 5.3.3, “Security-Related mysqld Options”

--local-load

Description

--local-load=path

Description

--local-service

Section 2.3.11, “Starting MySQL as a Windows Service”

--lock-all-tables

Description

--lock-directory

Description

--lock-directory=path

Description

--lock-tables

Description
Description

--log

Section 5.4.7, “Causes of Access-Denied Errors”
Section 5.2.1, “Selecting General Query and Slow Query Log Output Destinations”
Section 5.1.2, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 5.2.3, “The General Query Log”

--log-backup-output[=value,...]

Section 5.1.2, “Server Command Options”

--log-bin

Section 12.6.2.1, “CHANGE MASTER TO Syntax”
Section 12.6.1.1, “PURGE BINARY LOGS Syntax”
Section 6.2.1, “Backup Policy”
Section 6.2.3, “Backup Strategy Summary”
Section 16.1.3.4, “Binary Log Options and Variables”
Section 18.6, “Binary Logging of Stored Programs”
Section 6.1, “Database Backups”
Section 16.3.6, “How to Report Replication Bugs or Problems”
Section 6.4, “Point-in-Time Recovery”
Section 16.1.3.3, “Replication Slave Options and Variables”
Section 5.2.4, “The Binary Log”
Section 16.3.5, “Troubleshooting Replication”
Section 6.2.2, “Using Backups for Recovery”

--log-bin-index[=file_name]

Section 16.1.3.4, “Binary Log Options and Variables”
Section 5.2.4, “The Binary Log”

--log-bin-trust-function-creators

Section 16.1.3.4, “Binary Log Options and Variables”

--log-bin-trust-function-creators=1

Section 16.1.3.4, “Binary Log Options and Variables”
Section 18.6, “Binary Logging of Stored Programs”

--log-bin-trust-function-creators[={0|1}]

Section 16.1.3.4, “Binary Log Options and Variables”

--log-bin-trust-routine-creators

Section 16.1.3.4, “Binary Log Options and Variables”

--log-bin-trust-routine-creators[={0|1}]

Section 16.1.3.4, “Binary Log Options and Variables”

--log-bin=base_name.extension

Section 5.2.4, “The Binary Log”

--log-bin=log_name

Section 6.2.3, “Backup Strategy Summary”

--log-bin=old_host_name-bin

Section B.1.8.1, “Open Issues in MySQL”

--log-bin[=base_name]

Section 16.1.3.4, “Binary Log Options and Variables”
Section 5.2.4, “The Binary Log”

--log-bin[=file_name]

Section 5.6, “Running Multiple MySQL Servers on the Same Machine”

--log-error

Section 12.5.7.3, “FLUSH Syntax”
Description
Section 4.2.3.5, “Option Defaults, Options Expecting Values, and the = Sign”
Section 5.1.2, “Server Command Options”
Section 5.2.6, “Server Log Maintenance”
Section 5.2.2, “The Error Log”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 6.0”

--log-error my-errors

Section 4.2.3.5, “Option Defaults, Options Expecting Values, and the = Sign”

--log-error=file_name

Description
Description
Section 5.2.2, “The Error Log”

--log-error[=file_name]

Section 5.6, “Running Multiple MySQL Servers on the Same Machine”
Section 5.1.2, “Server Command Options”
Section 5.2.2, “The Error Log”

--log-isam[=file_name]

Section 5.1.2, “Server Command Options”

--log-long-format

Section 5.1.2, “Server Command Options”

--log-output

Section 1.4.1, “What Is New in MySQL 6.0”
Section 5.2.1, “Selecting General Query and Slow Query Log Output Destinations”
Section 5.1.2, “Server Command Options”
Section 5.2.3, “The General Query Log”
Section 5.2.5, “The Slow Query Log”

--log-output=FILE

Section 5.2.1, “Selecting General Query and Slow Query Log Output Destinations”

--log-output=TABLE

Section 5.2.1, “Selecting General Query and Slow Query Log Output Destinations”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 6.0”

--log-output=TABLE,FILE

Section 5.2.1, “Selecting General Query and Slow Query Log Output Destinations”

--log-output[=value,...]

Section 5.2.1, “Selecting General Query and Slow Query Log Output Destinations”
Section 5.1.2, “Server Command Options”

--log-queries-not-using-indexes

Section 5.1.2, “Server Command Options”
Section 5.2.5, “The Slow Query Log”

--log-short-format

Section 5.1.2, “Server Command Options”

--log-slave-updates

Section 16.3.6, “How to Report Replication Bugs or Problems”
Section 16.1.3.3, “Replication Slave Options and Variables”
Section 5.2.4, “The Binary Log”

--log-slow-admin-statements

Section 5.1.2, “Server Command Options”
Section 5.2.5, “The Slow Query Log”

--log-slow-queries

Section 5.2.1, “Selecting General Query and Slow Query Log Output Destinations”
Section 5.1.2, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 5.2.5, “The Slow Query Log”

--log-slow-queries[=file_name]

Section 5.6, “Running Multiple MySQL Servers on the Same Machine”
Section 5.1.2, “Server Command Options”
Section 5.2.5, “The Slow Query Log”

--log-slow-slave-statements

Section 16.1.3.3, “Replication Slave Options and Variables”

--log-tc-size

Section 5.1.7, “Server Status Variables”

--log-tc-size=size

Section 5.1.2, “Server Command Options”

--log-tc=file_name

Section 5.1.2, “Server Command Options”

--log-warnings

Section B.1.2.11, “Communication Errors and Aborted Connections”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 5.1.2, “Server Command Options”
Section 5.2.2, “The Error Log”

--log-warnings=0

Section 5.1.2, “Server Command Options”

--log-warnings=2

Section B.1.2.9, “MySQL server has gone away

--log-warnings[=level]

Section 16.1.3.3, “Replication Slave Options and Variables”
Section 5.1.2, “Server Command Options”

--log=file_name

Description

--log[=file_name]

Section 5.6, “Running Multiple MySQL Servers on the Same Machine”
Section 5.1.2, “Server Command Options”
Section 5.2.3, “The General Query Log”

--loose

Section 4.2.3.2, “Program Option Modifiers”

--loose-opt_name

Section 4.2.3.3, “Using Option Files”

--low-priority

Description

--low-priority-updates

Section 12.2.5, “INSERT Syntax”
Section 7.3.3, “Concurrent Inserts”
Section 16.3.4, “Replication FAQ”
Section 5.1.2, “Server Command Options”
Section 7.3.2, “Table Locking Issues”

--lower-case-table-names=0

Section 8.2.2, “Identifier Case Sensitivity”

--master-bind

Section 12.6.2.1, “CHANGE MASTER TO Syntax”

--master-connect-retry

Section 12.5.6.34, “SHOW SLAVE STATUS Syntax”
Section 16.3.1.15, “Replication During a Master Shutdown”
Section 7.5.6.5, “Replication Slave I/O Thread States”
Section 16.1.3.3, “Replication Slave Options and Variables”

--master-connect-retry=seconds

Section 16.1.3.3, “Replication Slave Options and Variables”

--master-data

Section 16.1.1.5, “Creating a Data Snapshot Using mysqldump
Description

--master-data[=value]

Description

--master-host

Section 16.1.3.3, “Replication Slave Options and Variables”

--master-host=host_name

Section 16.1.3.3, “Replication Slave Options and Variables”

--master-info-file

Section 16.4.2.2, “The Slave Status Files”

--master-info-file=file_name

Section 16.1.3.3, “Replication Slave Options and Variables”

--master-password

Section 16.1.3.3, “Replication Slave Options and Variables”

--master-password=password

Section 16.1.3.3, “Replication Slave Options and Variables”

--master-port

Section 16.1.3.3, “Replication Slave Options and Variables”

--master-port=port_number

Section 16.1.3.3, “Replication Slave Options and Variables”

--master-retry-count

Section 12.6.2.1, “CHANGE MASTER TO Syntax”
Section 16.1.3.3, “Replication Slave Options and Variables”

--master-retry-count=count

Section 16.1.3.3, “Replication Slave Options and Variables”

--master-ssl

Section 16.1.3.3, “Replication Slave Options and Variables”

--master-ssl*

Section 5.5.7.3, “SSL Command Options”

--master-ssl-ca

Section 16.1.3.3, “Replication Slave Options and Variables”

--master-ssl-ca=file_name

Section 16.1.3.3, “Replication Slave Options and Variables”

--master-ssl-capath

Section 16.1.3.3, “Replication Slave Options and Variables”

--master-ssl-capath=directory_name

Section 16.1.3.3, “Replication Slave Options and Variables”

--master-ssl-cert

Section 16.1.3.3, “Replication Slave Options and Variables”

--master-ssl-cert=file_name

Section 16.1.3.3, “Replication Slave Options and Variables”

--master-ssl-cipher

Section 16.1.3.3, “Replication Slave Options and Variables”

--master-ssl-cipher=cipher_list

Section 16.1.3.3, “Replication Slave Options and Variables”

--master-ssl-key

Section 16.1.3.3, “Replication Slave Options and Variables”

--master-ssl-key=file_name

Section 16.1.3.3, “Replication Slave Options and Variables”

--master-user

Section 16.1.3.3, “Replication Slave Options and Variables”

--master-user=user_name

Section 16.1.3.3, “Replication Slave Options and Variables”

--max

Section 4.2.3.4, “Using Options to Set Program Variables”

--max-binlog-dump-events

Section 16.1.3.4, “Binary Log Options and Variables”

--max-binlog-size

Section 16.1.3.3, “Replication Slave Options and Variables”

--max-record-length

Section 12.5.2.5, “REPAIR TABLE Syntax”

--max-record-length=len

Section 4.6.3.3, “myisamchk Repair Options”

--max-relay-log-size

Section 16.1.3.3, “Replication Slave Options and Variables”

--max-relay-log-size=size

Section 16.1.3.3, “Replication Slave Options and Variables”

--max-seeks-for-key=1000

Section 7.2.23, “How to Avoid Table Scans”
Section B.1.6, “Optimizer-Related Issues”

--max_a

Section 4.2.3.4, “Using Options to Set Program Variables”

--max_connect_errors=999999999

Section 12.5.7.3, “FLUSH Syntax”

--max_join_size

Section 4.5.1.5.2, “Using the --safe-updates Option”

--max_sort_length=N

Section 10.4.3, “The BLOB and TEXT Types”

--maximum

Section 4.2.3.2, “Program Option Modifiers”

--maximum-query_cache_size=32M

Section 7.5.5.3, “Query Cache Configuration”
Section 5.1.6, “Using System Variables”

--maximum-query_cache_size=4M

Section 4.2.3.2, “Program Option Modifiers”

--maximum-var_name=value

Section 5.1.2, “Server Command Options”
Section 5.1.6, “Using System Variables”

--medium-check

Section 4.6.3.2, “myisamchk Check Options”
Description

--memlock

Section 5.1.2, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 13.7.2.2, “Using Raw Devices for the Shared Tablespace”

--method=command

Description

--min-examined-row-limit=number

Section 5.1.2, “Server Command Options”

--myisam-block-size

Section 7.4.5.5, “Key Cache Block Size”

--myisam-block-size=N

Section 5.1.2, “Server Command Options”

--myisam-recover

Section 13.5.1, “MyISAM Startup Options”
Section 7.2.28, “Other Optimization Tips”
Section 5.1.4, “Server System Variables”
Section 6.5.6, “Setting Up a Table Maintenance Schedule”
Section B.1.2.19, “Table-Corruption Issues”
Section 13.5, “The MyISAM Storage Engine”
Section 21.5.1.6, “Using Server Logs to Find Causes of Errors in mysqld

--myisam-recover=BACKUP,FORCE

Section 5.1.4, “Server System Variables”

--myisam-recover=mode

Section 13.5.1, “MyISAM Startup Options”

--myisam-recover[=option[,option]...]]

Section 5.1.2, “Server Command Options”

--mysqladmin=prog_name

Description

--mysqld

Description
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 6.0”

--mysqld-version

Description
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 6.0”

--mysqld-version=debug

Description

--mysqld-version=max

Description

--mysqld-version=suffix

Description

--mysqld=mysqld_safe

Description

--mysqld=prog_name

Description
Description

--name_file=file_name, -N file_name

Description

--named-commands

Section 4.5.1.1, “mysql Options”

--ndb

Description

--ndb-connectstring

Section A.10, “MySQL 6.0 FAQ — MySQL Cluster”

--ndb-log-empty-epochs

Section 16.1.3.3, “Replication Slave Options and Variables”

--ndbcluster

Section 12.5.6.17, “SHOW ENGINES Syntax”
Section A.10, “MySQL 6.0 FAQ — MySQL Cluster”

--new

Section 2.11.1.1, “Upgrading from MySQL 5.1 to 6.0”
Section 4.2.3.3, “Using Option Files”

--nice=priority

Description

--no-auto-rehash

Section 4.5.1.1, “mysql Options”

--no-autocommit

Description

--no-beep

Section 4.5.1.1, “mysql Options”
Description

--no-create-db

Description

--no-create-info

Description

--no-data

Description

--no-debug

Description

--no-defaults

Section 5.4.7, “Causes of Access-Denied Errors”
Section 4.2.3.3.1, “Command-Line Options that Affect Option-File Handling”
Description
Description
Description

--no-embedded

Description

--no-log

Description

--no-named-commands

Section 4.5.1.1, “mysql Options”

--no-pager

Section 4.5.1.1, “mysql Options”

--no-set-names

Description

--no-symlinks

Section 4.6.3.3, “myisamchk Repair Options”

--no-tee

Section 4.5.1.1, “mysql Options”

--noindices

Description

--number-char-cols=N

Description

--number-int-cols=N

Description

--number-of-queries=N

Description

--numeric-dump-file=file_name

Description

--offset=N

Description

--old-passwords

Section B.1.2.4, “Client does not support authentication protocol
Section 5.5.6.3, “Password Hashing in MySQL”
Section 5.3.3, “Security-Related mysqld Options”
Section 5.1.2, “Server Command Options”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 6.0”

--old-style-user-limits

Section 5.5.4, “Limiting Account Resources”
Section 5.1.2, “Server Command Options”

--old_server

Description

--one-database

Section 4.5.1.1, “mysql Options”

--one-thread

Section 5.1.2, “Server Command Options”

--only-debug

Description

--only-print

Description

--open-files-limit

Section B.1.2.18, “'File' Not Found and Similar Errors”
Section 13.7.3, “InnoDB Startup Options and System Variables”
Section 2.12.4.1, “FreeBSD Notes”
Section 7.4.7, “How MySQL Opens and Closes Tables”
Section 2.3.15, “MySQL on Windows Compared to MySQL on Unix”
Section 5.1.4, “Server System Variables”

--open-files-limit=count

Description
Section 5.1.2, “Server Command Options”

--opt

Section 13.7.13.1, “InnoDB Performance Tuning Tips”
Section 2.11.5, “Copying MySQL Databases to Another Machine”
Description
Section 2.11.4, “Rebuilding or Repairing Tables or Indexes”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 6.0”

--opt_name

Section 4.2.3.3, “Using Option Files”

--opt_name=value

Section 4.2.3.3, “Using Option Files”

--optimize

Description

--order-by-primary

Description

--out_dir=path, -D path

Description

--out_file=file_name, -O file_name

Description

--pager

Section 4.5.1.2, “mysql Commands”
Section 4.5.1.1, “mysql Options”

--pager[=command]

Section 4.5.1.1, “mysql Options”

--parallel-recover

Section 4.6.3.3, “myisamchk Repair Options”

--password

Section 4.5.1.1, “mysql Options”
Section 5.5.2, “Adding User Accounts”
Section 5.4.7, “Causes of Access-Denied Errors”
Section 4.2.2, “Connecting to the MySQL Server”
Description
Description
Description
Description
Description
Description
Description
Description
Section 5.5.6.2, “End-User Guidelines for Password Security”
Section 6.2, “Example Backup and Recovery Strategy”
Section 4.2.1, “Invoking MySQL Programs”
Section B.1.2.5, “Password Fails When Entered Interactively”
Section 4.2.3.1, “Using Options on the Command Line”

--password=

Section 4.2.2, “Connecting to the MySQL Server”

--password=pass_val

Section 4.2.3.1, “Using Options on the Command Line”

--password=password

Description
Description

--password=your_pass

Section 5.4.7, “Causes of Access-Denied Errors”
Section 5.5.6.2, “End-User Guidelines for Password Security”

--password[=pass_val]

Section 4.2.2, “Connecting to the MySQL Server”

--password[=password]

Section 4.5.1.1, “mysql Options”
Description
Description
Description
Description
Description
Description
Description
Description

--pid-file

Description
Section 5.1.4, “Server System Variables”

--pid-file=file_name

Description
Description
Section 5.6, “Running Multiple MySQL Servers on the Same Machine”

--pid-file=path

Section 5.1.2, “Server Command Options”

--pipe

Section 4.5.1.1, “mysql Options”
Section 4.2.2, “Connecting to the MySQL Server”
Description
Description
Description
Description
Description
Description
Section 2.3.12, “Testing The MySQL Installation”

--plan

Description

--plugin-load

Section 12.5.4.3, “INSTALL PLUGIN Syntax”
Section 5.1.2, “Server Command Options”

--plugin-load=plugin_list

Section 5.1.2, “Server Command Options”

--plugin_dir=path

Section 21.2.1, “Characteristics of the Plugin Interface”

--plugin_name

Section 5.1.3, “Server Options for Loading Plugins”

--plugin_name=0

Section 5.1.3, “Server Options for Loading Plugins”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 6.0”

--plugin_name=1

Section 5.1.3, “Server Options for Loading Plugins”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 6.0”

--plugin_name=FORCE

Section 5.1.3, “Server Options for Loading Plugins”

--plugin_name=OFF

Section 5.1.3, “Server Options for Loading Plugins”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 6.0”

--plugin_name=ON

Section 5.1.3, “Server Options for Loading Plugins”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 6.0”

--plugin_name[=ON]

Section 5.1.3, “Server Options for Loading Plugins”

--plugindir

Description

--port

Section 5.4.7, “Causes of Access-Denied Errors”
Section 4.2.2, “Connecting to the MySQL Server”
Description
Description
Section 4.2.1, “Invoking MySQL Programs”
Section 5.6, “Running Multiple MySQL Servers on the Same Machine”
Section 5.6.2, “Running Multiple Servers on Unix”
Section 5.1.4, “Server System Variables”
Section 2.10.2.3, “Starting and Troubleshooting the MySQL Server”
Section 5.6.3, “Using Client Programs in a Multiple-Server Environment”

--port-open-timeout=num

Section 5.1.2, “Server Command Options”

--port=port_num

Section 4.5.1.1, “mysql Options”
Section 4.2.2, “Connecting to the MySQL Server”
Description
Description
Description
Description
Description
Description
Description
Description
Description
Section 5.6, “Running Multiple MySQL Servers on the Same Machine”
Section 5.1.2, “Server Command Options”

--port=port_number

Section 5.6.3, “Using Client Programs in a Multiple-Server Environment”

--position=N

Description

--post-query=value

Description

--post-system=str

Description

--pre-query=value

Description

--pre-system=str

Description

--prefix

Section 21.2.3.3, “Creating a Plugin Library”
Section 2.9.3, “Installing from the Development Source Tree”
Section 5.6.2, “Running Multiple Servers on Unix”

--preserve-schema

Description

--preview

Description

--print-defaults

Section 4.2.3.3.1, “Command-Line Options that Affect Option-File Handling”
Section 2.11.1, “Upgrading MySQL”

--prompt

Section 4.5.1.2, “mysql Commands”

--prompt=format_str

Section 4.5.1.1, “mysql Options”

--protocol

Section 4.2.2, “Connecting to the MySQL Server”
Description

--protocol=MEMORY

Section 2.3.9, “Starting the Server for the First Time”
Section 5.6.3, “Using Client Programs in a Multiple-Server Environment”

--protocol=PIPE

Section 4.2.2, “Connecting to the MySQL Server”
Section 2.3.12, “Testing The MySQL Installation”
Section 5.6.3, “Using Client Programs in a Multiple-Server Environment”

--protocol=SOCKET

Section 5.6.3, “Using Client Programs in a Multiple-Server Environment”

--protocol=TCP

Section 4.2.2, “Connecting to the MySQL Server”
Section 5.6.3, “Using Client Programs in a Multiple-Server Environment”

--protocol={TCP|SOCKET|PIPE|MEMORY}

Section 4.5.1.1, “mysql Options”
Section 4.2.2, “Connecting to the MySQL Server”
Description
Description
Description
Description
Description
Description
Description
Section 5.6.2, “Running Multiple Servers on Unix”

--query

Description

--query-cache-size=0

Section 7.3.5, “External Locking”

--query=value

Description

--quick

Section 4.6.3.5, “myisamchk Memory Usage”
Section 4.6.3.3, “myisamchk Repair Options”
Section 4.5.1.1, “mysql Options”
Section B.1.2.8, “Out of memory
Description
Description
Description
Section 6.5.1, “Using myisamchk for Crash Recovery”
Section 4.2.3.3, “Using Option Files”

--quiet

Description

--quote-names

Description
Section 2.11.4, “Rebuilding or Repairing Tables or Indexes”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 6.0”

--raw

Section 4.5.1.1, “mysql Options”

--read-from-remote-server

Description

--read-only

Section 4.6.3.2, “myisamchk Check Options”
Section 16.1.3.3, “Replication Slave Options and Variables”

--reconnect

Section 4.5.1.1, “mysql Options”

--record_log_pos

Description

--record_log_pos=db_name.tbl_name

Description

--recover

Section 4.6.3.2, “myisamchk Check Options”
Section 4.6.3.1, “myisamchk General Options”
Section 4.6.3.5, “myisamchk Memory Usage”
Section 4.6.3.3, “myisamchk Repair Options”

--regexp=expr

Description

--relative

Description

--relay-log

Section 16.1.1.9, “Introducing Additional Slaves to an Existing Replication Environment”
Section 16.1.3.3, “Replication Slave Options and Variables”
Section 16.4.2.1, “The Slave Relay Log”

--relay-log-index

Section 16.1.1.9, “Introducing Additional Slaves to an Existing Replication Environment”
Section 16.1.3.3, “Replication Slave Options and Variables”
Section 16.4.2.1, “The Slave Relay Log”

--relay-log-index=file_name

Section 16.1.3.3, “Replication Slave Options and Variables”

--relay-log-info-file

Section 16.4.2.2, “The Slave Status Files”

--relay-log-info-file=file_name

Section 16.1.3.3, “Replication Slave Options and Variables”

--relay-log-purge={0|1}

Section 16.1.3.3, “Replication Slave Options and Variables”

--relay-log-recovery

Section 16.1.3.3, “Replication Slave Options and Variables”

--relay-log-recovery={0|1}

Section 16.1.3.3, “Replication Slave Options and Variables”

--relay-log-space-limit

Section 16.1.3.3, “Replication Slave Options and Variables”

--relay-log-space-limit=size

Section 16.1.3.3, “Replication Slave Options and Variables”

--relay-log=file_name

Section 16.1.3.3, “Replication Slave Options and Variables”

--relay-log=myhost-bin

Section 12.6.2.1, “CHANGE MASTER TO Syntax”

--relnotes

Description

--remove

Section 5.6.1.2, “Starting Multiple Windows Servers as Services”
Section 2.3.11, “Starting MySQL as a Windows Service”

--repair

Description

--replace

Description
Description

--replicate-*

Section 16.4.3, “How Servers Evaluate Replication Filtering Rules”
Section 16.1.3.3, “Replication Slave Options and Variables”

--replicate-*-db

Section 16.4.3, “How Servers Evaluate Replication Filtering Rules”
Section 16.1.3.3, “Replication Slave Options and Variables”

--replicate-*-table

Section 16.4.3, “How Servers Evaluate Replication Filtering Rules”

--replicate-do-db

Section 12.5.6.34, “SHOW SLAVE STATUS Syntax”
Section 12.4.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”
Section 16.1.3.4, “Binary Log Options and Variables”
Section 16.4.3, “How Servers Evaluate Replication Filtering Rules”
Section 16.1.3.3, “Replication Slave Options and Variables”
Section 16.3.1.19, “Replication and Reserved Words”
Section 16.3.1.22, “Replication and Temporary Tables”

--replicate-do-db=db1

Section 16.1.3.3, “Replication Slave Options and Variables”

--replicate-do-db=db_name

Section 16.1.3.3, “Replication Slave Options and Variables”

--replicate-do-db=sales

Section 16.1.3.4, “Binary Log Options and Variables”
Section 16.1.3.3, “Replication Slave Options and Variables”

--replicate-do-table

Section 12.5.6.34, “SHOW SLAVE STATUS Syntax”
Section 16.4.3, “How Servers Evaluate Replication Filtering Rules”
Section 16.3.1.19, “Replication and Reserved Words”
Section 16.3.1.22, “Replication and Temporary Tables”

--replicate-do-table=db_name.tbl_name

Section 16.1.3.3, “Replication Slave Options and Variables”

--replicate-ignore-db

Section 12.5.6.34, “SHOW SLAVE STATUS Syntax”
Section 12.4.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”
Section 16.1.3.4, “Binary Log Options and Variables”
Section 16.4.3, “How Servers Evaluate Replication Filtering Rules”
Section 16.1.3.3, “Replication Slave Options and Variables”
Section 16.3.1.19, “Replication and Reserved Words”

--replicate-ignore-db=db_name

Section 16.1.3.3, “Replication Slave Options and Variables”

--replicate-ignore-db=sales

Section 16.1.3.3, “Replication Slave Options and Variables”

--replicate-ignore-table

Section 12.5.6.34, “SHOW SLAVE STATUS Syntax”
Section 16.4.3, “How Servers Evaluate Replication Filtering Rules”
Section 16.3.1.19, “Replication and Reserved Words”
Section 16.3.1.22, “Replication and Temporary Tables”

--replicate-ignore-table=db_name.tbl_name

Section 16.1.3.3, “Replication Slave Options and Variables”

--replicate-rewrite-db=from_name->to_name

Section 16.1.3.3, “Replication Slave Options and Variables”

--replicate-same-server-id

Section 12.6.2.1, “CHANGE MASTER TO Syntax”
Section 16.1.3.3, “Replication Slave Options and Variables”

--replicate-wild-do-table

Section 12.5.6.34, “SHOW SLAVE STATUS Syntax”
Section 16.4.3, “How Servers Evaluate Replication Filtering Rules”
Section 16.1.3.3, “Replication Slave Options and Variables”
Section 16.3.1.22, “Replication and Temporary Tables”

--replicate-wild-do-table=db_name.%

Section 16.1.3.3, “Replication Slave Options and Variables”

--replicate-wild-do-table=db_name.tbl_name

Section 16.1.3.3, “Replication Slave Options and Variables”

--replicate-wild-do-table=foo%.%

Section 16.1.3.3, “Replication Slave Options and Variables”

--replicate-wild-do-table=foo%.bar%

Section 16.1.3.3, “Replication Slave Options and Variables”

--replicate-wild-do-table=my\\_own\\%db

Section 16.1.3.3, “Replication Slave Options and Variables”

--replicate-wild-do-table=my\_own\%db

Section 16.1.3.3, “Replication Slave Options and Variables”

--replicate-wild-ignore-table

Section 12.5.6.34, “SHOW SLAVE STATUS Syntax”
Section 16.4.3, “How Servers Evaluate Replication Filtering Rules”
Section 16.1.3.3, “Replication Slave Options and Variables”
Section 16.3.1.22, “Replication and Temporary Tables”

--replicate-wild-ignore-table=db_name.%

Section 16.1.3.3, “Replication Slave Options and Variables”

--replicate-wild-ignore-table=db_name.tbl_name

Section 16.1.3.3, “Replication Slave Options and Variables”

--replicate-wild-ignore-table=foo%.bar%

Section 16.1.3.3, “Replication Slave Options and Variables”

--replicate-wild-ignore-table=mysql.%

Section 16.3.4, “Replication FAQ”

--replicate-wild-ignore-table=norep_

Section 16.3.1.22, “Replication and Temporary Tables”

--report-host

Section 5.1.4, “Server System Variables”

--report-host=host_name

Section 12.5.6.33, “SHOW SLAVE HOSTS Syntax”
Section 16.1.3.3, “Replication Slave Options and Variables”

--report-password

Section 16.1.3.3, “Replication Slave Options and Variables”
Section 5.1.4, “Server System Variables”

--report-password=password

Section 16.1.3.3, “Replication Slave Options and Variables”

--report-port

Section 5.1.4, “Server System Variables”

--report-port=slave_port_num

Section 16.1.3.3, “Replication Slave Options and Variables”

--report-user

Section 16.1.3.3, “Replication Slave Options and Variables”
Section 5.1.4, “Server System Variables”

--report-user=user_name

Section 16.1.3.3, “Replication Slave Options and Variables”

--resetmaster

Description

--resetslave

Description

--result-file=file_name

Description

--result-file=name

Description

--rhost=host_name

Description

--rollback

Description

--routines

Description
Section 2.11.2.1, “Downgrading to MySQL 5.0”

--safe-mode

Section 12.5.2.4, “OPTIMIZE TABLE Syntax”
Section 21.5.1, “Debugging a MySQL Server”
Section 5.1.2, “Server Command Options”
Section 5.1.4, “Server System Variables”

--safe-recover

Section 4.6.3.1, “myisamchk General Options”
Section 4.6.3.5, “myisamchk Memory Usage”
Section 4.6.3.3, “myisamchk Repair Options”

--safe-show-database

Section 5.3.3, “Security-Related mysqld Options”
Section 5.1.2, “Server Command Options”

--safe-updates

Section 4.5.1.2, “mysql Commands”
Section 4.5.1.1, “mysql Options”
Section 4.5.1.5.2, “Using the --safe-updates Option”

--safe-user-create

Section 5.3.3, “Security-Related mysqld Options”
Section 5.1.2, “Server Command Options”

--secure-auth

Section 4.5.1.1, “mysql Options”
Section 5.3.3, “Security-Related mysqld Options”
Section 5.1.2, “Server Command Options”
Section 5.1.4, “Server System Variables”

--secure-backup-file-priv

Section 5.1.2, “Server Command Options”

--secure-backup-file-priv=path

Section 5.1.2, “Server Command Options”

--secure-file-priv

Section 5.1.2, “Server Command Options”

--secure-file-priv=path

Section 5.3.3, “Security-Related mysqld Options”
Section 5.1.2, “Server Command Options”

--select_limit

Section 4.5.1.5.2, “Using the --safe-updates Option”

--server-id

Section 16.1.3, “Replication and Binary Logging Options and Variables”
Section 5.1.4, “Server System Variables”
Section 16.3.5, “Troubleshooting Replication”

--server-id=id

Description

--server-id=value

Section 12.5.6.33, “SHOW SLAVE HOSTS Syntax”

--service-startup-timeout=file_name

Description

--set-auto-increment[=value]

Section 4.6.3.4, “Other myisamchk Options”

--set-character-set

Section 2.9.2, “Typical configure Options”

--set-character-set=name

Section 4.6.3.3, “myisamchk Repair Options”

--set-charset

Description

--set-charset=charset_name

Description

--set-collation

Section 4.6.3.3, “myisamchk Repair Options”

--set-collation=name

Section 4.6.3.3, “myisamchk Repair Options”

--set-variable

Section 4.5.1.1, “mysql Options”
Section 13.7.3, “InnoDB Startup Options and System Variables”
Description

--set-variable=option=value

Section 4.2.3.4, “Using Options to Set Program Variables”

--set-variable=var_name=value

Section 7.5.3, “Tuning Server Parameters”

--shared-memory

Section 4.2.2, “Connecting to the MySQL Server”
Section 5.1.2, “Server Command Options”
Section 5.6.1.1, “Starting Multiple Windows Servers at the Command Line”
Section 2.3.9, “Starting the Server for the First Time”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 6.0”

--shared-memory-base-name

Section 20.10.3.49, “mysql_options()
Section 5.6.1.1, “Starting Multiple Windows Servers at the Command Line”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 6.0”
Section 5.6.3, “Using Client Programs in a Multiple-Server Environment”

--shared-memory-base-name=name

Section 4.2.2, “Connecting to the MySQL Server”
Description
Section 5.6, “Running Multiple MySQL Servers on the Same Machine”
Section 5.1.2, “Server Command Options”

--short-form

Description

--show-slave-auth-info

Section 16.1.3.3, “Replication Slave Options and Variables”

--show-table-type

Description

--show-warnings

Section 4.5.1.1, “mysql Options”

--sigint-ignore

Section 4.5.1.1, “mysql Options”

--silent

Section 4.6.3.1, “myisamchk General Options”
Section 4.5.1.1, “mysql Options”
Description
Description
Description
Description
Description
Description
Description
Description
Section 6.5.6, “Setting Up a Table Maintenance Schedule”

--single-transaction

Section 13.7.6, “Backing Up and Recovering an InnoDB Database”
Section 6.2.1, “Backup Policy”
Description

--skip

Description
Section 4.2.3.2, “Program Option Modifiers”

--skip-add-drop-table

Description

--skip-add-locks

Description

--skip-auto-rehash

Section 13.7.13.4, “Troubleshooting InnoDB Data Dictionary Operations”

--skip-base64-output

Description

--skip-character-set-client-handshake

Section A.11, “MySQL 6.0 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”
Section 5.1.2, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 9.1.13.7.1, “The cp932 Character Set”

--skip-column-names

Section 4.5.1.1, “mysql Options”

--skip-comments

Description

--skip-compact

Description

--skip-concurrent-insert

Section 5.1.2, “Server Command Options”

--skip-disable-keys

Description

--skip-dump-date

Description

--skip-engine_name

Section 12.5.6.17, “SHOW ENGINES Syntax”

--skip-events

Section 2.11.2.1, “Downgrading to MySQL 5.0”

--skip-extended-insert

Description

--skip-external-locking

Section 7.3.5, “External Locking”
Section 7.5.6.2, “General Thread States”
Section 2.7, “Installing MySQL on NetWare”
Section 5.1.2, “Server Command Options”
Section 7.5.2, “System Factors and Startup Parameter Tuning”
Section B.1.4.2, “What to Do If MySQL Keeps Crashing”

--skip-grant-tables

Section 12.5.4.1, “CREATE FUNCTION Syntax”
Section 12.5.4.3, “INSTALL PLUGIN Syntax”
Section 2.9.6.1, “Building MySQL from Source Using CMake and Visual Studio”
Section 5.4.7, “Causes of Access-Denied Errors”
Section 21.3.2.5, “Compiling and Installing User-Defined Functions”
Description
Section 2.10.2.1, “Problems Running mysql_install_db
Section B.1.4.1.2, “Resetting the Root Password on Unix Systems”
Section 5.3.3, “Security-Related mysqld Options”
Section 5.1.2, “Server Command Options”
Section 2.9.2, “Typical configure Options”
Section 4.2.3.1, “Using Options on the Command Line”
Section 5.4.6, “When Privilege Changes Take Effect”

--skip-host-cache

Section 5.4.7, “Causes of Access-Denied Errors”
Section 7.5.11, “How MySQL Uses DNS”
Section 5.1.2, “Server Command Options”

--skip-innodb

Section 13.7.2, “InnoDB Configuration”
Section 13.7.3, “InnoDB Startup Options and System Variables”
Section 12.5.6.17, “SHOW ENGINES Syntax”
Section 16.3.4, “Replication FAQ”
Section 5.1.2, “Server Command Options”
Section 5.1.4, “Server System Variables”

--skip-innodb-checksums

Section 13.7.3, “InnoDB Startup Options and System Variables”

--skip-innodb_adaptive_hash_index

Section 13.7.3, “InnoDB Startup Options and System Variables”

--skip-innodb_checksums

Section 13.7.3, “InnoDB Startup Options and System Variables”

--skip-innodb_doublewrite

Section 13.7.3, “InnoDB Startup Options and System Variables”

--skip-kill-mysqld

Description

--skip-line-numbers

Section 4.5.1.1, “mysql Options”

--skip-locking

Section 7.3.5, “External Locking”

--skip-log-warnings

Section 16.1.3.3, “Replication Slave Options and Variables”

--skip-merge

Section 5.3.3, “Security-Related mysqld Options”
Section 5.1.4, “Server System Variables”
Section 13.10, “The MERGE Storage Engine”

--skip-name-resolve

Section 5.4.7, “Causes of Access-Denied Errors”
Section 2.12.4.1, “FreeBSD Notes”
Section 7.5.11, “How MySQL Uses DNS”
Section 5.3.3, “Security-Related mysqld Options”
Section 5.1.2, “Server Command Options”
Section 2.3.12, “Testing The MySQL Installation”

--skip-named-commands

Section 4.5.1.1, “mysql Options”

--skip-networking

Section B.1.2.2, “Can't connect to [local] MySQL server
Section B.1.2.9, “MySQL server has gone away
Section 5.4.7, “Causes of Access-Denied Errors”
Section 7.5.11, “How MySQL Uses DNS”
Section 5.3.3, “Security-Related mysqld Options”
Section 5.1.2, “Server Command Options”
Section 5.1.4, “Server System Variables”

--skip-new

Section 12.5.2.4, “OPTIMIZE TABLE Syntax”
Section 21.5.1, “Debugging a MySQL Server”
Section 5.1.4, “Server System Variables”

--skip-opt

Description
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 6.0”

--skip-pager

Section 4.5.1.1, “mysql Options”

--skip-plugin_name

Section 5.1.3, “Server Options for Loading Plugins”

--skip-quick

Description

--skip-quote-names

Description
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 6.0”

--skip-reconnect

Section 4.5.1.1, “mysql Options”
Section 20.10.11, “Controlling Automatic Reconnection Behavior”
Section 4.5.1.5.3, “Disabling mysql Auto-Reconnect”

--skip-safemalloc

Section 21.5.1.1, “Compiling MySQL for Debugging”
Section 7.5.1, “How Compiling and Linking Affects the Speed of MySQL”
Section 5.1.2, “Server Command Options”

--skip-set-charset

Description

--skip-show-database

Section 12.5.6.15, “SHOW DATABASES Syntax”
Section 5.4.1, “Privileges Provided by MySQL”
Section 5.3.3, “Security-Related mysqld Options”
Section 5.1.2, “Server Command Options”

--skip-slave-start

Section 12.6.2.1, “CHANGE MASTER TO Syntax”
Section 12.6.2.5, “START SLAVE Syntax”
Section 16.1.3.3, “Replication Slave Options and Variables”
Section 16.3.5, “Troubleshooting Replication”

--skip-ssl

Section 5.5.7.3, “SSL Command Options”

--skip-stack-trace

Section 21.5.1.4, “Debugging mysqld under gdb
Section 5.1.2, “Server Command Options”

--skip-super-large-pages

Section 7.5.9, “Enabling Large Page Support”
Section 5.1.2, “Server Command Options”

--skip-symbolic-links

Section 12.1.14, “CREATE TABLE Syntax”
Section 5.3.2, “Making MySQL Secure Against Attackers”
Section 5.1.2, “Server Command Options”
Section 7.6.1.3, “Using Symbolic Links for Databases on Windows”
Section 7.6.1.2, “Using Symbolic Links for Tables on Unix”

--skip-syslog

Description
Section 5.2.2, “The Error Log”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 6.0”

--skip-thread-priority

Section 2.12.4.5, “BSD/OS Version 3.x Notes”
Section 2.12.2.1, “Mac OS X 10.x (Darwin)”
Section 5.1.2, “Server Command Options”

--skip-triggers

Description

--skip-tz-utc

Description

--skip-write-binlog

Description

--skip-xxx

Description

--skip_grant_tables

Section 4.2.3.1, “Using Options on the Command Line”

--slave

Description

--slave-load-tmpdir

Section 6.1, “Database Backups”

--slave-load-tmpdir=file_name

Section 16.1.3.3, “Replication Slave Options and Variables”

--slave-net-timeout

Section 16.1.3.3, “Replication Slave Options and Variables”

--slave-net-timeout=seconds

Section 16.1.3.3, “Replication Slave Options and Variables”

--slave-skip-errors

Section 16.3.1.25, “Replication and Transactions”

--slave-skip-errors=[err_code1,err_code2,...|all]

Section 16.1.3.3, “Replication Slave Options and Variables”

--slave_compressed_protocol={0|1}

Section 16.1.3.3, “Replication Slave Options and Variables”

--sleep

Description

--sleep=delay

Description

--slow-query-log

Section 5.1.2, “Server Command Options”

--slow-query-log[={0|1}]

Section 5.1.2, “Server Command Options”

--slow_query_log

Section 5.6, “Running Multiple MySQL Servers on the Same Machine”
Section 5.2.1, “Selecting General Query and Slow Query Log Output Destinations”
Section 5.1.2, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 5.2.5, “The Slow Query Log”

--slow_query_log_file

Section 5.1.4, “Server System Variables”

--slow_query_log_file=file_name

Section 5.2.1, “Selecting General Query and Slow Query Log Output Destinations”
Section 5.1.2, “Server Command Options”
Section 5.2.5, “The Slow Query Log”

--socket

Section B.1.2.2, “Can't connect to [local] MySQL server
Section 5.4.7, “Causes of Access-Denied Errors”
Section 4.2.2, “Connecting to the MySQL Server”
Description
Description
Section B.1.4.5, “How to Protect or Change the MySQL Unix Socket File”
Section 4.2.1, “Invoking MySQL Programs”
Section 5.6, “Running Multiple MySQL Servers on the Same Machine”
Section 5.6.2, “Running Multiple Servers on Unix”
Section 2.3.12, “Testing The MySQL Installation”
Section 5.6.3, “Using Client Programs in a Multiple-Server Environment”

--socket=/path/to/socket

Section B.1.2.2, “Can't connect to [local] MySQL server

--socket=file_name

Section 4.2.2, “Connecting to the MySQL Server”
Section 5.6.3, “Using Client Programs in a Multiple-Server Environment”

--socket=path

Section 4.5.1.1, “mysql Options”
Description
Description
Description
Description
Description
Description
Description
Description
Description
Section 5.6, “Running Multiple MySQL Servers on the Same Machine”
Section 5.1.2, “Server Command Options”

--sort-index

Section 4.6.3.4, “Other myisamchk Options”
Section 6.5.4, “Table Optimization”

--sort-records=N

Section 4.6.3.4, “Other myisamchk Options”

--sort-records=index_num

Section 6.5.4, “Table Optimization”

--sort-recover

Section 4.6.3.1, “myisamchk General Options”
Section 4.6.3.5, “myisamchk Memory Usage”
Section 4.6.3.3, “myisamchk Repair Options”

--sort_buffer_size=16M

Section 4.6.3.5, “myisamchk Memory Usage”

--spassword[=password]

Description

--sporadic-binlog-dump-fail

Section 16.1.3.4, “Binary Log Options and Variables”

--sql-mode

Section A.3, “MySQL 6.0 FAQ — Server SQL Mode”
Section 5.1.2, “Server Command Options”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 6.0”

--sql-mode=""

Section 5.1.8, “Server SQL Modes”

--sql-mode="mode_value"

Section 1.7.2, “Selecting SQL Modes”

--sql-mode="modes"

Section 5.1.8, “Server SQL Modes”

--sql-mode=IGNORE_SPACE

Chapter 11, Functions and Operators

--sql-mode=MAXDB

Section 10.3.1.1, “TIMESTAMP Properties”

--sql-mode=value[,value[,value...]]

Section 5.1.2, “Server Command Options”

--sql_mode="TRADITIONAL,ALLOW_INVALID_DATES"

Section 2.11.1.1, “Upgrading from MySQL 5.1 to 6.0”

--ssl

Section 4.5.1.1, “mysql Options”
Section 4.2.2, “Connecting to the MySQL Server”
Description
Description
Description
Description
Description
Description
Section 16.1.3.3, “Replication Slave Options and Variables”
Section 5.5.7.3, “SSL Command Options”
Section 5.3.3, “Security-Related mysqld Options”
Section 5.1.2, “Server Command Options”
Section 5.5.7.2, “Using SSL Connections”

--ssl*

Section 4.5.1.1, “mysql Options”
Section 4.2.2, “Connecting to the MySQL Server”
Description
Description
Description
Description
Description
Description
Section 5.3.3, “Security-Related mysqld Options”
Section 5.1.2, “Server Command Options”

--ssl-ca

Section 12.5.1.3, “GRANT Syntax”
Section 16.1.3.3, “Replication Slave Options and Variables”
Section 5.5.7.3, “SSL Command Options”
Section 5.5.7.2, “Using SSL Connections”

--ssl-ca=file_name

Section 5.5.7.3, “SSL Command Options”

--ssl-capath

Section 16.1.3.3, “Replication Slave Options and Variables”
Section 5.5.7.3, “SSL Command Options”

--ssl-capath=directory_name

Section 5.5.7.3, “SSL Command Options”

--ssl-cert

Section 12.5.1.3, “GRANT Syntax”
Section 16.1.3.3, “Replication Slave Options and Variables”
Section 5.5.7.3, “SSL Command Options”
Section 5.5.7.2, “Using SSL Connections”

--ssl-cert=file_name

Section 5.5.7.3, “SSL Command Options”

--ssl-cipher

Section 16.1.3.3, “Replication Slave Options and Variables”

--ssl-cipher=cipher_list

Section 5.5.7.3, “SSL Command Options”

--ssl-key

Section 12.5.1.3, “GRANT Syntax”
Section 16.1.3.3, “Replication Slave Options and Variables”
Section 5.5.7.3, “SSL Command Options”
Section 5.5.7.2, “Using SSL Connections”

--ssl-key=file_name

Section 5.5.7.3, “SSL Command Options”

--ssl-verify-server-cert

Section 12.6.2.1, “CHANGE MASTER TO Syntax”
Section 5.5.7.3, “SSL Command Options”
Section 16.4.2.2, “The Slave Status Files”

--ssl-xxx

Section 5.5.7.2, “Using SSL Connections”

--ssl=0

Section 5.5.7.3, “SSL Command Options”

--standalone

Section 21.5.1.2, “Creating Trace Files”
Section 5.1.2, “Server Command Options”
Section 2.3.10, “Starting MySQL from the Windows Command Line”

--start-datetime

Description
Section 6.4.1, “Specifying Times for Recovery”

--start-datetime=datetime

Description

--start-position

Description
Section 6.4.2, “Specifying Positions for Recovery”

--start-position=N

Description

--statefile=file_name, -S file_name

Description

--static

Section 2.12.3, “Solaris Notes”

--stats

Description

--status

Description

--stop-datetime

Description
Section 6.4.1, “Specifying Times for Recovery”

--stop-datetime=datetime

Description

--stop-position

Section 6.4.2, “Specifying Positions for Recovery”

--stop-position=N

Description

--suffix=str

Description

--super-large-pages

Section 7.5.9, “Enabling Large Page Support”
Section 5.1.2, “Server Command Options”

--superuser=user_name

Description

--symbolic-links

Section 5.1.2, “Server Command Options”
Section 7.6.1.3, “Using Symbolic Links for Databases on Windows”

--symbols-file=file_name

Description

--sysdate-is-now

Section 11.6, “Date and Time Functions”
Section 16.3.1.10, “Replication and System Functions”
Section 5.1.2, “Server Command Options”
Section 5.1.5, “Session System Variables”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 6.0”

--syslog

Description
Section 5.2.2, “The Error Log”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 6.0”

--syslog-tag=tag

Description
Section 5.2.2, “The Error Log”

--tab

Chapter 6, Backup and Recovery
Description

--tab=path

Description

--table

Section 4.5.1.1, “mysql Options”
Description

--table_cache

Section 7.4.7, “How MySQL Opens and Closes Tables”

--table_open_cache

Section 7.4.7, “How MySQL Opens and Closes Tables”

--tables

Description
Description

--tc-heuristic-recover={COMMIT|ROLLBACK}

Section 5.1.2, “Server Command Options”

--tcp-ip

Description

--tee

Section 4.5.1.2, “mysql Commands”

--tee=file_name

Section 4.5.1.1, “mysql Options”

--temp-pool

Section 5.1.2, “Server Command Options”

--test

Description

--thread-stack=192K

Section 2.12.1.5, “Linux x86 Notes”

--thread_cache_size=5'

Section 21.5.1.4, “Debugging mysqld under gdb

--thread_handling=no-threads

Section 5.1.2, “Server Command Options”

--thread_handling=one-thread

Section 5.1.2, “Server Command Options”

--thread_handling=one-thread-per-connection

Section 7.5.7, “How MySQL Uses Threads for Client Connections”

--thread_handling=pool-of-threads

Section 7.5.7, “How MySQL Uses Threads for Client Connections”

--thread_pool_size=N

Section 7.5.7, “How MySQL Uses Threads for Client Connections”

--thread_stack=N

Section 7.5.7, “How MySQL Uses Threads for Client Connections”

--timezone

Section 9.7, “MySQL Server Time Zone Support”
Section 5.1.4, “Server System Variables”
Section B.1.4.6, “Time Zone Problems”

--timezone=timezone

Description

--timezone=timezone_name

Section 9.7, “MySQL Server Time Zone Support”
Section 16.3.1.24, “Replication and Time Zones”
Section B.1.4.6, “Time Zone Problems”

--tmpdir

Section B.1.2.13, “Can't create/write to file
Section 5.1.2, “Server Command Options”
Section B.1.4.4, “Where MySQL Stores Temporary Files”

--tmpdir=path

Section 4.6.3.5, “myisamchk Memory Usage”
Section 4.6.3.3, “myisamchk Repair Options”
Description
Description
Section 5.6, “Running Multiple MySQL Servers on the Same Machine”
Section 5.1.2, “Server Command Options”

--to-last-log

Description

--transaction-isolation

Section 13.7.8, “The InnoDB Transaction Model and Locking”

--transaction-isolation=SERIALIZABLE

Section 2.11.1.1, “Upgrading from MySQL 5.1 to 6.0”

--transaction-isolation=level

Section 12.4.6, “SET TRANSACTION Syntax”
Section 5.1.2, “Server Command Options”

--triggers

Description

--tz-utc

Description

--unbuffered

Section 4.5.1.1, “mysql Options”

--unpack

Section 4.6.3.3, “myisamchk Repair Options”
Section 13.5.3, “MyISAM Table Storage Formats”
Description

--update-state

Section 4.6.3.2, “myisamchk Check Options”
Section 6.5.3, “How to Repair Tables”
Section 13.5, “The MyISAM Storage Engine”

--use-frm

Description

--use-manager

Description

--use-mysqld_safe

Description

--use-threads

Description

--use-threads=N

Description

--user

Section B.1.2.18, “'File' Not Found and Similar Errors”
Description
Description
Section 6.2, “Example Backup and Recovery Strategy”
Section 2.8, “Installing MySQL from tar.gz Packages on Other Unix-Like Systems”
Section 4.2.1, “Invoking MySQL Programs”
Section 2.12.1.2, “Linux Binary Distribution Notes”
Section 4.2.3.5, “Option Defaults, Options Expecting Values, and the = Sign”
Section 5.1.2, “Server Command Options”
Section 2.12.3, “Solaris Notes”
Section 2.9.1, “Source Installation Overview”
Section 2.10.2, “Unix Post-Installation Procedures”
Section 5.5.1, “User Names and Passwords”
Section 4.2.3.3, “Using Option Files”

--user=mysql

Section B.1.4.1.2, “Resetting the Root Password on Unix Systems”

--user=root

Section 5.3.5, “How to Run MySQL as a Normal User”
Section 5.3.2, “Making MySQL Secure Against Attackers”
Section 5.1.2, “Server Command Options”

--user=user_name

Section 4.5.1.1, “mysql Options”
Section 4.2.2, “Connecting to the MySQL Server”
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Section 5.3.5, “How to Run MySQL as a Normal User”

--user={user_name|user_id}

Description
Section 5.1.2, “Server Command Options”

--var_name=value

Section 4.6.3.1, “myisamchk General Options”
Section 4.5.1.1, “mysql Options”
Section 13.7.3, “InnoDB Startup Options and System Variables”
Description
Description
Description
Section 5.1.2, “Server Command Options”
Section 7.5.3, “Tuning Server Parameters”

--verbose

Section 4.6.3.1, “myisamchk General Options”
Section 4.5.1.1, “mysql Options”
Section 4.6.8.2, “mysqlbinlog Row Event Display”
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Section 5.1.2, “Server Command Options”
Section 2.3.10, “Starting MySQL from the Windows Command Line”
Section 2.10.2.3, “Starting and Troubleshooting the MySQL Server”
Section 7.5.3, “Tuning Server Parameters”
Section 4.2.3.3, “Using Option Files”
Section 4.2.3.1, “Using Options on the Command Line”

--version

Section 4.6.3.1, “myisamchk General Options”
Section 4.5.1.1, “mysql Options”
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Section 5.1.2, “Server Command Options”
Section 4.2.3.1, “Using Options on the Command Line”

--vertical

Section 4.5.1.1, “mysql Options”
Description
Section 1.6, “How to Report Bugs or Problems”

--wait

Section 4.6.3.1, “myisamchk General Options”
Section 4.5.1.1, “mysql Options”
Description

--wait[=count]

Description

--where='where_condition'

Description

--with

Section 2.9.2, “Typical configure Options”

--with-archive-storage-engine

Section 13.14, “The ARCHIVE Storage Engine”

--with-berkeley-db

Section 2.1.2.2, “Choosing a Distribution Format”

--with-big-tables

Section 13.10.1, “MERGE Table Problems”
Section 5.1.4, “Server System Variables”
Section 13.5, “The MyISAM Storage Engine”
Section 2.9.2, “Typical configure Options”

--with-blackhole-storage-engine

Section 13.16, “The BLACKHOLE Storage Engine”

--with-charset

Section 9.1.5, “Configuring the Character Set and Collation for Applications”
Section 7.5.1, “How Compiling and Linking Affects the Speed of MySQL”
Section 9.1.3.1, “Server Character Set and Collation”
Section 2.9.2, “Typical configure Options”

--with-charset=MYSET

Section 9.4, “Adding a New Character Set”

--with-charset=charset_name

Section B.1.2.17, “Can't initialize character set
Section 9.2, “The Character Set Used for Data and Sorting”

--with-collation

Section 9.1.5, “Configuring the Character Set and Collation for Applications”
Section 9.1.3.1, “Server Character Set and Collation”
Section 2.9.2, “Typical configure Options”

--with-comment

Section 5.1.4, “Server System Variables”

--with-csv-storage-engine

Section 13.15, “The CSV Storage Engine”

--with-debug

Section 21.5.1.1, “Compiling MySQL for Debugging”
Section 2.9.4, “Dealing with Problems Compiling MySQL”
Section 21.5.2, “Debugging a MySQL Client”
Section 7.5.1, “How Compiling and Linking Affects the Speed of MySQL”
Section 2.1.2.4, “MySQL Binaries Compiled by Sun Microsystems, Inc.”
Section 5.1.2, “Server Command Options”
Section 2.9.2, “Typical configure Options”
Section B.1.4.2, “What to Do If MySQL Keeps Crashing”

--with-debug=full

Section 21.5.1.1, “Compiling MySQL for Debugging”
Section 21.5.2, “Debugging a MySQL Client”
Description
Section 7.5.1, “How Compiling and Linking Affects the Speed of MySQL”
Section 2.1.2.4, “MySQL Binaries Compiled by Sun Microsystems, Inc.”
Section 5.1.2, “Server Command Options”
Section B.1.4.2, “What to Do If MySQL Keeps Crashing”

--with-debug[=full]

Section 2.1.2.2, “Choosing a Distribution Format”

--with-embedded-privilege-control

Section 20.9, “libmysqld, the Embedded MySQL Server Library”

--with-embedded-server

Section 20.9.1, “Compiling Programs with libmysqld
Section 2.9.2, “Typical configure Options”

--with-example-storage-engine

Section 13.12, “The EXAMPLE Storage Engine”

--with-extra-charsets=LIST

Section 2.9.2, “Typical configure Options”

--with-extra-charsets=charset_name

Section B.1.2.17, “Can't initialize character set

--with-extra-charsets=complex

Section B.1.2.17, “Can't initialize character set
Section 9.2, “The Character Set Used for Data and Sorting”

--with-extra-charsets=list-of-charsets | complex | all | none

Section 9.2, “The Character Set Used for Data and Sorting”

--with-federated-storage-engine

Section 13.13, “The FEDERATED Storage Engine”

--with-libevent

Section 7.5.7, “How MySQL Uses Threads for Client Connections”
Section 5.1.4, “Server System Variables”
Section 2.9.2, “Typical configure Options”

--with-libwrap

Section 2.1.2.2, “Choosing a Distribution Format”

--with-low-memory

Section 2.12.4.4, “BSD/OS Version 2.x Notes”
Section 2.9.4, “Dealing with Problems Compiling MySQL”

--with-max-indexes=N

Section 13.5, “The MyISAM Storage Engine”

--with-mit-threads

Section 2.12.4.1, “FreeBSD Notes”
Section 2.9.5, “MIT-pthreads Notes”

--with-mysqld-ldflags=-all-static

Section 21.3.2, “Adding a New User-Defined Function”
Section 2.12.1.7, “Linux Alpha Notes”

--with-mysqld-ldflags=-rdynamic

Section 21.3.2, “Adding a New User-Defined Function”

--with-named-thread-libs="-lpthread -lmach -lexc -lc"

Section 2.12.5.6, “Alpha-DEC-OSF/1 Notes”

--with-named-z-libs

Section 2.1.2.2, “Choosing a Distribution Format”

--with-named-z-libs=no

Section 2.12.3.1, “Solaris 2.7/2.8 Notes”
Section 2.12.3, “Solaris Notes”

--with-openssl

Section 2.11.1.1, “Upgrading from MySQL 5.1 to 6.0”

--with-partition

Chapter 17, Partitioning

--with-plugin-PLUGIN

Section 2.9.2, “Typical configure Options”

--with-plugins

Section 2.9.2, “Typical configure Options”

--with-raid

Section 2.1.2.2, “Choosing a Distribution Format”
Section 2.9.4, “Dealing with Problems Compiling MySQL”

--with-ssl

Section 2.11.1.1, “Upgrading from MySQL 5.1 to 6.0”
Section 5.5.7.2, “Using SSL Connections”

--with-ssl=path

Section 2.11.1.1, “Upgrading from MySQL 5.1 to 6.0”

--with-tcp-port

Section 2.9.3, “Installing from the Development Source Tree”

--with-unix-socket-path

Section B.1.4.5, “How to Protect or Change the MySQL Unix Socket File”
Section 2.9.3, “Installing from the Development Source Tree”

--with-yassl

Section 2.11.1.1, “Upgrading from MySQL 5.1 to 6.0”

--with-zlib-dir=no|bundled|DIR

Section 2.9.2, “Typical configure Options”

--without

Section 2.9.2, “Typical configure Options”

--without-libevent

Section 7.5.7, “How MySQL Uses Threads for Client Connections”
Section 2.9.2, “Typical configure Options”

--without-plugin-PLUGIN

Section 2.9.2, “Typical configure Options”

--without-query-cache

Section 7.5.5, “The MySQL Query Cache”

--without-server

Section 2.9.5, “MIT-pthreads Notes”
Section 2.9.2, “Typical configure Options”

--write-binlog

Description

--xml

Section 4.5.1.1, “mysql Options”
Section 12.2.7, “LOAD XML Syntax”
Description
Section 11.10, “XML Functions”

-1

Section 1.7.5.6, “'--' as the Start of a Comment”
Section 17.2.3, “HASH Partitioning”
Section 11.2.3, “Comparison Functions and Operators”
Description
Section 11.5.2, “Mathematical Functions”
Section 11.11.4, “Miscellaneous Functions”
Section 11.4.1, “String Comparison Functions”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 6.0”

-?

Section 4.6.3.1, “myisamchk General Options”
Section 4.5.1.1, “mysql Options”
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Section 5.1.2, “Server Command Options”
Section 4.2.3.1, “Using Options on the Command Line”

-A

Section 4.5.1.1, “mysql Options”
Description
Description

-A[value]

Section 4.6.3.4, “Other myisamchk Options”

-B

Section 4.6.3.3, “myisamchk Repair Options”
Section 4.5.1.1, “mysql Options”
Description
Description

-C

Section 4.6.3.2, “myisamchk Check Options”
Section 4.5.1.1, “mysql Options”
Description
Description
Description
Description
Description
Description

-C charset_name

Section 5.1.2, “Server Command Options”

-D

Description
Description

-D db_name

Section 4.5.1.1, “mysql Options”

-DBIG_TABLES

Section 2.9.2, “Typical configure Options”

-DHAVE_rts_threads

Section 21.5.4, “Comments about RTS Threads”

-DUSE_ALARM_THREAD

Section 21.1.1, “MySQL Threads”

-DUSE_SYMDIR

Section 7.6.1.3, “Using Symbolic Links for Databases on Windows”

-E

Section 4.5.1.1, “mysql Options”
Description
Description

-F

Section 4.6.3.2, “myisamchk Check Options”
Section 4.5.1.2, “mysql Commands”
Description
Description

-F str

Description

-G

Section 4.5.1.1, “mysql Options”

-H

Section 4.6.3.1, “myisamchk General Options”
Section 4.5.1.1, “mysql Options”
Description

-H host_name

Description

-I

Section 20.10.16, “Building Client Programs”
Description
Description
Description
Description
Description

-I/usr/local/mysql/include

Section 20.10.16, “Building Client Programs”

-K

Description

-L

Section 4.5.1.1, “mysql Options”
Section 20.10.16, “Building Client Programs”
Description
Section 2.14.3, “Problems Using the Perl DBI/DBD Interface”
Section 5.3.4, “Security Issues with LOAD DATA LOCAL
Section 9.3, “Setting the Error Message Language”

-L/lib

Section 2.14.3, “Problems Using the Perl DBI/DBD Interface”

-L/usr/lib

Section 2.14.3, “Problems Using the Perl DBI/DBD Interface”

-L/usr/lib/gcc-lib/... -lgcc

Section 2.14.3, “Problems Using the Perl DBI/DBD Interface”

-L/usr/local/mysql/lib -lmysqlclient -lz

Section 20.10.16, “Building Client Programs”

-Lpath

Section 2.12.1.3, “Linux Source Distribution Notes”
Section 2.12.3, “Solaris Notes”

-N

Section 4.5.1.1, “mysql Options”

-O

Section 2.12.5.6, “Alpha-DEC-OSF/1 Notes”

-O var_name=value

Section 7.5.3, “Tuning Server Parameters”

-O back_log=50

Section 2.12.3, “Solaris Notes”

-O thread_stack=192K

Section 2.12.1.5, “Linux x86 Notes”

-O0

Section 2.12.5.6, “Alpha-DEC-OSF/1 Notes”
Section 2.9.4, “Dealing with Problems Compiling MySQL”

-O2

Section 2.12.5.3, “IBM-AIX notes”

-O3

Section 2.12.5.6, “Alpha-DEC-OSF/1 Notes”
Section 7.5.1, “How Compiling and Linking Affects the Speed of MySQL”
Section 2.12.5.3, “IBM-AIX notes”

-O6

Section 2.12.5.1, “HP-UX Version 10.20 Notes”
Section 7.5.1, “How Compiling and Linking Affects the Speed of MySQL”

-P

Section 4.2.2, “Connecting to the MySQL Server”
Section 4.2.1, “Invoking MySQL Programs”

-P port_num

Section 4.5.1.1, “mysql Options”
Section 4.2.2, “Connecting to the MySQL Server”
Description
Description
Description
Description
Description
Description
Description
Description
Section 5.1.2, “Server Command Options”

-P[password]

Description

-Q

Description

-R

Description
Description

-R N

Section 4.6.3.4, “Other myisamchk Options”

-R index_num

Section 6.5.4, “Table Optimization”

-R record_pos_file record_pos

Description

-RELEASE

Section 2.12.4.1, “FreeBSD Notes”

-S

Section 4.5.1.2, “mysql Commands”
Section 4.2.1, “Invoking MySQL Programs”
Section 4.6.3.4, “Other myisamchk Options”
Section 6.5.4, “Table Optimization”

-S file_name

Section 4.2.2, “Connecting to the MySQL Server”

-S path

Section 4.5.1.1, “mysql Options”
Description
Description
Description
Description
Description
Description
Description
Description

-T

Section 4.6.3.2, “myisamchk Check Options”
Section 4.5.1.1, “mysql Options”
Description
Description
Description

-T [flags]

Section 5.1.2, “Server Command Options”

-T path

Description
Description

-U

Section 4.6.3.2, “myisamchk Check Options”
Section 4.5.1.1, “mysql Options”

-U user_name

Description

-V

Section 4.6.3.1, “myisamchk General Options”
Section 4.5.1.1, “mysql Options”
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Section 5.1.2, “Server Command Options”
Section 4.2.3.1, “Using Options on the Command Line”

-W

Section 4.5.1.1, “mysql Options”
Section 4.2.2, “Connecting to the MySQL Server”
Description
Description
Description
Description
Description
Description

-W [level]

Section 5.1.2, “Server Command Options”

-Wa,-many

Section 2.12.5.3, “IBM-AIX notes”

-Wl,r/full/path/to/libmysqlclient.so

Section 2.12.1.3, “Linux Source Distribution Notes”
Section 2.12.3, “Solaris Notes”

-X

Section 4.5.1.2, “mysql Commands”
Section 4.5.1.1, “mysql Options”
Description

-Xc

Section 2.12.3, “Solaris Notes”

-Y

Description
Section 1.4.1, “What Is New in MySQL 6.0”

-a

Description
Description
Description
Section 4.6.3.4, “Other myisamchk Options”
Section 6.5.4, “Table Optimization”

-arch generic

Section 2.12.1.7, “Linux Alpha Notes”

-arch generic

Section 2.12.1.7, “Linux Alpha Notes”

-b

Section 4.5.1.1, “mysql Options”
Description
Description
Description

-b path

Section 5.1.2, “Server Command Options”

-b offset

Section 4.6.3.4, “Other myisamchk Options”

-c

Section 4.6.3.2, “myisamchk Check Options”
Section 4.5.1.1, “mysql Options”
Description
Description
Description
Description
Section A.10, “MySQL 6.0 FAQ — MySQL Cluster”

-c N

Description
Description
Description

-c column_list

Description

-c file_name

Description

-d

Section 4.6.3.1, “myisamchk General Options”
Description
Description
Description
Description
Section 4.6.3.4, “Other myisamchk Options”

-d db_name

Description
Description

-e

Section 4.6.3.2, “myisamchk Check Options”
Section 4.6.3.1, “myisamchk General Options”
Section 4.6.3.3, “myisamchk Repair Options”
Section 12.2.7, “LOAD XML Syntax”
Description
Description
Section 6.5.2, “How to Check MyISAM Tables for Errors”
Section 4.2.3.1, “Using Options on the Command Line”

-e engine_name

Description

-e file_name

Description

-e num

Description

-e statement

Section 4.5.1.1, “mysql Options”

-eis

Section 6.5.5, “Getting Information About a Table”

-f

Section 4.6.3.2, “myisamchk Check Options”
Section 4.6.3.3, “myisamchk Repair Options”
Section 4.5.1.1, “mysql Options”
Description
Description
Description
Description
Description
Description
Section A.10, “MySQL 6.0 FAQ — MySQL Cluster”

-f N

Description

-fast

Section 2.12.1.7, “Linux Alpha Notes”

-felide-constructors

Section 2.9, “MySQL Installation Using a Source Distribution”

-fno-exceptions

Section 2.12.5.3, “IBM-AIX notes”
Section 2.9, “MySQL Installation Using a Source Distribution”

-fno-inline

Section 2.9.4, “Dealing with Problems Compiling MySQL”

-fno-rtti

Section 2.9, “MySQL Installation Using a Source Distribution”

-fomit-frame-pointer

Section 7.5.1, “How Compiling and Linking Affects the Speed of MySQL”
Section 2.1.2.4, “MySQL Binaries Compiled by Sun Microsystems, Inc.”
Section 21.5.1.5, “Using a Stack Trace”

-fomit-frame-pointer -ffixed-ebp

Section 7.5.1, “How Compiling and Linking Affects the Speed of MySQL”

-g

Section 4.5.1.1, “mysql Options”
Section 21.5.1.1, “Compiling MySQL for Debugging”
Description

-g pattern

Description

-g suffix

Description

-h

Section B.1.2.2, “Can't connect to [local] MySQL server
Section 4.2.2, “Connecting to the MySQL Server”
Description
Description
Section 4.2.1, “Invoking MySQL Programs”
Section 2.9.5, “MIT-pthreads Notes”

-h host_name

Section 4.5.1.1, “mysql Options”
Section 4.2.2, “Connecting to the MySQL Server”
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description

-h localhost

Section 4.2.3.1, “Using Options on the Command Line”

-h path

Section 5.1.2, “Server Command Options”

-hlocalhost

Section 4.2.3.1, “Using Options on the Command Line”

-i

Section 4.6.3.2, “myisamchk Check Options”
Section 4.5.1.1, “mysql Options”
Description
Description
Description
Description
Section 6.5.2, “How to Check MyISAM Tables for Errors”
Section 21.5.1.3, “Using pdb to create a Windows crashdump”

-i N

Description

-i delay

Description

-i name

Description

-j N

Description

-j big_tbl_name

Description

-k

Description

-k val

Section 4.6.3.3, “myisamchk Repair Options”

-l

Section 4.6.3.3, “myisamchk Repair Options”
Description
Description
Description
Description
Section 5.2.3, “The General Query Log”

-l [file_name]

Section 5.1.2, “Server Command Options”
Section 5.2.3, “The General Query Log”

-l path

Description

-ldbug

Section 20.10.17, “How to Make a Threaded Client”

-lg++

Section 2.9.4, “Dealing with Problems Compiling MySQL”

-lgcc

Section 2.12.3, “Solaris Notes”

-lgthreads -lsocket -lgthreads

Section 2.12.5.8, “SCO UNIX and OpenServer 5.0.x Notes”

-libmysqlclient

Section 20.10.2, “C API Function Overview”

-libmysqld

Section 20.10.2, “C API Function Overview”

-lm

Section 20.10.10.4, “Problems Linking with the C API”

-lmach -lexc

Section 2.12.5.5, “Alpha-DEC-UNIX Notes (Tru64)”

-lmysqlclient

Section 20.10.3.39, “mysql_library_end()
Section 20.10.9, “C API Embedded Server Function Descriptions”

-lmysqlclient -lz

Section 20.10.16, “Building Client Programs”

-lmysqld

Section 20.10.3.39, “mysql_library_end()
Section 20.10.9, “C API Embedded Server Function Descriptions”

-lmystrings

Section 20.10.17, “How to Make a Threaded Client”

-lmysys

Section 20.10.17, “How to Make a Threaded Client”

-lpthread

Section 2.12.5.5, “Alpha-DEC-UNIX Notes (Tru64)”

-lz

Section 20.9.1, “Compiling Programs with libmysqld
Section 2.14.3, “Problems Using the Perl DBI/DBD Interface”
Section 2.12.3.1, “Solaris 2.7/2.8 Notes”
Section 2.12.3, “Solaris Notes”

-m

Section 4.6.3.2, “myisamchk Check Options”
Section 4.5.1.1, “mysql Options”
Description

-m64

Section 2.9, “MySQL Installation Using a Source Distribution”
Section 2.12.3, “Solaris Notes”

-max

Section 2.3.8, “Selecting a MySQL Server Type”

-mcpu

Section 2.12.3, “Solaris Notes”

-mcpu=v8 -Wa,-xarch=v8plusa

Section 2.12.3, “Solaris Notes”

-mcpu=v8 -Wa,-xarch=v8plusa

Section 7.5.1, “How Compiling and Linking Affects the Speed of MySQL”

-mcpu=xxx

Section 2.12.5.3, “IBM-AIX notes”

-mt

Section 2.12.3, “Solaris Notes”

-n

Section 4.6.3.3, “myisamchk Repair Options”
Section 4.5.1.1, “mysql Options”
Description
Description
Description
Description

-n N

Description

-n file_name

Description

-nt

Section 2.3.8, “Selecting a MySQL Server Type”

-o

Section 4.6.3.3, “myisamchk Repair Options”
Section 4.5.1.1, “mysql Options”
Section 20.9.1, “Compiling Programs with libmysqld
Description

-o async

Section 7.6, “Disk Issues”

-o N

Description

-o noatime

Section 7.6, “Disk Issues”

-o offset

Description

-p

Section 4.6.3.3, “myisamchk Repair Options”
Section 4.5.1.1, “mysql Options”
Section 5.5.2, “Adding User Accounts”
Section 5.4.7, “Causes of Access-Denied Errors”
Section 4.2.2, “Connecting to the MySQL Server”
Section 3.3.1, “Creating and Selecting a Database”
Description
Description
Description
Description
Description
Description
Description
Description
Section 5.5.6.2, “End-User Guidelines for Password Security”
Section 2.7, “Installing MySQL on NetWare”
Section 4.2.1, “Invoking MySQL Programs”
Section B.1.2.5, “Password Fails When Entered Interactively”
Section 2.3.11, “Starting MySQL as a Windows Service”
Section 2.3.10, “Starting MySQL from the Windows Command Line”
Section 2.3.12, “Testing The MySQL Installation”
Section 2.3.14, “Upgrading MySQL on Windows”
Section 5.5.1, “User Names and Passwords”
Section 4.2.3.1, “Using Options on the Command Line”
Section 2.10.1, “Windows Post-Installation Procedures”

-p N

Description

-p num

Description

-p[pass_val]

Section 4.2.2, “Connecting to the MySQL Server”

-p[password]

Section 4.5.1.1, “mysql Options”
Description
Description
Description
Description
Description
Description
Description
Description

-ppass_val

Section 4.2.3.1, “Using Options on the Command Line”

-ppassword

Description

-pthread

Section 2.12.5.5, “Alpha-DEC-UNIX Notes (Tru64)”

-pyour_pass

Section 5.5.6.2, “End-User Guidelines for Password Security”

-q

Section 4.6.3.3, “myisamchk Repair Options”
Section 4.5.1.1, “mysql Options”
Description
Description
Description

-q value

Description

-qstrict

Section 2.12.5.3, “IBM-AIX notes”

-r

Section 4.6.3.2, “myisamchk Check Options”
Section 4.6.3.3, “myisamchk Repair Options”
Section 4.5.1.1, “mysql Options”
Description
Description
Description
Description
Description
Section 6.5.3, “How to Repair Tables”

-r -q

Section 6.5.3, “How to Repair Tables”

-r file_name

Description

-r name

Description

-r path

Section 5.1.2, “Server Command Options”

-rdynamic

Section 21.3.2, “Adding a New User-Defined Function”

-s

Section 4.6.3.1, “myisamchk General Options”
Section 4.5.1.1, “mysql Options”
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Section 6.5.2, “How to Check MyISAM Tables for Errors”
Section 6.5.3, “How to Repair Tables”
Section 6.5.6, “Setting Up a Table Maintenance Schedule”

-s file_name

Description

-s num

Description

-s sort_type

Description

-server

Section 2.4, “Installing MySQL from RPM Packages on Linux”

-skip-auto-rehash

Section 4.5.1.1, “mysql Options”

-slow_query_log_file

Section 5.1.2, “Server Command Options”

-ss

Section 4.6.3.1, “myisamchk General Options”

-static

Section 7.5.1, “How Compiling and Linking Affects the Speed of MySQL”
Section 2.12.1.2, “Linux Binary Distribution Notes”

-t

Section 4.5.1.1, “mysql Options”
Description
Description
Description
Description
Description

-t N

Description

-t path

Section 4.6.3.3, “myisamchk Repair Options”
Section 5.1.2, “Server Command Options”

-u

Section 4.6.3.3, “myisamchk Repair Options”
Description
Section 4.2.1, “Invoking MySQL Programs”
Section 2.3.12, “Testing The MySQL Installation”
Section 5.5.1, “User Names and Passwords”
Section 2.10.1, “Windows Post-Installation Procedures”

-u {user_name|user_id}

Section 5.1.2, “Server Command Options”

-u user_name

Section 4.5.1.1, “mysql Options”
Section 4.2.2, “Connecting to the MySQL Server”
Description
Description
Description
Description
Description
Description
Description
Description
Description

-v

Section 4.6.3.1, “myisamchk General Options”
Section 4.5.1.1, “mysql Options”
Section 4.6.8.2, “mysqlbinlog Row Event Display”
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Section 6.5.5, “Getting Information About a Table”
Section 6.5.2, “How to Check MyISAM Tables for Errors”
Section 5.1.2, “Server Command Options”
Section 4.2.3.1, “Using Options on the Command Line”

-v -v -v

Section 4.5.1.1, “mysql Options”

-vv

Section 4.6.3.1, “myisamchk General Options”

-vvv

Section 4.6.3.1, “myisamchk General Options”

-w

Section 4.6.3.1, “myisamchk General Options”
Section 4.5.1.1, “mysql Options”
Description

-w 'where_condition'

Description

-w write_file

Description

-w[count]

Description

-x

Description

-x N

Description

-y N

Description

Aborted_connects

Section B.1.2.11, “Communication Errors and Aborted Connections”

CFLAGS

Section 2.12.3, “Solaris Notes”

Com_dealloc_sql

Section 5.1.7, “Server Status Variables”

Com_delete

Section 5.1.7, “Server Status Variables”

Com_execute_sql

Section 5.1.7, “Server Status Variables”

Com_insert

Section D.1, “Restrictions on Stored Routines, Triggers, and Events”
Section 5.1.7, “Server Status Variables”

Com_prepare_sql

Section 5.1.7, “Server Status Variables”

Com_select

Section 7.5.5.1, “How the Query Cache Operates”
Section 7.5.5.4, “Query Cache Status and Maintenance”
Section D.1, “Restrictions on Stored Routines, Triggers, and Events”
Section 5.1.7, “Server Status Variables”

Com_stmt_close

Section 5.1.7, “Server Status Variables”

Com_stmt_execute

Section 5.1.7, “Server Status Variables”

Com_stmt_fetch

Section 5.1.7, “Server Status Variables”

Com_stmt_prepare

Section 5.1.7, “Server Status Variables”

Com_stmt_reprepare

Section 12.7.4, “Automatic Prepared Statement Repreparation”
Section 5.1.7, “Server Status Variables”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 6.0”

Com_stmt_reset

Section 5.1.7, “Server Status Variables”

Com_stmt_send_long_data

Section 5.1.7, “Server Status Variables”

ON

Section 3.3.4.9, “Using More Than one Table”

Queries

Section 5.1.7, “Server Status Variables”

Questions

Section 5.1.7, “Server Status Variables”

Slave_running

Section 5.1.7, “Server Status Variables”

\G

Section 4.5.1.1, “mysql Options”
Section 13.7.13.2, “SHOW ENGINE INNODB STATUS and the InnoDB Monitors”
Section 12.5.6.34, “SHOW SLAVE STATUS Syntax”
Description
Section 1.6, “How to Report Bugs or Problems”

\P

Section 4.5.1.2, “mysql Commands”

\c

Section 4.5.1.2, “mysql Commands”
Section 3.2, “Entering Queries”

\q

Section 4.5.1.1, “mysql Options”
Section 3.1, “Connecting to and Disconnecting from the Server”

\s

Section 4.5.1.2, “mysql Commands”
Section 4.2.3.3, “Using Option Files”
Section 5.5.7.2, “Using SSL Connections”

\t

Section 4.5.1.2, “mysql Commands”
Section 4.5.1.1, “mysql Options”
Section 12.2.6, “LOAD DATA INFILE Syntax”
Section 8.1.1, “Strings”
Section 4.2.3.3, “Using Option Files”

\w

Section 4.5.1.2, “mysql Commands”

all

Section 7.2.1, “Optimizing Queries with EXPLAIN
Section 16.1.3.3, “Replication Slave Options and Variables”
Section 2.9.2, “Typical configure Options”

analyze

Section 12.5.2.1, “ANALYZE TABLE Syntax”

ansi

Description

basedir

Section 2.3.7, “Creating an Option File”
Section 2.10.2.2, “Starting and Stopping MySQL Automatically”
Section 2.3.13, “Troubleshooting a MySQL Installation Under Windows”

binlog_format

Section 12.2.5.2, “INSERT DELAYED Syntax”
Section 5.1.2, “Server Command Options”

c

Section 12.1.6, “ALTER TABLE Syntax”
Section 12.1.14, “CREATE TABLE Syntax”
Description
Section 8.2.1, “Identifier Qualifiers”
Section 3.3.4.7, “Pattern Matching”
Section 11.4.2, “Regular Expressions”
Section 9.1.13.1, “Unicode Character Sets”

charset

Section 4.5.1.2, “mysql Commands”
Section 9.1.4, “Connection Character Sets and Collations”

check

Section 12.5.2.2, “CHECK TABLE Syntax”

col

Section 16.1.3.2, “Replication Master Options and Variables”

compress

Section 20.10.3.49, “mysql_options()
Section B.1.3.1, “Problems Linking to the MySQL Client Library”

connect

Section B.1.3.1, “Problems Linking to the MySQL Client Library”

connect_timeout

Section 4.5.1.1, “mysql Options”
Description

count

Section 12.5.6.16, “SHOW ENGINE Syntax”
Section 8.2.4, “Function Name Parsing and Resolution”
Section 5.1.8, “Server SQL Modes”

csv

Section 2.9.2, “Typical configure Options”

d

Section 12.1.6, “ALTER TABLE Syntax”
Section 7.2.10, “LEFT JOIN and RIGHT JOIN Optimization”
Section 11.4.2, “Regular Expressions”
Section 21.5.3, “The DBUG Package”
Section 9.1.13.1, “Unicode Character Sets”

data

Section 20.10.7.26, “mysql_stmt_send_long_data()
Section 17.3.1, “Management of RANGE and LIST Partitions”
Section 7.6.1.2, “Using Symbolic Links for Tables on Unix”
Section 12.4.7.1, “XA Transaction SQL Syntax”

datadir

Section 2.3.7, “Creating an Option File”
Section 2.10.2.2, “Starting and Stopping MySQL Automatically”
Section 2.3.13, “Troubleshooting a MySQL Installation Under Windows”
Section D.9.3, “Windows Platform Limitations”

date

Section 11.6, “Date and Time Functions”

db

Section 12.5.1.3, “GRANT Syntax”
Section 12.5.6.30, “SHOW PROCESSLIST Syntax”
Section 20.10.3.3, “mysql_change_user()
Section 20.10.3.8, “mysql_create_db()
Section 20.10.3.11, “mysql_drop_db()
Section 20.10.3.52, “mysql_real_connect()
Section 20.10.3.60, “mysql_select_db()
Section 5.4.5, “Access Control, Stage 2: Request Verification”
Section 5.5.2, “Adding User Accounts”
Section 20.10.1, “C API Data Types”
Section 5.4.7, “Causes of Access-Denied Errors”
Section 2.11.5, “Copying MySQL Databases to Another Machine”
Description
Section 7.5.6, “Examining Thread Information”
Section 5.4.2, “Privilege System Grant Tables”
Section 5.4.1, “Privileges Provided by MySQL”
Section D.7, “Restrictions on Character Sets”
Section 19.23, “The INFORMATION_SCHEMA PROCESSLIST Table”
Section 19.14, “The INFORMATION_SCHEMA ROUTINES Table”
Section 2.10.2, “Unix Post-Installation Procedures”

dbname

Section A.5, “MySQL 6.0 FAQ — Triggers”

debug

Section 20.10.3.49, “mysql_options()
Description

decode_bits

Section 4.6.3.1, “myisamchk General Options”

default-storage-engine

Section 13.3, “Setting the Storage Engine”
Chapter 13, Storage Engines

default-table-type

Section 13.3, “Setting the Storage Engine”
Chapter 13, Storage Engines

defaults-extra-file

Section 4.2.3.3, “Using Option Files”

delimiter

Section 4.5.1.2, “mysql Commands”
Section 12.1.9, “CREATE EVENT Syntax”
Section 12.1.12, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
Section 18.1, “Defining Stored Programs”

description

Section 12.3.3, “HELP Syntax”

e

Section B.1.5.1, “Case Sensitivity in String Searches”

event-scheduler

Section 5.1.2, “Server Command Options”

exit

Section 21.5.3, “The DBUG Package”

extended-status

Description

fields

Section 13.7.13.2.3, “InnoDB Table Monitor Output”

flush-hosts

Section 12.5.7.3, “FLUSH Syntax”
Description
Section 5.4.1, “Privileges Provided by MySQL”

flush-logs

Section 12.5.7.3, “FLUSH Syntax”
Description
Section 5.4.1, “Privileges Provided by MySQL”

flush-privileges

Section 12.5.7.3, “FLUSH Syntax”
Description
Section 5.4.1, “Privileges Provided by MySQL”

flush-status

Section 12.5.7.3, “FLUSH Syntax”
Description
Section 5.4.1, “Privileges Provided by MySQL”

flush-tables

Section 12.5.7.3, “FLUSH Syntax”
Description
Section 5.4.1, “Privileges Provided by MySQL”

flush-threads

Description
Section 5.4.1, “Privileges Provided by MySQL”

force

Section 7.2.14, “Multi-Range Read Optimization”

forcedirectio

Section 2.12.3, “Solaris Notes”

ft_max_word_len

Section 4.6.3.1, “myisamchk General Options”

ft_min_word_len

Section 4.6.3.1, “myisamchk General Options”

ft_stopword_file

Section 4.6.3.1, “myisamchk General Options”

general_log

Section 5.1.4, “Server System Variables”

have_partition_engine

Chapter 17, Partitioning
Section 5.1.4, “Server System Variables”

have_profiling

Section 5.1.4, “Server System Variables”

help

Section 4.5.1.2, “mysql Commands”
Section 4.5.1.3, “mysql Server-Side Help”

host

Section 12.5.1.3, “GRANT Syntax”
Section 20.10.3.7, “mysql_connect()
Section 20.10.3.52, “mysql_real_connect()
Section 5.4.5, “Access Control, Stage 2: Request Verification”
Section 5.4.7, “Causes of Access-Denied Errors”
Section 3.1, “Connecting to and Disconnecting from the Server”
Section 13.7.4.2, “Converting Tables from Other Storage Engines to InnoDB
Section 2.11.5, “Copying MySQL Databases to Another Machine”
Description
Section 5.4.2, “Privilege System Grant Tables”
Section 5.4.1, “Privileges Provided by MySQL”
Section 2.10.2, “Unix Post-Installation Procedures”

init-file

Section 7.4.5.2, “Multiple Key Caches”

innodb

Section 5.1.3, “Server Options for Loading Plugins”

innodb_file_per_table

Section 13.7.13.2.2, “InnoDB Tablespace Monitor Output”
Section 16.1.1.6, “Creating a Data Snapshot Using Raw Data Files”

innodb_safe_binlog

Section 13.7.3, “InnoDB Startup Options and System Variables”

innodb_status_file=1

Section 13.7.13.2, “SHOW ENGINE INNODB STATUS and the InnoDB Monitors”

innodb_support_xa

Section 13.7.3, “InnoDB Startup Options and System Variables”

innodb_table_locks

Section 2.11.1.1, “Upgrading from MySQL 5.1 to 6.0”

innodb_thread_concurrency

Section 13.7.3, “InnoDB Startup Options and System Variables”

key_buffer_size

Section 4.6.3.2, “myisamchk Check Options”
Section 4.6.3.1, “myisamchk General Options”
Section 4.6.3.3, “myisamchk Repair Options”

language

Section 19.14, “The INFORMATION_SCHEMA ROUTINES Table”

ledir

Description
Description

length

Section 20.10.3.34, “mysql_hex_string()
Section 20.10.3.53, “mysql_real_escape_string()
Section 20.10.3.54, “mysql_real_query()
Section 20.10.7.11, “mysql_stmt_fetch()
Section 20.10.7.21, “mysql_stmt_prepare()
Section 20.10.7.26, “mysql_stmt_send_long_data()
Section 20.10.5, “C API Prepared Statement Data types”
Section 21.2.3.3, “Creating a Plugin Library”
Section 21.2.3.2, “Type-Specific Plugin Structures and Functions”

local

Section 5.1.6.1, “Structured System Variables”

local-infile

Section 5.3.4, “Security Issues with LOAD DATA LOCAL

log

Section 2.9.3, “Installing from the Development Source Tree”

log_backup_output

Section 5.1.4, “Server System Variables”

log_bin_trust_routine_creators

Section 16.1.3.4, “Binary Log Options and Variables”

max_allowed_packet

Section 4.5.1.1, “mysql Options”
Description
Section 4.2.3.4, “Using Options to Set Program Variables”

multi_range_count

Section 5.1.4, “Server System Variables”

myisam_block_size

Section 4.6.3.1, “myisamchk General Options”

myisam_stats_method

Section 4.6.3.1, “myisamchk General Options”

myisamchk

Section 4.6.3.4, “Other myisamchk Options”

mysql

Section 4.5.1.3, “mysql Server-Side Help”
Section 12.5.3.1, “BACKUP DATABASE Syntax”
Section 12.5.4.1, “CREATE FUNCTION Syntax”
Section 12.1.13, “CREATE SERVER Syntax”
Section 12.5.1.1, “CREATE USER Syntax”
Section B.1.2.4, “Client does not support authentication protocol
Section 12.5.4.2, “DROP FUNCTION Syntax”
Section 12.5.1.2, “DROP USER Syntax”
Section 12.5.7.3, “FLUSH Syntax”
Section 12.5.1.3, “GRANT Syntax”
Section 12.3.3, “HELP Syntax”
Section B.1.2.9, “MySQL server has gone away
Section 12.5.3.2, “PURGE BACKUP LOGS Syntax”
Section 12.5.1.4, “RENAME USER Syntax”
Section 12.5.1.5, “REVOKE Syntax”
Section 12.5.1.6, “SET PASSWORD Syntax”
Section 12.5.6.22, “SHOW GRANTS Syntax”
Section 20.10.3.3, “mysql_change_user()
Section 20.10.3.5, “mysql_close()
Section 20.10.3.14, “mysql_errno()
Section 20.10.3.15, “mysql_error()
Section 20.10.3.33, “mysql_get_ssl_cipher()
Section 20.10.3.36, “mysql_init()
Section 20.10.3.53, “mysql_real_escape_string()
Section 20.10.3.60, “mysql_select_db()
Section 20.10.3.67, “mysql_ssl_set()
Section 20.10.7.10, “mysql_stmt_execute()
Section 20.10.7.11, “mysql_stmt_fetch()
Section 20.10.7.26, “mysql_stmt_send_long_data()
Section 5.4.4, “Access Control, Stage 1: Connection Verification”
Section 12.5.1, “Account Management Statements”
Section 5.5.2, “Adding User Accounts”
Section 5.5.6.1, “Administrator Guidelines for Password Security”
Section 5.5.5, “Assigning Account Passwords”
Section 6.2.1, “Backup Policy”
Section 20.10.14, “C API Prepared Statement Handling of Date and Time Values”
Section 5.4.7, “Causes of Access-Denied Errors”
Section 21.2.1, “Characteristics of the Plugin Interface”
Section 21.3.2.5, “Compiling and Installing User-Defined Functions”
Chapter 20, Connectors and APIs
Section 13.7.4.2, “Converting Tables from Other Storage Engines to InnoDB
Section 2.11.5, “Copying MySQL Databases to Another Machine”
Section 13.13.2.1, “Creating a FEDERATED Table Using CONNECTION
Section 16.1.1.6, “Creating a Data Snapshot Using Raw Data Files”
Section 3.3, “Creating and Using a Database”
Section 8.2, “Schema Object Names”
Description
Section 2.11.2, “Downgrading MySQL”
Section 7.5.9, “Enabling Large Page Support”
Section 5.3.1, “General Security Guidelines”
Section 7.5.5.1, “How the Query Cache Operates”
Section 2.8, “Installing MySQL from tar.gz Packages on Other Unix-Like Systems”
Section 2.4, “Installing MySQL from RPM Packages on Linux”
Section 2.5, “Installing MySQL on Mac OS X”
Section 2.6, “Installing MySQL on Solaris”
Section 5.5.4, “Limiting Account Resources”
Section 5.2.4.4, “Logging Format for Changes to mysql Database Tables”
Section 5.3.2, “Making MySQL Secure Against Attackers”
Section 1.4.1, “What Is New in MySQL 6.0”
Section A.11, “MySQL 6.0 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”
Section A.4, “MySQL 6.0 FAQ — Stored Procedures and Functions”
Section 20.11, “MySQL PHP API”
Section 9.7, “MySQL Server Time Zone Support”
Section 12.4.5.3, “Other Table-Locking Notes”
Section 4.1, “Overview of MySQL Programs”
Section 5.5.6.3, “Password Hashing in MySQL”
Section 5.4.2, “Privilege System Grant Tables”
Section 5.4.1, “Privileges Provided by MySQL”
Section 2.10.2.1, “Problems Running mysql_install_db
Section 16.3.1.9, “Replication and FLUSH
Section 16.3.1.17, “Replication of the System mysql Database”
Section B.1.4.1.2, “Resetting the Root Password on Unix Systems”
Section 13.7.14, “Restrictions on InnoDB Tables”
Section D.7, “Restrictions on Character Sets”
Section D.1, “Restrictions on Stored Routines, Triggers, and Events”
Section 2.12.5.9, “SCO OpenServer 6.0.x Notes”
Section 2.10.3, “Securing the Initial MySQL Accounts”
Section 5.2.1, “Selecting General Query and Slow Query Log Output Destinations”
Section 5.1.2, “Server Command Options”
Section 5.1.9, “Server-Side Help”
Section 2.9.1, “Source Installation Overview”
Section 5.6.1.1, “Starting Multiple Windows Servers at the Command Line”
Section 2.10.2.2, “Starting and Stopping MySQL Automatically”
Section 2.10.2.3, “Starting and Troubleshooting the MySQL Server”
Section 12.4.3, “Statements That Cause an Implicit Commit”
Section 9.7.1, “Staying Current with Time Zone Changes”
Section 5.4, “The MySQL Access Privilege System”
Section 21.2, “The MySQL Plugin Interface”
Section 2.3.13, “Troubleshooting a MySQL Installation Under Windows”
Section 2.10.2, “Unix Post-Installation Procedures”
Section 2.11.1, “Upgrading MySQL”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 6.0”
Section 5.5.1, “User Names and Passwords”
Section 4.2.3.1, “Using Options on the Command Line”
Section 13.7.2.2, “Using Raw Devices for the Shared Tablespace”
Section 5.5.7.2, “Using SSL Connections”
Section 21.5.1.6, “Using Server Logs to Find Causes of Errors in mysqld
Section 18.2, “Using Stored Routines (Procedures and Functions)”
Section 2.10.1, “Windows Post-Installation Procedures”

mysql.server

Section 12.1.13, “CREATE SERVER Syntax”

mysqlbinlog

Section 12.5.6.3, “SHOW BINLOG EVENTS Syntax”
Section 6.4, “Point-in-Time Recovery”

mysqld

Section B.1.2.2, “Can't connect to [local] MySQL server
Section 20.10.2, “C API Function Overview”
Description
Description
Section 13.13.1, “FEDERATED Storage Engine Overview”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 5.1.1, “Server Option and Variable Reference”
Section 5.2.2, “The Error Log”
Section 16.4.2.2, “The Slave Status Files”
Section 21.5.1.3, “Using pdb to create a Windows crashdump”

mysqld_safe

Description
Section 5.2.2, “The Error Log”

ndb_optimization_delay

Section 12.5.2.4, “OPTIMIZE TABLE Syntax”

net_retry_count

Section 16.4.1, “Replication Implementation Details”

net_write_timeout

Section 16.4.1, “Replication Implementation Details”

nice

Description

offset

Section 20.10.3.9, “mysql_data_seek()
Section 20.10.3.23, “mysql_field_seek()
Section 20.10.3.58, “mysql_row_seek()
Section 20.10.7.7, “mysql_stmt_data_seek()
Section 20.10.7.12, “mysql_stmt_fetch_column()
Section 20.10.7.24, “mysql_stmt_row_seek()

one-thread

Section 5.1.4, “Server System Variables”

open_files_limit

Description
Section D.9.3, “Windows Platform Limitations”

optimize

Section 12.5.2.4, “OPTIMIZE TABLE Syntax”

p

Section 12.2.1, “CALL Syntax”
Section 17.2.6, “How MySQL Partitioning Handles NULL
Section 18.2.1, “Stored Routine Syntax”
Section 21.5.3, “The DBUG Package”

password

Description

pid-file

Section 2.10.2.2, “Starting and Stopping MySQL Automatically”
Section 5.2.4, “The Binary Log”

ping

Description
Section 16.3.5, “Troubleshooting Replication”

pipe

Section 20.10.3.49, “mysql_options()

port

Section 20.10.3.52, “mysql_real_connect()

print

Section 11.4.2, “Regular Expressions”

processlist

Description

prompt

Section 4.5.1.2, “mysql Commands”

quick

Section 4.2.3.3, “Using Option Files”

quit

Section 4.5.1.1, “mysql Options”

raw

Section 13.7.2.2, “Using Raw Devices for the Shared Tablespace”

read_buffer_size

Section 4.6.3.1, “myisamchk General Options”

reconnect

Section B.1.2.9, “MySQL server has gone away
Section 20.10.3.52, “mysql_real_connect()
Section 20.10.2, “C API Function Overview”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 6.0”

record_buffer

Section 7.5.8, “How MySQL Uses Memory”
Section 7.5.3, “Tuning Server Parameters”

refresh

Description
Section 5.4.1, “Privileges Provided by MySQL”

rehash

Section 4.5.1.1, “mysql Options”

relay_log_recovery

Section 16.1.3.3, “Replication Slave Options and Variables”

reload

Description
Section 5.4.1, “Privileges Provided by MySQL”

repair

Section 12.5.2.5, “REPAIR TABLE Syntax”

replication-ignore-table

Section 16.3.1.29, “Replication and Views”

resolve_stack_dump

Section B.1.4.2, “What to Do If MySQL Keeps Crashing”

resolveip

Section 2.12.1.2, “Linux Binary Distribution Notes”

rowid

Section 7.2.16, “Semi-Join Strategies”

rows

Section 17.3.4, “Obtaining Information About Partitions”
Section 7.2.1, “Optimizing Queries with EXPLAIN

s

Description
Section 11.4.2, “Regular Expressions”
Section 9.1.13.1, “Unicode Character Sets”

select_limit

Section 4.5.1.1, “mysql Options”

server-id

Section 16.1.1.9, “Introducing Additional Slaves to an Existing Replication Environment”
Section 16.1.3.2, “Replication Master Options and Variables”
Section 16.1.3.3, “Replication Slave Options and Variables”
Section 16.1.1.8, “Setting Up Replication with Existing Data”
Section 16.1.1.2, “Setting the Replication Master Configuration”
Section 16.1.1.3, “Setting the Replication Slave Configuration”

server-id=3

Section 16.1.3.3, “Replication Slave Options and Variables”

set-variable=option=value

Section 4.2.3.4, “Using Options to Set Program Variables”

shutdown

Description
Section 2.12.5.10, “SCO UnixWare 7.1.x and OpenUNIX 8.0.0 Notes”

shutdown_timeout

Description

skip-innodb

Section 13.7.2, “InnoDB Configuration”

skip-networking

Section 16.3.4, “Replication FAQ”
Section 16.1.1.2, “Setting the Replication Master Configuration”
Section 16.3.5, “Troubleshooting Replication”

slave

Section 1.2, “Typographical and Syntax Conventions”

slave_exec_mode

Section 16.1.3.3, “Replication Slave Options and Variables”

slave_net_timeout

Section 16.1.3.3, “Replication Slave Options and Variables”

slave_skip_errors

Section 16.1.3.3, “Replication Slave Options and Variables”

slave_transaction_retries

Section 16.1.3.3, “Replication Slave Options and Variables”

slow_query_log

Section 5.1.4, “Server System Variables”

sort

Section 11.12.3, “GROUP BY and HAVING with Hidden Columns”

sort_buffer_size

Section 4.6.3.1, “myisamchk General Options”
Section 4.6.3.3, “myisamchk Repair Options”

sort_key_blocks

Section 4.6.3.1, “myisamchk General Options”

source

Section 4.5.1.4, “Executing SQL Statements from a Text File”
Section 3.5, “Using mysql in Batch Mode”

sql-mode=""

Section 5.1.8, “Server SQL Modes”

sql-mode="modes"

Section 5.1.8, “Server SQL Modes”

sql_big_tables

Section 7.5.8, “How MySQL Uses Memory”
Section 5.1.5, “Session System Variables”

sql_low_priority_updates

Section 5.1.4, “Server System Variables”

sql_max_join_size

Section 5.1.4, “Server System Variables”

sql_slave_skip_counter

Section 16.1.3.3, “Replication Slave Options and Variables”

start-slave

Description

stats_method

Section 4.6.3.1, “myisamchk General Options”

status

Section 4.5.1.2, “mysql Commands”
Section 12.5.2.1, “ANALYZE TABLE Syntax”
Section 12.5.2.2, “CHECK TABLE Syntax”
Section 12.5.2.4, “OPTIMIZE TABLE Syntax”
Section 12.5.2.5, “REPAIR TABLE Syntax”
Description

stop-slave

Description

syslog

Description
Section 5.2.2, “The Error Log”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 6.0”

system

Chapter 19, INFORMATION_SCHEMA Tables

tab

Section 11.4.2, “Regular Expressions”

table

Section 20.10.1, “C API Data Types”
Section 7.2.1, “Optimizing Queries with EXPLAIN
Section 12.2.10.8, “Subqueries in the FROM clause”

test

Section 12.2.2, “DELETE Syntax”
Section 7.2.24, “INFORMATION_SCHEMA Optimization”
Section 13.7.13.2.3, “InnoDB Table Monitor Output”
Section 12.2.7, “LOAD XML Syntax”
Section 12.5.6.19, “SHOW EVENTS Syntax”
Section 11.3, “Control Flow Functions”
Section 13.7.4, “Creating and Using InnoDB Tables”
Section 3.3, “Creating and Using a Database”
Description
Section 3.6, “Examples of Common Queries”
Section 8.2.4, “Function Name Parsing and Resolution”
Section 4.2.1, “Invoking MySQL Programs”
Section 16.1.3.3, “Replication Slave Options and Variables”
Section 2.10.3, “Securing the Initial MySQL Accounts”
Section 18.2.1, “Stored Routine Syntax”
Section 19.19, “The INFORMATION_SCHEMA PARTITIONS Table”
Section 2.10.2, “Unix Post-Installation Procedures”
Section 4.2.3.1, “Using Options on the Command Line”

timeout

Section 20.10.3.49, “mysql_options()

tmpdir

Section 4.6.3.3, “myisamchk Repair Options”
Section B.1.2.13, “Can't create/write to file
Section 7.2.17, “ORDER BY Optimization”
Section 6.1, “Database Backups”
Section 2.3, “Installing MySQL on Windows”
Section 16.1.3.3, “Replication Slave Options and Variables”
Section 5.1.4, “Server System Variables”

type

Section 12.5.4.1, “CREATE FUNCTION Syntax”
Section 13.7.13.2.3, “InnoDB Table Monitor Output”
Section 7.2.15.3, “Batched Key Access Joins”
Section 7.2.15.2, “Block Nested-Loop Algorithm for Outer Joins and Semi-Joins”
Section 20.10.1, “C API Data Types”
Section 21.2.3.1, “General Plugin Structures and Functions”
Section 7.2.23, “How to Avoid Table Scans”
Section 7.2.6, “Index Merge Optimization”
Section 7.2.1, “Optimizing Queries with EXPLAIN
Section 19.14, “The INFORMATION_SCHEMA ROUTINES Table”
Section 21.2.3.2, “Type-Specific Plugin Structures and Functions”

update

Section 7.5.6.3, “Delayed-Insert Thread States”
Description

user

Section 12.5.1.2, “DROP USER Syntax”
Section B.1.2.15, “Ignoring user
Section 20.10.3.49, “mysql_options()
Section 20.10.3.52, “mysql_real_connect()
Section 5.4.4, “Access Control, Stage 1: Connection Verification”
Section 5.4.5, “Access Control, Stage 2: Request Verification”
Section 5.5.2, “Adding User Accounts”
Section 5.5.5, “Assigning Account Passwords”
Section 5.5.9, “Auditing MySQL Account Activity”
Section 5.4.7, “Causes of Access-Denied Errors”
Section 3.1, “Connecting to and Disconnecting from the Server”
Section 13.7.4.2, “Converting Tables from Other Storage Engines to InnoDB
Section 2.11.5, “Copying MySQL Databases to Another Machine”
Description
Section 11.11.2, “Encryption and Compression Functions”
Section 5.3.1, “General Security Guidelines”
Section 5.3.5, “How to Run MySQL as a Normal User”
Section 5.5.4, “Limiting Account Resources”
Section 5.3.2, “Making MySQL Secure Against Attackers”
Section 5.5.6.3, “Password Hashing in MySQL”
Section 5.4.2, “Privilege System Grant Tables”
Section 5.4.1, “Privileges Provided by MySQL”
Section D.7, “Restrictions on Character Sets”
Section 2.10.3, “Securing the Initial MySQL Accounts”
Section 5.1.2, “Server Command Options”
Section 5.4.3, “Specifying Account Names”
Section 2.10.2.2, “Starting and Stopping MySQL Automatically”
Section 2.10.2, “Unix Post-Installation Procedures”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 6.0”
Section 5.5.1, “User Names and Passwords”
Section 5.5.7.2, “Using SSL Connections”
Section 11.10, “XML Functions”

v

Section 12.1.16, “CREATE VIEW Syntax”
Section 16.3.1.10, “Replication and System Functions”

variables

Description

version

Description
Section 21.2.3.1, “General Plugin Structures and Functions”
Section 5.1.4, “Server System Variables”

write

Section 21.5.4, “Comments about RTS Threads”
Description

write_buffer_size

Section 4.6.3.1, “myisamchk General Options”