Related Documentation Download this Manual
PDF (US Ltr) - 44.5Mb
PDF (A4) - 44.6Mb
PDF (RPM) - 40.3Mb
HTML Download (TGZ) - 10.5Mb
HTML Download (Zip) - 10.5Mb
HTML Download (RPM) - 9.1Mb
Man Pages (TGZ) - 204.6Kb
Man Pages (Zip) - 311.6Kb
Info (Gzip) - 3.9Mb
Info (Zip) - 3.9Mb
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 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.17, “ndb_perror — Obtain NDB Error Message Information”
Section 22.4.19, “ndb_print_file — Print NDB Disk Data File Contents”
Section 22.4.30, “ndb_top — View CPU usage information for NDB threads”
Section 22.4.32, “Options Common to NDB Cluster Programs — Options Common to NDB Cluster Programs”
Section 4.8.2, “perror — Display MySQL Error Message Information”
Section 4.8.3, “resolveip — Resolve Host name to IP Address or Vice Versa”
Section 5.1.7, “Server Command Options”
Section 1.3.2, “The Main Features of MySQL”
Section 4.2.5, “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”

--auto-vertical-output

Section 4.5.1.1, “mysql Options”

B

[index top]

C

[index top]

--connection-control-failed-login-attempts

Section 6.5.2.1, “Connection-Control Plugin Installation”

D

[index top]

-D

Section 10.12, “Adding a Character Set”
Section 6.4.5, “Building MySQL with Support for Encrypted Connections”
Section 22.2.2.4, “Building NDB Cluster from Source on Linux”
Section B.5.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”
Chapter 22, MySQL NDB Cluster 8.0
Section 4.5.1.1, “mysql Options”
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.25, “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 22.1.4, “What is New in NDB Cluster”
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 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.10, “ndb_desc — Describe NDB Tables”
Section 22.4.15, “ndb_index_stat — NDB Index Statistics Utility”
Section 22.4.4, “ndb_mgmd — The NDB Cluster Management Server Daemon”
Section 22.4.16, “ndb_move_data — NDB Data Copy Utility”
Section 22.4.23, “ndb_redo_log_reader — Check and Print Content of Cluster Redo Log”
Section 22.4.24, “ndb_restore — Restore an NDB Cluster Backup”
Section 22.4.25, “ndb_select_all — Print Rows from an NDB Table”
Section 22.4.27, “ndb_setup.py — Start browser-based Auto-Installer for NDB Cluster”
Section 22.4.28, “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.5.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 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.32, “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.3, “The DBUG Package”
Section 6.2.9, “Troubleshooting Problems Connecting to MySQL”
Section 2.10.2.1, “Troubleshooting Problems Starting the MySQL Server”

--default-authentication-plugin

Section 2.11.1.3, “Changes in MySQL 8.0”

--defaults-extra-file

Section 4.2.8, “Command-Line Options that Affect Option-File Handling”
Section 2.10.1.1, “Initializing the Data Directory Manually Using mysqld”
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 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.30, “ndb_top — View CPU usage information for NDB threads”
Section 22.4.32, “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.7, “Using Option Files”

--defaults-file

Section 2.11.1.3, “Changes in MySQL 8.0”
Section 4.2.8, “Command-Line Options that Affect Option-File Handling”
Section 6.1.2.1, “End-User Guidelines for Password Security”
Section 2.10.1.1, “Initializing the Data Directory Manually Using mysqld”
Section 15.8.1, “InnoDB Startup Configuration”
Section 6.5.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 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.30, “ndb_top — View CPU usage information for NDB threads”
Section 22.4.32, “Options Common to NDB Cluster Programs — Options Common to NDB Cluster Programs”
Section 26.12.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.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”

--disable-named-commands

Section 4.5.1.1, “mysql Options”

E

[index top]

F

[index top]

G

[index top]

H

[index top]

-h

Section 4.2.2, “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 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.19, “ndb_print_file — Print NDB Disk Data File Contents”
Section 22.4.27, “ndb_setup.py — Start browser-based Auto-Installer for NDB Cluster”
Section 22.4.30, “ndb_top — View CPU usage information for NDB threads”
Section 4.7.3, “resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols”
Section 5.1.7, “Server Command Options”
Section 1.2, “Typographical and Syntax Conventions”
Section 4.2.5, “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 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.17, “ndb_perror — Obtain NDB Error Message Information”
Section 22.4.19, “ndb_print_file — Print NDB Disk Data File Contents”
Section 22.4.23, “ndb_redo_log_reader — Check and Print Content of Cluster Redo Log”
Section 22.4.27, “ndb_setup.py — Start browser-based Auto-Installer for NDB Cluster”
Section 22.4.30, “ndb_top — View CPU usage information for NDB threads”
Section 22.4.32, “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 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.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.7, “Using Option Files”
Section 4.2.5, “Using Options on the Command Line”

--host

Section 4.2.2, “Connecting to the MySQL Server”
Section 2.10.1.1, “Initializing the Data Directory Manually Using mysqld”
Section 4.2.1, “Invoking MySQL Programs”
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, “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.30, “ndb_top — View CPU usage information for NDB threads”
Section 4.2.10, “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.9, “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.7, “Using Option Files”
Section 4.2.5, “Using Options on the Command Line”
Section 20.5.5.2, “X Plugin System Variables and Options”

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.6, “Program Option Modifiers”

N

[index top]

--no-defaults

Section 4.2.8, “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.7, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.8, “mysqlslap — Load Emulation Client”
Section 22.4.30, “ndb_top — View CPU usage information for NDB threads”
Section 22.4.32, “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.9, “Troubleshooting Problems Connecting to MySQL”
Section 4.2.7, “Using Option Files”

O

[index top]

P

[index top]

-p

Section 22.5.14.3, “Adding NDB Cluster Data Nodes Online: Detailed Example”
Section 6.3.2, “Adding User Accounts”
Section 4.2.2, “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 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.10, “ndb_desc — Describe NDB Tables”
Section 22.4.23, “ndb_redo_log_reader — Check and Print Content of Cluster Redo Log”
Section 22.4.24, “ndb_restore — Restore an NDB Cluster Backup”
Section 22.4.25, “ndb_select_all — Print Rows from an NDB Table”
Section 22.4.27, “ndb_setup.py — Start browser-based Auto-Installer for NDB Cluster”
Section 22.4.28, “ndb_show_tables — Display List of NDB Tables”
Section 22.4.30, “ndb_top — View CPU usage information for NDB threads”
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.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.9, “Troubleshooting Problems Connecting to MySQL”
Section 2.11.1, “Upgrading MySQL”
Section 2.3.8, “Upgrading MySQL on Windows”
Section 6.3.1, “User Names and Passwords”
Section 4.2.5, “Using Options on the Command Line”
Section 2.3.7, “Windows Postinstallation Procedures”

--password

Section 6.3.2, “Adding User Accounts”
Section 4.2.2, “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 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.30, “ndb_top — View CPU usage information for NDB threads”
Section B.5.2.4, “Password Fails When Entered Interactively”
Section 22.4.24.1.2, “Restoring to More Nodes Than the Original”
Section 6.5.1.10, “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.5, “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.2, “Connecting to the MySQL Server”
Section 4.2.1, “Invoking MySQL Programs”
Section 4.5.1.1, “mysql 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.27, “ndb_setup.py — Start browser-based Auto-Installer for NDB Cluster”
Section 22.4.30, “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.9, “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 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.17, “ndb_perror — Obtain NDB Error Message Information”
Section 22.4.24, “ndb_restore — Restore an NDB Cluster Backup”
Section 22.4.27, “ndb_setup.py — Start browser-based Auto-Installer for NDB Cluster”
Section 22.4.30, “ndb_top — View CPU usage information for NDB threads”
Section 4.8.2, “perror — Display MySQL Error Message Information”
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 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.5.2.2, “Can't connect to [local] MySQL server”
Section 4.2.2, “Connecting to the MySQL Server”
Section 2.5.6.3, “Deploying MySQL on Windows and Other Non-Linux Platforms with Docker”
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 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.30, “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.9, “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 4.2.2, “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 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.10, “ndb_desc — Describe NDB Tables”
Section 22.4.24, “ndb_restore — Restore an NDB Cluster Backup”
Section 22.4.28, “ndb_show_tables — Display List of NDB Tables”
Section 22.4.30, “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.1, “Upgrading MySQL”
Section 6.3.1, “User Names and Passwords”
Section 2.3.7, “Windows Postinstallation Procedures”

--user

Section 4.2.2, “Connecting to the MySQL Server”
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.10.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 6.5.4.6, “Migrating Keys Between Keyring Keystores”
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, “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.30, “ndb_top — View CPU usage information for NDB threads”
Section 4.2.10, “Option Defaults, Options Expecting Values, and the = Sign”
Section B.5.3.2.2, “Resetting the Root Password: Unix and Unix-Like Systems”
Section 22.4.24.1.2, “Restoring to More Nodes Than the Original”
Section 5.1.7, “Server Command Options”
Section 6.5.1.9, “Socket Peer-Credential Pluggable Authentication”
Section 2.10.2, “Starting the Server”
Section 6.5.1.10, “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.7, “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 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.17, “ndb_perror — Obtain NDB Error Message Information”
Section 22.4.32, “Options Common to NDB Cluster Programs — Options Common to NDB Cluster Programs”
Section 4.8.2, “perror — Display MySQL Error Message Information”
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.7, “Server Command Options”
Section 4.2.5, “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 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.14, “ndb_import — Import CSV Data Into NDB”
Section 22.4.4, “ndb_mgmd — The NDB Cluster Management Server Daemon”
Section 22.4.17, “ndb_perror — Obtain NDB Error Message Information”
Section 22.4.19, “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.5, “Using Options on the Command Line”
Section 6.5.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 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.14, “ndb_import — Import CSV Data Into NDB”
Section 22.4.15, “ndb_index_stat — NDB Index Statistics Utility”
Section 22.4.4, “ndb_mgmd — The NDB Cluster Management Server Daemon”
Section 22.4.16, “ndb_move_data — NDB Data Copy Utility”
Section 22.4.17, “ndb_perror — Obtain NDB Error Message Information”
Section 22.4.24, “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.7, “Using Option Files”
Section 4.2.5, “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 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.17, “ndb_perror — Obtain NDB Error Message Information”
Section 22.4.32, “Options Common to NDB Cluster Programs — Options Common to NDB Cluster Programs”
Section 4.8.2, “perror — Display MySQL Error Message Information”
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.7, “Server Command Options”
Section 4.2.5, “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]


User Comments
User comments in this section are, as the name implies, provided by MySQL users. The MySQL documentation team is not responsible for, nor do they endorse, any of the information provided here.
Sign Up Login You must be logged in to post a comment.