Option Index

-

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 4.2.3.1, “Using Options on the Command Line”

-#

Description
Section 22.5.3, “The DBUG Package”

-# [debug_options]

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

-#...

Section 22.5.3, “The DBUG Package”

-#D,20

Section 22.5.3, “The DBUG Package”

--

Section 8.5, “Comment Syntax”
Section 4.2.1, “Invoking MySQL Programs”

--HELP

Section 4.6.3.1, “myisamchk General Options”

--add-drop-database

Description

--add-drop-table

Description

--add-locks

Description

--add-user

Section 4.6.10.1, “MySQL Instance Manager Command Options”

--addtodest

Description

--all-databases

Description
Description
Section 8.2.3, “Mapping of Identifiers to File Names”

--all-in-1

Description

--all-tablespaces

Description

--allow-keywords

Description

--allow-suspicious-udfs

Section 5.3.3, “Security-Related mysqld Options”
Section 22.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.4.4, “Table Optimization”

--angel-pid-file

Section 4.6.10.1, “MySQL Instance Manager Command Options”

--angel-pid-file=file_name

Section 4.6.10.1, “MySQL Instance Manager Command Options”

--append

Description

--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

--backup

Section 4.6.3.3, “myisamchk Repair Options”
Description

--backup-id

Description

--backup_id

Description

--backup_path

Description

--backup_path=/path/to/backup/files

Description

--base64-output

Description

--base64-output=DECODE-ROWS

Section 4.6.7.2, “mysqlbinlog Row Event Display”

--base64-output=NEVER

Section 4.6.7.2, “mysqlbinlog Row Event Display”

--base64-output[=value]

Description

--basedir

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

--basedir=path

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

--batch

Section 4.5.1.1, “mysql Options”

--bind-address

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

--bind-address=127.0.0.1

Section 4.6.10.4, “Instance Manager User and Password Management”

--bind-address=IP

Section 4.6.10.1, “MySQL Instance Manager Command Options”

--binlog-do-db

Section 16.4.3, “How Servers Evaluate Replication Filtering Rules”

--binlog-format=mixed

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

--binlog-ignore-db

Section 16.4.3, “How Servers Evaluate Replication Filtering Rules”

--block-search=offset

Section 4.6.3.4, “Other myisamchk Options”

--brief

Description

--character-set-client-handshake

Section A.11, “MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”
Section 9.1.12.7.1, “The cp932 Character Set”

--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 9.2, “The Character Set Used for Data and Sorting”
Section 8.4, “User-Defined Variables”

--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 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”

--character-sets-dir

Description
Section 9.6, “Problems With Character Sets”
Section 9.2, “The Character Set Used for Data and Sorting”

--character-sets-dir=name

Section 17.6.23, “Options Common to MySQL Cluster Programs”

--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

--check

Section 4.6.3.2, “myisamchk Check Options”
Description

--check-only-changed

Section 4.6.3.2, “myisamchk Check Options”
Description

--check-password-file

Section 4.6.10.1, “MySQL Instance Manager Command Options”

--check-upgrade

Description

--checkpoint

Description

--checkpoint=db_name.tbl_name

Description

--chroot

Description

--chroot=path

Description

--clean-password-file

Section 4.6.10.4, “Instance Manager User and Password Management”
Section 4.6.10.1, “MySQL Instance Manager 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 9.2, “The Character Set Used for Data and Sorting”

--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 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
Description
Description
Section 17.2.4, “Initial Startup of MySQL Cluster”
Section A.10, “MySQL 5.1 FAQ — MySQL Cluster”

--config-file=file_name

Description

--config-file=filename

Description

--config-file=path-to-file

Description

--configdir=directory

Description

--configinfo

Description

--connect

Description

--connect-string

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

--connect-string=connect_string

Section 17.6.23, “Options Common to MySQL Cluster Programs”

--connectstring

Description

--copy

Description

--core-file

Section 22.5.1.4, “Debugging mysqld under gdb
Description
Section 17.6.23, “Options Common to MySQL Cluster Programs”

--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

--daemon

Description
Description

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

Section 4.6.3.3, “myisamchk Repair Options”

--database

Description
Description

--database=db_name

Section 4.5.1.1, “mysql Options”
Description

--databases

Description
Description

--datadir

Description
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”

--db=db_name

Description

--debug

Section 22.5.1.1, “Compiling MySQL for Debugging”
Description
Description
Description
Section 17.6.23, “Options Common to MySQL Cluster Programs”
Section 22.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

--debug="..."

Section 22.5.3, “The DBUG Package”

--debug=N

Description

--debug=debug_options, -# debug_options

Section 4.6.3.1, “myisamchk General Options”
Section 4.6.10.1, “MySQL Instance Manager Command Options”

--debug[=debug_options]

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

--debug[=options]

Section 17.6.23, “Options Common to MySQL Cluster Programs”

--default-character-set

Section 9.1.4, “Connection Character Sets and Collations”
Description

--default-character-set=charset_name

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

--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-mysqld-path=/usr/sbin/mysqld

Section 4.6.10.1, “MySQL Instance Manager Command Options”

--default-mysqld-path=path

Section 4.6.10.1, “MySQL Instance Manager Command Options”

--default-storage-engine

Section 13.3, “Setting the Storage Engine”

--default-table-type

Section 13.3, “Setting the Storage Engine”

--default-time-zone

Section 16.3.1.24, “Replication and Time Zones”

--default-time-zone=timezone

Section 9.7, “MySQL Server Time Zone Support”

--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

--defaults-extra-file=path

Description
Section 4.2.3.3, “Using Option Files”

--defaults-file

Section 4.2.3.3.1, “Command-Line Options that Affect Option-File Handling”
Description
Section 4.6.10.1, “MySQL Instance Manager Command Options”
Section 4.6.10.7, “MySQL Instance Manager Commands”
Section 4.6.10.2, “MySQL Instance Manager Configuration Files”
Section 21.9.3, “Options with the Embedded Server”
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”

--defaults-file=file_name

Section 4.2.3.3.1, “Command-Line Options that Affect Option-File Handling”
Description
Description
Section 4.6.10.1, “MySQL Instance Manager Command Options”

--defaults-group-suffix

Section 2.14, “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”

--delay-key-write=ALL

Section 13.5.1, “MyISAM Startup Options”
Section 16.3.4, “Replication FAQ”

--delayed-insert

Description

--delete

Description

--delete-master-logs

Description

--delimiter

Description

--delimiter=character

Description

--delimiter=str

Section 4.5.1.1, “mysql Options”
Description

--demangle

Section 22.5.1.5, “Using a Stack Trace”

--des-key-file

Section 11.11.2, “Encryption and Compression Functions”

--descending

Description

--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-keys

Description

--disable-log-bin

Description

--disable-named-commands

Section 4.5.1.1, “mysql Options”

--disk

Description

--dont_ignore_systab_0

Description

--drop-user

Section 4.6.10.1, “MySQL Instance Manager Command Options”

--dryrun

Description

--dump

Description

--dump-date

Description

--edit-user

Section 4.6.10.1, “MySQL Instance Manager Command Options”

--enable-local-infile

Section 5.3.4, “Security Issues with LOAD DATA LOCAL

--enable-named-pipe

Section 4.2.2, “Connecting to the MySQL Server”

--engine=engine_name

Description

--events

Description

--example

Description

--exclude-databases

Description

--exclude-databases=db_list

Description

--exclude-tables

Description

--exclude-tables=tbl_list

Description

--excludedbs

Description

--excludetables

Description

--execute

Section 17.6.23, “Options Common to MySQL Cluster Programs”
Section 4.2.3.1, “Using Options on the Command Line”
Section 17.7.3.2, “Using The MySQL Cluster Management Client to Create a Backup”

--execute=command

Section 17.6.23, “Options Common to MySQL Cluster Programs”

--execute=statement

Section 4.5.1.1, “mysql 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”

--extra-partition-info

Description

--fast

Section 4.6.3.2, “myisamchk Check Options”
Description

--federated

Section 13.11, “The FEDERATED Storage Engine”

--fields

Description

--fields-enclosed-by

Description

--fields-enclosed-by=...

Description
Description

--fields-escaped-by=...

Description
Description

--fields-optionally-enclosed-by

Description

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

Description
Description

--fields-terminated-by

Description

--fields-terminated-by=...

Description
Description

--fields-xxx

Description

--fields=delimiter

Description

--first-slave

Description

--fix-db-names

Description

--fix-table-names

Description

--flush-logs

Description

--flush-privileges

Description

--flush_time=val

Section 22.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 22.1.2, “MySQL Test Suite”
Section 3.5, “Using mysql in Batch Mode”

--force-read

Description

--format

Description

--fs

Description

--gci

Description

--gdb

Section 22.5.1.4, “Debugging mysqld under gdb

--general_log

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

--header=FALSE

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
Section 4.6.10.1, “MySQL Instance Manager Command Options”
Section 17.6.23, “Options Common to MySQL Cluster Programs”
Chapter 3, Tutorial
Section 4.2.3.3, “Using Option Files”
Section 4.2.3.1, “Using Options on the Command Line”

--hex

Description

--hex-blob

Description

--hexdump

Section 4.6.7.1, “mysqlbinlog Hex Dump Format”
Description

--host

Section 4.2.2, “Connecting to the MySQL Server”
Description
Description
Section 4.2.1, “Invoking MySQL Programs”
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.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=hostname

Description

--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”

--hostname

Description

--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”

--id

Description

--id=node_id

Description

--ignore

Description

--ignore-lines=N

Description

--ignore-spaces

Section 4.5.1.1, “mysql Options”

--ignore-table=db_name.tbl_name

Description

--include-databases

Description

--include-databases=db_list

Description

--include-tables

Description

--include-tables=tbl_list

Description

--information

Section 4.6.3.2, “myisamchk Check Options”

--init-file

Section 13.9, “The MEMORY (HEAP) Storage Engine”

--init_connect="SET NAMES 'utf8'"

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

--initial

Section 17.7.8.2, “Adding MySQL Cluster Data Nodes Online: Basic procedure”
Section 17.7.8.3, “Adding MySQL Cluster Data Nodes Online: Detailed Example”
Description
Description
Description
Description
Section 17.7.1, “Summary of MySQL Cluster Start Phases”

--initial-start

Description

--insert-ignore

Description

--install

Section 4.6.10.1, “MySQL Instance Manager Command Options”
Section 5.6.1.2, “Starting Multiple Windows Servers as Services”

--install-manual

Section 5.6.1.2, “Starting Multiple Windows Servers as Services”

--iterations=N

Description

--join=big_tbl_name

Description

--keepold

Description

--keys

Description

--keys-used=val

Section 4.6.3.3, “myisamchk Repair Options”

--language

Section 9.3, “Setting the Error Message Language”

--ledir

Description

--ledir=path

Description

--length

Description

--line-numbers

Section 4.5.1.1, “mysql Options”

--lines-terminated-by

Description
Description

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

Description

--lines-terminated-by=...

Description
Description

--list-users

Section 4.6.10.1, “MySQL Instance Manager Command Options”

--loadqueries

Description

--local

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 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[=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

--lock-all-tables

Description

--lock-directory

Description

--lock-directory=path

Description

--lock-tables

Description
Description

--lock=lock_type

Description

--log

Section 4.6.10.1, “MySQL Instance Manager 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 19.6, “Binary Logging of Stored Programs”
Section 6.1, “Database Backups”
Section 16.3.6, “How to Report Replication Bugs or Problems”
Section 6.3, “Point-in-Time Recovery”
Section 16.3.5, “Troubleshooting Replication”
Section 6.2.2, “Using Backups for Recovery”

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

Section 19.6, “Binary Logging of Stored Programs”

--log-bin=log_name

Section 6.2.3, “Backup Strategy Summary”

--log-bin[=file_name]

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

--log-error

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

--log-error my-errors

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

--log-error=file_name

Description
Description

--log-error[=file_name]

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

--log-slave-updates

Section 16.3.6, “How to Report Replication Bugs or Problems”

--log-slow-queries[=file_name]

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

--log=file_name

Description
Section 4.6.10.1, “MySQL Instance Manager Command Options”

--log[=file_name]

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

--loops

Description

--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 16.3.4, “Replication FAQ”

--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 16.3.1.15, “Replication During a Master Shutdown”

--master-data

Section 16.1.1.5, “Creating a Data Snapshot Using mysqldump
Description

--master-data[=value]

Description

--master-info-file

Section 16.4.2.2, “The Slave Status Files”

--master-retry-count

Section 12.6.2.1, “CHANGE MASTER TO Syntax”

--master-ssl*

Section 5.5.7.3, “SSL Command Options”

--max

Section 4.2.3.4, “Using Options to Set Program Variables”

--max-record-length=len

Section 4.6.3.3, “myisamchk Repair Options”

--max_a

Section 4.2.3.4, “Using Options to Set Program Variables”

--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=4M

Section 4.2.3.2, “Program Option Modifiers”

--medium-check

Section 4.6.3.2, “myisamchk Check Options”
Description

--method=command

Description

--monitoring-interval=seconds

Section 4.6.10.1, “MySQL Instance Manager Command Options”

--myisam-recover

Section 13.5.1, “MyISAM Startup Options”
Section 6.4.6, “Setting Up a Table Maintenance Schedule”
Section 13.5, “The MyISAM Storage Engine”
Section 22.5.1.6, “Using Server Logs to Find Causes of Errors in mysqld

--myisam-recover=mode

Section 13.5.1, “MyISAM Startup Options”

--mysqladmin=prog_name

Description

--mysqld

Description

--mysqld-safe-compatible

Section 4.6.10.1, “MySQL Instance Manager Command Options”
Section 4.6.10.3, “Starting the MySQL Server with MySQL Instance Manager”

--mysqld-version

Description

--mysqld-version=debug

Description

--mysqld-version=suffix

Description

--mysqld=mysqld_safe

Description

--mysqld=prog_name

Description
Description

--named-commands

Section 4.5.1.1, “mysql Options”

--ndb-batch-size=#

Section 17.4.2, “mysqld Command Options for MySQL Cluster”

--ndb-cluster-connection-pool

Section 17.4.2, “mysqld Command Options for MySQL Cluster”

--ndb-cluster-connection-pool=#

Section 17.4.2, “mysqld Command Options for MySQL Cluster”

--ndb-cluster-connection-pool=4

Section 17.4.2, “mysqld Command Options for MySQL Cluster”

--ndb-connectstring

Section 17.4.2, “mysqld Command Options for MySQL Cluster”
Description
Description
Section A.10, “MySQL 5.1 FAQ — MySQL Cluster”
Section 17.1.1, “MySQL Cluster Core Concepts”
Section 17.6.1, “MySQL Server Usage for MySQL Cluster”

--ndb-connectstring=connect_string

Section 17.4.2, “mysqld Command Options for MySQL Cluster”
Description

--ndb-mgmd-host

Description

--ndb-nodegroup-map

Description

--ndb-nodeid

Section 17.4.2, “mysqld Command Options for MySQL Cluster”
Description

--ndb-nodeid=#

Section 17.4.2, “mysqld Command Options for MySQL Cluster”
Section 17.6.23, “Options Common to MySQL Cluster Programs”

--ndb-optimized-node-selection

Description
Section 17.6.23, “Options Common to MySQL Cluster Programs”

--ndb-shm

Description

--ndb_optimized_node_selection

Section 17.4.3, “MySQL Cluster System Variables”

--ndbcluster

Section 17.4.2, “mysqld Command Options for MySQL Cluster”
Section A.10, “MySQL 5.1 FAQ — MySQL Cluster”
Section 17.1.1, “MySQL Cluster Core Concepts”
Section 17.6.1, “MySQL Server Usage for MySQL Cluster”

--ndbcluster --ndb-connectstring=management_host

Section 17.8.2, “MySQL Cluster and MySQL Privileges”

--new

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-binlog

Description

--no-contact

Description

--no-create-db

Description

--no-create-info

Description

--no-data

Description

--no-defaults

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

--no-log

Description

--no-named-commands

Section 4.5.1.1, “mysql Options”

--no-pager

Section 4.5.1.1, “mysql Options”

--no-restore-disk-objects

Description

--no-set-names

Description

--no-symlinks

Section 4.6.3.3, “myisamchk Repair Options”

--no-tee

Section 4.5.1.1, “mysql Options”

--no-upgrade

Description

--nodaemon

Description
Description

--nodata

Description

--nodeid

Section 17.4.2, “mysqld Command Options for MySQL Cluster”
Description
Description

--nodeid=node_id

Description

--nodes

Description

--noindices

Description

--nostart

Description

--not-started

Description

--nowait

Section 17.7.8.3, “Adding MySQL Cluster Data Nodes Online: Detailed Example”

--nowait-nodes

Description

--nowait-nodes=3

Description

--nowait-nodes=3,5

Description

--nowait-nodes=node_id_1[, node_id_2[, ...]]

Description

--number-char-cols=N

Description

--number-int-cols=N

Description

--number-of-queries=N

Description

--offset=N

Description

--old-passwords

Section 5.5.6.3, “Password Hashing in MySQL”
Section 5.3.3, “Security-Related mysqld Options”

--old-style-user-limits

Section 5.5.4, “Limiting Account Resources”

--old_server

Description

--one-database

Section 4.5.1.1, “mysql Options”

--only-print

Description

--open-files-limit=count

Description

--opt

Description

--opt_name

Section 4.2.3.3, “Using Option Files”

--opt_name=value

Section 4.2.3.3, “Using Option Files”

--optimize

Description

--order

Description

--order-by-primary

Description

--order=index_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”

--parallelism

Description

--parsable

Description

--passwd

Section 4.6.10.4, “Instance Manager User and Password Management”
Section 4.6.10.1, “MySQL Instance Manager Command Options”

--password

Section 4.5.1.1, “mysql Options”
Section 5.5.2, “Adding User Accounts”
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.6.10.4, “Instance Manager User and Password Management”
Section 4.2.1, “Invoking MySQL Programs”
Section 4.6.10.1, “MySQL Instance Manager Command Options”
Section 4.2.3.1, “Using Options on the Command Line”

--password-file

Section 4.6.10.4, “Instance Manager User and Password Management”

--password-file=file_name

Section 4.6.10.1, “MySQL Instance Manager Command Options”

--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
Section 4.6.10.1, “MySQL Instance Manager Command Options”

--password=your_pass

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

--pid-file=file_name

Description
Description
Section 4.6.10.1, “MySQL Instance Manager Command Options”
Section 5.6, “Running Multiple MySQL Servers on the Same Machine”

--pipe

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

--plan

Description

--plugin_dir=path

Section 22.2.1, “Characteristics of the Plugin Interface”

--plugins=max

Section 17.2.2, “MySQL Cluster Multi-Computer Installation”

--plugins=max-no-innodb

Section 17.2.2, “MySQL Cluster Multi-Computer Installation”

--port

Section 4.2.2, “Connecting to the MySQL Server”
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.6.3, “Using Client Programs in a Multiple-Server Environment”

--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 4.6.10.1, “MySQL Instance Manager Command Options”
Section 5.6, “Running Multiple MySQL Servers on the Same Machine”

--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 22.2.3.3, “Creating a Plugin Library”
Section 17.2.2, “MySQL Cluster Multi-Computer Installation”
Section 5.6.2, “Running Multiple Servers on Unix”

--preserve-schema

Description

--preserve-trailing-spaces

Description

--preview

Description

--print

Description

--print-defaults

Section 4.2.3.3.1, “Command-Line Options that Affect Option-File Handling”
Section 4.6.10.1, “MySQL Instance Manager Command Options”

--print-full-config

Description

--print-password-line

Section 4.6.10.4, “Instance Manager User and Password Management”
Section 4.6.10.1, “MySQL Instance Manager Command Options”

--print_data

Description

--print_log

Description

--print_meta

Description

--promote-attributes

Description

--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 5.6.3, “Using Client Programs in a Multiple-Server Environment”

--protocol=PIPE

Section 4.2.2, “Connecting to the MySQL Server”
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
Description

--query=id,type,indexmemory,datamemory

Description

--query=query-options

Description

--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”
Description
Description
Description
Section 6.4.1, “Using myisamchk for Crash Recovery”
Section 4.2.3.3, “Using Option Files”

--quiet

Description

--quote-names

Description

--raw

Section 4.5.1.1, “mysql Options”

--read-from-remote-server

Description

--read-only

Section 4.6.3.2, “myisamchk Check Options”

--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.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.4.2.1, “The Slave Relay Log”

--relay-log-info-file

Section 16.4.2.2, “The Slave Status Files”

--relay-log=myhost-bin

Section 12.6.2.1, “CHANGE MASTER TO Syntax”

--relnotes

Description

--reload

Section 17.7.8.2, “Adding MySQL Cluster Data Nodes Online: Basic procedure”
Section 17.7.8.3, “Adding MySQL Cluster Data Nodes Online: Detailed Example”
Description

--remove

Section 4.6.10.1, “MySQL Instance Manager Command Options”
Section 5.6.1.2, “Starting Multiple Windows Servers as Services”

--repair

Description

--replace

Description
Description

--replicate-*

Section 16.4.3, “How Servers Evaluate Replication Filtering Rules”

--replicate-*-db

Section 16.4.3, “How Servers Evaluate Replication Filtering Rules”

--replicate-*-do-*

Section 12.6.2.2, “LOAD DATA FROM MASTER Syntax”

--replicate-*-ignore-*

Section 12.6.2.2, “LOAD DATA FROM MASTER Syntax”

--replicate-*-table

Section 16.4.3, “How Servers Evaluate Replication Filtering Rules”

--replicate-do-db

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

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-db

Section 16.4.3, “How Servers Evaluate Replication Filtering Rules”
Section 16.3.1.19, “Replication and Reserved Words”

--replicate-ignore-table

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-rewrite-db

Section 12.6.2.2, “LOAD DATA FROM MASTER Syntax”

--replicate-rewrite-db="db1->db3"

Section 12.6.2.2, “LOAD DATA FROM MASTER Syntax”

--replicate-rewrite-db="db2->db3"

Section 12.6.2.2, “LOAD DATA FROM MASTER Syntax”

--replicate-same-server-id

Section 12.6.2.1, “CHANGE MASTER TO Syntax”

--replicate-wild-do-table

Section 16.4.3, “How Servers Evaluate Replication Filtering Rules”
Section 16.3.1.22, “Replication and Temporary Tables”

--replicate-wild-ignore-table

Section 16.4.3, “How Servers Evaluate Replication Filtering Rules”
Section 16.3.1.22, “Replication and Temporary Tables”

--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”

--resetmaster

Description

--resetslave

Description

--restore_data

Description

--restore_epoch

Description

--restore_meta

Description

--result-file=file_name

Description

--result-file=name

Description

--rhost=host_name

Description

--rollback

Description

--routines

Description

--rowid

Description

--rows

Description

--rows=separator

Description

--run-as-service

Section 4.6.10.1, “MySQL Instance Manager Command Options”

--safe-mode

Section 22.5.1, “Debugging a MySQL Server”

--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”

--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”

--savequeries

Description

--secure-auth

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

--secure-file-priv=path

Section 5.3.3, “Security-Related mysqld Options”

--select_limit

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

--server-id

Section 16.3.5, “Troubleshooting Replication”

--server-id=id

Description

--service-startup-timeout=file_name

Description

--set-auto-increment[=value]

Section 4.6.3.4, “Other myisamchk 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”
Description

--set-variable=option=value

Section 4.2.3.4, “Using Options to Set Program Variables”

--shared-memory

Section 4.2.2, “Connecting to the MySQL Server”
Section 5.6.1.1, “Starting Multiple Windows Servers at the Command Line”

--shared-memory-base-name

Section 21.10.3.49, “mysql_options()
Section 5.6.1.1, “Starting Multiple Windows Servers at the Command Line”
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”

--short-form

Description

--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
Section 6.4.6, “Setting Up a Table Maintenance Schedule”

--single-transaction

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-base64-output

Description

--skip-character-set-client-handshake

Section A.11, “MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”
Section 9.1.12.7.1, “The cp932 Character Set”

--skip-column-names

Section 4.5.1.1, “mysql Options”

--skip-comments

Description

--skip-compact

Description

--skip-disable-keys

Description

--skip-dump-date

Description

--skip-extended-insert

Description

--skip-grant-tables

Section 22.3.2.5, “Compiling and Installing User-Defined Functions”
Description
Section 5.3.3, “Security-Related mysqld Options”
Section 4.2.3.1, “Using Options on the Command Line”

--skip-innodb

Section 16.3.4, “Replication FAQ”

--skip-kill-mysqld

Description

--skip-line-numbers

Section 4.5.1.1, “mysql Options”

--skip-merge

Section 5.3.3, “Security-Related mysqld Options”

--skip-name-resolve

Section 5.3.3, “Security-Related mysqld Options”

--skip-named-commands

Section 4.5.1.1, “mysql Options”

--skip-ndbcluster

Section 17.4.2, “mysqld Command Options for MySQL Cluster”
Section 17.4.3, “MySQL Cluster System Variables”

--skip-networking

Section 5.3.3, “Security-Related mysqld Options”

--skip-new

Section 22.5.1, “Debugging a MySQL Server”

--skip-opt

Description

--skip-pager

Section 4.5.1.1, “mysql Options”

--skip-quick

Description

--skip-quote-names

Description

--skip-reconnect

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

--skip-safemalloc

Section 22.5.1.1, “Compiling MySQL for Debugging”

--skip-set-charset

Description

--skip-show-database

Section 5.3.3, “Security-Related mysqld Options”

--skip-slave-start

Section 12.6.2.1, “CHANGE MASTER TO Syntax”
Section 12.6.2.7, “START SLAVE Syntax”
Section 16.3.5, “Troubleshooting Replication”

--skip-ssl

Section 5.5.7.3, “SSL Command Options”

--skip-stack-trace

Section 22.5.1.4, “Debugging mysqld under gdb

--skip-symbolic-links

Section 5.3.2, “Making MySQL Secure Against Attackers”

--skip-syslog

Description

--skip-table-check

Description

--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-skip-errors

Section 16.3.1.25, “Replication and Transactions”

--sleep

Description

--sleep=delay

Description

--slow_query_log

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

--socket

Section 4.2.2, “Connecting to the MySQL Server”
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.6.3, “Using Client Programs in a Multiple-Server Environment”

--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 4.6.10.1, “MySQL Instance Manager Command Options”
Section 5.6, “Running Multiple MySQL Servers on the Same Machine”

--sort-index

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

--sort-records=N

Section 4.6.3.4, “Other myisamchk Options”

--sort-records=index_num

Section 6.4.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

--sql-mode

Section A.3, “MySQL 5.1 FAQ — Server SQL Mode”

--sql-mode=IGNORE_SPACE

Chapter 11, Functions and Operators

--sql-mode=MAXDB

Section 10.3.1.1, “TIMESTAMP Properties”

--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.5.7.3, “SSL Command Options”
Section 5.3.3, “Security-Related mysqld 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”

--ssl-ca

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 5.5.7.3, “SSL Command Options”

--ssl-capath=directory_name

Section 5.5.7.3, “SSL Command Options”

--ssl-cert

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=cipher_list

Section 5.5.7.3, “SSL Command Options”

--ssl-key

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 22.5.1.2, “Creating Trace Files”
Section 4.6.10.1, “MySQL Instance Manager Command Options”

--start-datetime

Description
Section 6.3.1, “Specifying Times for Recovery”

--start-datetime=datetime

Description

--start-position

Description
Section 6.3.2, “Specifying Positions for Recovery”

--start-position=N

Description

--stats

Description

--status

Description

--stop-datetime

Description
Section 6.3.1, “Specifying Times for Recovery”

--stop-datetime=datetime

Description

--stop-position

Section 6.3.2, “Specifying Positions for Recovery”

--stop-position=N

Description

--suffix=str

Description

--superuser=user_name

Description

--sysdate-is-now

Section 11.6, “Date and Time Functions”
Section 16.3.1.10, “Replication and System Functions”

--syslog

Description

--syslog-tag=tag

Description

--tab

Chapter 6, Backup and Recovery
Description
Description

--tab=path

Description

--table

Section 4.5.1.1, “mysql Options”
Description

--tables

Description
Description

--tcp-ip

Description

--tee

Section 4.5.1.2, “mysql Commands”

--tee=file_name

Section 4.5.1.1, “mysql Options”

--test

Description

--thread_cache_size=5'

Section 22.5.1.4, “Debugging mysqld under gdb

--timeout

Description

--timeout=seconds

Description

--timezone

Section 9.7, “MySQL Server Time Zone Support”

--timezone=timezone

Description

--timezone=timezone_name

Section 9.7, “MySQL Server Time Zone Support”
Section 16.3.1.24, “Replication and Time Zones”

--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”

--to-last-log

Description

--transactional

Description

--triggers

Description

--try-reconnect=number

Description

--tupscan

Description

--type

Description
Description

--type=node_type

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

--unqualified

Description

--update-state

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

--usage

Description
Description
Section 17.6.23, “Options Common to MySQL Cluster Programs”

--use-frm

Description

--use-manager

Description

--use-mysqld_safe

Description

--use-threads

Description

--use-threads=N

Description

--useHexFormat

Description

--user

Description
Description
Section 6.2, “Example Backup and Recovery Strategy”
Section 4.2.1, “Invoking MySQL Programs”
Section 4.2.3.5, “Option Defaults, Options Expecting Values, and the = Sign”
Section 5.5.1, “User Names and Passwords”
Section 4.2.3.3, “Using Option Files”

--user=mysql

Section 17.8.3, “MySQL Cluster and MySQL Security Procedures”

--user=root

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

--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”
Section 4.6.10.1, “MySQL Instance Manager Command Options”

--user={user_name|user_id}

Description

--username

Section 4.6.10.4, “Instance Manager User and Password Management”
Section 4.6.10.1, “MySQL Instance Manager Command Options”

--username=user_name

Section 4.6.10.1, “MySQL Instance Manager Command Options”

--var_name=value

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

--verbose

Section 4.6.3.1, “myisamchk General Options”
Section 4.5.1.1, “mysql Options”
Section 4.6.7.2, “mysqlbinlog Row Event Display”
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
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
Section 4.6.10.1, “MySQL Instance Manager Command Options”
Section 17.6.23, “Options Common to MySQL Cluster Programs”
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-timeout=N

Section 4.6.10.1, “MySQL Instance Manager Command Options”

--wait[=count]

Description

--where='where_condition'

Description

--with-archive-storage-engine

Section 13.12, “The ARCHIVE Storage Engine”

--with-big-tables

Section 13.5, “The MyISAM Storage Engine”

--with-blackhole-storage-engine

Section 13.14, “The BLACKHOLE Storage Engine”

--with-charset

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

--with-charset=MYSET

Section 9.4, “Adding a New Character Set”

--with-charset=charset_name

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”

--with-csv-storage-engine

Section 13.13, “The CSV Storage Engine”

--with-debug

Section 22.5.1.1, “Compiling MySQL for Debugging”
Section 22.5.2, “Debugging a MySQL Client”

--with-debug=full

Section 22.5.1.1, “Compiling MySQL for Debugging”
Section 22.5.2, “Debugging a MySQL Client”
Description

--with-embedded-privilege-control

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

--with-embedded-server

Section 21.9.1, “Compiling Programs with libmysqld

--with-example-storage-engine

Section 13.10, “The EXAMPLE Storage Engine”

--with-extra-charsets=complex

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.11, “The FEDERATED Storage Engine”

--with-max-indexes=N

Section 13.5, “The MyISAM Storage Engine”

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

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

--with-mysqld-ldflags=-rdynamic

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

--with-ndb-sci=/opt/DIS

Section 17.11.1, “Configuring MySQL Cluster to use SCI Sockets”

--with-ndbcluster

Section 17.2.2, “MySQL Cluster Multi-Computer Installation”
Section 17.6.1, “MySQL Server Usage for MySQL Cluster”

--with-partition

Chapter 18, Partitioning

--with-ssl

Section 5.5.7.2, “Using SSL Connections”

--write-binlog

Description

--xml

Section 4.5.1.1, “mysql Options”
Description
Description
Section 11.10, “XML Functions”

-1

Section 18.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 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
Section 4.6.10.1, “MySQL Instance Manager Command Options”
Section 17.6.23, “Options Common to MySQL Cluster Programs”
Section 4.2.3.1, “Using Options on the Command Line”

-A

Section 4.5.1.1, “mysql Options”
Description
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
Description

-D

Description
Description

-D character

Description

-D db_name

Section 4.5.1.1, “mysql Options”

-DHAVE_rts_threads

Section 22.5.4, “Comments about RTS Threads”

-DUSE_ALARM_THREAD

Section 22.1.1, “MySQL Threads”

-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 21.10.16, “Building Client Programs”
Description

-I/usr/local/mysql/include

Section 21.10.16, “Building Client Programs”

-K

Description

-L

Section 4.5.1.1, “mysql Options”
Section 21.10.16, “Building Client Programs”
Description
Section 5.3.4, “Security Issues with LOAD DATA LOCAL
Section 9.3, “Setting the Error Message Language”

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

Section 21.10.16, “Building Client Programs”

-N

Section 4.5.1.1, “mysql Options”

-P

Section 4.2.2, “Connecting to the MySQL Server”
Description
Section 4.2.1, “Invoking MySQL Programs”
Section 4.6.10.1, “MySQL Instance Manager Command Options”

-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

-P[password]

Description

-Q

Description

-R

Description
Description
Description

-R N

Section 4.6.3.4, “Other myisamchk Options”

-R index_num

Section 6.4.4, “Table Optimization”

-R record_pos_file record_pos

Description

-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.4.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 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
Section 4.6.10.1, “MySQL Instance Manager Command Options”
Section 17.6.23, “Options Common to MySQL Cluster Programs”
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

-X

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

-Y

Description

-a

Section 17.7.2, “Commands in the MySQL Cluster Management Client”
Description
Description
Description
Section 4.6.3.4, “Other myisamchk Options”
Section 6.4.4, “Table Optimization”

-b

Section 4.5.1.1, “mysql Options”
Description
Description
Description
Description

-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
Description
Description
Section A.10, “MySQL 5.1 FAQ — MySQL Cluster”

-c N

Description
Description
Description

-c column_list

Description

-c connect_string

Section 17.6.23, “Options Common to MySQL Cluster Programs”

-d

Section 4.6.3.1, “myisamchk General Options”
Description
Description
Description
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”
Description
Description
Description
Section 6.4.2, “How to Check MyISAM Tables for Errors”
Section 17.6.23, “Options Common to MySQL Cluster Programs”
Section 17.2.6, “Safe Shutdown and Restart of MySQL Cluster”
Section 4.2.3.1, “Using Options on the Command Line”
Section 17.7.3.2, “Using The MySQL Cluster Management Client to Create a Backup”

-e command

Section 17.6.23, “Options Common to MySQL Cluster Programs”

-e engine_name

Description

-e num

Description

-e statement

Section 4.5.1.1, “mysql Options”

-eis

Section 6.4.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
Description
Description
Description
Section 17.2.4, “Initial Startup of MySQL Cluster”
Section A.10, “MySQL 5.1 FAQ — MySQL Cluster”

-f N

Description

-f filename

Description

-fomit-frame-pointer

Section 22.5.1.5, “Using a Stack Trace”

-g

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

-g pattern

Description

-h

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

-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”

-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”
Section 17.7.2, “Commands in the MySQL Cluster Management Client”
Description
Description
Description
Description
Section 6.4.2, “How to Check MyISAM Tables for Errors”
Section 22.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
Description

-l lock_type

Description

-l path

Description

-ldbug

Section 21.10.17, “How to Make a Threaded Client”

-libmysqlclient

Section 21.10.2, “C API Function Overview”

-libmysqld

Section 21.10.2, “C API Function Overview”

-lm

Section 21.10.10.4, “Problems Linking with the C API”

-lmysqlclient

Section 21.10.3.39, “mysql_library_end()
Section 21.10.9, “C API Embedded Server Function Descriptions”

-lmysqlclient -lz

Section 21.10.16, “Building Client Programs”

-lmysqld

Section 21.10.3.39, “mysql_library_end()
Section 21.10.9, “C API Embedded Server Function Descriptions”

-lmystrings

Section 21.10.17, “How to Make a Threaded Client”

-lmysys

Section 21.10.17, “How to Make a Threaded Client”

-lz

Section 21.9.1, “Compiling Programs with libmysqld

-m

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

-n

Section 4.6.3.3, “myisamchk Repair Options”
Section 4.5.1.1, “mysql Options”
Section 17.7.2, “Commands in the MySQL Cluster Management Client”
Description
Description
Description
Description
Description
Description

-n N

Description

-nocheck

Description

-noprint

Description

-o

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

-o N

Description

-o index_name

Description

-o offset

Description

-p

Section 4.6.3.3, “myisamchk Repair Options”
Section 4.5.1.1, “mysql Options”
Section 17.7.8.3, “Adding MySQL Cluster Data Nodes Online: Detailed Example”
Section 5.5.2, “Adding User Accounts”
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
Description
Description
Description
Section 5.5.6.2, “End-User Guidelines for Password Security”
Section 4.6.10.4, “Instance Manager User and Password Management”
Section 4.2.1, “Invoking MySQL Programs”
Section 5.5.1, “User Names and Passwords”
Section 4.2.3.1, “Using Options on the Command Line”

-p N

Description

-p num

Description

-p password

Section 4.6.10.1, “MySQL Instance Manager Command Options”

-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

-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
Description

-q value

Description

-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
Description
Description
Section 6.4.3, “How to Repair Tables”

-r -q

Section 6.4.3, “How to Repair Tables”

-r file_name

Description

-r name

Description

-rdynamic

Section 22.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
Section 6.4.2, “How to Check MyISAM Tables for Errors”
Section 6.4.3, “How to Repair Tables”
Section 6.4.6, “Setting Up a Table Maintenance Schedule”

-s num

Description

-s sort_type

Description

-skip-auto-rehash

Section 4.5.1.1, “mysql Options”

-ss

Section 4.6.3.1, “myisamchk General Options”

-t

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

-t N

Description

-t path

Section 4.6.3.3, “myisamchk Repair Options”

-t seconds

Description

-u

Section 4.6.3.3, “myisamchk Repair Options”
Description
Description
Description
Section 4.6.10.4, “Instance Manager User and Password Management”
Section 4.2.1, “Invoking MySQL Programs”
Section 5.5.1, “User Names and Passwords”

-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
Section 4.6.10.1, “MySQL Instance Manager Command Options”

-v

Section 4.6.3.1, “myisamchk General Options”
Section 4.5.1.1, “mysql Options”
Section 4.6.7.2, “mysqlbinlog Row Event Display”
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Section 6.4.5, “Getting Information About a Table”
Section 6.4.2, “How to Check MyISAM Tables for Errors”
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
Description

-x N

Description

-y N

Description

-z

Description
Description

Com_insert

Section D.1, “Restrictions on Stored Routines, Triggers, and Events”

Com_select

Section D.1, “Restrictions on Stored Routines, Triggers, and Events”

Com_stmt_reprepare

Section 12.7.4, “Automatic Prepared Statement Repreparation”

HELP

Section 17.7.2, “Commands in the MySQL Cluster Management Client”

Ndb_cluster_node_id

Section 17.4.2, “mysqld Command Options for MySQL Cluster”

ON

Section 3.3.4.9, “Using More Than one Table”

\G

Section 4.5.1.1, “mysql Options”
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”
Description
Section 8.1.1, “Strings”
Section 4.2.3.3, “Using Option Files”

\w

Section 4.5.1.2, “mysql Commands”

ansi

Description

backup_path

Description

backup_path=

Description

c

Description
Section 8.2.1, “Identifier Qualifiers”
Section 3.3.4.7, “Pattern Matching”
Section 11.4.2, “Regular Expressions”
Section 9.1.12.1, “Unicode Character Sets”

charset

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

compress

Section 21.10.3.49, “mysql_options()

connect_timeout

Section 4.5.1.1, “mysql Options”
Description

count

Section 8.2.4, “Function Name Parsing and Resolution”

d

Section 11.4.2, “Regular Expressions”
Section 22.5.3, “The DBUG Package”
Section 9.1.12.1, “Unicode Character Sets”

data

Section 21.10.7.25, “mysql_stmt_send_long_data()
Section 18.3.1, “Management of RANGE and LIST Partitions”

datadir

Section 4.6.10.3, “Starting the MySQL Server with MySQL Instance Manager”
Section D.7.3, “Windows Platform Limitations”

date

Section 11.6, “Date and Time Functions”

db

Section 21.10.3.3, “mysql_change_user()
Section 21.10.3.8, “mysql_create_db()
Section 21.10.3.11, “mysql_drop_db()
Section 21.10.3.52, “mysql_real_connect()
Section 21.10.3.60, “mysql_select_db()
Section 5.5.2, “Adding User Accounts”
Section 21.10.1, “C API Data Types”
Description
Section D.6, “Restrictions on Character Sets”
Section 20.22, “The INFORMATION_SCHEMA PROCESSLIST Table”
Section 20.14, “The INFORMATION_SCHEMA ROUTINES Table”

dbname

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

debug

Section 21.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”

default-table-type

Section 13.3, “Setting the Storage Engine”

defaults-extra-file

Section 4.2.3.3, “Using Option Files”

delimiter

Section 4.5.1.2, “mysql Commands”
Section 19.1, “Defining Stored Programs”

description

Section 12.3.3, “HELP Syntax”

exit

Section 22.5.3, “The DBUG Package”

extended-status

Description

flush-hosts

Description

flush-logs

Description

flush-privileges

Description

flush-status

Description

flush-tables

Description

flush-threads

Description

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”

have_partition_engine

Chapter 18, Partitioning

help

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

host

Section 21.10.3.7, “mysql_connect()
Section 21.10.3.52, “mysql_real_connect()
Section 3.1, “Connecting to and Disconnecting from the Server”
Description

html

Description

initial

Section 17.7.5.1, “MySQL Cluster — Messages in the Cluster Log”

innodb_file_per_table

Section 16.1.1.6, “Creating a Data Snapshot Using Raw Data Files”

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 20.14, “The INFORMATION_SCHEMA ROUTINES Table”

ledir

Description
Description

length

Section 21.10.3.34, “mysql_hex_string()
Section 21.10.3.53, “mysql_real_escape_string()
Section 21.10.3.54, “mysql_real_query()
Section 21.10.7.11, “mysql_stmt_fetch()
Section 21.10.7.20, “mysql_stmt_prepare()
Section 21.10.7.25, “mysql_stmt_send_long_data()
Section 21.10.5, “C API Prepared Statement Data types”
Section 22.2.3.3, “Creating a Plugin Library”
Section 22.2.3.2, “Type-Specific Plugin Structures and Functions”

local-infile

Section 5.3.4, “Security Issues with LOAD DATA LOCAL

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 17.4.3, “MySQL Cluster 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.3.3, “HELP Syntax”
Section 12.6.2.2, “LOAD DATA FROM MASTER Syntax”
Section 21.10.3.3, “mysql_change_user()
Section 21.10.3.5, “mysql_close()
Section 21.10.3.14, “mysql_errno()
Section 21.10.3.15, “mysql_error()
Section 21.10.3.33, “mysql_get_ssl_cipher()
Section 21.10.3.36, “mysql_init()
Section 21.10.3.53, “mysql_real_escape_string()
Section 21.10.3.60, “mysql_select_db()
Section 21.10.3.67, “mysql_ssl_set()
Section 21.10.7.10, “mysql_stmt_execute()
Section 21.10.7.11, “mysql_stmt_fetch()
Section 21.10.7.25, “mysql_stmt_send_long_data()
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 21.10.14, “C API Prepared Statement Handling of Date and Time Values”
Section 22.2.1, “Characteristics of the Plugin Interface”
Section 22.3.2.5, “Compiling and Installing User-Defined Functions”
Chapter 21, Connectors and APIs
Section 13.11.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 5.3.1, “General Security Guidelines”
Section 5.5.4, “Limiting Account Resources”
Section 5.3.2, “Making MySQL Secure Against Attackers”
Section A.11, “MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”
Section A.4, “MySQL 5.1 FAQ — Stored Procedures and Functions”
Section 17.2.2, “MySQL Cluster Multi-Computer Installation”
Section 17.8.2, “MySQL Cluster and MySQL Privileges”
Section 17.8.3, “MySQL Cluster and MySQL Security Procedures”
Section 21.11, “MySQL PHP API”
Section 9.7, “MySQL Server Time Zone Support”
Section 5.5.6.3, “Password Hashing in MySQL”
Section 16.3.1.9, “Replication and FLUSH
Section 16.3.1.17, “Replication of the System mysql Database”
Section D.6, “Restrictions on Character Sets”
Section D.1, “Restrictions on Stored Routines, Triggers, and Events”
Section 5.6.1.1, “Starting Multiple Windows Servers at the Command Line”
Section 9.7.1, “Staying Current with Time Zone Changes”
Section 22.2, “The MySQL Plugin Interface”
Section 5.5.1, “User Names and Passwords”
Section 4.2.3.1, “Using Options on the Command Line”
Section 5.5.7.2, “Using SSL Connections”
Section 22.5.1.6, “Using Server Logs to Find Causes of Errors in mysqld
Section 19.2, “Using Stored Routines (Procedures and Functions)”

mysqlbinlog

Section 6.3, “Point-in-Time Recovery”

mysqld

Section 21.10.2, “C API Function Overview”
Description
Description
Description
Section 13.11.1, “FEDERATED Storage Engine Overview”
Section 17.4.1, “MySQL Cluster Server Option and Variable Reference”
Section 4.6.10.7, “MySQL Instance Manager Commands”
Section 4.6.10.3, “Starting the MySQL Server with MySQL Instance Manager”
Section 16.4.2.2, “The Slave Status Files”
Section 22.5.1.3, “Using pdb to create a Windows crashdump”

mysqld-path

Section 4.6.10.1, “MySQL Instance Manager Command Options”

mysqld-path=path-to-mysqld-binary

Section 4.6.10.3, “Starting the MySQL Server with MySQL Instance Manager”

mysqld_safe

Description
Description

ndb-connectstring

Section 17.2.3, “MySQL Cluster Multi-Computer Configuration”
Section 17.6.1, “MySQL Server Usage for MySQL Cluster”

ndb_mgmd

Description

ndb_restore

Description

ndbd

Description

net_retry_count

Section 16.4.1, “Replication Implementation Details”

net_write_timeout

Section 16.4.1, “Replication Implementation Details”

nice

Description

nodeid

Description

nonguarded

Description

offset

Section 21.10.3.9, “mysql_data_seek()
Section 21.10.3.23, “mysql_field_seek()
Section 21.10.3.58, “mysql_row_seek()
Section 21.10.7.7, “mysql_stmt_data_seek()
Section 21.10.7.12, “mysql_stmt_fetch_column()
Section 21.10.7.23, “mysql_stmt_row_seek()

open_files_limit

Description
Section D.7.3, “Windows Platform Limitations”

p

Section 18.2.6, “How MySQL Partitioning Handles NULL
Section 19.2.1, “Stored Routine Syntax”
Section 22.5.3, “The DBUG Package”

password

Description

ping

Description
Section 16.3.5, “Troubleshooting Replication”

pipe

Section 21.10.3.49, “mysql_options()

port

Section 21.10.3.52, “mysql_real_connect()
Section 4.6.10.3, “Starting the MySQL Server with MySQL Instance Manager”

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”

read_buffer_size

Section 4.6.3.1, “myisamchk General Options”

reconnect

Section 21.10.3.52, “mysql_real_connect()
Section 21.10.2, “C API Function Overview”

refresh

Description

rehash

Section 4.5.1.1, “mysql Options”

reload

Description

replication-ignore-table

Section 16.3.1.29, “Replication and Views”

rows

Section 18.3.4, “Obtaining Information About Partitions”

s

Description
Section 11.4.2, “Regular Expressions”
Section 9.1.12.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.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”

set-variable=option=value

Section 4.2.3.4, “Using Options to Set Program Variables”

shutdown

Description

shutdown_timeout

Description

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”

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”

start-slave

Description

stats_method

Section 4.6.3.1, “myisamchk General Options”

status

Section 4.5.1.2, “mysql Commands”
Description
Section 4.6.10.5, “MySQL Server Instance Status Monitoring”

stop-slave

Description

syslog

Description
Section 17.7.4, “Event Reports Generated in MySQL Cluster”
Section 17.7.4.1, “MySQL Cluster Logging Management Commands”

system

Chapter 20, INFORMATION_SCHEMA Tables

tab

Section 11.4.2, “Regular Expressions”

table

Section 21.10.1, “C API Data Types”

test

Section 11.3, “Control Flow Functions”
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 19.2.1, “Stored Routine Syntax”
Section 20.19, “The INFORMATION_SCHEMA PARTITIONS Table”
Section 4.2.3.1, “Using Options on the Command Line”

timeout

Section 21.10.3.49, “mysql_options()

tmpdir

Section 4.6.3.3, “myisamchk Repair Options”
Section 6.1, “Database Backups”

type

Section 21.10.1, “C API Data Types”
Section 22.2.3.1, “General Plugin Structures and Functions”
Section 20.14, “The INFORMATION_SCHEMA ROUTINES Table”
Section 22.2.3.2, “Type-Specific Plugin Structures and Functions”

update

Description

use-manager

Section 4.6.10.3, “Starting the MySQL Server with MySQL Instance Manager”

user

Section 21.10.3.49, “mysql_options()
Section 21.10.3.52, “mysql_real_connect()
Section 5.5.2, “Adding User Accounts”
Section 5.5.5, “Assigning Account Passwords”
Section 5.5.9, “Auditing MySQL Account Activity”
Section 3.1, “Connecting to and Disconnecting from the Server”
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 D.6, “Restrictions on Character Sets”
Section 5.5.1, “User Names and Passwords”
Section 5.5.7.2, “Using SSL Connections”
Section 11.10, “XML Functions”

v

Section 16.3.1.10, “Replication and System Functions”

variables

Description

version

Description
Section 22.2.3.1, “General Plugin Structures and Functions”

write

Section 22.5.4, “Comments about RTS Threads”
Description

write_buffer_size

Section 4.6.3.1, “myisamchk General Options”