Related Documentation Download this Manual
PDF (US Ltr) - 45.9Mb
PDF (A4) - 46.0Mb
PDF (RPM) - 41.4Mb
HTML Download (TGZ) - 10.6Mb
HTML Download (Zip) - 10.6Mb
HTML Download (RPM) - 9.1Mb
Man Pages (TGZ) - 218.8Kb
Man Pages (Zip) - 324.0Kb
Info (Gzip) - 4.1Mb
Info (Zip) - 4.1Mb
Excerpts from this Manual

MySQL 8.0 Reference Manual  /  Indexes  /  Option Index

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

Symbols

[index top]

-?

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 Client 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.7, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.8, “mysqlslap — Load Emulation Client”
Section 22.4.7, “ndb_config — Extract NDB Cluster Configuration Information”
Section 22.4.16, “ndb_perror — Obtain NDB Error Message Information”
Section 22.4.18, “ndb_print_file — Print NDB Disk Data File Contents”
Section 22.4.29, “ndb_top — View CPU usage information for NDB threads”
Section 22.4.31, “Options Common to NDB Cluster Programs — Options Common to NDB Cluster Programs”
Section 4.8.2, “perror — Display MySQL Error Message Information”
Section 5.1.7, “Server Command Options”
Section 1.3.2, “The Main Features of MySQL”
Section 4.2.2.1, “Using Options on the Command Line”

A

[index top]

--auto-generate-sql-add-autoincrement

Section 4.5.8, “mysqlslap — Load Emulation Client”

--auto-generate-sql-secondary-indexes

Section 4.5.8, “mysqlslap — Load Emulation Client”

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

Section 4.5.8, “mysqlslap — Load Emulation Client”

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

Section 4.5.8, “mysqlslap — Load Emulation Client”

B

[index top]

C

[index top]

--connection-control-failed-login-attempts

Section 6.4.2.1, “Connection-Control Plugin Installation”

D

[index top]

-D

Section 10.12, “Adding a Character Set”
Section 6.3.5, “Building MySQL with Support for Encrypted Connections”
Section 22.2.2.4, “Building NDB Cluster from Source on Linux”
Section B.4.2.16, “Can't initialize character set”
Section 4.4.1, “comp_err — Compile MySQL Error Message File”
Section 22.2.3.2, “Compiling and Installing NDB Cluster from Source on Windows”
Section 29.5.1.1, “Compiling MySQL for Debugging”
Section 29.5.2, “Debugging a MySQL Client”
Section 20.5.2, “Disabling X Plugin”
Section 4.6.2, “innochecksum — Offline InnoDB File Checksum Utility”
Section 2.9.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 4.6.4.3, “myisamchk Repair Options”
Section A.2, “MySQL 8.0 FAQ: Storage Engines”
Section 4.5.1.1, “mysql Client Options”
Chapter 22, MySQL NDB Cluster 8.0
Section 22.5.4, “MySQL Server Usage for NDB Cluster”
Section 2.9.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 22.4.24, “ndb_select_all — Print Rows from an NDB Table”
Section 17.1.6.3, “Replication Slave Options and Variables”
Section 5.1.7, “Server Command Options”
Section 5.1.8, “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 29.5.3, “The LOCK_ORDER Tool”
Section 22.1.4, “What is New in NDB Cluster”
Section B.4.3.3, “What to Do If MySQL Keeps Crashing”
Section 2.1.1, “Which MySQL Version and Distribution to Install”
Section 4.8.3, “zlib_decompress — Decompress mysqlpump ZLIB-Compressed Output”

-d

Section 2.5.6.1, “Basic Steps for MySQL Server Deployment with Docker”
Section 4.6.1, “ibd2sdi — InnoDB Tablespace SDI Extraction Utility”
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 22.4.6, “ndb_blob_tool — Check and Repair BLOB and TEXT columns of NDB Cluster Tables”
Section 22.4.9, “ndb_desc — Describe NDB Tables”
Section 22.4.14, “ndb_index_stat — NDB Index Statistics Utility”
Section 22.4.4, “ndb_mgmd — The NDB Cluster Management Server Daemon”
Section 22.4.15, “ndb_move_data — NDB Data Copy Utility”
Section 22.4.22, “ndb_redo_log_reader — Check and Print Content of Cluster Redo Log”
Section 22.4.23, “ndb_restore — Restore an NDB Cluster Backup”
Section 22.4.24, “ndb_select_all — Print Rows from an NDB Table”
Section 22.4.26, “ndb_setup.py — Start browser-based Auto-Installer for NDB Cluster”
Section 22.4.27, “ndb_show_tables — Display List of NDB Tables”
Section 22.4.1, “ndbd — The NDB Cluster Data Node Daemon”
Section 4.6.4.4, “Other myisamchk Options”
Section 5.1.8, “Server System Variables”
Section 6.4.4.4, “Using the keyring_okv KMIP Plugin”

--debug

Section 4.4.1, “comp_err — Compile MySQL Error Message File”
Section 29.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 Client Options”
Section 2.9.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.7, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.8, “mysqlslap — Load Emulation Client”
Section 22.4.31, “Options Common to NDB Cluster Programs — Options Common to NDB Cluster Programs”
Section 5.1.7, “Server Command Options”
Section 5.1.8, “Server System Variables”
Section 2.3.5.6, “Starting MySQL from the Windows Command Line”
Section 29.5.4, “The DBUG Package”
Section 6.2.21, “Troubleshooting Problems Connecting to MySQL”
Section 2.10.2.1, “Troubleshooting Problems Starting the MySQL Server”

--default-authentication-plugin

Section 2.11.4, “Changes in MySQL 8.0”

--defaults-extra-file

Section 4.2.2.3, “Command-Line Options that Affect Option-File Handling”
Section 2.10.1, “Initializing the Data Directory”
Section 21.5, “Known Limitations”
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 Client 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.7, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.8, “mysqlslap — Load Emulation Client”
Section 22.4.29, “ndb_top — View CPU usage information for NDB threads”
Section 22.4.31, “Options Common to NDB Cluster Programs — Options Common to NDB Cluster Programs”
Section 26.12.13.2, “Performance Schema variables_info Table”
Section 5.1.7, “Server Command Options”
Section 4.2.2.2, “Using Option Files”

--defaults-file

Section 2.11.4, “Changes in MySQL 8.0”
Section 4.2.2.3, “Command-Line Options that Affect Option-File Handling”
Section 6.1.2.1, “End-User Guidelines for Password Security”
Section 2.10.1, “Initializing the Data Directory”
Section 15.8.1, “InnoDB Startup Configuration”
Section 6.4.4.6, “Migrating Keys Between Keyring Keystores”
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 Client Options”
Section 2.9.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.7, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.8, “mysqlslap — Load Emulation Client”
Section 22.4.29, “ndb_top — View CPU usage information for NDB threads”
Section 22.4.31, “Options Common to NDB Cluster Programs — Options Common to NDB Cluster Programs”
Section 26.12.13.2, “Performance Schema variables_info Table”
Section B.4.3.2.2, “Resetting the Root Password: Unix and Unix-Like Systems”
Section B.4.3.2.1, “Resetting the Root Password: Windows Systems”
Section 5.8, “Running Multiple MySQL Instances on One Machine”
Section 5.8.3, “Running Multiple MySQL Instances on Unix”
Section 5.1.7, “Server Command Options”
Section 5.1.3, “Server Configuration Validation”
Section 5.8.2.2, “Starting Multiple MySQL Instances as Windows Services”
Section 5.8.2.1, “Starting Multiple MySQL Instances at the Windows Command Line”
Section 2.3.5.8, “Starting MySQL as a Windows Service”

E

[index top]

F

[index top]

G

[index top]

H

[index top]

-h

Section 4.2.3, “Connecting to the MySQL Server”
Section 4.6.1, “ibd2sdi — InnoDB Tablespace SDI Extraction Utility”
Section 4.2.1, “Invoking MySQL Programs”
Section 4.6.3, “myisam_ftdump — Display Full-Text Index information”
Section 4.5.1.1, “mysql Client 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, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.8, “mysqlslap — Load Emulation Client”
Section 22.4.18, “ndb_print_file — Print NDB Disk Data File Contents”
Section 22.4.26, “ndb_setup.py — Start browser-based Auto-Installer for NDB Cluster”
Section 22.4.29, “ndb_top — View CPU usage information for NDB threads”
Section 5.1.7, “Server Command Options”
Section 1.2, “Typographical and Syntax Conventions”
Section 4.2.2.1, “Using Options on the Command Line”

--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 22.2.3.4, “Installing NDB Cluster Processes as Windows Services”
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 Client 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, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.8, “mysqlslap — Load Emulation Client”
Section 22.4.6, “ndb_blob_tool — Check and Repair BLOB and TEXT columns of NDB Cluster Tables”
Section 22.4.7, “ndb_config — Extract NDB Cluster Configuration Information”
Section 22.4.16, “ndb_perror — Obtain NDB Error Message Information”
Section 22.4.18, “ndb_print_file — Print NDB Disk Data File Contents”
Section 22.4.22, “ndb_redo_log_reader — Check and Print Content of Cluster Redo Log”
Section 22.4.26, “ndb_setup.py — Start browser-based Auto-Installer for NDB Cluster”
Section 22.4.29, “ndb_top — View CPU usage information for NDB threads”
Section 22.4.31, “Options Common to NDB Cluster Programs — Options Common to NDB Cluster Programs”
Section 4.1, “Overview of MySQL Programs”
Section 4.8.2, “perror — Display MySQL Error Message Information”
Section 5.1.7, “Server Command Options”
Section 2.10.3, “Testing the Server”
Section 1.3.2, “The Main Features of MySQL”
Section 2.10.2.1, “Troubleshooting Problems Starting the MySQL Server”
Chapter 3, Tutorial
Section 4.2.2.2, “Using Option Files”
Section 4.2.2.1, “Using Options on the Command Line”

--host

Section 4.2.3, “Connecting to the MySQL Server”
Section 2.10.1, “Initializing the Data Directory”
Section 4.2.1, “Invoking MySQL Programs”
Section 4.5.1.1, “mysql Client 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, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.8, “mysqlslap — Load Emulation Client”
Section 22.4.7, “ndb_config — Extract NDB Cluster Configuration Information”
Section 22.4.29, “ndb_top — View CPU usage information for NDB threads”
Section 4.2.2.6, “Option Defaults, Options Expecting Values, and the = Sign”
Section 5.1.7, “Server Command Options”
Section 5.1.8, “Server System Variables”
Section 6.2.21, “Troubleshooting Problems Connecting to MySQL”
Section 1.2, “Typographical and Syntax Conventions”
Section 5.8.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.2.2, “Using Option Files”
Section 4.2.2.1, “Using Options on the Command Line”
Section 20.5.5.2, “X Plugin Options and System Variables”

I

[index top]

INSTALL_SECURE_FILE_PRIV_EMBEDDEDDIR

Section 1.4, “What Is New in MySQL 8.0”

INSTALL_SECURE_FILE_PRIVDIR

Section 5.1.8, “Server System Variables”

J

[index top]

K

[index top]

L

[index top]

--log-queries-not-using-indexes

Section 5.1.7, “Server Command Options”

M

[index top]

--maximum-innodb-log-file-size

Section 5.1.9, “Using System Variables”

--maximum-max_heap_table_size

Section 4.2.2.4, “Program Option Modifiers”

N

[index top]

--no-defaults

Section 4.2.2.3, “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 Client 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, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.8, “mysqlslap — Load Emulation Client”
Section 22.4.29, “ndb_top — View CPU usage information for NDB threads”
Section 22.4.31, “Options Common to NDB Cluster Programs — Options Common to NDB Cluster Programs”
Section 5.1.9.3, “Persisted System Variables”
Section 5.1.7, “Server Command Options”
Section 6.2.21, “Troubleshooting Problems Connecting to MySQL”
Section 4.2.2.2, “Using Option Files”

O

[index top]

P

[index top]

-p

Section 6.2.1, “Account User Names and Passwords”
Section 22.5.15.3, “Adding NDB Cluster Data Nodes Online: Detailed Example”
Section 4.2.3, “Connecting to the MySQL Server”
Section 6.1.2.1, “End-User Guidelines for Password Security”
Section 4.6.1, “ibd2sdi — InnoDB Tablespace SDI Extraction Utility”
Section 4.6.2, “innochecksum — Offline InnoDB File Checksum Utility”
Section 4.2.1, “Invoking MySQL Programs”
Section 23.2.5, “KEY Partitioning”
Section 4.6.4.3, “myisamchk Repair Options”
Section 4.6.5, “myisamlog — Display MyISAM Log File Contents”
Section 4.5.1.1, “mysql Client 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, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.8, “mysqlslap — Load Emulation Client”
Section 22.4.9, “ndb_desc — Describe NDB Tables”
Section 22.4.22, “ndb_redo_log_reader — Check and Print Content of Cluster Redo Log”
Section 22.4.23, “ndb_restore — Restore an NDB Cluster Backup”
Section 22.4.24, “ndb_select_all — Print Rows from an NDB Table”
Section 22.4.26, “ndb_setup.py — Start browser-based Auto-Installer for NDB Cluster”
Section 22.4.27, “ndb_show_tables — Display List of NDB Tables”
Section 22.4.29, “ndb_top — View CPU usage information for NDB threads”
Section B.4.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.10.3, “Testing the Server”
Section 22.5.10.5, “The ndbinfo cluster_operations Table”
Section 22.5.10.34, “The ndbinfo server_operations Table”
Section 6.2.21, “Troubleshooting Problems Connecting to MySQL”
Section 2.11, “Upgrading MySQL”
Section 2.11.10, “Upgrading MySQL on Windows”
Section 4.2.2.1, “Using Options on the Command Line”
Section 2.3.7, “Windows Postinstallation Procedures”

--password

Section 6.2.1, “Account User Names and Passwords”
Section 4.2.3, “Connecting to the MySQL Server”
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 Client 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.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, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.8, “mysqlslap — Load Emulation Client”
Section 22.4.29, “ndb_top — View CPU usage information for NDB threads”
Section B.4.2.4, “Password Fails When Entered Interactively”
Section 22.4.23.1.2, “Restoring to More Nodes Than the Original”
Section 6.4.1.10, “Test Pluggable Authentication”
Section 6.2.21, “Troubleshooting Problems Connecting to MySQL”
Section 4.6.8.3, “Using mysqlbinlog to Back Up Binary Log Files”
Section 4.2.2.1, “Using Options on the Command Line”

--performance-schema-consumer-consumer_name

Section 26.14, “Performance Schema Command Options”

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

Section 26.14, “Performance Schema Command Options”

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

Section 26.14, “Performance Schema Command Options”

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

Section 26.14, “Performance Schema Command Options”

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

Section 26.14, “Performance Schema Command Options”

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

Section 26.14, “Performance Schema Command Options”

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

Section 26.14, “Performance Schema Command Options”

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

Section 26.14, “Performance Schema Command Options”

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

Section 26.14, “Performance Schema Command Options”

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

Section 26.14, “Performance Schema Command Options”

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

Section 26.14, “Performance Schema Command Options”

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

Section 26.14, “Performance Schema Command Options”

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

Section 26.14, “Performance Schema Command Options”

--performance-schema-consumer-global-instrumentation

Section 26.14, “Performance Schema Command Options”

--performance-schema-consumer-statements-digest

Section 26.14, “Performance Schema Command Options”

--performance-schema-consumer-thread-instrumentation

Section 26.14, “Performance Schema Command Options”

--performance_schema_max_mutex_classes

Section 26.7, “Performance Schema Status Monitoring”

--performance_schema_max_mutex_instances

Section 26.7, “Performance Schema Status Monitoring”

--plugin-innodb-file-per-table

Section 5.1.7, “Server Command Options”

--port

Section 4.2.3, “Connecting to the MySQL Server”
Section 4.2.1, “Invoking MySQL Programs”
Section 4.5.1.1, “mysql Client Options”
Section 2.9.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, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.8, “mysqlslap — Load Emulation Client”
Section 22.4.26, “ndb_setup.py — Start browser-based Auto-Installer for NDB Cluster”
Section 22.4.29, “ndb_top — View CPU usage information for NDB threads”
Section 5.8, “Running Multiple MySQL Instances on One Machine”
Section 5.8.3, “Running Multiple MySQL Instances on Unix”
Section 5.1.7, “Server Command Options”
Section 5.1.8, “Server System Variables”
Section 6.2.21, “Troubleshooting Problems Connecting to MySQL”
Section 2.10.2.1, “Troubleshooting Problems Starting the MySQL Server”
Section 5.8.4, “Using Client Programs in a Multiple-Server Environment”

Q

[index top]

R

[index top]

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

Section 17.1.6.3, “Replication Slave Options and Variables”

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

Section 17.1.6.3, “Replication Slave Options and Variables”

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

Section 17.1.6.3, “Replication Slave Options and Variables”

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

Section 17.1.6.3, “Replication Slave Options and Variables”

S

[index top]

-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 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 Client 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.8, “mysqlslap — Load Emulation Client”
Section 22.4.16, “ndb_perror — Obtain NDB Error Message Information”
Section 22.4.23, “ndb_restore — Restore an NDB Cluster Backup”
Section 22.4.26, “ndb_setup.py — Start browser-based Auto-Installer for NDB Cluster”
Section 22.4.29, “ndb_top — View CPU usage information for NDB threads”
Section 4.8.2, “perror — Display MySQL Error Message Information”
Section 7.6.5, “Setting Up a MyISAM Table Maintenance Schedule”

--skip-plugin-innodb-file-per-table

Section 5.1.7, “Server Command Options”

--socket

Section B.4.2.2, “Can't connect to [local] MySQL server”
Section 4.2.3, “Connecting to the MySQL Server”
Section 2.5.6.3, “Deploying MySQL on Windows and Other Non-Linux Platforms with Docker”
Section B.4.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 Client Options”
Section 2.9.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, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.8, “mysqlslap — Load Emulation Client”
Section 22.4.29, “ndb_top — View CPU usage information for NDB threads”
Section 5.8, “Running Multiple MySQL Instances on One Machine”
Section 5.8.3, “Running Multiple MySQL Instances on Unix”
Section 5.1.7, “Server Command Options”
Section 29.2.4.2.1, “Server Plugin Library and Plugin Descriptors”
Section 2.3.5.9, “Testing The MySQL Installation”
Section 6.2.21, “Troubleshooting Problems Connecting to MySQL”
Section 5.8.4, “Using Client Programs in a Multiple-Server Environment”

T

[index top]

U

[index top]

-u

Section 6.2.1, “Account User Names and Passwords”
Section 4.2.3, “Connecting to the MySQL Server”
Section 4.2.1, “Invoking MySQL Programs”
Section 4.6.4.3, “myisamchk Repair Options”
Section 4.6.5, “myisamlog — Display MyISAM Log File Contents”
Section 4.5.1.1, “mysql Client 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, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.8, “mysqlslap — Load Emulation Client”
Section 22.4.9, “ndb_desc — Describe NDB Tables”
Section 22.4.23, “ndb_restore — Restore an NDB Cluster Backup”
Section 22.4.27, “ndb_show_tables — Display List of NDB Tables”
Section 22.4.29, “ndb_top — View CPU usage information for NDB threads”
Section 5.1.7, “Server Command Options”
Section 2.3.5.9, “Testing The MySQL Installation”
Section 2.10.3, “Testing the Server”
Section 2.11, “Upgrading MySQL”
Section 2.3.7, “Windows Postinstallation Procedures”

--user

Section 6.2.1, “Account User Names and Passwords”
Section 4.2.3, “Connecting to the MySQL Server”
Section 7.3, “Example Backup and Recovery Strategy”
Section B.4.2.17, “File Not Found and Similar Errors”
Section 6.1.5, “How to Run MySQL as a Normal User”
Section 2.10.1, “Initializing the Data Directory”
Section 4.2.1, “Invoking MySQL Programs”
Section 6.1.3, “Making MySQL Secure Against Attackers”
Section 6.4.4.6, “Migrating Keys Between Keyring Keystores”
Section 4.5.1.3, “mysql Client Logging”
Section 4.5.1.1, “mysql Client 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, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.8, “mysqlslap — Load Emulation Client”
Section 22.5.12.3, “NDB Cluster and MySQL Security Procedures”
Section 22.4.29, “ndb_top — View CPU usage information for NDB threads”
Section 4.2.2.6, “Option Defaults, Options Expecting Values, and the = Sign”
Section B.4.3.2.2, “Resetting the Root Password: Unix and Unix-Like Systems”
Section 22.4.23.1.2, “Restoring to More Nodes Than the Original”
Section 5.1.7, “Server Command Options”
Section 6.4.1.9, “Socket Peer-Credential Pluggable Authentication”
Section 2.10.2, “Starting the Server”
Section 6.4.1.10, “Test Pluggable Authentication”
Section 4.6.8.3, “Using mysqlbinlog to Back Up Binary Log Files”
Section 4.2.2.2, “Using Option Files”

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 Client 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, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.8, “mysqlslap — Load Emulation Client”
Section 22.4.7, “ndb_config — Extract NDB Cluster Configuration Information”
Section 22.4.16, “ndb_perror — Obtain NDB Error Message Information”
Section 22.4.31, “Options Common to NDB Cluster Programs — Options Common to NDB Cluster Programs”
Section 4.8.2, “perror — Display MySQL Error Message Information”
Section 5.1.7, “Server Command Options”
Section 4.2.2.1, “Using Options on the Command Line”
Section 22.1.4, “What is New in NDB Cluster”

-v

Section 17.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 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 Client 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.7, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.8, “mysqlslap — Load Emulation Client”
Section 22.4.13, “ndb_import — Import CSV Data Into NDB”
Section 22.4.4, “ndb_mgmd — The NDB Cluster Management Server Daemon”
Section 22.4.16, “ndb_perror — Obtain NDB Error Message Information”
Section 22.4.18, “ndb_print_file — Print NDB Disk Data File Contents”
Section 22.4.1, “ndbd — The NDB Cluster Data Node Daemon”
Section 4.6.4.5, “Obtaining Table Information with myisamchk”
Section 4.8.2, “perror — Display MySQL Error Message Information”
Section 5.1.7, “Server Command Options”
Section 4.2.2.1, “Using Options on the Command Line”
Section 6.4.4.4, “Using the keyring_okv KMIP Plugin”

--verbose

Section 17.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 17.1.6.4, “Binary Logging Options and Variables”
Section 22.5.2, “Commands in the NDB Cluster Management Client”
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 Client 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.7, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.8, “mysqlslap — Load Emulation Client”
Section 22.4.6, “ndb_blob_tool — Check and Repair BLOB and TEXT columns of NDB Cluster Tables”
Section 22.4.13, “ndb_import — Import CSV Data Into NDB”
Section 22.4.14, “ndb_index_stat — NDB Index Statistics Utility”
Section 22.4.4, “ndb_mgmd — The NDB Cluster Management Server Daemon”
Section 22.4.15, “ndb_move_data — NDB Data Copy Utility”
Section 22.4.16, “ndb_perror — Obtain NDB Error Message Information”
Section 22.4.23, “ndb_restore — Restore an NDB Cluster Backup”
Section 22.4.1, “ndbd — The NDB Cluster Data Node Daemon”
Section 4.6.4.4, “Other myisamchk Options”
Section 4.8.2, “perror — Display MySQL Error Message Information”
Section 5.1.7, “Server Command Options”
Section 2.10.2.1, “Troubleshooting Problems Starting the MySQL Server”
Section 17.2.1.2, “Usage of Row-Based Logging and Replication”
Section 4.2.2.2, “Using Option Files”
Section 4.2.2.1, “Using Options on the Command Line”

--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 Client 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, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.8, “mysqlslap — Load Emulation Client”
Section 22.4.7, “ndb_config — Extract NDB Cluster Configuration Information”
Section 22.4.16, “ndb_perror — Obtain NDB Error Message Information”
Section 22.4.31, “Options Common to NDB Cluster Programs — Options Common to NDB Cluster Programs”
Section 4.8.2, “perror — Display MySQL Error Message Information”
Section 5.1.7, “Server Command Options”
Section 4.2.2.1, “Using Options on the Command Line”

W

[index top]

WITH_EMBEDDED_SHARED_LIBRARY

Section 1.4, “What Is New in MySQL 8.0”

X

[index top]

Y

[index top]

Z

[index top]