Option Index

Symbols | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y

Symbols

[index top]

--

Section 1.8.2.4, “'--' as the Start of a Comment”

-#

Section 4.4.1, “comp_err — Compile MySQL Error Message File”
Section 4.6.1, “ibd2sdi — InnoDB Tablespace SDI Extraction Utility”
Section 4.7.2, “my_print_defaults — Display Options from Option Files”
Section 4.6.4.1, “myisamchk General Options”
Section 4.6.6, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.5.1.1, “mysql Options”
Section 4.6.7, “mysql_config_editor — MySQL Configuration Utility”
Section 4.4.5, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”
Section 4.5.8, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.9, “mysqlslap — Load Emulation Client”
Section 5.1.4, “Server Command Options”
Section 28.5.3, “The DBUG Package”

-1

Section 4.5.3, “mysqlcheck — A Table Maintenance Program”

-?

Section 4.4.1, “comp_err — Compile MySQL Error Message File”
Section 4.6.2, “innochecksum — Offline InnoDB File Checksum Utility”
Section 4.7.2, “my_print_defaults — Display Options from Option Files”
Section 4.6.3, “myisam_ftdump — Display Full-Text Index information”
Section 4.6.4.1, “myisamchk General Options”
Section 4.6.5, “myisamlog — Display MyISAM Log File Contents”
Section 4.6.6, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.5.1.1, “mysql Options”
Section 4.6.7, “mysql_config_editor — MySQL Configuration Utility”
Section 4.4.2, “mysql_secure_installation — Improve MySQL Installation Security”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”
Section 4.5.8, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.9, “mysqlslap — Load Emulation Client”
Section 4.8.2, “perror — Explain Error Codes”
Section 4.8.3, “resolveip — Resolve Host name to IP Address or Vice Versa”
Section 5.1.4, “Server Command Options”
Section 1.3.2, “The Main Features of MySQL”
Section 4.2.4, “Using Options on the Command Line”

?

Section 4.4.3, “mysql_ssl_rsa_setup — Create SSL/RSA Files”

A

[index top]

-A

Section 4.5.1.1, “mysql Options”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”
Section 4.6.4.4, “Other myisamchk Options”

-a

Section 4.6.2, “innochecksum — Offline InnoDB File Checksum Utility”
Section 17.2.2.1, “memcached Command-Line Options”
Section 7.6.4, “MyISAM Table Optimization”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.6.9, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.5.9, “mysqlslap — Load Emulation Client”
Section 4.6.4.4, “Other myisamchk Options”

--abort-slave-event-count

Section 18.1.6.3, “Replication Slave Options and Variables”

--add-drop-database

Section 7.4.1, “Dumping Data in SQL Format with mysqldump”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”

--add-drop-table

Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”

--add-drop-trigger

Section 4.5.4, “mysqldump — A Database Backup Program”

--add-drop-user

Section 4.5.6, “mysqlpump — A Database Backup Program”

--add-locks

Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”

--all

Section 4.6.7, “mysql_config_editor — MySQL Configuration Utility”

--all-databases

Section 18.1.2.5.1, “Creating a Data Snapshot Using mysqldump”
Section 14.6, “Data Dictionary Usage Differences”
Section 7.4.1, “Dumping Data in SQL Format with mysqldump”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”
Section 2.10.3, “Rebuilding or Repairing Tables or Indexes”
Section 7.4.2, “Reloading SQL-Format Backups”
Section 4.6.8.3, “Using mysqlbinlog to Back Up Binary Log Files”

--all-in-1

Section 4.5.3, “mysqlcheck — A Table Maintenance Program”

--all-tablespaces

Section 4.5.4, “mysqldump — A Database Backup Program”

--allow-keywords

Section 4.5.4, “mysqldump — A Database Backup Program”

--allow-mismatches

Section 4.6.2, “innochecksum — Offline InnoDB File Checksum Utility”

--allow-suspicious-udfs

Section 5.1.4, “Server Command Options”
Section 28.4.2.6, “UDF Security Precautions”

--analyze

Section 7.6.4, “MyISAM Table Optimization”
Section 4.6.4.1, “myisamchk General Options”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.6.4.4, “Other myisamchk Options”

--ansi

Section 1.8, “MySQL Standards Compliance”
Section 5.1.4, “Server Command Options”

--apply-slave-statements

Section 4.5.4, “mysqldump — A Database Backup Program”

--auth-method

Section 4.5.7, “mysqlsh — The MySQL Shell”

--auto-generate-sql

Section 4.5.9, “mysqlslap — Load Emulation Client”

--auto-generate-sql-add-autoincrement

Section 4.5.9, “mysqlslap — Load Emulation Client”

--auto-generate-sql-execute-number

Section 4.5.9, “mysqlslap — Load Emulation Client”

--auto-generate-sql-guid-primary

Section 4.5.9, “mysqlslap — Load Emulation Client”

--auto-generate-sql-load-type

Section 4.5.9, “mysqlslap — Load Emulation Client”

--auto-generate-sql-secondary-indexes

Section 4.5.9, “mysqlslap — Load Emulation Client”

--auto-generate-sql-unique-query-number

Section 4.5.9, “mysqlslap — Load Emulation Client”

--auto-generate-sql-unique-write-number

Section 4.5.9, “mysqlslap — Load Emulation Client”

--auto-generate-sql-write-number

Section 4.5.9, “mysqlslap — Load Emulation Client”

--auto-rehash

Section 15.6.11.2, “Configuring Non-Persistent Optimizer Statistics Parameters”
Section 4.5.1.2, “mysql Commands”
Section 4.5.1.1, “mysql Options”

auto-rehash

Section 15.6.11.2, “Configuring Non-Persistent Optimizer Statistics Parameters”

--auto-repair

Section 4.5.3, “mysqlcheck — A Table Maintenance Program”

--auto-vertical-output

Section 4.5.1.1, “mysql Options”

--autocommit

Section 5.1.5, “Server System Variables”

B

[index top]

-B

Section 17.2.2.1, “memcached Command-Line Options”
Section 4.6.4.3, “myisamchk Repair Options”
Section 4.5.1.1, “mysql Options”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”

-b

Section 17.2.2.1, “memcached Command-Line Options”
Section 4.6.6, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.5.1.1, “mysql Options”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.4.4, “Other myisamchk Options”
Section 5.1.4, “Server Command Options”

--back_log

Section 2.6, “Installing MySQL on Solaris”

--backup

Section 4.6.4.3, “myisamchk Repair Options”
Section 4.6.6, “myisampack — Generate Compressed, Read-Only MyISAM Tables”

--base64-output

Section 18.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 18.1.3.1, “GTID Concepts”
Section 4.6.8.2, “mysqlbinlog Row Event Display”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 18.2.1.2, “Usage of Row-Based Logging and Replication”

--basedir

Section 2.9.1.1, “Initializing the Data Directory Manually Using mysqld”
Section 2.8.4, “MySQL Source-Configuration Options”
Section 4.4.5, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 5.7, “Running Multiple MySQL Instances on One Machine”
Section 5.1.4, “Server Command Options”
Section 2.9.2.1, “Troubleshooting Problems Starting the MySQL Server”

basedir

Section 2.3.5.2, “Creating an Option File”
Section 4.3.3, “mysql.server — MySQL Server Startup Script”
Section 2.3.6, “Troubleshooting a Microsoft Windows MySQL Server Installation”

--batch

Section 4.5.1.3, “mysql Logging”
Section 4.5.1.1, “mysql Options”

--big-tables

Section 5.1.4, “Server Command Options”

--binary-as-hex

Section 4.5.1.1, “mysql Options”

--binary-mode

Section 4.5.1.2, “mysql Commands”
Section 4.5.1.1, “mysql Options”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 7.5, “Point-in-Time (Incremental) Recovery Using the Binary Log”

--bind-address

Section B.5.2.2, “Can't connect to [local] MySQL server”
Section 5.1.9.2, “Configuring the MySQL Server to Permit IPv6 Connections”
Section 5.1.9.4, “Connecting Using IPv6 Nonlocal Host Addresses”
Section 5.1.9.3, “Connecting Using the IPv6 Local Host Address”
Section 5.1.9, “IPv6 Support”
Section 4.5.1.1, “mysql Options”
Section 4.4.5, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”
Section 4.5.8, “mysqlshow — Display Database, Table, and Column Information”
Section 5.1.9.5, “Obtaining an IPv6 Address from a Broker”
Section 5.7, “Running Multiple MySQL Instances on One Machine”
Section 5.1.4, “Server Command Options”
Section 5.1.5, “Server System Variables”
Section 6.2.9, “Troubleshooting Problems Connecting to MySQL”

--binlog-checksum

Section 18.1.6.4, “Binary Logging Options and Variables”

--binlog-do-db

Section 18.1.6.4, “Binary Logging Options and Variables”
Section 18.2.5.1, “Evaluation of Database-Level Replication and Binary Logging Options”
Section 18.2.5, “How Servers Evaluate Replication Filtering Rules”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 18.1.6.3, “Replication Slave Options and Variables”
Section 5.4.4, “The Binary Log”

--binlog-format

Section 5.4.4.1, “Binary Logging Formats”
Section 18.1.6.4, “Binary Logging Options and Variables”
Section A.4, “MySQL 8.0 FAQ: Stored Procedures and Functions”
Section 5.1.4, “Server Command Options”
Section 5.4.4.2, “Setting The Binary Log Format”

--binlog-ignore-db

Section 18.1.6.4, “Binary Logging Options and Variables”
Section 18.2.5.1, “Evaluation of Database-Level Replication and Binary Logging Options”
Section 18.2.5, “How Servers Evaluate Replication Filtering Rules”
Section 18.1.6.3, “Replication Slave Options and Variables”
Section 5.4.4, “The Binary Log”

--binlog-row-event-max-size

Section 18.1.6.4, “Binary Logging Options and Variables”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 5.4.4.2, “Setting The Binary Log Format”

--binlog-rows-query-log-events

Section 18.1.6.4, “Binary Logging Options and Variables”

--block-search

Section 4.6.4.4, “Other myisamchk Options”

--bootstrap

Section 1.4, “What Is New in MySQL 8.0”

C

[index top]

-C

Section 4.4.1, “comp_err — Compile MySQL Error Message File”
Section 4.6.2, “innochecksum — Offline InnoDB File Checksum Utility”
Section 17.2.2.1, “memcached Command-Line Options”
Section 4.6.4.2, “myisamchk Check Options”
Section 4.5.1.1, “mysql Options”
Section 4.4.5, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”
Section 4.5.8, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.9, “mysqlslap — Load Emulation Client”
Section 5.1.4, “Server Command Options”

-c

Section 4.6.1, “ibd2sdi — InnoDB Tablespace SDI Extraction Utility”
Section 4.6.2, “innochecksum — Offline InnoDB File Checksum Utility”
Section 17.2.2.1, “memcached Command-Line Options”
Section 4.7.2, “my_print_defaults — Display Options from Option Files”
Section 4.6.3, “myisam_ftdump — Display Full-Text Index information”
Section 4.6.4.2, “myisamchk Check Options”
Section 4.6.5, “myisamlog — Display MyISAM Log File Contents”
Section 4.5.1.1, “mysql Options”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.9, “mysqlslap — Load Emulation Client”

--cflags

Section 2.8.5, “Dealing with Problems Compiling MySQL”
Section 4.7.1, “mysql_config — Display Options for Compiling Clients”

--character-set-client-handshake

Section A.11, “MySQL 8.0 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
Section 5.1.4, “Server Command Options”
Section 10.1.10.7.1, “The cp932 Character Set”

--character-set-filesystem

Section 5.1.4, “Server Command Options”

--character-set-server

Section 10.5, “Character Set Configuration”
Section 10.1.5, “Configuring Application Character Set and Collation”
Section A.11, “MySQL 8.0 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
Section 10.1.3.2, “Server Character Set and Collation”
Section 5.1.4, “Server Command Options”

--character-sets-dir

Section B.5.2.16, “Can't initialize character set”
Section 10.5, “Character Set Configuration”
Section 4.6.4.3, “myisamchk Repair Options”
Section 4.6.6, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.5.1.1, “mysql Options”
Section 4.4.5, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”
Section 4.5.8, “mysqlshow — Display Database, Table, and Column Information”
Section 5.1.4, “Server Command Options”

--character_set_server

Section 2.8.4, “MySQL Source-Configuration Options”

--charset

Section 4.4.1, “comp_err — Compile MySQL Error Message File”

--check

Section 4.6.4.2, “myisamchk Check Options”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”

--check-only-changed

Section 4.6.4.2, “myisamchk Check Options”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”

--check-upgrade

Section 4.5.3, “mysqlcheck — A Table Maintenance Program”

--chroot

Section 5.1.4, “Server Command Options”

--classic

Section 19.2.2.1, “MySQL Shell Sessions Explained”
Section 4.5.7, “mysqlsh — The MySQL Shell”

CMAKE_BUILD_TYPE

Section 2.8.4, “MySQL Source-Configuration Options”

CMAKE_C_FLAGS

Section 28.5.1.1, “Compiling MySQL for Debugging”
Section 2.8.5, “Dealing with Problems Compiling MySQL”
Section 2.8.4, “MySQL Source-Configuration Options”

CMAKE_C_FLAGS_build_type

Section 2.8.4, “MySQL Source-Configuration Options”

CMAKE_C_FLAGS_RELWITHDEBINFO

Section 2.8.4, “MySQL Source-Configuration Options”

CMAKE_CXX_FLAGS

Section 28.5.1.1, “Compiling MySQL for Debugging”
Section 2.8.5, “Dealing with Problems Compiling MySQL”
Section 2.8.4, “MySQL Source-Configuration Options”

CMAKE_CXX_FLAGS_build_type

Section 2.8.4, “MySQL Source-Configuration Options”

CMAKE_CXX_FLAGS_RELWITHDEBINFO

Section 2.8.4, “MySQL Source-Configuration Options”

CMAKE_INSTALL_PREFIX

Section 28.2.4.3, “Compiling and Installing Plugin Libraries”
Section 2.8.3, “Installing MySQL Using a Development Source Tree”
Section 6.5.4.6, “Keyring System Variables”
Section 2.8.4, “MySQL Source-Configuration Options”
Section 5.7.3, “Running Multiple MySQL Instances on Unix”
Section 5.1.5, “Server System Variables”

CMAKE_PREFIX_PATH

Section 2.8.4, “MySQL Source-Configuration Options”

--collation-server

Section 10.5, “Character Set Configuration”
Section 10.1.5, “Configuring Application Character Set and Collation”
Section 10.1.3.2, “Server Character Set and Collation”
Section 5.1.4, “Server Command Options”

--collation_server

Section 2.8.4, “MySQL Source-Configuration Options”

--column-names

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

--column-statistics

Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”

--column-type-info

Section 8.2.1.16, “LIMIT Query Optimization”
Section 4.5.1.1, “mysql Options”

--columns

Section 4.5.5, “mysqlimport — A Data Import Program”

--comments

Section 4.5.1.1, “mysql Options”
Section 4.5.4, “mysqldump — A Database Backup Program”

--commit

Section 4.5.9, “mysqlslap — Load Emulation Client”

--compact

Section 4.5.4, “mysqldump — A Database Backup Program”

--compatible

Section 4.5.4, “mysqldump — A Database Backup Program”

COMPILATION_COMMENT

Section 5.1.5, “Server System Variables”

--complete-insert

Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”

--compress

Section 13.2.7, “LOAD DATA INFILE Syntax”
Section 4.5.1.1, “mysql Options”
Section 4.4.5, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”
Section 4.5.8, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.9, “mysqlslap — Load Emulation Client”

--compress-output

Section 4.5.6, “mysqlpump — A Database Backup Program”

--concurrency

Section 4.5.9, “mysqlslap — Load Emulation Client”

--config-file

Section 4.7.2, “my_print_defaults — Display Options from Option Files”

--connect-expired-password

Section 4.5.1.1, “mysql Options”
Section 6.3.9, “Password Expiration and Sandbox Mode”

--connection-control

Section 6.5.2.1, “Connection-Control Plugin Installation”

--connection-control-failed-login-attempts

Section 6.5.2.1, “Connection-Control Plugin Installation”

--connection-server-id

Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”

--console

Section 15.16.2, “Enabling InnoDB Monitors”
Section 2.9.1.1, “Initializing the Data Directory Manually Using mysqld”
Section 15.20, “InnoDB Troubleshooting”
Section B.5.3.2.1, “Resetting the Root Password: Windows Systems”
Section 5.1.4, “Server Command Options”
Section 2.3.5.6, “Starting MySQL from the Windows Command Line”
Section 2.3.5.5, “Starting the Server for the First Time”
Section 5.4.2, “The Error Log”

--core-file

Section 28.5.1.4, “Debugging mysqld under gdb”
Section 5.1.4, “Server Command Options”
Section 5.1.5, “Server System Variables”

core-file

Section 28.5.1.3, “Using WER with PDB to create a Windows crashdump”

--core-file-size

Section 2.5.9, “Managing MySQL Server with systemd”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 5.1.4, “Server Command Options”

--correct-checksum

Section 4.6.4.3, “myisamchk Repair Options”

--count

Section 4.6.2, “innochecksum — Offline InnoDB File Checksum Utility”
Section 4.6.3, “myisam_ftdump — Display Full-Text Index information”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.8, “mysqlshow — Display Database, Table, and Column Information”

--create

Section 4.5.9, “mysqlslap — Load Emulation Client”

--create-options

Section 4.5.4, “mysqldump — A Database Backup Program”

--create-schema

Section 4.5.9, “mysqlslap — Load Emulation Client”

--csv

Section 4.5.9, “mysqlslap — Load Emulation Client”

--cxxflags

Section 2.8.5, “Dealing with Problems Compiling MySQL”
Section 4.7.1, “mysql_config — Display Options for Compiling Clients”

D

[index top]

-D

Section 10.3, “Adding a Character Set”
Section 6.4.5, “Building MySQL with Support for Encrypted Connections”
Section B.5.2.16, “Can't initialize character set”
Section 4.4.1, “comp_err — Compile MySQL Error Message File”
Section 28.5.1.1, “Compiling MySQL for Debugging”
Section 19.2.1.2, “Connecting using Individual Parameters”
Section 28.5.2, “Debugging a MySQL Client”
Section 4.6.2, “innochecksum — Offline InnoDB File Checksum Utility”
Section 2.8.2, “Installing MySQL Using a Standard Source Distribution”
Section 4.8.1, “lz4_decompress — Decompress mysqlpump LZ4-Compressed Output”
Section 2.5.9, “Managing MySQL Server with systemd”
Section 17.2.2.1, “memcached Command-Line Options”
Section 4.6.4.3, “myisamchk Repair Options”
Section A.2, “MySQL 8.0 FAQ: Storage Engines”
Section 4.5.1.1, “mysql Options”
Section 2.8.4, “MySQL Source-Configuration Options”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.7, “mysqlsh — The MySQL Shell”
Section 18.1.6.3, “Replication Slave Options and Variables”
Section 5.1.4, “Server Command Options”
Section 5.1.5, “Server System Variables”
Section 15.19.3, “Setting Up the InnoDB memcached Plugin”
Section 16.5, “The ARCHIVE Storage Engine”
Section 16.6, “The BLACKHOLE Storage Engine”
Section 16.9, “The EXAMPLE Storage Engine”
Section 16.8, “The FEDERATED Storage Engine”
Section B.5.3.3, “What to Do If MySQL Keeps Crashing”
Section 2.1.1, “Which MySQL Version and Distribution to Install”
Section 4.8.4, “zlib_decompress — Decompress mysqlpump ZLIB-Compressed Output”

-d

Section 4.6.1, “ibd2sdi — InnoDB Tablespace SDI Extraction Utility”
Section 17.2.2.1, “memcached Command-Line Options”
Section 4.6.3, “myisam_ftdump — Display Full-Text Index information”
Section 4.6.4.1, “myisamchk General Options”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.6.9, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.5.6, “mysqlpump — A Database Backup Program”
Section 4.6.4.4, “Other myisamchk Options”
Section 5.1.5, “Server System Variables”

--daemonize

Section 5.1.4, “Server Command Options”

--data-file-length

Section 4.6.4.3, “myisamchk Repair Options”

--database

Section 19.2.1.2, “Connecting using Individual Parameters”
Section 4.5.1.1, “mysql Options”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.7, “mysqlsh — The MySQL Shell”

--databases

Section 7.4.5.2, “Copy a Database from one Server to Another”
Section 18.1.2.5.1, “Creating a Data Snapshot Using mysqldump”
Section 7.4.1, “Dumping Data in SQL Format with mysqldump”
Section 7.4.5.1, “Making a Copy of a Database”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”
Section 2.10.3, “Rebuilding or Repairing Tables or Indexes”
Section 7.4.2, “Reloading SQL-Format Backups”

--datadir

Section 2.3.5.2, “Creating an Option File”
Section 2.9.1.1, “Initializing the Data Directory Manually Using mysqld”
Section 2.8.4, “MySQL Source-Configuration Options”
Section 4.4.3, “mysql_ssl_rsa_setup — Create SSL/RSA Files”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 5.7, “Running Multiple MySQL Instances on One Machine”
Section 5.7.3, “Running Multiple MySQL Instances on Unix”
Section 5.1.4, “Server Command Options”
Section 5.7.1, “Setting Up Multiple Data Directories”
Section 5.2, “The MySQL Data Directory”
Section 2.9.2.1, “Troubleshooting Problems Starting the MySQL Server”
Section 4.2.6, “Using Option Files”

datadir

Section 2.3.5.2, “Creating an Option File”
Section 2.4.1, “General Notes on Installing MySQL on OS X”
Section 4.3.3, “mysql.server — MySQL Server Startup Script”
Section 2.3.6, “Troubleshooting a Microsoft Windows MySQL Server Installation”
Section C.10.5, “Windows Platform Limitations”

--dba

Section 4.5.7, “mysqlsh — The MySQL Shell”

--dbpassword

Section 19.2.1.2, “Connecting using Individual Parameters”
Section 4.5.7, “mysqlsh — The MySQL Shell”

--dbuser

Section 19.2.1.2, “Connecting using Individual Parameters”
Section 4.5.7, “mysqlsh — The MySQL Shell”

--debug

Section 4.4.1, “comp_err — Compile MySQL Error Message File”
Section 28.5.1.1, “Compiling MySQL for Debugging”
Section 4.6.1, “ibd2sdi — InnoDB Tablespace SDI Extraction Utility”
Section 4.7.2, “my_print_defaults — Display Options from Option Files”
Section 4.6.4.1, “myisamchk General Options”
Section 4.6.6, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.5.1.1, “mysql Options”
Section 2.8.4, “MySQL Source-Configuration Options”
Section 4.6.7, “mysql_config_editor — MySQL Configuration Utility”
Section 4.4.5, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.6.9, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”
Section 4.5.8, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.9, “mysqlslap — Load Emulation Client”
Section 5.1.4, “Server Command Options”
Section 5.1.5, “Server System Variables”
Section 2.3.5.6, “Starting MySQL from the Windows Command Line”
Section 28.5.3, “The DBUG Package”
Section 6.2.9, “Troubleshooting Problems Connecting to MySQL”
Section 2.9.2.1, “Troubleshooting Problems Starting the MySQL Server”

debug

Section 14.1, “Data Dictionary Schema”

--debug-check

Section 4.5.1.1, “mysql Options”
Section 4.4.5, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”
Section 4.5.8, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.9, “mysqlslap — Load Emulation Client”

--debug-info

Section 4.4.1, “comp_err — Compile MySQL Error Message File”
Section 4.5.1.1, “mysql Options”
Section 4.4.5, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”
Section 4.5.8, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.9, “mysqlslap — Load Emulation Client”

--debug-sync-timeout

Section 2.8.4, “MySQL Source-Configuration Options”
Section 5.1.4, “Server Command Options”
Section 5.1.5, “Server System Variables”

--default-auth

Section 27.7.13, “C API Client Plugin Functions”
Section 28.2.4.2.3, “Client Plugin Descriptors”
Section 4.5.1.1, “mysql Options”
Section 4.4.5, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”
Section 4.5.8, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.9, “mysqlslap — Load Emulation Client”
Section 6.5.1.1, “Native Pluggable Authentication”
Section 6.3.10, “Pluggable Authentication”
Section 28.2.4.9.3, “Using the Authentication Plugins”

--default-character-set

Section 10.5, “Character Set Configuration”
Section 10.1.5, “Configuring Application Character Set and Collation”
Section 10.1.4, “Connection Character Sets and Collations”
Section 4.5.1.5, “Executing SQL Statements from a Text File”
Section 13.2.7, “LOAD DATA INFILE Syntax”
Section 4.5.1.1, “mysql Options”
Section 4.4.5, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”
Section 4.5.8, “mysqlshow — Display Database, Table, and Column Information”
Section 5.1.5, “Server System Variables”
Section 4.5.1.6.2, “Unicode Support on Windows”
Section 6.3.1, “User Names and Passwords”

--default-parallelism

Section 4.5.6, “mysqlpump — A Database Backup Program”

--default-storage-engine

Section 15.13, “InnoDB Startup Options and System Variables”
Section 5.1.4, “Server Command Options”
Section 16.1, “Setting the Storage Engine”

default-storage-engine

Section 16.1, “Setting the Storage Engine”

--default-time-zone

Section 10.6, “MySQL Server Time Zone Support”
Section 5.1.4, “Server Command Options”
Section 5.1.5, “Server System Variables”

--default-tmp-storage-engine

Section 15.13, “InnoDB Startup Options and System Variables”
Section 5.1.4, “Server Command Options”

--default.key_buffer_size

Section 5.1.6.1, “Structured System Variables”

DEFAULT_CHARSET

Section 10.1.5, “Configuring Application Character Set and Collation”
Section 10.1.3.2, “Server Character Set and Collation”

DEFAULT_COLLATION

Section 10.1.5, “Configuring Application Character Set and Collation”
Section 10.1.3.2, “Server Character Set and Collation”

--defaults-extra-file

Section 4.2.7, “Command-Line Options that Affect Option-File Handling”
Section 2.9.1.1, “Initializing the Data Directory Manually Using mysqld”
Section 4.7.2, “my_print_defaults — Display Options from Option Files”
Section 4.6.4.1, “myisamchk General Options”
Section 4.5.1.1, “mysql Options”
Section 4.4.2, “mysql_secure_installation — Improve MySQL Installation Security”
Section 4.4.5, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”
Section 4.5.8, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.9, “mysqlslap — Load Emulation Client”
Section 25.11.13.2, “Performance Schema variables_info Table”
Section 5.1.4, “Server Command Options”
Section 4.2.6, “Using Option Files”

--defaults-file

Section 4.2.7, “Command-Line Options that Affect Option-File Handling”
Section 6.1.2.1, “End-User Guidelines for Password Security”
Section 2.9.1.1, “Initializing the Data Directory Manually Using mysqld”
Section 15.6.1, “InnoDB Startup Configuration”
Section 4.7.2, “my_print_defaults — Display Options from Option Files”
Section 4.6.4.1, “myisamchk General Options”
Section 4.5.1.1, “mysql Options”
Section 2.8.4, “MySQL Source-Configuration Options”
Section 4.4.2, “mysql_secure_installation — Improve MySQL Installation Security”
Section 4.4.5, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”
Section 4.5.8, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.9, “mysqlslap — Load Emulation Client”
Section 25.11.13.2, “Performance Schema variables_info Table”
Section B.5.3.2.2, “Resetting the Root Password: Unix and Unix-Like Systems”
Section B.5.3.2.1, “Resetting the Root Password: Windows Systems”
Section 5.7, “Running Multiple MySQL Instances on One Machine”
Section 5.7.3, “Running Multiple MySQL Instances on Unix”
Section 5.1.4, “Server Command Options”
Section 5.7.2.2, “Starting Multiple MySQL Instances as Windows Services”
Section 5.7.2.1, “Starting Multiple MySQL Instances at the Windows Command Line”
Section 2.3.5.8, “Starting MySQL as a Windows Service”

--defaults-group-suffix

Section 4.2.7, “Command-Line Options that Affect Option-File Handling”
Section 4.7.2, “my_print_defaults — Display Options from Option Files”
Section 4.6.4.1, “myisamchk General Options”
Section 4.5.1.1, “mysql Options”
Section 4.9, “MySQL Program Environment Variables”
Section 4.4.2, “mysql_secure_installation — Improve MySQL Installation Security”
Section 4.4.5, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”
Section 4.5.8, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.9, “mysqlslap — Load Emulation Client”
Section 5.1.4, “Server Command Options”

--defer-table-indexes

Section 4.5.6, “mysqlpump — A Database Backup Program”

--delay-key-write

Section 8.11.5, “External Locking”
Section 16.2.1, “MyISAM Startup Options”
Section A.13, “MySQL 8.0 FAQ: Replication”
Section 5.1.4, “Server Command Options”
Section B.5.3.3, “What to Do If MySQL Keeps Crashing”

--delay_key_write

Section 5.1.6, “Using System Variables”

--delete

Section 4.5.5, “mysqlimport — A Data Import Program”

--delete-master-logs

Section 4.5.4, “mysqldump — A Database Backup Program”

--delimiter

Section 4.5.1.1, “mysql Options”
Section 4.5.9, “mysqlslap — Load Emulation Client”

--demangle

Section 28.5.1.5, “Using a Stack Trace”

--des-key-file

Section 5.1.4, “Server Command Options”
Section 1.4, “What Is New in MySQL 8.0”

--description

Section 4.6.4.4, “Other myisamchk Options”

--detach

Section 4.5.9, “mysqlslap — Load Emulation Client”

--disable

Section 4.2.5, “Program Option Modifiers”

--disable-auto-rehash

Section 15.6.11.2, “Configuring Non-Persistent Optimizer Statistics Parameters”
Section 4.5.1.1, “mysql Options”

--disable-keys

Section 4.5.4, “mysqldump — A Database Backup Program”

--disable-log-bin

Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”

--disable-named-commands

Section 4.5.1.1, “mysql Options”

--disable-plugin_name

Section 5.6.1, “Installing and Uninstalling Plugins”

--disable-ssl

Section 6.4.2, “Command Options for Encrypted Connections”
Section 1.4, “What Is New in MySQL 8.0”

--disconnect-slave-event-count

Section 18.1.6.3, “Replication Slave Options and Variables”

--dump

Section 4.6.3, “myisam_ftdump — Display Full-Text Index information”

--dump-date

Section 4.5.4, “mysqldump — A Database Backup Program”

--dump-file

Section 4.6.1, “ibd2sdi — InnoDB Tablespace SDI Extraction Utility”

--dump-slave

Section 4.5.4, “mysqldump — A Database Backup Program”
Section 18.4.1.34, “Replication and Transaction Inconsistencies”

E

[index top]

-E

Section 4.5.1.1, “mysql Options”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.7, “mysqlsh — The MySQL Shell”

-e

Section 7.6.2, “How to Check MyISAM Tables for Errors”
Section 4.6.2, “innochecksum — Offline InnoDB File Checksum Utility”
Section 13.2.8, “LOAD XML Syntax”
Section 4.7.2, “my_print_defaults — Display Options from Option Files”
Section 4.6.4.2, “myisamchk Check Options”
Section 4.6.4.1, “myisamchk General Options”
Section 4.6.4.3, “myisamchk Repair Options”
Section 4.5.1.1, “mysql Options”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.7, “mysqlsh — The MySQL Shell”
Section 4.5.9, “mysqlslap — Load Emulation Client”
Section 4.6.4.5, “Obtaining Table Information with myisamchk”
Section 4.2.4, “Using Options on the Command Line”

--early-plugin-load

Section 15.7.10, “InnoDB Tablespace Encryption”
Section 5.6.1, “Installing and Uninstalling Plugins”
Section 6.5.4.1, “Keyring Plugin Installation”
Section 5.1.4, “Server Command Options”
Section 2.10.1, “Upgrading MySQL”
Section 6.5.4.2, “Using the keyring_file File-Based Plugin”
Section 28.2.4.12, “Writing Keyring Plugins”

early-plugin-load

Section 15.7.10, “InnoDB Tablespace Encryption”

--embedded

Section 1.4, “What Is New in MySQL 8.0”

--embedded-libs

Section 1.4, “What Is New in MySQL 8.0”

--embedded-server

Section 1.4, “What Is New in MySQL 8.0”

--enable-64bit

Section 17.2.1, “Installing memcached

--enable-cleartext-plugin

Section 6.5.1.3, “Client-Side Cleartext Pluggable Authentication”
Section 4.5.1.1, “mysql Options”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.8, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.9, “mysqlslap — Load Emulation Client”

--enable-dtrace

Section 17.2.1, “Installing memcached
Section 17.2.2.6, “Using memcached and DTrace”

--enable-memcache

Section 17.2.3.6, “Using MySQL and memcached with PHP”

--enable-named-pipe

Section B.5.2.2, “Can't connect to [local] MySQL server”
Section 4.2.2, “Connecting to the MySQL Server”
Section 2.3.5.3, “Selecting a MySQL Server Type”
Section 5.1.4, “Server Command Options”
Section 1.3.2, “The Main Features of MySQL”

--enable-plugin_name

Section 5.6.1, “Installing and Uninstalling Plugins”

--enable-ssl

Section 1.4, “What Is New in MySQL 8.0”

--enable-threads

Section 17.2.1, “Installing memcached

ENABLE_DEBUG_SYNC

Section 2.8.4, “MySQL Source-Configuration Options”

enabled

Section 2.5.1, “Installing MySQL on Linux Using the MySQL Yum Repository”
Section 20.3.1.2, “Installing MySQL Shell on Linux”

ENABLED_LOCAL_INFILE

Section 2.8.4, “MySQL Source-Configuration Options”
Section 6.1.6, “Security Issues with LOAD DATA LOCAL”

--end-page

Section 4.6.2, “innochecksum — Offline InnoDB File Checksum Utility”

--enforce-gtid-consistency

Section 18.1.6.5, “Global Transaction ID Options and Variables”
Section 18.1.3.4, “Restrictions on Replication with GTIDs”

enforce-gtid-consistency

Section 18.1.6.5, “Global Transaction ID Options and Variables”

--engine

Section 4.5.9, “mysqlslap — Load Emulation Client”

--event-scheduler

Section 23.4.2, “Event Scheduler Configuration”
Section 5.1.4, “Server Command Options”

event-scheduler

Section 23.4.2, “Event Scheduler Configuration”

--events

Section 14.6, “Data Dictionary Usage Differences”
Section 7.4.5.3, “Dumping Stored Programs”
Section 7.4.5.4, “Dumping Table Definitions and Content Separately”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”
Section 2.10.1, “Upgrading MySQL”
Section 4.6.8.3, “Using mysqlbinlog to Back Up Binary Log Files”

--example

Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”

--exclude-databases

Section 4.5.6, “mysqlpump — A Database Backup Program”

--exclude-events

Section 4.5.6, “mysqlpump — A Database Backup Program”

--exclude-gtids

Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”

--exclude-routines

Section 4.5.6, “mysqlpump — A Database Backup Program”

--exclude-tables

Section 4.5.6, “mysqlpump — A Database Backup Program”

--exclude-triggers

Section 4.5.6, “mysqlpump — A Database Backup Program”

--exclude-users

Section 4.5.6, “mysqlpump — A Database Backup Program”

--execute

Section 4.5.1.3, “mysql Logging”
Section 4.5.1.1, “mysql Options”
Section 4.5.7, “mysqlsh — The MySQL Shell”
Section 4.2.4, “Using Options on the Command Line”

--executed-gtids-compression-period

Section 18.1.6.5, “Global Transaction ID Options and Variables”

--exit-info

Section 5.1.4, “Server Command Options”

--extend-check

Section 4.6.4.2, “myisamchk Check Options”
Section 4.6.4.1, “myisamchk General Options”
Section 4.6.4.3, “myisamchk Repair Options”

--extended

Section 4.5.3, “mysqlcheck — A Table Maintenance Program”

--extended-insert

Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”

--external-locking

Section 8.11.5, “External Locking”
Section 16.2.1, “MyISAM Startup Options”
Section 5.1.4, “Server Command Options”
Section 5.1.5, “Server System Variables”

--extra-file

Section 4.7.2, “my_print_defaults — Display Options from Option Files”

F

[index top]

-F

Section 4.4.1, “comp_err — Compile MySQL Error Message File”
Section 4.6.4.2, “myisamchk Check Options”
Section 4.5.1.2, “mysql Commands”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.9, “mysqlslap — Load Emulation Client”

-f

Section 17.2.2.1, “memcached Command-Line Options”
Section 4.6.4.2, “myisamchk Check Options”
Section 4.6.4.3, “myisamchk Repair Options”
Section 4.6.5, “myisamlog — Display MyISAM Log File Contents”
Section 4.6.6, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.5.1.1, “mysql Options”
Section 2.8.4, “MySQL Source-Configuration Options”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 28.5.1.5, “Using a Stack Trace”

--fast

Section 4.6.4.2, “myisamchk Check Options”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”

--federated

Section 16.8, “The FEDERATED Storage Engine”

--fields-enclosed-by

Section 7.4.3, “Dumping Data in Delimited-Text Format with mysqldump”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”

--fields-escaped-by

Section 7.4.3, “Dumping Data in Delimited-Text Format with mysqldump”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”

--fields-optionally-enclosed-by

Section 7.4.3, “Dumping Data in Delimited-Text Format with mysqldump”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”

--fields-terminated-by

Section 7.4.3, “Dumping Data in Delimited-Text Format with mysqldump”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”

--fields-xxx

Section 4.5.4, “mysqldump — A Database Backup Program”

--file

Section 19.3.2, “Batch Code Execution”
Section 4.5.7, “mysqlsh — The MySQL Shell”

--fix-db-names

Section 1.4, “What Is New in MySQL 8.0”

--fix-table-names

Section 1.4, “What Is New in MySQL 8.0”

--flush

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

--flush-logs

Section 7.3.1, “Establishing a Backup Policy”
Section 5.4, “MySQL Server Logs”
Section 4.5.4, “mysqldump — A Database Backup Program”

--flush-privileges

Section 4.5.4, “mysqldump — A Database Backup Program”

--flush_time

Section 28.1.1, “MySQL Threads”

--force

Section 4.6.4.2, “myisamchk Check Options”
Section 4.6.4.3, “myisamchk Repair Options”
Section 4.6.6, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.5.1.1, “mysql Options”
Section 4.4.5, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.7, “mysqlsh — The MySQL Shell”
Section 28.1.2, “The MySQL Test Suite”
Section 2.10.1, “Upgrading MySQL”
Section 3.5, “Using mysql in Batch Mode”

--force-if-open

Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”

--force-read

Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”

G

[index top]

-G

Section 4.5.1.1, “mysql Options”
Section 4.6.7, “mysql_config_editor — MySQL Configuration Utility”

-g

Section 28.5.1.1, “Compiling MySQL for Debugging”
Section 4.7.2, “my_print_defaults — Display Options from Option Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.6.9, “mysqldumpslow — Summarize Slow Query Log Files”

--gdb

Section 28.5.1.4, “Debugging mysqld under gdb”
Section 5.1.4, “Server Command Options”

--general-log

Section 5.1.4, “Server Command Options”

--general_log

Section 5.4.1, “Selecting General Query and Slow Query Log Output Destinations”
Section 5.1.4, “Server Command Options”
Section 5.1.5, “Server System Variables”
Section 5.4.3, “The General Query Log”

--general_log_file

Section 5.7, “Running Multiple MySQL Instances on One Machine”
Section 5.1.4, “Server Command Options”
Section 5.1.5, “Server System Variables”
Section 5.4.3, “The General Query Log”

--gtid-executed-compression-period

Section 18.1.6.5, “Global Transaction ID Options and Variables”

--gtid-mode

Section 18.1.6.5, “Global Transaction ID Options and Variables”
Section 4.4.5, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 18.1.6.3, “Replication Slave Options and Variables”
Section 18.1.3.4, “Restrictions on Replication with GTIDs”
Section 2.10.1, “Upgrading MySQL”

H

[index top]

-H

Section 4.4.1, “comp_err — Compile MySQL Error Message File”
Section 4.6.4.1, “myisamchk General Options”
Section 4.5.1.1, “mysql Options”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”

-h

Section 4.2.2, “Connecting to the MySQL Server”
Section 19.2.1.2, “Connecting using Individual Parameters”
Section 4.6.1, “ibd2sdi — InnoDB Tablespace SDI Extraction Utility”
Section 4.2.1, “Invoking MySQL Programs”
Section 17.2.2.1, “memcached Command-Line Options”
Section 4.6.3, “myisam_ftdump — Display Full-Text Index information”
Section 4.5.1.1, “mysql Options”
Section 4.6.7, “mysql_config_editor — MySQL Configuration Utility”
Section 4.4.2, “mysql_secure_installation — Improve MySQL Installation Security”
Section 4.4.5, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.6.9, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”
Section 4.5.7, “mysqlsh — The MySQL Shell”
Section 4.5.8, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.9, “mysqlslap — Load Emulation Client”
Section 4.7.3, “resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols”
Section 5.1.4, “Server Command Options”
Section 1.2, “Typographical and Syntax Conventions”
Section 4.2.4, “Using Options on the Command Line”

HAVE_CRYPT

Section 1.4, “What Is New in MySQL 8.0”

--header_file

Section 4.4.1, “comp_err — Compile MySQL Error Message File”

--HELP

Section 4.6.4.1, “myisamchk General Options”

--help

Section 4.4.1, “comp_err — Compile MySQL Error Message File”
Section 4.6.1, “ibd2sdi — InnoDB Tablespace SDI Extraction Utility”
Section 4.6.2, “innochecksum — Offline InnoDB File Checksum Utility”
Section 4.7.2, “my_print_defaults — Display Options from Option Files”
Section 4.6.3, “myisam_ftdump — Display Full-Text Index information”
Section 4.6.4.1, “myisamchk General Options”
Section 4.6.6, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.5.1.1, “mysql Options”
Section 4.6.7, “mysql_config_editor — MySQL Configuration Utility”
Section 4.4.2, “mysql_secure_installation — Improve MySQL Installation Security”
Section 4.4.3, “mysql_ssl_rsa_setup — Create SSL/RSA Files”
Section 4.4.5, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.6.9, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”
Section 4.5.7, “mysqlsh — The MySQL Shell”
Section 4.5.8, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.9, “mysqlslap — Load Emulation Client”
Section 4.1, “Overview of MySQL Programs”
Section 4.8.2, “perror — Explain Error Codes”
Section 4.7.3, “resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols”
Section 4.8.3, “resolveip — Resolve Host name to IP Address or Vice Versa”
Section 5.1.4, “Server Command Options”
Section 2.9.3, “Testing the Server”
Section 1.3.2, “The Main Features of MySQL”
Section 2.9.2.1, “Troubleshooting Problems Starting the MySQL Server”
Chapter 3, Tutorial
Section 4.2.6, “Using Option Files”
Section 4.2.4, “Using Options on the Command Line”

--hex-blob

Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”

--hexdump

Section 4.6.8.1, “mysqlbinlog Hex Dump Format”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”

--histignore

Section 4.5.1.3, “mysql Logging”
Section 4.5.1.1, “mysql Options”

--host

Section 5.1.9.2, “Configuring the MySQL Server to Permit IPv6 Connections”
Section 4.2.2, “Connecting to the MySQL Server”
Section 19.2.1.2, “Connecting using Individual Parameters”
Section 4.2.1, “Invoking MySQL Programs”
Section 4.5.1.1, “mysql Options”
Section 19.2.1, “MySQL Shell Connections”
Section 4.6.7, “mysql_config_editor — MySQL Configuration Utility”
Section 4.4.2, “mysql_secure_installation — Improve MySQL Installation Security”
Section 4.4.5, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”
Section 4.5.7, “mysqlsh — The MySQL Shell”
Section 4.5.8, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.9, “mysqlslap — Load Emulation Client”
Section 4.2.9, “Option Defaults, Options Expecting Values, and the = Sign”
Section 5.1.4, “Server Command Options”
Section 6.2.9, “Troubleshooting Problems Connecting to MySQL”
Section 1.2, “Typographical and Syntax Conventions”
Section 5.7.4, “Using Client Programs in a Multiple-Server Environment”
Section 4.6.8.3, “Using mysqlbinlog to Back Up Binary Log Files”
Section 4.2.6, “Using Option Files”
Section 4.2.4, “Using Options on the Command Line”

host

Section 4.6.7, “mysql_config_editor — MySQL Configuration Utility”
Section 4.2.6, “Using Option Files”

--html

Section 4.5.1.1, “mysql Options”

I

[index top]

-I

Section 27.7.4.1, “Building C API Client Programs”
Section 4.6.2, “innochecksum — Offline InnoDB File Checksum Utility”
Section 17.2.2.1, “memcached Command-Line Options”
Section 17.2.5, “memcached FAQ”
Section 4.6.5, “myisamlog — Display MyISAM Log File Contents”
Section 4.8.2, “perror — Explain Error Codes”
Section 4.8.3, “resolveip — Resolve Host name to IP Address or Vice Versa”
Section 5.1.4, “Server Command Options”

-i

Section 19.3.5, “Batch Mode Made Interactive”
Section 7.6.2, “How to Check MyISAM Tables for Errors”
Section 4.6.1, “ibd2sdi — InnoDB Tablespace SDI Extraction Utility”
Section 17.2.2.1, “memcached Command-Line Options”
Section 4.6.4.2, “myisamchk Check Options”
Section 4.6.5, “myisamlog — Display MyISAM Log File Contents”
Section 4.5.1.1, “mysql Options”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.6.9, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.8, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.9, “mysqlslap — Load Emulation Client”

--i-am-a-dummy

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

--id

Section 4.6.1, “ibd2sdi — InnoDB Tablespace SDI Extraction Utility”

--idempotent

Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 5.1.5, “Server System Variables”

--ignore

Section 4.5.5, “mysqlimport — A Data Import Program”

--ignore-builtin-innodb

Section 15.13, “InnoDB Startup Options and System Variables”
Section 1.4, “What Is New in MySQL 8.0”

--ignore-db-dir

Section 2.10.1, “Upgrading MySQL”
Section 1.4, “What Is New in MySQL 8.0”

--ignore-error

Section 4.5.4, “mysqldump — A Database Backup Program”

--ignore-lines

Section 4.5.5, “mysqlimport — A Data Import Program”

--ignore-spaces

Section 4.5.1.1, “mysql Options”

--ignore-table

Section 18.1.2.5.1, “Creating a Data Snapshot Using mysqldump”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 2.10.1, “Upgrading MySQL”

--in_file

Section 4.4.1, “comp_err — Compile MySQL Error Message File”

--include

Section 4.7.1, “mysql_config — Display Options for Compiling Clients”

--include-databases

Section 4.5.6, “mysqlpump — A Database Backup Program”

--include-events

Section 4.5.6, “mysqlpump — A Database Backup Program”

--include-gtids

Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”

--include-master-host-port

Section 4.5.4, “mysqldump — A Database Backup Program”

--include-routines

Section 4.5.6, “mysqlpump — A Database Backup Program”

--include-tables

Section 4.5.6, “mysqlpump — A Database Backup Program”

--include-triggers

Section 4.5.6, “mysqlpump — A Database Backup Program”

--include-users

Section 4.5.6, “mysqlpump — A Database Backup Program”

--info

Section 4.6.2, “innochecksum — Offline InnoDB File Checksum Utility”
Section 4.8.2, “perror — Explain Error Codes”
Section 4.8.3, “resolveip — Resolve Host name to IP Address or Vice Versa”

--information

Section 4.6.4.2, “myisamchk Check Options”

--init-command

Section 4.5.1.1, “mysql Options”
Section 18.4.1.29, “Replication of Server-Side Help Tables”

--init-file

Section 2.9.1.1, “Initializing the Data Directory Manually Using mysqld”
Section 25.4, “Performance Schema Runtime Configuration”
Section 25.11.13.2, “Performance Schema variables_info Table”
Section B.5.3.2.2, “Resetting the Root Password: Unix and Unix-Like Systems”
Section B.5.3.2.1, “Resetting the Root Password: Windows Systems”
Section 5.1.4, “Server Command Options”
Section 5.1.5, “Server System Variables”
Section 16.3, “The MEMORY Storage Engine”

--init_connect

Section 10.1.5, “Configuring Application Character Set and Collation”

--initialize

Section 2.3.5.2, “Creating an Option File”
Section 2.9.1.1, “Initializing the Data Directory Manually Using mysqld”
Chapter 26, MySQL sys Schema
Section 5.1.4, “Server Command Options”
Section 5.1.5, “Server System Variables”
Section 1.4, “What Is New in MySQL 8.0”

--initialize-insecure

Section 2.3.5.2, “Creating an Option File”
Section 2.9.1.1, “Initializing the Data Directory Manually Using mysqld”
Chapter 26, MySQL sys Schema
Section 5.1.4, “Server Command Options”
Section 5.1.5, “Server System Variables”
Section 1.4, “What Is New in MySQL 8.0”

--innodb

Section 15.13, “InnoDB Startup Options and System Variables”

--innodb-status-file

Section 15.13, “InnoDB Startup Options and System Variables”

innodb-status-file

Section 15.16.2, “Enabling InnoDB Monitors”

--innodb-xxx

Section 5.1.4, “Server Command Options”

--innodb_adaptive_hash_index

Section 15.13, “InnoDB Startup Options and System Variables”

--innodb_file_per_table

Section 15.7.4.1, “Enabling and Disabling File-Per-Table Tablespaces”
Section 5.1.4, “Server Command Options”

innodb_file_per_table

Section 18.1.2.5.2, “Creating a Data Snapshot Using Raw Data Files”
Section 5.1.4, “Server Command Options”

--innodb_rollback_on_timeout

Section 15.20.4, “InnoDB Error Handling”
Section 15.13, “InnoDB Startup Options and System Variables”

--insert-ignore

Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”

--install

Section 4.2.7, “Command-Line Options that Affect Option-File Handling”
Section 5.1.4, “Server Command Options”
Section 5.7.2.2, “Starting Multiple MySQL Instances as Windows Services”
Section 2.3.5.8, “Starting MySQL as a Windows Service”

--install-manual

Section 5.1.4, “Server Command Options”
Section 5.7.2.2, “Starting Multiple MySQL Instances as Windows Services”
Section 2.3.5.8, “Starting MySQL as a Windows Service”

INSTALL_LAYOUT

Section 6.5.4.6, “Keyring System Variables”
Section 2.8.4, “MySQL Source-Configuration Options”
Section 5.1.5, “Server System Variables”

INSTALL_LIBDIR

Section 2.8.4, “MySQL Source-Configuration Options”

INSTALL_MYSQLKEYRINGDIR

Section 6.5.4.6, “Keyring System Variables”

INSTALL_PKGCONFIGDIR

Section 27.7.4.2, “Building C API Client Programs Using pkg-config”

INSTALL_SCRIPTDIR

Section 1.4, “What Is New in MySQL 8.0”

INSTALL_SECURE_FILE_PRIV_EMBEDDEDDIR

Section 1.4, “What Is New in MySQL 8.0”

INSTALL_SECURE_FILE_PRIVDIR

Section 5.1.5, “Server System Variables”

--interactive

Section 19.3.5, “Batch Mode Made Interactive”
Section 19.1, “MySQL Shell Features”
Section 4.5.7, “mysqlsh — The MySQL Shell”

--iterations

Section 4.5.9, “mysqlslap — Load Emulation Client”

J

[index top]

-j

Section 4.6.6, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.5.1.1, “mysql Options”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”

--join

Section 4.6.6, “myisampack — Generate Compressed, Read-Only MyISAM Tables”

--js

Section 19.3.4, “Active Language”
Section 4.5.7, “mysqlsh — The MySQL Shell”

--json

Section 19.3.3.3, “JSON Format Output”
Section 4.5.7, “mysqlsh — The MySQL Shell”

K

[index top]

-K

Section 4.5.4, “mysqldump — A Database Backup Program”

-k

Section 17.2.2.1, “memcached Command-Line Options”
Section 4.6.4.3, “myisamchk Repair Options”
Section 4.4.5, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.8, “mysqlshow — Display Database, Table, and Column Information”

--keep_files_on_create

Section 13.1.16, “CREATE TABLE Syntax”

--keys

Section 4.5.8, “mysqlshow — Display Database, Table, and Column Information”

--keys-used

Section 4.6.4.3, “myisamchk Repair Options”

L

[index top]

-L

Section 27.7.4.1, “Building C API Client Programs”
Section 17.2.2.1, “memcached Command-Line Options”
Section 4.5.1.1, “mysql Options”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 2.11.3, “Problems Using the Perl DBI/DBD Interface”

-l

Section 27.7.4.1, “Building C API Client Programs”
Section 4.6.2, “innochecksum — Offline InnoDB File Checksum Utility”
Section 17.2.2.1, “memcached Command-Line Options”
Section 4.7.2, “my_print_defaults — Display Options from Option Files”
Section 4.6.3, “myisam_ftdump — Display Full-Text Index information”
Section 4.6.4.3, “myisamchk Repair Options”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.6.9, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.5.5, “mysqlimport — A Data Import Program”

--language

Section 5.1.4, “Server Command Options”

--large-pages

Section 8.12.3.2, “Enabling Large Page Support”
Section 5.1.4, “Server Command Options”
Section 5.1.5, “Server System Variables”

--lc-messages

Section 5.1.4, “Server Command Options”

--lc-messages-dir

Section 5.1.4, “Server Command Options”

--ledir

Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”

--length

Section 4.6.3, “myisam_ftdump — Display Full-Text Index information”

--libmysqld-libs

Section 1.4, “What Is New in MySQL 8.0”

--libs

Section 4.7.1, “mysql_config — Display Options for Compiling Clients”

--libs_r

Section 4.7.1, “mysql_config — Display Options for Compiling Clients”

--line-numbers

Section 4.5.1.1, “mysql Options”

--lines-terminated-by

Section 7.4.3, “Dumping Data in Delimited-Text Format with mysqldump”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”

LINK_RANDOMIZE

Section 2.8.4, “MySQL Source-Configuration Options”

--local

Section 13.2.7, “LOAD DATA INFILE Syntax”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 6.1.6, “Security Issues with LOAD DATA LOCAL”

--local-infile

Section 13.2.8, “LOAD XML Syntax”
Section 4.5.1.1, “mysql Options”
Section 6.1.6, “Security Issues with LOAD DATA LOCAL”

--local-load

Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”

--local-service

Section 5.1.4, “Server Command Options”
Section 2.3.5.8, “Starting MySQL as a Windows Service”

--lock-all-tables

Section 4.5.4, “mysqldump — A Database Backup Program”

--lock-tables

Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”

--log

Section 4.6.2, “innochecksum — Offline InnoDB File Checksum Utility”
Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”

--log-bin

Section 7.3.3, “Backup Strategy Summary”
Section 23.7, “Binary Logging of Stored Programs”
Section 18.1.6.4, “Binary Logging Options and Variables”
Section 13.4.2.1, “CHANGE MASTER TO Syntax”
Section 7.2, “Database Backup Methods”
Section 7.3.1, “Establishing a Backup Policy”
Section 18.4.5, “How to Report Replication Bugs or Problems”
Section B.5.7, “Known Issues in MySQL”
Section 7.5, “Point-in-Time (Incremental) Recovery Using the Binary Log”
Section 13.4.1.1, “PURGE BINARY LOGS Syntax”
Section 18.1.6.3, “Replication Slave Options and Variables”
Section 5.7, “Running Multiple MySQL Instances on One Machine”
Section 18.3.8, “Switching Masters During Failover”
Section 5.4.4, “The Binary Log”
Section 18.4.4, “Troubleshooting Replication”
Section 18.4.3, “Upgrading a Replication Setup”
Section 7.3.2, “Using Backups for Recovery”

--log-bin-index

Section 18.1.6.4, “Binary Logging Options and Variables”
Section 5.4.4, “The Binary Log”

--log-bin-trust-function-creators

Section 23.7, “Binary Logging of Stored Programs”
Section 18.1.6.4, “Binary Logging Options and Variables”

--log-bin-use-v1-row-events

Section 18.1.6.4, “Binary Logging Options and Variables”

--log-error

Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.2.9, “Option Defaults, Options Expecting Values, and the = Sign”
Section 5.7, “Running Multiple MySQL Instances on One Machine”
Section 5.1.4, “Server Command Options”
Section 5.4.7, “Server Log Maintenance”
Section 2.3.5.6, “Starting MySQL from the Windows Command Line”
Section 2.3.5.5, “Starting the Server for the First Time”
Section 5.4.2, “The Error Log”

--log-error-file

Section 4.5.6, “mysqlpump — A Database Backup Program”

--log-isam

Section 4.6.5, “myisamlog — Display MyISAM Log File Contents”
Section 5.1.4, “Server Command Options”

--log-level

Section 19.5.1, “Application Log”
Section 4.5.7, “mysqlsh — The MySQL Shell”

--log-output

Section 5.4.1, “Selecting General Query and Slow Query Log Output Destinations”
Section 5.1.4, “Server Command Options”
Section 5.4.3, “The General Query Log”
Section 5.4.5, “The Slow Query Log”

--log-queries-not-using-indexes

Section 5.1.4, “Server Command Options”

--log-raw

Section 6.1.2.3, “Passwords and Logging”
Section 5.1.4, “Server Command Options”
Section 5.4.3, “The General Query Log”
Section 28.2.1, “Types of Plugins”

--log-short-format

Section 5.1.4, “Server Command Options”
Section 5.4.5, “The Slow Query Log”

--log-slave-updates

Section 18.4.5, “How to Report Replication Bugs or Problems”
Section 18.3.7, “Improving Replication Performance”
Section 18.1.6.3, “Replication Slave Options and Variables”
Section 18.3.8, “Switching Masters During Failover”
Section 5.4.4, “The Binary Log”

--log-tc

Section 5.1.4, “Server Command Options”

--log-tc-size

Section 5.1.4, “Server Command Options”
Section 5.1.7, “Server Status Variables”

--log-warnings

Section 5.1.4, “Server Command Options”
Section 1.4, “What Is New in MySQL 8.0”

--log_timestamps

Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”

--login-path

Section 4.2.7, “Command-Line Options that Affect Option-File Handling”
Section 4.7.2, “my_print_defaults — Display Options from Option Files”
Section 4.5.1.1, “mysql Options”
Section 4.6.7, “mysql_config_editor — MySQL Configuration Utility”
Section 4.4.5, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”
Section 4.5.8, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.9, “mysqlslap — Load Emulation Client”
Section 4.2.6, “Using Option Files”

--loose

Section 4.2.5, “Program Option Modifiers”

--loose-opt_name

Section 4.2.6, “Using Option Files”

--low-priority

Section 4.5.5, “mysqlimport — A Data Import Program”

--low-priority-updates

Section 8.11.3, “Concurrent Inserts”
Section 13.2.6, “INSERT Syntax”
Section A.13, “MySQL 8.0 FAQ: Replication”
Section 5.1.4, “Server Command Options”
Section 8.11.2, “Table Locking Issues”

--lower-case-table-names

Section 9.2.2, “Identifier Case Sensitivity”

M

[index top]

-M

Section 17.2.2.1, “memcached Command-Line Options”
Section 4.5.4, “mysqldump — A Database Backup Program”

-m

Section 17.2.2.1, “memcached Command-Line Options”
Section 4.6.4.2, “myisamchk Check Options”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”

--malloc-lib

Section 2.5.9, “Managing MySQL Server with systemd”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”

--master-data

Section 18.1.2.5.1, “Creating a Data Snapshot Using mysqldump”
Section 7.3.1, “Establishing a Backup Policy”
Section 5.4, “MySQL Server Logs”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 18.1.3.3, “Using GTIDs for Failover and Scaleout”
Section 4.6.8.3, “Using mysqlbinlog to Back Up Binary Log Files”

--master-info-file

Section 18.1.6.3, “Replication Slave Options and Variables”
Section 18.2.4.2, “Slave Status Logs”

--master-info-repository

Section 13.4.2.1, “CHANGE MASTER TO Syntax”
Section 15.13, “InnoDB Startup Options and System Variables”
Section 18.2.4, “Replication Relay and Status Logs”
Section 18.1.6.3, “Replication Slave Options and Variables”
Section 18.1.2.6.2, “Setting Up Replication with Existing Data”
Section 18.2.4.2, “Slave Status Logs”
Section 18.2.3.3, “Startup Options and Replication Channels”

--master-retry-count

Section 13.4.2.1, “CHANGE MASTER TO Syntax”
Section 18.1.6.3, “Replication Slave Options and Variables”
Section 13.7.5.34, “SHOW SLAVE STATUS Syntax”

--master-verify-checksum

Section 18.1.6.4, “Binary Logging Options and Variables”

--max

Section 4.2.8, “Using Options to Set Program Variables”

--max-allowed-packet

Section 4.4.5, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.6, “mysqlpump — A Database Backup Program”

--max-binlog-dump-events

Section 18.1.6.4, “Binary Logging Options and Variables”

--max-binlog-size

Section 18.1.6.3, “Replication Slave Options and Variables”

--max-record-length

Section 4.6.4.3, “myisamchk Repair Options”
Section 13.7.2.5, “REPAIR TABLE Syntax”

--max-relay-log-size

Section 18.1.6.3, “Replication Slave Options and Variables”
Section 18.2.3.3, “Startup Options and Replication Channels”

--max-seeks-for-key

Section 8.2.1.20, “Avoiding Full Table Scans”
Section B.5.5, “Optimizer-Related Issues”

--max_a

Section 4.2.8, “Using Options to Set Program Variables”

max_allowed_packet

Section 4.5.4, “mysqldump — A Database Backup Program”

--max_join_size

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

--maximum

Section 4.2.5, “Program Option Modifiers”

--maximum-back_log

Section 4.2.5, “Program Option Modifiers”

--maximum-innodb_log_file_size

Section 5.1.6, “Using System Variables”

--maximum-max_heap_table_size

Section 4.2.5, “Program Option Modifiers”

--maximum-var_name

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

--medium-check

Section 4.6.4.2, “myisamchk Check Options”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”

--memlock

Section 5.1.4, “Server Command Options”
Section 5.1.5, “Server System Variables”
Section 15.7.3, “Using Raw Disk Partitions for the System Tablespace”

--min-examined-row-limit

Section 5.1.4, “Server Command Options”

--my-plugin

Section 5.6.1, “Installing and Uninstalling Plugins”

--my_plugin

Section 5.6.1, “Installing and Uninstalling Plugins”

--myisam-block-size

Section 8.10.2.5, “Key Cache Block Size”
Section 5.1.4, “Server Command Options”

--myisam-recover-options

Section 16.2.1, “MyISAM Startup Options”
Section 8.6.1, “Optimizing MyISAM Queries”
Section 5.1.4, “Server Command Options”
Section 5.1.5, “Server System Variables”
Section 7.6.5, “Setting Up a MyISAM Table Maintenance Schedule”
Section B.5.2.18, “Table-Corruption Issues”
Section 16.2, “The MyISAM Storage Engine”
Section 28.5.1.6, “Using Server Logs to Find Causes of Errors in mysqld”

--myisam_sort_buffer_size

Section 4.6.4.6, “myisamchk Memory Usage”

MYSQL_MAINTAINER_MODE

Section 2.8.5, “Dealing with Problems Compiling MySQL”

MYSQL_TCP_PORT

Section 2.8.3, “Installing MySQL Using a Development Source Tree”
Section 2.8.4, “MySQL Source-Configuration Options”

MYSQL_UNIX_ADDR

Section B.5.3.6, “How to Protect or Change the MySQL Unix Socket File”
Section 2.8.3, “Installing MySQL Using a Development Source Tree”
Section 2.8.4, “MySQL Source-Configuration Options”

--mysqladmin

Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”

--mysqld

Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”

--mysqld-safe-log-timestamps

Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”

--mysqld-version

Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”

--mysqlx-socket

Section 2.8.4, “MySQL Source-Configuration Options”

--mysqlx_connect_timeout

Section 20.7.2.2, “X Plugin System Variables and Options”

mysqlx_idle_worker_thread_timeout

Section 20.7.2.2, “X Plugin System Variables and Options”

mysqlx_max_allowed_packet

Section 20.7.2.2, “X Plugin System Variables and Options”

--mysqlx_max_connections

Section 20.7.2.2, “X Plugin System Variables and Options”

mysqlx_max_connections

Section 20.7.2.2, “X Plugin System Variables and Options”

mysqlx_min_worker_threads

Section 20.7.2.2, “X Plugin System Variables and Options”

--mysqlx_port

Section 2.8.4, “MySQL Source-Configuration Options”
Section 20.7.2.2, “X Plugin System Variables and Options”

--mysqlx_ssl

Section 20.7.2.2, “X Plugin System Variables and Options”

--mysqlx_ssl_ca

Section 20.7.2.2, “X Plugin System Variables and Options”

--mysqlx_ssl_capath

Section 20.7.2.2, “X Plugin System Variables and Options”

--mysqlx_ssl_cert

Section 20.7.2.2, “X Plugin System Variables and Options”

--mysqlx_ssl_cipher

Section 20.7.2.2, “X Plugin System Variables and Options”

--mysqlx_ssl_crl

Section 20.7.2.2, “X Plugin System Variables and Options”

--mysqlx_ssl_crlpath

Section 20.7.2.2, “X Plugin System Variables and Options”

--mysqlx_ssl_key

Section 20.7.2.2, “X Plugin System Variables and Options”

N

[index top]

-N

Section 4.4.1, “comp_err — Compile MySQL Error Message File”
Section 4.5.1.1, “mysql Options”
Section 4.5.4, “mysqldump — A Database Backup Program”

-n

Section 4.6.1, “ibd2sdi — InnoDB Tablespace SDI Extraction Utility”
Section 4.6.2, “innochecksum — Offline InnoDB File Checksum Utility”
Section 17.2.2.1, “memcached Command-Line Options”
Section 4.7.2, “my_print_defaults — Display Options from Option Files”
Section 4.6.4.3, “myisamchk Repair Options”
Section 4.5.1.1, “mysql Options”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.6.9, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.7.3, “resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols”

--name_file

Section 4.4.1, “comp_err — Compile MySQL Error Message File”

--named-commands

Section 4.5.1.1, “mysql Options”

--ndb

Section 4.8.2, “perror — Explain Error Codes”

--net-buffer-length

Section 4.4.5, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.6, “mysqlpump — A Database Backup Program”

net_retry_count

Section 18.2.2, “Replication Implementation Details”

net_write_timeout

Section 18.2.2, “Replication Implementation Details”

--network-timeout

Section 4.5.4, “mysqldump — A Database Backup Program”

--nice

Section 2.5.9, “Managing MySQL Server with systemd”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”

--no-auto-rehash

Section 4.5.1.1, “mysql Options”

--no-autocommit

Section 4.5.4, “mysqldump — A Database Backup Program”

--no-beep

Section 4.5.1.1, “mysql Options”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”

--no-check

Section 4.6.1, “ibd2sdi — InnoDB Tablespace SDI Extraction Utility”
Section 4.6.2, “innochecksum — Offline InnoDB File Checksum Utility”

--no-create-db

Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”

--no-create-info

Section 7.4.5.4, “Dumping Table Definitions and Content Separately”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”

--no-data

Section 7.4.5.4, “Dumping Table Definitions and Content Separately”
Section 4.5.4, “mysqldump — A Database Backup Program”

--no-defaults

Section 4.2.7, “Command-Line Options that Affect Option-File Handling”
Section 4.7.2, “my_print_defaults — Display Options from Option Files”
Section 4.6.4.1, “myisamchk General Options”
Section 4.5.1.1, “mysql Options”
Section 4.6.7, “mysql_config_editor — MySQL Configuration Utility”
Section 4.4.2, “mysql_secure_installation — Improve MySQL Installation Security”
Section 4.4.5, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”
Section 4.5.8, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.9, “mysqlslap — Load Emulation Client”
Section 5.1.4, “Server Command Options”
Section 13.7.4.1, “SET Syntax for Variable Assignment”
Section 6.2.9, “Troubleshooting Problems Connecting to MySQL”
Section 4.2.6, “Using Option Files”
Section 5.1.6, “Using System Variables”

--no-drop

Section 4.5.9, “mysqlslap — Load Emulation Client”

--no-history-logging

Section 21.4.4, “Using MySQL Enterprise Backup with Group Replication”

--no-log

Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”

--no-set-names

Section 4.5.4, “mysqldump — A Database Backup Program”

--no-symlinks

Section 4.6.4.3, “myisamchk Repair Options”

--no-tablespaces

Section 4.5.4, “mysqldump — A Database Backup Program”

--no-wizard

Section 21.7.2, “Group Replication Limitations”
Section 4.5.7, “mysqlsh — The MySQL Shell”

--node

Section 19.2.2.1, “MySQL Shell Sessions Explained”
Section 4.5.7, “mysqlsh — The MySQL Shell”

--number-char-cols

Section 4.5.9, “mysqlslap — Load Emulation Client”

--number-int-cols

Section 4.5.9, “mysqlslap — Load Emulation Client”

--number-of-queries

Section 4.5.9, “mysqlslap — Load Emulation Client”

--numeric-dump-file

Section 4.7.3, “resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols”

O

[index top]

-O

Section 4.4.1, “comp_err — Compile MySQL Error Message File”
Section 2.8.4, “MySQL Source-Configuration Options”

-o

Section 4.6.4.3, “myisamchk Repair Options”
Section 4.6.5, “myisamlog — Display MyISAM Log File Contents”
Section 4.5.1.1, “mysql Options”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 8.12.1, “Optimizing Disk I/O”

--offset

Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”

--old-alter-table

Section 5.1.4, “Server Command Options”

--old-style-user-limits

Section 5.1.4, “Server Command Options”
Section 6.3.6, “Setting Account Resource Limits”

--oldpackage

Section 2.5.4, “Installing MySQL on Linux Using RPM Packages from Oracle”

ON

Section 3.3.4.9, “Using More Than one Table”

--one-database

Section 4.5.1.1, “mysql Options”

--only-print

Section 4.5.9, “mysqlslap — Load Emulation Client”

--open-files-limit

Section B.5.2.17, “File Not Found and Similar Errors”
Section 8.4.3.1, “How MySQL Opens and Closes Tables”
Section 15.13, “InnoDB Startup Options and System Variables”
Section 2.5.9, “Managing MySQL Server with systemd”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 5.1.4, “Server Command Options”

open-files-limit

Section B.5.2.6, “Too many connections”

--opt

Section 8.5.5, “Bulk Data Loading for InnoDB Tables”
Section 4.5.4, “mysqldump — A Database Backup Program”

--opt_name

Section 4.2.6, “Using Option Files”

--optimize

Section 4.5.3, “mysqlcheck — A Table Maintenance Program”

--order-by-primary

Section 4.5.4, “mysqldump — A Database Backup Program”

--out_dir

Section 4.4.1, “comp_err — Compile MySQL Error Message File”

--out_file

Section 4.4.1, “comp_err — Compile MySQL Error Message File”

P

[index top]

-P

Section 4.2.2, “Connecting to the MySQL Server”
Section 19.2.1.2, “Connecting using Individual Parameters”
Section 4.2.1, “Invoking MySQL Programs”
Section 17.2.2.1, “memcached Command-Line Options”
Section 4.5.1.1, “mysql Options”
Section 4.6.7, “mysql_config_editor — MySQL Configuration Utility”
Section 4.4.2, “mysql_secure_installation — Improve MySQL Installation Security”
Section 4.4.5, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”
Section 4.5.7, “mysqlsh — The MySQL Shell”
Section 4.5.8, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.9, “mysqlslap — Load Emulation Client”
Section 5.1.4, “Server Command Options”

-p

Section 6.3.2, “Adding User Accounts”
Section 4.2.2, “Connecting to the MySQL Server”
Section 19.2.1.2, “Connecting using Individual Parameters”
Section 2.10.2, “Downgrading MySQL”
Section 6.1.2.1, “End-User Guidelines for Password Security”
Section 4.6.2, “innochecksum — Offline InnoDB File Checksum Utility”
Section 4.2.1, “Invoking MySQL Programs”
Section 17.2.2.1, “memcached Command-Line Options”
Section 4.6.4.3, “myisamchk Repair Options”
Section 4.6.5, “myisamlog — Display MyISAM Log File Contents”
Section 4.5.1.1, “mysql Options”
Section 4.6.7, “mysql_config_editor — MySQL Configuration Utility”
Section 4.4.2, “mysql_secure_installation — Improve MySQL Installation Security”
Section 4.4.5, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”
Section 4.5.7, “mysqlsh — The MySQL Shell”
Section 4.5.8, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.9, “mysqlslap — Load Emulation Client”
Section B.5.2.4, “Password Fails When Entered Interactively”
Section 2.3.5.8, “Starting MySQL as a Windows Service”
Section 2.3.5.6, “Starting MySQL from the Windows Command Line”
Section 2.3.5.9, “Testing The MySQL Installation”
Section 2.9.3, “Testing the Server”
Section 6.2.9, “Troubleshooting Problems Connecting to MySQL”
Section 2.10.1, “Upgrading MySQL”
Section 2.3.8, “Upgrading MySQL on Windows”
Section 6.3.1, “User Names and Passwords”
Section 4.2.4, “Using Options on the Command Line”
Section 2.3.7, “Windows Postinstallation Procedures”

--page

Section 4.6.2, “innochecksum — Offline InnoDB File Checksum Utility”

--page-type-dump

Section 4.6.2, “innochecksum — Offline InnoDB File Checksum Utility”

--page-type-summary

Section 4.6.2, “innochecksum — Offline InnoDB File Checksum Utility”

--pager

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

--parallel-recover

Section 4.6.4.3, “myisamchk Repair Options”

--parallel-schemas

Section 4.5.6, “mysqlpump — A Database Backup Program”

--partition

Section 1.4, “What Is New in MySQL 8.0”

--password

Section 6.3.2, “Adding User Accounts”
Section 4.2.2, “Connecting to the MySQL Server”
Section 19.2.1.2, “Connecting using Individual Parameters”
Section 6.1.2.1, “End-User Guidelines for Password Security”
Section 7.3, “Example Backup and Recovery Strategy”
Section 4.2.1, “Invoking MySQL Programs”
Section 4.5.1.1, “mysql Options”
Section 19.2.1, “MySQL Shell Connections”
Section 4.6.7, “mysql_config_editor — MySQL Configuration Utility”
Section 4.4.2, “mysql_secure_installation — Improve MySQL Installation Security”
Section 4.4.5, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”
Section 4.5.7, “mysqlsh — The MySQL Shell”
Section 4.5.8, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.9, “mysqlslap — Load Emulation Client”
Section B.5.2.4, “Password Fails When Entered Interactively”
Section 6.5.1.6, “Test Pluggable Authentication”
Section 6.2.9, “Troubleshooting Problems Connecting to MySQL”
Section 6.3.1, “User Names and Passwords”
Section 4.6.8.3, “Using mysqlbinlog to Back Up Binary Log Files”
Section 4.2.4, “Using Options on the Command Line”

password

Section 4.6.7, “mysql_config_editor — MySQL Configuration Utility”
Section 4.2.6, “Using Option Files”

--passwords-from-stdin

Section 4.5.7, “mysqlsh — The MySQL Shell”

--performance-schema-consumer-consumer_name

Section 25.13, “Performance Schema Command Options”

--performance-schema-consumer-events-stages-current

Section 25.13, “Performance Schema Command Options”

--performance-schema-consumer-events-stages-history

Section 25.13, “Performance Schema Command Options”

--performance-schema-consumer-events-stages-history-long

Section 25.13, “Performance Schema Command Options”

--performance-schema-consumer-events-statements-current

Section 25.13, “Performance Schema Command Options”

--performance-schema-consumer-events-statements-history

Section 25.13, “Performance Schema Command Options”

--performance-schema-consumer-events-statements-history-long

Section 25.13, “Performance Schema Command Options”

--performance-schema-consumer-events-transactions-current

Section 25.13, “Performance Schema Command Options”

--performance-schema-consumer-events-transactions-history

Section 25.13, “Performance Schema Command Options”

--performance-schema-consumer-events-transactions-history-long

Section 25.13, “Performance Schema Command Options”

--performance-schema-consumer-events-waits-current

Section 25.13, “Performance Schema Command Options”

--performance-schema-consumer-events-waits-history

Section 25.13, “Performance Schema Command Options”

--performance-schema-consumer-events-waits-history-long

Section 25.13, “Performance Schema Command Options”

--performance-schema-consumer-global-instrumentation

Section 25.13, “Performance Schema Command Options”

--performance-schema-consumer-statements-digest

Section 25.13, “Performance Schema Command Options”

--performance-schema-consumer-thread-instrumentation

Section 25.13, “Performance Schema Command Options”

--performance-schema-instrument

Section 25.13, “Performance Schema Command Options”
Section 25.3, “Performance Schema Startup Configuration”

--performance-schema-xxx

Section 5.1.4, “Server Command Options”

--performance_schema_max_mutex_classes

Section 25.7, “Performance Schema Status Monitoring”

--performance_schema_max_mutex_instances

Section 25.7, “Performance Schema Status Monitoring”

--pid-file

Section 2.5.9, “Managing MySQL Server with systemd”
Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 5.7, “Running Multiple MySQL Instances on One Machine”
Section 5.1.4, “Server Command Options”
Section 5.1.5, “Server System Variables”
Section 5.4.2, “The Error Log”

pid-file

Section 4.3.3, “mysql.server — MySQL Server Startup Script”

--pipe

Section 4.2.2, “Connecting to the MySQL Server”
Section 4.5.1.1, “mysql Options”
Section 4.4.5, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.8, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.9, “mysqlslap — Load Emulation Client”
Section 2.3.5.9, “Testing The MySQL Installation”

--plugin

Section 5.1.4, “Server Command Options”

--plugin-dir

Section 27.7.13, “C API Client Plugin Functions”
Section 28.2.4.2.3, “Client Plugin Descriptors”
Section 4.5.1.1, “mysql Options”
Section 27.7.13.3, “mysql_load_plugin()”
Section 4.4.5, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”
Section 4.5.8, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.9, “mysqlslap — Load Emulation Client”
Section 6.3.10, “Pluggable Authentication”
Section C.9, “Restrictions on Pluggable Authentication”
Section 28.2.4.9.3, “Using the Authentication Plugins”
Section 28.2.4.11.2, “Using Your Own Protocol Trace Plugins”

--plugin-innodb_file_per_table

Section 5.1.4, “Server Command Options”

--plugin-load

Section 13.7.3.4, “INSTALL PLUGIN Syntax”
Section 5.6.1, “Installing and Uninstalling Plugins”
Section 6.5.4.1, “Keyring Plugin Installation”
Section 2.8.4, “MySQL Source-Configuration Options”
Section 28.2.3, “Plugin API Components”
Section 28.2.4.2, “Plugin Data Structures”
Section 5.1.4, “Server Command Options”
Section 28.2.4.2.1, “Server Plugin Library and Plugin Descriptors”
Section 28.2, “The MySQL Plugin API”
Section 28.2.4.9.3, “Using the Authentication Plugins”
Section 1.4, “What Is New in MySQL 8.0”

--plugin-load-add

Section 6.5.2.1, “Connection-Control Plugin Installation”
Section 5.6.1, “Installing and Uninstalling Plugins”
Section 6.5.4.1, “Keyring Plugin Installation”
Section 6.5.1.4, “No-Login Pluggable Authentication”
Section 6.5.3.1, “Password Validation Plugin Installation”
Section 6.5.3.2, “Password Validation Plugin Options and Variables”
Section 5.1.4, “Server Command Options”
Section 6.5.1.5, “Socket Peer-Credential Pluggable Authentication”
Section 6.5.1.6, “Test Pluggable Authentication”
Section 1.4, “What Is New in MySQL 8.0”

--plugin-sql-mode

Section 5.1.4, “Server Command Options”

--plugin-xxx

Section 5.1.4, “Server Command Options”

--plugin_dir

Section 2.8.4, “MySQL Source-Configuration Options”
Section 28.2.3, “Plugin API Components”

--plugin_name

Section 5.6.1, “Installing and Uninstalling Plugins”

--plugindir

Section 4.7.1, “mysql_config — Display Options for Compiling Clients”

--port

Section 4.2.2, “Connecting to the MySQL Server”
Section 19.2.1.2, “Connecting using Individual Parameters”
Section 4.2.1, “Invoking MySQL Programs”
Section 4.5.1.1, “mysql Options”
Section 19.2.1, “MySQL Shell Connections”
Section 2.8.4, “MySQL Source-Configuration Options”
Section 4.7.1, “mysql_config — Display Options for Compiling Clients”
Section 4.6.7, “mysql_config_editor — MySQL Configuration Utility”
Section 4.4.2, “mysql_secure_installation — Improve MySQL Installation Security”
Section 4.4.5, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”
Section 4.5.7, “mysqlsh — The MySQL Shell”
Section 4.5.8, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.9, “mysqlslap — Load Emulation Client”
Section 5.7, “Running Multiple MySQL Instances on One Machine”
Section 5.7.3, “Running Multiple MySQL Instances on Unix”
Section 5.1.4, “Server Command Options”
Section 5.1.5, “Server System Variables”
Section 6.2.9, “Troubleshooting Problems Connecting to MySQL”
Section 2.9.2.1, “Troubleshooting Problems Starting the MySQL Server”
Section 5.7.4, “Using Client Programs in a Multiple-Server Environment”

port

Section 4.6.7, “mysql_config_editor — MySQL Configuration Utility”
Section 4.2.6, “Using Option Files”

--port-open-timeout

Section 5.1.4, “Server Command Options”

--post-query

Section 4.5.9, “mysqlslap — Load Emulation Client”

--post-system

Section 4.5.9, “mysqlslap — Load Emulation Client”

--pre-query

Section 4.5.9, “mysqlslap — Load Emulation Client”

--pre-system

Section 4.5.9, “mysqlslap — Load Emulation Client”

--prefix

Section 17.2.1, “Installing memcached

--print-defaults

Section 4.2.7, “Command-Line Options that Affect Option-File Handling”
Section 4.6.4.1, “myisamchk General Options”
Section 4.5.1.1, “mysql Options”
Section 4.4.2, “mysql_secure_installation — Improve MySQL Installation Security”
Section 4.4.5, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”
Section 4.5.8, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.9, “mysqlslap — Load Emulation Client”
Section 5.1.4, “Server Command Options”
Section 2.10.1, “Upgrading MySQL”

--print-table-metadata

Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”

--prompt

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

--protocol

Section 4.2.2, “Connecting to the MySQL Server”
Section 4.5.1.1, “mysql Options”
Section 4.4.2, “mysql_secure_installation — Improve MySQL Installation Security”
Section 4.4.5, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”
Section 4.5.8, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.9, “mysqlslap — Load Emulation Client”
Section 5.7.3, “Running Multiple MySQL Instances on Unix”
Section 2.3.5.5, “Starting the Server for the First Time”
Section 2.3.5.9, “Testing The MySQL Installation”
Section 1.3.2, “The Main Features of MySQL”
Section 5.7.4, “Using Client Programs in a Multiple-Server Environment”

--py

Section 19.3.4, “Active Language”
Section 4.5.7, “mysqlsh — The MySQL Shell”

Q

[index top]

-Q

Section 4.5.4, “mysqldump — A Database Backup Program”

-q

Section 4.6.4.3, “myisamchk Repair Options”
Section 4.5.1.1, “mysql Options”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.9, “mysqlslap — Load Emulation Client”

--query

Section 4.5.9, “mysqlslap — Load Emulation Client”

--quick

Section 4.6.4.6, “myisamchk Memory Usage”
Section 4.6.4.3, “myisamchk Repair Options”
Section 4.5.1.1, “mysql Options”
Section 4.5.1, “mysql — The MySQL Command-Line Tool”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section B.5.2.7, “Out of memory”
Section 7.6.1, “Using myisamchk for Crash Recovery”
Section 4.2.6, “Using Option Files”

--quote-names

Section 4.5.4, “mysqldump — A Database Backup Program”

R

[index top]

-R

Section 17.2.2.1, “memcached Command-Line Options”
Section 17.2.4.1, “memcached General Statistics”
Section 7.6.4, “MyISAM Table Optimization”
Section 4.6.5, “myisamlog — Display MyISAM Log File Contents”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.6.4.4, “Other myisamchk Options”
Section 4.6.8.3, “Using mysqlbinlog to Back Up Binary Log Files”

-r

Section 28.4.2, “Adding a New User-Defined Function”
Section 7.6.3, “How to Repair MyISAM Tables”
Section 2.2, “Installing MySQL on Unix/Linux Using Generic Binaries”
Section 17.2.2.1, “memcached Command-Line Options”
Section 4.6.4.2, “myisamchk Check Options”
Section 4.6.4.3, “myisamchk Repair Options”
Section 4.6.5, “myisamlog — Display MyISAM Log File Contents”
Section 4.5.1.1, “mysql Options”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.6.9, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 5.1.4, “Server Command Options”

--raw

Section 4.5.1.1, “mysql Options”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 18.1.3.3, “Using GTIDs for Failover and Scaleout”
Section 4.6.8.3, “Using mysqlbinlog to Back Up Binary Log Files”

--read-from-remote-master

Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 18.1.3.3, “Using GTIDs for Failover and Scaleout”

--read-from-remote-server

Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.8.4, “Specifying the mysqlbinlog Server ID”
Section 18.1.3.3, “Using GTIDs for Failover and Scaleout”
Section 4.6.8.3, “Using mysqlbinlog to Back Up Binary Log Files”

--read-only

Section 4.6.4.2, “myisamchk Check Options”

--reconnect

Section 4.5.1.1, “mysql Options”

--recover

Section 4.6.4.2, “myisamchk Check Options”
Section 4.6.4.1, “myisamchk General Options”
Section 4.6.4.6, “myisamchk Memory Usage”
Section 4.6.4.3, “myisamchk Repair Options”

--recreate-schema

Section 4.5.7, “mysqlsh — The MySQL Shell”

--relative

Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”

--relay-log

Section 18.1.2.8, “Adding Slaves to a Replication Environment”
Section 13.4.2.1, “CHANGE MASTER TO Syntax”
Section 18.3.7, “Improving Replication Performance”
Section 4.2.9, “Option Defaults, Options Expecting Values, and the = Sign”
Section 18.2.3.4, “Replication Channel Naming Conventions”
Section 18.1.6.3, “Replication Slave Options and Variables”
Section 18.2.3.3, “Startup Options and Replication Channels”
Section 18.2.4.1, “The Slave Relay Log”

--relay-log-index

Section 18.1.2.8, “Adding Slaves to a Replication Environment”
Section 18.1.6.3, “Replication Slave Options and Variables”
Section 18.2.3.3, “Startup Options and Replication Channels”
Section 18.2.4.1, “The Slave Relay Log”

--relay-log-info-file

Section 18.1.6.3, “Replication Slave Options and Variables”
Section 18.2.4.2, “Slave Status Logs”

--relay-log-info-repository

Section 15.13, “InnoDB Startup Options and System Variables”
Section 18.2.4, “Replication Relay and Status Logs”
Section 18.1.6.3, “Replication Slave Options and Variables”
Section 18.2.4.2, “Slave Status Logs”

--relay-log-purge

Section 18.1.6.3, “Replication Slave Options and Variables”

relay-log-purge

Section 18.1.6.3, “Replication Slave Options and Variables”

--relay-log-recovery

Section 18.4.1.34, “Replication and Transaction Inconsistencies”
Section 18.2.4, “Replication Relay and Status Logs”
Section 18.1.6.3, “Replication Slave Options and Variables”
Section 13.7.5.34, “SHOW SLAVE STATUS Syntax”
Section 5.1.12, “The Server Shutdown Process”

--relay-log-space-limit

Section 18.1.6.3, “Replication Slave Options and Variables”
Section 18.2.3.3, “Startup Options and Replication Channels”

--remove

Section 5.1.4, “Server Command Options”
Section 5.7.2.2, “Starting Multiple MySQL Instances as Windows Services”
Section 2.3.5.8, “Starting MySQL as a Windows Service”

--repair

Section 4.5.3, “mysqlcheck — A Table Maintenance Program”

--replace

Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”

--replicate-*

Section 13.4.2.2, “CHANGE REPLICATION FILTER Syntax”
Section 18.2.5, “How Servers Evaluate Replication Filtering Rules”
Section 18.2.5.4, “Replication Channel Based Filters”
Section 18.2.5.3, “Replication Rule Application”
Section 18.1.6.3, “Replication Slave Options and Variables”
Section 25.11.11.8, “The replication_applier_filters Table”
Section 25.11.11.7, “The replication_applier_global_filters Table”

--replicate-*-db

Section 18.2.5.3, “Replication Rule Application”
Section 18.1.6.3, “Replication Slave Options and Variables”
Section C.1, “Restrictions on Stored Programs”

--replicate-*-table

Section 18.2.5.3, “Replication Rule Application”

--replicate-do-db

Section 18.1.6.4, “Binary Logging Options and Variables”
Section 13.4.2.2, “CHANGE REPLICATION FILTER Syntax”
Section 18.2.5.1, “Evaluation of Database-Level Replication and Binary Logging Options”
Section 18.2.5, “How Servers Evaluate Replication Filtering Rules”
Section 18.3.6, “Replicating Different Databases to Different Slaves”
Section 18.4.1.27, “Replication and Reserved Words”
Section 18.4.1.24, “Replication and Temporary Tables”
Section 18.2.5.4, “Replication Channel Based Filters”
Section 18.1.6.3, “Replication Slave Options and Variables”
Section 13.7.5.34, “SHOW SLAVE STATUS Syntax”
Section 13.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”
Section 5.4.4, “The Binary Log”
Section 18.2.1.2, “Usage of Row-Based Logging and Replication”

--replicate-do-db:channel_1:db_name

Section 18.1.6.3, “Replication Slave Options and Variables”

--replicate-do-table

Section 13.4.2.2, “CHANGE REPLICATION FILTER Syntax”
Section 18.2.5.2, “Evaluation of Table-Level Replication Options”
Section 18.4.1.27, “Replication and Reserved Words”
Section 18.4.1.24, “Replication and Temporary Tables”
Section 18.2.5.3, “Replication Rule Application”
Section 18.1.6.3, “Replication Slave Options and Variables”
Section 13.7.5.34, “SHOW SLAVE STATUS Syntax”
Section 16.6, “The BLACKHOLE Storage Engine”
Section 18.2.1.2, “Usage of Row-Based Logging and Replication”

--replicate-do-table:channel_1:db_name.tbl_name

Section 18.1.6.3, “Replication Slave Options and Variables”

--replicate-ignore-db

Section 18.1.6.4, “Binary Logging Options and Variables”
Section 13.4.2.2, “CHANGE REPLICATION FILTER Syntax”
Section 18.2.5.1, “Evaluation of Database-Level Replication and Binary Logging Options”
Section 18.2.5, “How Servers Evaluate Replication Filtering Rules”
Section 18.4.1.27, “Replication and Reserved Words”
Section 18.2.5.4, “Replication Channel Based Filters”
Section 18.2.5.3, “Replication Rule Application”
Section 18.1.6.3, “Replication Slave Options and Variables”
Section 13.7.5.34, “SHOW SLAVE STATUS Syntax”
Section 13.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”
Section 5.4.4, “The Binary Log”
Section 18.2.1.2, “Usage of Row-Based Logging and Replication”

--replicate-ignore-db:channel_1:db_name

Section 18.1.6.3, “Replication Slave Options and Variables”

--replicate-ignore-table

Section 13.4.2.2, “CHANGE REPLICATION FILTER Syntax”
Section 18.2.5.2, “Evaluation of Table-Level Replication Options”
Section 18.4.1.27, “Replication and Reserved Words”
Section 18.4.1.24, “Replication and Temporary Tables”
Section 18.1.6.3, “Replication Slave Options and Variables”
Section 13.7.5.34, “SHOW SLAVE STATUS Syntax”
Section 16.6, “The BLACKHOLE Storage Engine”
Section 18.2.1.2, “Usage of Row-Based Logging and Replication”

--replicate-ignore-table:channel_1:db_name.tbl_name

Section 18.1.6.3, “Replication Slave Options and Variables”

--replicate-rewrite-db

Section 13.4.2.2, “CHANGE REPLICATION FILTER Syntax”
Section 18.2.5, “How Servers Evaluate Replication Filtering Rules”
Section 18.1.6.3, “Replication Slave Options and Variables”
Section 18.2.1.2, “Usage of Row-Based Logging and Replication”

--replicate-rewrite-db:channel_1:(db_name1->db_name2)

Section 18.1.6.3, “Replication Slave Options and Variables”

--replicate-same-server-id

Section 13.4.2.1, “CHANGE MASTER TO Syntax”
Section 18.1.6, “Replication and Binary Logging Options and Variables”
Section 18.1.6.3, “Replication Slave Options and Variables”

--replicate-wild-do-table

Section 13.4.2.2, “CHANGE REPLICATION FILTER Syntax”
Section 18.2.5.2, “Evaluation of Table-Level Replication Options”
Section 18.2.5, “How Servers Evaluate Replication Filtering Rules”
Section 18.3.6, “Replicating Different Databases to Different Slaves”
Section 18.4.1.24, “Replication and Temporary Tables”
Section 18.1.6.3, “Replication Slave Options and Variables”
Section C.1, “Restrictions on Stored Programs”
Section 13.7.5.34, “SHOW SLAVE STATUS Syntax”

--replicate-wild-do-table:channel_1:db_name.tbl_name

Section 18.1.6.3, “Replication Slave Options and Variables”

--replicate-wild-ignore-table

Section 13.4.2.2, “CHANGE REPLICATION FILTER Syntax”
Section 18.2.5.2, “Evaluation of Table-Level Replication Options”
Section A.13, “MySQL 8.0 FAQ: Replication”
Section 18.4.1.24, “Replication and Temporary Tables”
Section 18.1.6.3, “Replication Slave Options and Variables”
Section 13.7.5.34, “SHOW SLAVE STATUS Syntax”

--replicate-wild-ignore:channel_1:db_name.tbl_name

Section 18.1.6.3, “Replication Slave Options and Variables”

replication-ignore-table

Section 18.4.1.39, “Replication and Views”

--replication-rewrite-db

Section 18.1.6.3, “Replication Slave Options and Variables”

--report-host

Section 18.1.7.1, “Checking Replication Status”
Section 18.1.6.3, “Replication Slave Options and Variables”
Section 5.1.5, “Server System Variables”
Section 13.7.5.33, “SHOW SLAVE HOSTS Syntax”

--report-password

Section 18.1.6.2, “Replication Master Options and Variables”
Section 18.1.6.3, “Replication Slave Options and Variables”
Section 5.1.5, “Server System Variables”
Section 13.7.5.33, “SHOW SLAVE HOSTS Syntax”

--report-port

Section 18.1.6.3, “Replication Slave Options and Variables”
Section 5.1.5, “Server System Variables”
Section 13.7.5.33, “SHOW SLAVE HOSTS Syntax”

--report-user

Section 18.1.6.2, “Replication Master Options and Variables”
Section 18.1.6.3, “Replication Slave Options and Variables”
Section 5.1.5, “Server System Variables”
Section 13.7.5.33, “SHOW SLAVE HOSTS Syntax”

--result-file

Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”
Section 4.6.8.3, “Using mysqlbinlog to Back Up Binary Log Files”

--rewrite-db

Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”

--routines

Section 14.6, “Data Dictionary Usage Differences”
Section 7.4.5.3, “Dumping Stored Programs”
Section 7.4.5.4, “Dumping Table Definitions and Content Separately”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”
Section 2.10.1, “Upgrading MySQL”
Section 4.6.8.3, “Using mysqlbinlog to Back Up Binary Log Files”

S

[index top]

-S

Section 4.4.1, “comp_err — Compile MySQL Error Message File”
Section 4.2.2, “Connecting to the MySQL Server”
Section 19.2.1.2, “Connecting using Individual Parameters”
Section 4.6.2, “innochecksum — Offline InnoDB File Checksum Utility”
Section 4.2.1, “Invoking MySQL Programs”
Section 7.6.4, “MyISAM Table Optimization”
Section 4.5.1.2, “mysql Commands”
Section 4.5.1.1, “mysql Options”
Section 4.6.7, “mysql_config_editor — MySQL Configuration Utility”
Section 4.4.2, “mysql_secure_installation — Improve MySQL Installation Security”
Section 4.4.5, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”
Section 4.5.7, “mysqlsh — The MySQL Shell”
Section 4.5.8, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.9, “mysqlslap — Load Emulation Client”
Section 4.6.4.4, “Other myisamchk Options”

-s

Section 7.6.2, “How to Check MyISAM Tables for Errors”
Section 7.6.3, “How to Repair MyISAM Tables”
Section 4.6.1, “ibd2sdi — InnoDB Tablespace SDI Extraction Utility”
Section 4.6.2, “innochecksum — Offline InnoDB File Checksum Utility”
Section 2.2, “Installing MySQL on Unix/Linux Using Generic Binaries”
Section 17.2.2.1, “memcached Command-Line Options”
Section 4.7.2, “my_print_defaults — Display Options from Option Files”
Section 4.6.3, “myisam_ftdump — Display Full-Text Index information”
Section 4.6.4.1, “myisamchk General Options”
Section 4.6.6, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.5.1.1, “mysql Options”
Section 4.4.5, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.6.9, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.9, “mysqlslap — Load Emulation Client”
Section 4.8.2, “perror — Explain Error Codes”
Section 4.7.3, “resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols”
Section 4.8.3, “resolveip — Resolve Host name to IP Address or Vice Versa”
Section 5.1.4, “Server Command Options”
Section 7.6.5, “Setting Up a MyISAM Table Maintenance Schedule”

--safe-recover

Section 4.6.4.1, “myisamchk General Options”
Section 4.6.4.6, “myisamchk Memory Usage”
Section 4.6.4.3, “myisamchk Repair Options”

--safe-updates

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

--safe-user-create

Section 5.1.4, “Server Command Options”

--schema

Section 19.2.1.2, “Connecting using Individual Parameters”
Section 4.5.7, “mysqlsh — The MySQL Shell”

--secure-auth

Section 4.5.1.1, “mysql Options”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”
Section 4.5.8, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.9, “mysqlslap — Load Emulation Client”
Section 5.1.4, “Server Command Options”
Section 1.4, “What Is New in MySQL 8.0”

--secure-file-priv

Section 6.1.3, “Making MySQL Secure Against Attackers”
Section 5.1.4, “Server Command Options”
Section 5.1.5, “Server System Variables”

--select_limit

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

--server-arg

Section 1.4, “What Is New in MySQL 8.0”

--server-file

Section 1.4, “What Is New in MySQL 8.0”

--server-id

Section 18.1.6.4, “Binary Logging Options and Variables”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 18.1.6, “Replication and Binary Logging Options and Variables”
Section 5.1.5, “Server System Variables”
Section 13.7.5.33, “SHOW SLAVE HOSTS Syntax”
Section 18.4.4, “Troubleshooting Replication”

server-id

Section 18.1.2.8, “Adding Slaves to a Replication Environment”
Section 18.1.1, “Binary Log File Position Based Replication Configuration Overview”
Section 18.1.6.2, “Replication Master Options and Variables”
Section 18.1.6.3, “Replication Slave Options and Variables”
Section 18.1.2.1, “Setting the Replication Master Configuration”
Section 18.1.2.2, “Setting the Replication Slave Configuration”
Section 18.1.2.6.2, “Setting Up Replication with Existing Data”

--server-public-key-path

Section 4.5.1.1, “mysql Options”
Section 6.5.1.2, “SHA-256 Pluggable Authentication”

service-startup-timeout

Section 4.3.3, “mysql.server — MySQL Server Startup Script”

--set-auto-increment

Section 4.6.4.4, “Other myisamchk Options”

--set-charset

Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”

--set-collation

Section 4.6.4.3, “myisamchk Repair Options”

--set-gtid-purged

Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”
Section 18.1.3.3, “Using GTIDs for Failover and Scaleout”

--shared-memory

Section 4.2.2, “Connecting to the MySQL Server”
Section 4.5.1.1, “mysql Options”
Section 4.4.5, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.8, “mysqlshow — Display Database, Table, and Column Information”
Section 5.1.4, “Server Command Options”
Section 5.7.2.1, “Starting Multiple MySQL Instances at the Windows Command Line”
Section 2.3.5.5, “Starting the Server for the First Time”
Section 1.3.2, “The Main Features of MySQL”

--shared-memory-base-name

Section 4.2.2, “Connecting to the MySQL Server”
Section 4.5.1.1, “mysql Options”
Section 27.7.7.50, “mysql_options()”
Section 4.4.5, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.8, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.9, “mysqlslap — Load Emulation Client”
Section 5.7, “Running Multiple MySQL Instances on One Machine”
Section 5.1.4, “Server Command Options”
Section 5.7.2.1, “Starting Multiple MySQL Instances at the Windows Command Line”
Section 5.7.4, “Using Client Programs in a Multiple-Server Environment”

--short-form

Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”

--show

Section 4.7.2, “my_print_defaults — Display Options from Option Files”

--show-slave-auth-info

Section 18.1.6.2, “Replication Master Options and Variables”
Section 18.1.6.3, “Replication Slave Options and Variables”
Section 13.7.5.33, “SHOW SLAVE HOSTS Syntax”

--show-table-type

Section 4.5.8, “mysqlshow — Display Database, Table, and Column Information”

--show-warnings

Section 4.5.1.1, “mysql Options”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.7, “mysqlsh — The MySQL Shell”

--sigint-ignore

Section 4.5.1.1, “mysql Options”

--silent

Section 4.6.4.1, “myisamchk General Options”
Section 4.6.6, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.5.1.1, “mysql Options”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.9, “mysqlslap — Load Emulation Client”
Section 4.8.2, “perror — Explain Error Codes”
Section 4.8.3, “resolveip — Resolve Host name to IP Address or Vice Versa”
Section 7.6.5, “Setting Up a MyISAM Table Maintenance Schedule”

--single-transaction

Section 7.2, “Database Backup Methods”
Section 7.3.1, “Establishing a Backup Policy”
Section 15.17.1, “InnoDB Backup”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”

--skip

Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.2.5, “Program Option Modifiers”
Section 5.1.4, “Server Command Options”

--skip-add-drop-table

Section 4.5.4, “mysqldump — A Database Backup Program”

--skip-add-locks

Section 4.5.4, “mysqldump — A Database Backup Program”

--skip-auto-rehash

Section 4.5.1.1, “mysql Options”

--skip-character-set-client-handshake

Section A.11, “MySQL 8.0 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
Section 5.1.4, “Server Command Options”
Section 5.1.5, “Server System Variables”
Section 10.1.10.7.1, “The cp932 Character Set”

--skip-column-names

Section 4.5.1.1, “mysql Options”

--skip-comments

Section 4.5.1.1, “mysql Options”
Section 4.5.4, “mysqldump — A Database Backup Program”

--skip-concurrent-insert

Section 5.1.4, “Server Command Options”

--skip-data

Section 4.6.1, “ibd2sdi — InnoDB Tablespace SDI Extraction Utility”

--skip-database

Section 4.5.3, “mysqlcheck — A Table Maintenance Program”

--skip-defer-table-indexes

Section 4.5.6, “mysqlpump — A Database Backup Program”

--skip-definer

Section 4.5.6, “mysqlpump — A Database Backup Program”

--skip-disable-keys

Section 4.5.4, “mysqldump — A Database Backup Program”

--skip-dump-date

Section 4.5.4, “mysqldump — A Database Backup Program”

--skip-dump-rows

Section 4.5.6, “mysqlpump — A Database Backup Program”

--skip-engine_name

Section 13.7.5.16, “SHOW ENGINES Syntax”

--skip-event-scheduler

Section 5.1.4, “Server Command Options”

--skip-events

Section 7.4.5.3, “Dumping Stored Programs”
Section 4.5.6, “mysqlpump — A Database Backup Program”

--skip-extended-insert

Section 4.5.4, “mysqldump — A Database Backup Program”

--skip-external-locking

Section 8.11.5, “External Locking”
Section 8.14.2, “General Thread States”
Section 5.1.4, “Server Command Options”
Section 5.1.5, “Server System Variables”
Section B.5.3.3, “What to Do If MySQL Keeps Crashing”

--skip-federated

Section 18.3.4, “Using Replication with Different Master and Slave Storage Engines”

--skip-grant-tables

Section 13.7.3.1, “CREATE FUNCTION Syntax for User-Defined Functions”
Section 23.4.2, “Event Scheduler Configuration”
Section 13.7.3.3, “INSTALL COMPONENT Syntax”
Section 13.7.3.4, “INSTALL PLUGIN Syntax”
Section 5.6.1, “Installing and Uninstalling Plugins”
Section 5.5, “MySQL Server Components”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 6.3.10, “Pluggable Authentication”
Section B.5.3.2.3, “Resetting the Root Password: Generic Instructions”
Section 5.1.4, “Server Command Options”
Section 5.1.5, “Server System Variables”
Section 6.2.2, “Static Versus Dynamic Privileges”
Section 5.3, “The mysql System Database”
Section 6.2.9, “Troubleshooting Problems Connecting to MySQL”
Section 28.4.2.5, “UDF Compiling and Installing”
Section 4.2.4, “Using Options on the Command Line”
Section 6.2.8, “When Privilege Changes Take Effect”

--skip-gtids

Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 7.5, “Point-in-Time (Incremental) Recovery Using the Binary Log”

--skip-host-cache

Section 5.1.4, “Server Command Options”
Section 5.1.5, “Server System Variables”
Section 6.2.9, “Troubleshooting Problems Connecting to MySQL”

--skip-innodb

Section 15.13, “InnoDB Startup Options and System Variables”
Section 5.6.1, “Installing and Uninstalling Plugins”
Section A.13, “MySQL 8.0 FAQ: Replication”
Section 5.1.4, “Server Command Options”

--skip-innodb_adaptive_hash_index

Section 15.13, “InnoDB Startup Options and System Variables”

--skip-innodb_doublewrite

Section 15.13, “InnoDB Startup Options and System Variables”

--skip-kill-mysqld

Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”

--skip-line-numbers

Section 4.5.1.1, “mysql Options”

--skip-lock-tables

Section 4.5.4, “mysqldump — A Database Backup Program”

--skip-name-resolve

Section 8.12.4.2, “DNS Lookup Optimization and the Host Cache”
Section 5.1.4, “Server Command Options”
Section 5.1.5, “Server System Variables”
Section 2.3.5.9, “Testing The MySQL Installation”
Section 6.2.9, “Troubleshooting Problems Connecting to MySQL”

--skip-named-commands

Section 4.5.1.1, “mysql Options”

--skip-network-timeout

Section 4.5.4, “mysqldump — A Database Backup Program”

--skip-networking

Section B.5.2.2, “Can't connect to [local] MySQL server”
Section 8.12.4.2, “DNS Lookup Optimization and the Host Cache”
Section B.5.2.8, “MySQL server has gone away”
Section 6.3.10, “Pluggable Authentication”
Section B.5.3.2.3, “Resetting the Root Password: Generic Instructions”
Section 5.1.4, “Server Command Options”
Section 5.1.5, “Server System Variables”
Section 6.2.9, “Troubleshooting Problems Connecting to MySQL”
Section 18.4.3, “Upgrading a Replication Setup”

skip-networking

Section A.13, “MySQL 8.0 FAQ: Replication”
Section 18.1.2.1, “Setting the Replication Master Configuration”
Section 18.4.4, “Troubleshooting Replication”

--skip-new

Section 28.5.1, “Debugging a MySQL Server”
Section 13.7.2.4, “OPTIMIZE TABLE Syntax”
Section 5.1.5, “Server System Variables”

--skip-opt

Section 4.5.4, “mysqldump — A Database Backup Program”

--skip-pager

Section 4.5.1.1, “mysql Options”

--skip-partition

Section 1.4, “What Is New in MySQL 8.0”

--skip-plugin-innodb_file_per_table

Section 5.1.4, “Server Command Options”

--skip-plugin_name

Section 5.6.1, “Installing and Uninstalling Plugins”

--skip-quick

Section 4.5.4, “mysqldump — A Database Backup Program”

--skip-quote-names

Section 4.5.4, “mysqldump — A Database Backup Program”

--skip-reconnect

Section 27.7.23, “C API Automatic Reconnection Control”
Section 4.5.1.6.5, “Disabling mysql Auto-Reconnect”
Section 4.5.1.1, “mysql Options”

--skip-routines

Section 7.4.5.3, “Dumping Stored Programs”
Section 4.5.6, “mysqlpump — A Database Backup Program”

--skip-set-charset

Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”

--skip-show-database

Section 6.2.1, “Privileges Provided by MySQL”
Section 5.1.4, “Server Command Options”
Section 13.7.5.14, “SHOW DATABASES Syntax”
Section 1.9.5, “Supporters of MySQL”

--skip-slave-start

Section 13.4.2.1, “CHANGE MASTER TO Syntax”
Section 18.1.6.3, “Replication Slave Options and Variables”
Section 18.3.9, “Setting Up Replication to Use Encrypted Connections”
Section 18.1.3.2, “Setting Up Replication Using GTIDs”
Section 18.1.2.6.2, “Setting Up Replication with Existing Data”
Section 13.4.2.6, “START SLAVE Syntax”
Section 18.2.3.3, “Startup Options and Replication Channels”
Section 18.4.4, “Troubleshooting Replication”
Section 18.4.3, “Upgrading a Replication Setup”

--skip-ssl

Section 6.4.2, “Command Options for Encrypted Connections”
Section 1.4, “What Is New in MySQL 8.0”

--skip-stack-trace

Section 28.5.1.4, “Debugging mysqld under gdb”
Section 5.1.4, “Server Command Options”

--skip-super-large-pages

Section 8.12.3.2, “Enabling Large Page Support”
Section 5.1.4, “Server Command Options”

--skip-symbolic-links

Section 13.1.16, “CREATE TABLE Syntax”
Section 6.1.3, “Making MySQL Secure Against Attackers”
Section 5.1.4, “Server Command Options”
Section 5.1.5, “Server System Variables”
Section 8.12.2.2, “Using Symbolic Links for MyISAM Tables on Unix”

--skip-sys-schema

Section 4.4.5, “mysql_upgrade — Check and Upgrade MySQL Tables”

--skip-syslog

Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”

--skip-triggers

Section 7.4.5.3, “Dumping Stored Programs”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”

--skip-tz-utc

Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”

--skip-version-check

Section 4.4.5, “mysql_upgrade — Check and Upgrade MySQL Tables”

--skip-warn

Section 4.6.7, “mysql_config_editor — MySQL Configuration Utility”

--skip-watch-progress

Section 4.5.6, “mysqlpump — A Database Backup Program”

--skip-write-binlog

Section 11.3.4, “Migrating YEAR(2) Columns to YEAR(4)”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”

--skip_grant_tables

Section 4.2.4, “Using Options on the Command Line”

--slave-checkpoint-group

Section 18.1.6.3, “Replication Slave Options and Variables”
Section 18.2.3.3, “Startup Options and Replication Channels”

--slave-checkpoint-period

Section 18.1.6.3, “Replication Slave Options and Variables”

--slave-load-tmpdir

Section 18.3.1.2, “Backing Up Raw Data from a Slave”
Section 7.2, “Database Backup Methods”
Section 18.1.6.3, “Replication Slave Options and Variables”
Section B.5.3.5, “Where MySQL Stores Temporary Files”

--slave-max-allowed-packet

Section 18.1.6.3, “Replication Slave Options and Variables”

slave-max-allowed-packet

Section 18.1.6.3, “Replication Slave Options and Variables”

--slave-net-timeout

Section 18.1.6.3, “Replication Slave Options and Variables”

--slave-parallel-type

Section 18.1.6.3, “Replication Slave Options and Variables”

--slave-parallel-workers

Section 18.1.6.3, “Replication Slave Options and Variables”
Section 18.2.3.3, “Startup Options and Replication Channels”

--slave-pending-jobs-size-max

Section 18.1.6.3, “Replication Slave Options and Variables”

--slave-rows-search-algorithms

Section 18.1.6.3, “Replication Slave Options and Variables”

slave-rows-search-algorithms

Section 18.1.6.3, “Replication Slave Options and Variables”

--slave-skip-counter

Section 18.2.3.3, “Startup Options and Replication Channels”

--slave-skip-errors

Section 18.1.6.3, “Replication Slave Options and Variables”
Section 18.4.1.28, “Slave Errors During Replication”

--slave-sql-verify-checksum

Section 18.1.6.4, “Binary Logging Options and Variables”
Section 18.1.6.3, “Replication Slave Options and Variables”

--slave_compressed_protocol

Section 18.1.6.3, “Replication Slave Options and Variables”

--slave_net-timeout

Section 18.2.3.3, “Startup Options and Replication Channels”

--sleep

Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”

--slow-query-log

Section 5.1.4, “Server Command Options”

--slow-start-timeout

Section 5.1.4, “Server Command Options”

--slow_query_log

Section 5.4.1, “Selecting General Query and Slow Query Log Output Destinations”
Section 5.1.4, “Server Command Options”
Section 5.1.5, “Server System Variables”
Section 5.4.5, “The Slow Query Log”

--slow_query_log_file

Section 5.7, “Running Multiple MySQL Instances on One Machine”
Section 5.4.5, “The Slow Query Log”

--socket

Section B.5.2.2, “Can't connect to [local] MySQL server”
Section 4.2.2, “Connecting to the MySQL Server”
Section 19.2.1.2, “Connecting using Individual Parameters”
Section B.5.3.6, “How to Protect or Change the MySQL Unix Socket File”
Section 4.2.1, “Invoking MySQL Programs”
Section 4.5.1.1, “mysql Options”
Section 19.2.1, “MySQL Shell Connections”
Section 2.8.4, “MySQL Source-Configuration Options”
Section 4.7.1, “mysql_config — Display Options for Compiling Clients”
Section 4.6.7, “mysql_config_editor — MySQL Configuration Utility”
Section 4.4.2, “mysql_secure_installation — Improve MySQL Installation Security”
Section 4.4.5, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”
Section 4.5.7, “mysqlsh — The MySQL Shell”
Section 4.5.8, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.9, “mysqlslap — Load Emulation Client”
Section 5.7, “Running Multiple MySQL Instances on One Machine”
Section 5.7.3, “Running Multiple MySQL Instances on Unix”
Section 5.1.4, “Server Command Options”
Section 28.2.4.2.1, “Server Plugin Library and Plugin Descriptors”
Section 2.3.5.9, “Testing The MySQL Installation”
Section 6.2.9, “Troubleshooting Problems Connecting to MySQL”
Section 5.7.4, “Using Client Programs in a Multiple-Server Environment”

socket

Section 4.6.7, “mysql_config_editor — MySQL Configuration Utility”
Section 4.2.6, “Using Option Files”

--sort-index

Section 7.6.4, “MyISAM Table Optimization”
Section 4.6.4.4, “Other myisamchk Options”

--sort-records

Section 7.6.4, “MyISAM Table Optimization”
Section 4.6.4.4, “Other myisamchk Options”

--sort-recover

Section 4.6.4.1, “myisamchk General Options”
Section 4.6.4.6, “myisamchk Memory Usage”
Section 4.6.4.3, “myisamchk Repair Options”

--sort_buffer_size

Section 5.1.4, “Server Command Options”

--sporadic-binlog-dump-fail

Section 18.1.6.4, “Binary Logging Options and Variables”

--sql

Section 19.3.4, “Active Language”
Section 4.5.7, “mysqlsh — The MySQL Shell”

--sql-mode

Chapter 12, Functions and Operators
Section A.3, “MySQL 8.0 FAQ: Server SQL Mode”
Section 4.5.9, “mysqlslap — Load Emulation Client”
Section 5.1.4, “Server Command Options”
Section 5.1.8, “Server SQL Modes”

sql-mode

Section 5.1.8, “Server SQL Modes”

--sqlc

Section 4.5.7, “mysqlsh — The MySQL Shell”

--sqln

Section 4.5.7, “mysqlsh — The MySQL Shell”

--ssl

Section 6.4.2, “Command Options for Encrypted Connections”
Section 6.4.1, “Configuring MySQL to Use Encrypted Connections”
Section 4.2.2, “Connecting to the MySQL Server”
Section 6.4.3.1, “Creating SSL and RSA Certificates and Keys using MySQL”
Section 4.5.1.1, “mysql Options”
Section 4.4.2, “mysql_secure_installation — Improve MySQL Installation Security”
Section 4.4.3, “mysql_ssl_rsa_setup — Create SSL/RSA Files”
Section 4.4.5, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”
Section 4.5.7, “mysqlsh — The MySQL Shell”
Section 4.5.8, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.9, “mysqlslap — Load Emulation Client”
Section 5.1.4, “Server Command Options”
Section 5.1.5, “Server System Variables”
Section 19.2.1.3, “Using Encrypted Connections”
Section 1.4, “What Is New in MySQL 8.0”

--ssl*

Section 4.2.2, “Connecting to the MySQL Server”
Section 4.5.1.1, “mysql Options”
Section 4.4.2, “mysql_secure_installation — Improve MySQL Installation Security”
Section 4.4.5, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”
Section 4.5.7, “mysqlsh — The MySQL Shell”
Section 4.5.8, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.9, “mysqlslap — Load Emulation Client”
Section 5.1.4, “Server Command Options”

--ssl-ca

Section 13.7.1.1, “ALTER USER Syntax”
Section 6.4.2, “Command Options for Encrypted Connections”
Section 6.4.1, “Configuring MySQL to Use Encrypted Connections”
Section 13.7.1.3, “CREATE USER Syntax”
Section 6.4.3.2, “Creating SSL Certificates and Keys Using openssl”
Section 4.4.3, “mysql_ssl_rsa_setup — Create SSL/RSA Files”
Section 4.5.7, “mysqlsh — The MySQL Shell”
Section 19.2.1.3, “Using Encrypted Connections”

ssl-ca

Section 18.3.9, “Setting Up Replication to Use Encrypted Connections”

--ssl-capath

Section 6.4.2, “Command Options for Encrypted Connections”
Section 4.5.7, “mysqlsh — The MySQL Shell”
Section 6.4.4, “OpenSSL Versus yaSSL”
Section 19.2.1.3, “Using Encrypted Connections”

--ssl-cert

Section 13.7.1.1, “ALTER USER Syntax”
Section 6.4.2, “Command Options for Encrypted Connections”
Section 6.4.1, “Configuring MySQL to Use Encrypted Connections”
Section 13.7.1.3, “CREATE USER Syntax”
Section 6.4.3.2, “Creating SSL Certificates and Keys Using openssl”
Section 4.4.3, “mysql_ssl_rsa_setup — Create SSL/RSA Files”
Section 4.5.7, “mysqlsh — The MySQL Shell”
Section 19.2.1.3, “Using Encrypted Connections”

ssl-cert

Section 18.3.9, “Setting Up Replication to Use Encrypted Connections”

--ssl-cipher

Section 6.4.2, “Command Options for Encrypted Connections”
Section 6.4.1, “Configuring MySQL to Use Encrypted Connections”
Section 6.4.6, “Encrypted Connection Protocols and Ciphers”
Section 4.4.3, “mysql_ssl_rsa_setup — Create SSL/RSA Files”
Section 4.5.7, “mysqlsh — The MySQL Shell”
Section 6.4.4, “OpenSSL Versus yaSSL”
Section 19.2.1.3, “Using Encrypted Connections”

--ssl-crl

Section 6.4.2, “Command Options for Encrypted Connections”
Section 4.5.7, “mysqlsh — The MySQL Shell”
Section 6.4.4, “OpenSSL Versus yaSSL”
Section 19.2.1.3, “Using Encrypted Connections”

--ssl-crlpath

Section 6.4.2, “Command Options for Encrypted Connections”
Section 4.5.7, “mysqlsh — The MySQL Shell”
Section 6.4.4, “OpenSSL Versus yaSSL”
Section 19.2.1.3, “Using Encrypted Connections”

--ssl-key

Section 13.7.1.1, “ALTER USER Syntax”
Section 6.4.2, “Command Options for Encrypted Connections”
Section 6.4.1, “Configuring MySQL to Use Encrypted Connections”
Section 13.7.1.3, “CREATE USER Syntax”
Section 6.4.3.2, “Creating SSL Certificates and Keys Using openssl”
Section 4.4.3, “mysql_ssl_rsa_setup — Create SSL/RSA Files”
Section 4.5.7, “mysqlsh — The MySQL Shell”
Section 19.2.1.3, “Using Encrypted Connections”

ssl-key

Section 18.3.9, “Setting Up Replication to Use Encrypted Connections”

--ssl-mode

Section 13.7.1.1, “ALTER USER Syntax”
Section 6.4.2, “Command Options for Encrypted Connections”
Section 6.4.1, “Configuring MySQL to Use Encrypted Connections”
Section 13.7.1.3, “CREATE USER Syntax”
Section 27.7.7.50, “mysql_options()”
Section 4.5.7, “mysqlsh — The MySQL Shell”
Section 6.1.6, “Security Issues with LOAD DATA LOCAL”
Section 19.2.1.3, “Using Encrypted Connections”
Section 1.4, “What Is New in MySQL 8.0”

--ssl-verify-server-cert

Section 1.4, “What Is New in MySQL 8.0”

--ssl-xxx

Section 6.4.5, “Building MySQL with Support for Encrypted Connections”
Section 13.4.2.1, “CHANGE MASTER TO Syntax”
Section 6.4.2, “Command Options for Encrypted Connections”
Section 6.4.1, “Configuring MySQL to Use Encrypted Connections”
Section 5.1.5, “Server System Variables”

--standalone

Section 28.5.1.2, “Creating Trace Files”
Section 5.1.4, “Server Command Options”
Section 2.3.5.6, “Starting MySQL from the Windows Command Line”

--start-datetime

Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 7.5.1, “Point-in-Time Recovery Using Event Times”

--start-page

Section 4.6.2, “innochecksum — Offline InnoDB File Checksum Utility”

--start-position

Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 7.5.2, “Point-in-Time Recovery Using Event Positions”

--statefile

Section 4.4.1, “comp_err — Compile MySQL Error Message File”

--static

Section 27.7.4.2, “Building C API Client Programs Using pkg-config”

--stats

Section 4.6.3, “myisam_ftdump — Display Full-Text Index information”

--status

Section 4.5.8, “mysqlshow — Display Database, Table, and Column Information”

--stop-datetime

Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 7.5.1, “Point-in-Time Recovery Using Event Times”

--stop-never

Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.8.4, “Specifying the mysqlbinlog Server ID”
Section 4.6.8.3, “Using mysqlbinlog to Back Up Binary Log Files”

--stop-never-slave-server-id

Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.8.4, “Specifying the mysqlbinlog Server ID”
Section 4.6.8.3, “Using mysqlbinlog to Back Up Binary Log Files”

--stop-position

Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 7.5.2, “Point-in-Time Recovery Using Event Positions”

--strict-check

Section 4.6.1, “ibd2sdi — InnoDB Tablespace SDI Extraction Utility”
Section 4.6.2, “innochecksum — Offline InnoDB File Checksum Utility”

--suffix

Section 6.4.3.1, “Creating SSL and RSA Certificates and Keys using MySQL”
Section 4.4.3, “mysql_ssl_rsa_setup — Create SSL/RSA Files”

--super-large-pages

Section 8.12.3.2, “Enabling Large Page Support”
Section 5.1.4, “Server Command Options”

--symbolic-links

Section 5.1.4, “Server Command Options”
Section 5.1.5, “Server System Variables”
Section 8.12.2.2, “Using Symbolic Links for MyISAM Tables on Unix”

--symbols-file

Section 4.7.3, “resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols”

SYSCONFDIR

Section 4.2.6, “Using Option Files”

--sysdate-is-now

Section 18.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 12.7, “Date and Time Functions”
Section 18.4.1.16, “Replication and System Functions”
Section 5.1.4, “Server Command Options”
Section 5.1.5, “Server System Variables”

--syslog

Section 2.5.9, “Managing MySQL Server with systemd”
Section 4.5.1.3, “mysql Logging”
Section 4.5.1.1, “mysql Options”
Section 4.9, “MySQL Program Environment Variables”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”

--syslog-tag

Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”

T

[index top]

-T

Section 4.4.1, “comp_err — Compile MySQL Error Message File”
Section 4.6.4.2, “myisamchk Check Options”
Section 4.6.6, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.5.1.1, “mysql Options”
Section 4.4.5, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”
Section 4.5.9, “mysqlslap — Load Emulation Client”
Section 5.1.4, “Server Command Options”

-t

Section 4.6.1, “ibd2sdi — InnoDB Tablespace SDI Extraction Utility”
Section 17.2.2.1, “memcached Command-Line Options”
Section 4.6.4.3, “myisamchk Repair Options”
Section 4.6.6, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.5.1.1, “mysql Options”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.6.9, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.5.6, “mysqlpump — A Database Backup Program”
Section 4.5.8, “mysqlshow — Display Database, Table, and Column Information”
Section 5.1.4, “Server Command Options”

--tab

Section 7.1, “Backup and Recovery Types”
Section 7.2, “Database Backup Methods”
Section 7.4.3, “Dumping Data in Delimited-Text Format with mysqldump”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 7.4, “Using mysqldump for Backups”

--table

Section 4.5.1.1, “mysql Options”
Section 4.5.7, “mysqlsh — The MySQL Shell”
Section 19.3.3.1, “Table Format”

--tables

Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”

--tc-heuristic-recover

Section 5.1.4, “Server Command Options”

--tcp-ip

Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”

--tee

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

--temp-pool

Section 5.1.4, “Server Command Options”
Section 1.4, “What Is New in MySQL 8.0”

--test

Section 4.6.6, “myisampack — Generate Compressed, Read-Only MyISAM Tables”

Text

Section 1.2, “Typographical and Syntax Conventions”

--thread_cache_size

Section 28.5.1.4, “Debugging mysqld under gdb”

--thread_stack

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

--timezone

Section 10.6, “MySQL Server Time Zone Support”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 18.4.1.32, “Replication and Time Zones”
Section 5.1.5, “Server System Variables”
Section B.5.3.7, “Time Zone Problems”

--tls-version

Section 6.4.2, “Command Options for Encrypted Connections”
Section 6.4.1, “Configuring MySQL to Use Encrypted Connections”
Section 4.2.2, “Connecting to the MySQL Server”
Section 6.4.6, “Encrypted Connection Protocols and Ciphers”
Section 4.5.1.1, “mysql Options”
Section 4.4.2, “mysql_secure_installation — Improve MySQL Installation Security”
Section 4.4.5, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”
Section 4.5.7, “mysqlsh — The MySQL Shell”
Section 4.5.8, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.9, “mysqlslap — Load Emulation Client”
Section 19.2.1.3, “Using Encrypted Connections”

--tmpdir

Section B.5.2.12, “Can't create/write to file”
Section 4.6.4.6, “myisamchk Memory Usage”
Section 4.6.4.3, “myisamchk Repair Options”
Section 4.6.6, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 5.7, “Running Multiple MySQL Instances on One Machine”
Section 5.1.4, “Server Command Options”
Section 2.3.5.8, “Starting MySQL as a Windows Service”
Section B.5.3.5, “Where MySQL Stores Temporary Files”

tmpdir

Section 2.3, “Installing MySQL on Microsoft Windows”

--to-last-log

Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.8.4, “Specifying the mysqlbinlog Server ID”
Section 4.6.8.3, “Using mysqlbinlog to Back Up Binary Log Files”

--transaction-isolation

Section 5.1.4, “Server Command Options”
Section 5.1.5, “Server System Variables”
Section 13.3.6, “SET TRANSACTION Syntax”
Section 15.5.2.1, “Transaction Isolation Levels”

--transaction-read-only

Section 5.1.4, “Server Command Options”
Section 5.1.5, “Server System Variables”
Section 13.3.6, “SET TRANSACTION Syntax”

--triggers

Section 7.4.5.3, “Dumping Stored Programs”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”

--type

Section 4.6.1, “ibd2sdi — InnoDB Tablespace SDI Extraction Utility”

--tz-utc

Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”

U

[index top]

-U

Section 17.2.2.1, “memcached Command-Line Options”
Section 4.6.4.2, “myisamchk Check Options”
Section 4.5.1.1, “mysql Options”

-u

Section 4.2.2, “Connecting to the MySQL Server”
Section 19.2.1.2, “Connecting using Individual Parameters”
Section 2.10.2, “Downgrading MySQL”
Section 4.2.1, “Invoking MySQL Programs”
Section 17.2.2.1, “memcached Command-Line Options”
Section 4.6.4.3, “myisamchk Repair Options”
Section 4.6.5, “myisamlog — Display MyISAM Log File Contents”
Section 4.5.1.1, “mysql Options”
Section 4.6.7, “mysql_config_editor — MySQL Configuration Utility”
Section 4.4.2, “mysql_secure_installation — Improve MySQL Installation Security”
Section 4.4.5, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”
Section 4.5.7, “mysqlsh — The MySQL Shell”
Section 4.5.8, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.9, “mysqlslap — Load Emulation Client”
Section 5.1.4, “Server Command Options”
Section 2.3.5.9, “Testing The MySQL Installation”
Section 2.9.3, “Testing the Server”
Section 2.10.1, “Upgrading MySQL”
Section 6.3.1, “User Names and Passwords”
Section 2.3.7, “Windows Postinstallation Procedures”

--uid

Section 6.4.3.1, “Creating SSL and RSA Certificates and Keys using MySQL”
Section 4.4.3, “mysql_ssl_rsa_setup — Create SSL/RSA Files”

--unbuffered

Section 4.5.1.1, “mysql Options”

--unpack

Section 16.2.3, “MyISAM Table Storage Formats”
Section 4.6.4.3, “myisamchk Repair Options”
Section 4.6.6, “myisampack — Generate Compressed, Read-Only MyISAM Tables”

--update-state

Section 7.6.3, “How to Repair MyISAM Tables”
Section 4.6.4.2, “myisamchk Check Options”
Section 16.2, “The MyISAM Storage Engine”

--upgrade-system-tables

Section 4.4.5, “mysql_upgrade — Check and Upgrade MySQL Tables”

--uri

Section 19.2.1.1, “Connecting using a URI String”
Section 19.2.1.2, “Connecting using Individual Parameters”
Section 4.5.7, “mysqlsh — The MySQL Shell”

--use-default

Section 4.4.2, “mysql_secure_installation — Improve MySQL Installation Security”

--use-frm

Section 4.5.3, “mysqlcheck — A Table Maintenance Program”

--use-threads

Section 4.5.5, “mysqlimport — A Data Import Program”

--user

Section 4.2.2, “Connecting to the MySQL Server”
Section 19.2.1.2, “Connecting using Individual Parameters”
Section 7.3, “Example Backup and Recovery Strategy”
Section B.5.2.17, “File Not Found and Similar Errors”
Section 6.1.5, “How to Run MySQL as a Normal User”
Section 2.9.1.1, “Initializing the Data Directory Manually Using mysqld”
Section 4.2.1, “Invoking MySQL Programs”
Section 6.1.3, “Making MySQL Secure Against Attackers”
Section 4.5.1.3, “mysql Logging”
Section 4.5.1.1, “mysql Options”
Section 4.6.7, “mysql_config_editor — MySQL Configuration Utility”
Section 4.4.2, “mysql_secure_installation — Improve MySQL Installation Security”
Section 4.4.5, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”
Section 4.5.7, “mysqlsh — The MySQL Shell”
Section 4.5.8, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.9, “mysqlslap — Load Emulation Client”
Section 4.2.9, “Option Defaults, Options Expecting Values, and the = Sign”
Section B.5.3.2.2, “Resetting the Root Password: Unix and Unix-Like Systems”
Section 5.1.4, “Server Command Options”
Section 6.5.1.5, “Socket Peer-Credential Pluggable Authentication”
Section 2.9.2, “Starting the Server”
Section 6.5.1.6, “Test Pluggable Authentication”
Section 6.3.1, “User Names and Passwords”
Section 4.6.8.3, “Using mysqlbinlog to Back Up Binary Log Files”
Section 4.2.6, “Using Option Files”

user

Section 4.6.7, “mysql_config_editor — MySQL Configuration Utility”
Section 4.2.6, “Using Option Files”

--users

Section 4.5.6, “mysqlpump — A Database Backup Program”

V

[index top]

-V

Section 4.4.1, “comp_err — Compile MySQL Error Message File”
Section 4.6.2, “innochecksum — Offline InnoDB File Checksum Utility”
Section 4.7.2, “my_print_defaults — Display Options from Option Files”
Section 4.6.4.1, “myisamchk General Options”
Section 4.6.5, “myisamlog — Display MyISAM Log File Contents”
Section 4.6.6, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.5.1.1, “mysql Options”
Section 4.6.7, “mysql_config_editor — MySQL Configuration Utility”
Section 4.4.3, “mysql_ssl_rsa_setup — Create SSL/RSA Files”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”
Section 4.5.7, “mysqlsh — The MySQL Shell”
Section 4.5.8, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.9, “mysqlslap — Load Emulation Client”
Section 4.8.2, “perror — Explain Error Codes”
Section 4.7.3, “resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols”
Section 4.8.3, “resolveip — Resolve Host name to IP Address or Vice Versa”
Section 5.1.4, “Server Command Options”
Section 4.2.4, “Using Options on the Command Line”

-v

Section 18.1.6.4, “Binary Logging Options and Variables”
Section 7.6.2, “How to Check MyISAM Tables for Errors”
Section 4.6.1, “ibd2sdi — InnoDB Tablespace SDI Extraction Utility”
Section 4.6.2, “innochecksum — Offline InnoDB File Checksum Utility”
Section 17.2.2.1, “memcached Command-Line Options”
Section 17.2.2.9, “memcached Logs”
Section 4.7.2, “my_print_defaults — Display Options from Option Files”
Section 4.6.3, “myisam_ftdump — Display Full-Text Index information”
Section 4.6.4.1, “myisamchk General Options”
Section 4.6.5, “myisamlog — Display MyISAM Log File Contents”
Section 4.6.6, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.5.1.1, “mysql Options”
Section 4.6.7, “mysql_config_editor — MySQL Configuration Utility”
Section 4.4.3, “mysql_ssl_rsa_setup — Create SSL/RSA Files”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.8.2, “mysqlbinlog Row Event Display”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.6.9, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.8, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.9, “mysqlslap — Load Emulation Client”
Section 4.6.4.5, “Obtaining Table Information with myisamchk”
Section 4.8.2, “perror — Explain Error Codes”
Section 5.1.4, “Server Command Options”
Section 4.2.4, “Using Options on the Command Line”

--validate-password

Section 6.5.3.1, “Password Validation Plugin Installation”
Section 6.5.3.2, “Password Validation Plugin Options and Variables”

--var_name

Section 15.13, “InnoDB Startup Options and System Variables”
Section 4.6.4.1, “myisamchk General Options”
Section 4.5.1.1, “mysql Options”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 5.1.4, “Server Command Options”

--variable

Section 27.7.4.2, “Building C API Client Programs Using pkg-config”
Section 4.7.1, “mysql_config — Display Options for Compiling Clients”

--verbose

Section 18.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 18.1.6.4, “Binary Logging Options and Variables”
Section 4.5.1.5, “Executing SQL Statements from a Text File”
Section 4.6.2, “innochecksum — Offline InnoDB File Checksum Utility”
Section 4.7.2, “my_print_defaults — Display Options from Option Files”
Section 4.6.3, “myisam_ftdump — Display Full-Text Index information”
Section 4.6.4.1, “myisamchk General Options”
Section 4.6.6, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.5.1.1, “mysql Options”
Section 4.6.7, “mysql_config_editor — MySQL Configuration Utility”
Section 4.4.3, “mysql_ssl_rsa_setup — Create SSL/RSA Files”
Section 4.4.5, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.8.2, “mysqlbinlog Row Event Display”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.6.9, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.8, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.9, “mysqlslap — Load Emulation Client”
Section 4.6.4.4, “Other myisamchk Options”
Section 4.8.2, “perror — Explain Error Codes”
Section 5.1.4, “Server Command Options”
Section 2.9.2.1, “Troubleshooting Problems Starting the MySQL Server”
Section 18.2.1.2, “Usage of Row-Based Logging and Replication”
Section 4.2.6, “Using Option Files”
Section 4.2.4, “Using Options on the Command Line”

--verify-binlog-checksum

Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”

--version

Section 4.4.1, “comp_err — Compile MySQL Error Message File”
Section 4.6.1, “ibd2sdi — InnoDB Tablespace SDI Extraction Utility”
Section 4.6.2, “innochecksum — Offline InnoDB File Checksum Utility”
Section 4.7.2, “my_print_defaults — Display Options from Option Files”
Section 4.6.4.1, “myisamchk General Options”
Section 4.6.6, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.5.1.1, “mysql Options”
Section 4.7.1, “mysql_config — Display Options for Compiling Clients”
Section 4.6.7, “mysql_config_editor — MySQL Configuration Utility”
Section 4.4.3, “mysql_ssl_rsa_setup — Create SSL/RSA Files”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”
Section 4.5.7, “mysqlsh — The MySQL Shell”
Section 4.5.8, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.9, “mysqlslap — Load Emulation Client”
Section 4.8.2, “perror — Explain Error Codes”
Section 4.7.3, “resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols”
Section 4.8.3, “resolveip — Resolve Host name to IP Address or Vice Versa”
Section 5.1.4, “Server Command Options”
Section 4.2.4, “Using Options on the Command Line”

--version-check

Section 4.4.5, “mysql_upgrade — Check and Upgrade MySQL Tables”

--vertical

Section 1.7, “How to Report Bugs or Problems”
Section 4.5.1.1, “mysql Options”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.7, “mysqlsh — The MySQL Shell”

W

[index top]

-W

Section 4.2.2, “Connecting to the MySQL Server”
Section 4.5.1.1, “mysql Options”
Section 4.4.5, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.8, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.9, “mysqlslap — Load Emulation Client”
Section 5.1.4, “Server Command Options”

-w

Section 4.6.2, “innochecksum — Offline InnoDB File Checksum Utility”
Section 4.6.4.1, “myisamchk General Options”
Section 4.6.5, “myisamlog — Display MyISAM Log File Contents”
Section 4.6.6, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.5.1.1, “mysql Options”
Section 4.6.7, “mysql_config_editor — MySQL Configuration Utility”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.4, “mysqldump — A Database Backup Program”

--wait

Section 4.6.4.1, “myisamchk General Options”
Section 4.6.6, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.5.1.1, “mysql Options”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”

--warn

Section 4.6.7, “mysql_config_editor — MySQL Configuration Utility”

--watch-progress

Section 4.5.6, “mysqlpump — A Database Backup Program”

--where

Section 4.5.4, “mysqldump — A Database Backup Program”

--with-libevent

Section 17.2.1, “Installing memcached

WITH_BOOST

Section 2.8, “Installing MySQL from Source”
Section 2.8.4, “MySQL Source-Configuration Options”

WITH_CLIENT_PROTOCOL_TRACING

Section 2.8.4, “MySQL Source-Configuration Options”

WITH_DEBUG

Section 15.13, “InnoDB Startup Options and System Variables”
Section 4.5.1.1, “mysql Options”
Section 2.8.4, “MySQL Source-Configuration Options”

WITH_EMBEDDED_SERVER

Section 1.4, “What Is New in MySQL 8.0”

WITH_EMBEDDED_SHARED_LIBRARY

Section 1.4, “What Is New in MySQL 8.0”

WITH_LZ4

Section 2.8.4, “MySQL Source-Configuration Options”

WITH_MECAB

Section 12.9.9, “MeCab Full-Text Parser Plugin”

WITH_NUMA

Section 15.13, “InnoDB Startup Options and System Variables”
Section 2.8.4, “MySQL Source-Configuration Options”

WITH_SYSTEMD

Section 2.8.4, “MySQL Source-Configuration Options”

WITH_TEST_TRACE_PLUGIN

Section 2.8.4, “MySQL Source-Configuration Options”
Section 28.2.4.11.1, “Using the Test Protocol Trace Plugin”
Section 28.2.4.11.2, “Using Your Own Protocol Trace Plugins”

WITH_ZLIB

Section 2.8.4, “MySQL Source-Configuration Options”

--write

Section 4.6.2, “innochecksum — Offline InnoDB File Checksum Utility”

--write-binlog

Section 4.4.5, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 18.1.3.4, “Restrictions on Replication with GTIDs”

X

[index top]

-X

Section 4.5.1.2, “mysql Commands”
Section 4.5.1.1, “mysql Options”
Section 4.5.4, “mysqldump — A Database Backup Program”

--x

Section 19.2.2.1, “MySQL Shell Sessions Explained”

-x

Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.9, “mysqlslap — Load Emulation Client”

--xml

Section 13.2.8, “LOAD XML Syntax”
Section 4.5.1.1, “mysql Options”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 12.11, “XML Functions”

Y

[index top]

-Y

Section 4.5.4, “mysqldump — A Database Backup Program”

-y

Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.9, “mysqlslap — Load Emulation Client”