MySQL 5.4 Reference Manual :: Option Index
Section Navigation [Toggle]
- Preface, Notes, Licenses
- 1 General Information
- 2 Installing and Upgrading MySQL
- 3 Tutorial
- 4 MySQL Programs
- 5 MySQL Server Administration
- 6 Backup and Recovery
- 7 Optimization
- 8 Language Structure
- 9 Internationalization and Localization
- 10 Data Types
- 11 Functions and Operators
- 12 SQL Statement Syntax
- 13 Storage Engines
- 14 High Availability and Scalability
- 15 MySQL Enterprise Monitor
- 16 Replication
- 17 Partitioning
- 18 Stored Programs and Views
- 19 INFORMATION_SCHEMA Tables
- 20 Connectors and APIs
- 21 Extending MySQL
- A MySQL 5.4 Frequently Asked Questions
- B Errors, Error Codes, and Common Problems
- C MySQL Change History
- D Restrictions and Limits
- Index
- Standard Index
- C Function Index
- Command Index
- Function Index
- INFORMATION_SCHEMA Index
- Transaction Isolation Level Index
- JOIN Types Index
- Operator Index
- Option Index
- Privileges Index
- SQL Modes Index
- Status Variable Index
- Statement/Syntax Index
- System Variable Index
-
- Section 12.1.1, “
ALTER DATABASESyntax” - Section 12.4.1.3, “
GRANTSyntax” - Section 11.8.2, “Boolean Full-Text Searches”
- Section 10.6, “Choosing the Right Type for a Column”
- Section 11.6, “Date and Time Functions”
- Section 4.2.1, “Invoking MySQL Programs”
- Section 5.2.4.3, “Mixed Binary Logging Format”
- Section 8.1.2, “Numbers”
- Section 10.2, “Numeric Types”
- Section 10.1.1, “Overview of Numeric Types”
- Section 11.4.2, “Regular Expressions”
- Section 5.1.2, “Server Command Options”
- Section 5.1.4, “Server System Variables”
- Section 5.4.3, “Specifying Account Names”
- Section 4.2.3.1, “Using Options on the Command Line”
-# [debug_options]
-# [debug_options]
-# debug_options
-#debug_options
--Information
--abort-slave-event-count
--add-drop-database
--add-drop-table
--add-locks
--addtodest
--all-databases
--all-in-1
--all-tablespaces
--allow-keywords
--allow-suspicious-udfs
--allowold
--analyze
--ansi
--apply-slave-statements
--auto-generate-sql
--auto-generate-sql-add-autoincrement
--auto-generate-sql-execute-number=N
--auto-generate-sql-guid-primary
--auto-generate-sql-load-type=type
--auto-generate-sql-secondary-indexes=N
--auto-generate-sql-select-columns=str
--auto-generate-sql-unique-query-number=N
--auto-generate-sql-unique-write-number=N
--auto-generate-sql-write-number
--auto-generate-sql-write-number=N
--auto-repair
--auto-vertical-output
--back_log=50
--backup_history_log
--backup_progress_log
--base64-output
--base64-output=DECODE-ROWS
--base64-output=NEVER
--base64-output[=value]
--basedir
- Section 2.10.6.1, “Building MySQL from Source Using CMake and Visual Studio”
- Description
- Section 5.6, “Running Multiple MySQL Servers on the Same Machine”
- Section 5.1.4, “Server System Variables”
- Section 2.11.2.3, “Starting and Troubleshooting the MySQL Server”
- Section 2.10.2, “Typical configure Options”
- Section 2.11.2, “Unix Post-Installation Procedures”
--basedir=path
--batch
--bdb-logdir
--bdb-logdir=file_name
--bdb-no-recover
--bdb-shared-data
--bdb-tmpdir=path
--big-tables
--bind-address=127.0.0.1
--bind-address=IP
--binlog-direct-non-transactional-updates
--binlog-direct-non-transactional-updates[={0|1}]
--binlog-do-db
- Section 16.1.3.4, “Binary Log Options and Variables”
- Description
- Section 16.2.3.1, “Evaluation of Database-Level Replication and Binary Logging Options”
- Section 16.2.3, “How Servers Evaluate Replication Filtering Rules”
- Section 16.4.1, “Replication Features and Issues”
- Section 16.1.3.3, “Replication Slave Options and Variables”
- Section 5.2.4, “The Binary Log”
--binlog-do-db=db1
--binlog-do-db=db_name
--binlog-do-db=sales
--binlog-format
--binlog-format=MIXED
--binlog-format=ROW
--binlog-format=STATEMENT
--binlog-format=type
--binlog-format={ROW|STATEMENT|MIXED}
--binlog-ignore-db
--binlog-ignore-db=db_name
--binlog-ignore-db=sales
--binlog-row-event-max-size
--binlog-row-event-max-size=N
--block-search=offset
--bootstrap
--brief
--build=x86_64-pc-solaris2.10
--burnin
--cflags
--character-set-client-handshake
--character-set-filesystem=charset_name
--character-set-server
- Section 9.5, “Character Set Configuration”
- Section 9.1.5, “Configuring the Character Set and Collation for Applications”
- Section 1.5, “What Is New in MySQL 5.4”
- Section 16.4.1, “Replication Features and Issues”
- Section 16.4.1.2, “Replication and Character Sets”
- Section 9.1.3.1, “Server Character Set and Collation”
- Section 5.1.2, “Server Command Options”
- Section 8.4, “User-Defined Variables”
--character-set-server=charset_name
--character-set-server=latin1
--character-sets-dir
--character-sets-dir=path
--charset=path
--check-only-changed
--check-upgrade
--checkpoint
--checkpoint=db_name.tbl_name
--chroot
--chroot=path
--collation-server
- Section 9.5, “Character Set Configuration”
- Section 9.1.5, “Configuring the Character Set and Collation for Applications”
- Section 1.5, “What Is New in MySQL 5.4”
- Section 16.4.1, “Replication Features and Issues”
- Section 16.4.1.2, “Replication and Character Sets”
- Section 9.1.3.1, “Server Character Set and Collation”
- Section 5.1.2, “Server Command Options”
--collation-server=collation_name
--collation-server=latin1_swedish_ci
--column-type-info
--columns=column_list
--comments
--commit
--commit=N
--compact
--compatible
--compatible=name
--compatible=oracle
--complete-insert
--compress
--concurrency=N
--config-file
--config-file=file_name
--console
- Section 13.6.13.3, “
InnoDBGeneral Troubleshooting” - Section 13.6.13.2, “
SHOW ENGINE INNODB STATUSand theInnoDBMonitors” - Section 13.6.2.3, “Creating the
InnoDBTablespace” - Section B.5.4.1.1, “Resetting the Root Password on Windows Systems”
- Section 5.1.2, “Server Command Options”
- Section 2.3.9, “Starting the Server for the First Time”
- Section 5.2.2, “The Error Log”
--copy
--core-file
--core-file-size
--core-file-size=1000000
--core-file-size=size
--correct-checksum
--count
--count=N
--create
--create-options
--create-schema=value
--create=value
--csv[=file_name]
--data-file-length=len
--database
--database=db_name
--databases
--datadir
- Section 2.10.6.1, “Building MySQL from Source Using CMake and Visual Studio”
- Section 2.3.7, “Creating an Option File”
- Description
- Description
- Section 5.1.4, “Server System Variables”
- Section 2.11.2.3, “Starting and Troubleshooting the MySQL Server”
- Section 2.10.2, “Typical configure Options”
- Section 2.11.2, “Unix Post-Installation Procedures”
- Section 4.2.3.3, “Using Option Files”
--datadir=path
--db=db_name
--debug
--debug-check
--debug-info
--debug-sync-timeout=N
--debug-sync-timeout[=N]
--debug="..."
--debug="d,parser_debug"
--debug=+P
--debug=N
--debug=T
--debug=d,general,query
--debug=debug_options
--debug[=debug_options]
--default-character-set
- Section 12.2.6, “
LOAD DATA INFILESyntax” - Section 9.1.4, “Connection Character Sets and Collations”
- Description
- Section 1.5, “What Is New in MySQL 5.4”
- Section 5.1.2, “Server Command Options”
- Section 5.1.4, “Server System Variables”
- Section 2.12.1.1, “Upgrading from MySQL 5.1 to 5.4”
- Section 8.4, “User-Defined Variables”
--default-character-set=charset_name
--default-character-set=system_character_set
--default-character-set=utf8
--default-collation
--default-collation=collation_name
--default-storage-engine
--default-storage-engine=type
--default-table-type
--default-table-type=InnoDB
--default-table-type=type
--default-time-zone
--default-time-zone=timezone
--default.key_buffer_size=256K
--defaults-extra-file
--defaults-extra-file=file_name
--defaults-extra-file=path
--defaults-file
- Section 13.6.2, “
InnoDBConfiguration” - Section 4.2.3.3.1, “Command-Line Options that Affect Option-File Handling”
- Description
- Section 20.8.3, “Options with the Embedded Server”
- Section B.5.4.1.1, “Resetting the Root Password on Windows Systems”
- Section 5.6, “Running Multiple MySQL Servers on the Same Machine”
- Section 5.6.1.2, “Starting Multiple Windows Servers as Services”
- Section 5.6.1.1, “Starting Multiple Windows Servers at the Command Line”
- Section 2.3.11, “Starting MySQL as a Windows Service”
--defaults-file=file_name
--defaults-file=option_file_name
--defaults-group-suffix
--defaults-group-suffix=_other
--defaults-group-suffix=str
--defaults-group-suffix=suffix
--delay-key-write
--delay-key-write-for-all-tables
--delay-key-write=ALL
--delay-key-write=OFF
--delay-key-write[={OFF|ON|ALL}]
--delay_key_write=1
--delay_key_write=ON
--delayed-insert
--delayed-start=N
--delete
--delete-master-logs
--delimiter
--delimiter=str
--demangle
--des-key-file
--des-key-file=file_name
--description
--detach=N
--disable-auto-rehash
--disable-community-features
--disable-debug-sync
--disable-dtrace
--disable-grant-options
--disable-keys
--disable-log-bin
--disable-named-commands
--disable-plugin_name
--disable-profiling
--disable-shared
--disconnect-slave-event-count
--dryrun
--dump
--dump-date
--dump-slave
--dump-slave[=value]
--embedded
--enable-assembler
--enable-community-features
--enable-debug-sync
--enable-dtrace
--enable-local-infile
--enable-locking
--enable-named-pipe
--enable-plugin_name
--enable-profiling
--enable-pstack
--enable-thread-safe-client
--engine-condition-pushdown
--engine=engine_name
--err-log=file_name
--event-scheduler
--event-scheduler=DISABLED
--event-scheduler[=value]
--events
--example
--exe-suffix=suffix
--execute=statement
--exit-info[=flags]
--extend-check
--extended
--extended-insert
--external-locking
--extra-file=file_name
--federated
--fields-enclosed-by
--fields-enclosed-by=...
--fields-enclosed-by=char
--fields-escaped-by=...
--fields-escaped-by=char
--fields-optionally-enclosed-by=...
--fields-optionally-enclosed-by=char
--fields-terminated-by=...
--fields-terminated-by=str
--fields-xxx
--first-slave
--fix-db-names
--fix-table-names
--flush
--flush-logs
--flush-privileges
--flush_time=val
--flushlog
--force
- Section 4.6.3.2, “myisamchk Check Options”
- Section 4.6.3.3, “myisamchk Repair Options”
- Section 4.5.1.1, “mysql Options”
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Section 2.13.1.2, “Linux Binary Distribution Notes”
- Section 21.1.2, “MySQL Test Suite”
- Section 3.5, “Using mysql in Batch Mode”
--force-read
--general-log
--general-log[={0|1}]
--general_log
--general_log[={0|1}]
--general_log_file
--general_log_file=file_name
--header_file=file_name
--help
- Section 4.6.3.1, “myisamchk General Options”
- Section 4.5.1.1, “mysql Options”
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Section 4.1, “Overview of MySQL Programs”
- Section 5.1.2, “Server Command Options”
- Section 2.11.2.3, “Starting and Troubleshooting the MySQL Server”
- Section 7.5.3, “Tuning Server Parameters”
- Chapter 3, Tutorial
- Section 2.11.2, “Unix Post-Installation Procedures”
- Section 4.2.3.3, “Using Option Files”
- Section 4.2.3.1, “Using Options on the Command Line”
--hex-blob
--host
- Section 5.4.7, “Causes of Access-Denied Errors”
- Section 4.2.2, “Connecting to the MySQL Server”
- Description
- Section 4.2.1, “Invoking MySQL Programs”
- Section 2.10.5, “MIT-pthreads Notes”
- Section 4.2.3.5, “Option Defaults, Options Expecting Values, and the
=Sign” - Section 1.2, “Typographical and Syntax Conventions”
- Section 5.6.3, “Using Client Programs in a Multiple-Server Environment”
--host=127.0.0.1
--host=host_name
--host=localhost
--howto
--i-am-a-dummy
--ignore
--ignore-builtin-innodb
--ignore-lines=N
--ignore-spaces
--ignore-sql-errors
--ignore-table=db_name.tbl_name
--in_file=file_name
--include
--include-master-host-port
--info
--information
--init-file
- Section 2.10.6.1, “Building MySQL from Source Using CMake and Visual Studio”
- Section B.5.4.1.2, “Resetting the Root Password on Unix Systems”
- Section B.5.4.1.1, “Resetting the Root Password on Windows Systems”
- Section 5.1.4, “Server System Variables”
- Section 13.9, “The
MEMORY(HEAP) Storage Engine” - Section 2.10.2, “Typical configure Options”
--init-file=file_name
--init_connect="SET NAMES 'utf8'"
--innodb-autoinc-lock-mode
--innodb-xxx
--innodb[=value]
--innodb_checksums
--innodb_file_per_table
--innodb_locks_unsafe_for_binlog
--innodb_rollback_on_timeout
--innodb_safe_binlog
--innodb_status_file
--innodb_status_file=1
--innodb_support_xa
--insert-ignore
--install
--install-manual
--iterations=N
--join=big_tbl_name
--keep_files_on_create
--keepold
--key_buffer_size=32M
--keys
--keys-used=val
--label=str
--language
--language=lang_name, -L lang_name
--large-pages
--lc-messages
--lc-messages-dir
--lc-messages-dir=path
--lc-messages=locale_name
--ldata=path
--ledir
--ledir=path
--length
--libmysqld-libs
--libs
--libs_r
--line-numbers
--lines-terminated-by
--lines-terminated-by="\r\n"
--lines-terminated-by=...
--lines-terminated-by=str
--local
--local-infile
--local-infile=0
--local-infile=1
--local-infile[=1]
--local-infile[={0|1}]
--local-load
--local-load=path
--local-service
--lock-all-tables
--lock-directory
--lock-directory=path
--lock-tables
--log
- Section 5.4.7, “Causes of Access-Denied Errors”
- Section 21.5.1.7, “Making a Test Case If You Experience Table Corruption”
- Section 5.2.1, “Selecting General Query and Slow Query Log Output Destinations”
- Section 5.1.2, “Server Command Options”
- Section 5.2.6, “Server Log Maintenance”
- Section 5.1.4, “Server System Variables”
- Section 5.2.3, “The General Query Log”
- Section 21.5.1.6, “Using Server Logs to Find Causes of Errors in mysqld”
--log-backup-output[=value,...]
--log-bin
- Section 12.5.2.1, “
CHANGE MASTER TOSyntax” - Section 12.5.1.1, “
PURGE BINARY LOGSSyntax” - Section 6.3.1, “Backup Policy”
- Section 6.3.3, “Backup Strategy Summary”
- Section 16.1.3.4, “Binary Log Options and Variables”
- Section 18.6, “Binary Logging of Stored Programs”
- Section 6.2, “Database Backup Methods”
- Section 16.4.6, “How to Report Replication Bugs or Problems”
- Section 21.5.1.7, “Making a Test Case If You Experience Table Corruption”
- Section 6.5, “Point-in-Time (Incremental) Recovery Using the Binary Log”
- Section 16.4.4, “Replication FAQ”
- Section 16.1.3.3, “Replication Slave Options and Variables”
- Section 5.1.2, “Server Command Options”
- Section 5.2.6, “Server Log Maintenance”
- Section 5.1.4, “Server System Variables”
- Section 5.2.4, “The Binary Log”
- Section 5.2.3, “The General Query Log”
- Section 16.4.5, “Troubleshooting Replication”
- Section 16.4.3, “Upgrading a Replication Setup”
- Section 6.3.2, “Using Backups for Recovery”
--log-bin-index[=file_name]
--log-bin-trust-function-creators
--log-bin-trust-function-creators=1
--log-bin-trust-function-creators[={0|1}]
--log-bin-trust-routine-creators
--log-bin-trust-routine-creators=1
--log-bin-trust-routine-creators[={0|1}]
--log-bin=base_name.extension
--log-bin=log_name
--log-bin=old_host_name-bin
--log-bin[=base_name]
--log-bin[=file_name]
--log-error
--log-error my-errors
--log-error=file_name
--log-error[=file_name]
--log-isam=file_name
--log-isam[=file_name]
--log-long-format
--log-output
--log-output=TABLE
--log-output=TABLE,FILE
--log-output[=value,...]
--log-queries-not-using-indexes
--log-short-format
--log-slave-updates
--log-slow-admin-statements
--log-slow-queries
- Section 5.2.1, “Selecting General Query and Slow Query Log Output Destinations”
- Section 5.1.2, “Server Command Options”
- Section 5.2.6, “Server Log Maintenance”
- Section 5.1.4, “Server System Variables”
- Section 5.2.5, “The Slow Query Log”
- Section 21.5.1.6, “Using Server Logs to Find Causes of Errors in mysqld”
--log-slow-queries[=file_name]
--log-slow-slave-statements
--log-tc-size
--log-tc-size=size
--log-tc=file_name
--log-update[=file_name]
--log-warnings
--log-warnings=0
--log-warnings=2
--log-warnings[=level]
--log=file_name
--log[=file_name]
--loose
--loose-opt_name
--loose-skip-innodb
--low-priority
--low-priority-updates
--lower-case-table-names=0
--malloc-lib
--malloc-lib=
--malloc-lib=/path/to/some/library
--malloc-lib=[lib_name]
--malloc-lib=tcmalloc
--master-bind
--master-connect-retry
- Section 12.4.5.35, “
SHOW SLAVE STATUSSyntax” - Section 1.5, “What Is New in MySQL 5.4”
- Section 16.4.1.16, “Replication During a Master Shutdown”
- Section 16.4.1, “Replication Features and Issues”
- Section 16.2, “Replication Implementation”
- Section 7.5.6.6, “Replication Slave I/O Thread States”
- Section 16.1.3.3, “Replication Slave Options and Variables”
--master-connect-retry=seconds
--master-data
--master-data[=value]
--master-host
--master-host=host_name
--master-info-file
--master-info-file=file_name
--master-password
--master-password=password
--master-port
--master-port=port_number
--master-retry-count
--master-retry-count=count
--master-ssl
--master-ssl*
--master-ssl-ca
--master-ssl-ca=file_name
--master-ssl-capath
--master-ssl-capath=directory_name
--master-ssl-cert
--master-ssl-cert=file_name
--master-ssl-cipher
--master-ssl-cipher=cipher_list
--master-ssl-key
--master-ssl-key=file_name
--master-user
--master-user=user_name
--master-xxx
--max-binlog-dump-events=N
--max-binlog-size
--max-record-length
--max-record-length=len
--max-relay-log-size
--max-relay-log-size=size
--max-seeks-for-key=1000
--max_connect_errors=999999999
--max_join_size
--max_sort_length=N
--maximum-query_cache_size=32M
--maximum-query_cache_size=4M
--maximum-var_name=value
--medium-check
--memlock
--method=command
--min-examined-row-limit=number
--mutex-deadlock-detector
--myisam-block-size
--myisam-block-size=N
--myisam-recover
- Section 13.5.1, “
MyISAMStartup Options” - Section 7.2.25, “Other Optimization Tips”
- Section 5.1.4, “Server System Variables”
- Section 6.6.5, “Setting Up a
MyISAMTable Maintenance Schedule” - Section B.5.2.19, “Table-Corruption Issues”
- Section 13.5, “The
MyISAMStorage Engine” - Section 21.5.1.6, “Using Server Logs to Find Causes of Errors in mysqld”
--myisam-recover=BACKUP,FORCE
--myisam-recover=mode
--myisam-recover[=option[,option]...]]
--mysql-backup[={0|1}]
--mysqladmin=prog_name
--mysqld-version
--mysqld-version=debug
--mysqld-version=max
--mysqld-version=suffix
--mysqld=mysqld_safe
--mysqld=prog_name
--name_file=file_name
--named-commands
--ndb
--ndb-cluster
--ndb-log-empty-epochs
--new
--nice=priority
--no-auto-rehash
--no-autocommit
--no-beep
--no-create-db
--no-debug
--no-defaults
--no-embedded
--no-log
--no-named-commands
--no-set-names
--no-symlinks
--noindices
--number-blob-cols=str
--number-char-cols=N
--number-int-cols=N
--number-of-queries=N
--numeric-dump-file=file_name
--offset=N
--old-alter-table
--old-passwords
- Section B.5.2.4, “
Client does not support authentication protocol” - Section 5.3.2.3, “Password Hashing in MySQL”
- Section 16.4.1, “Replication Features and Issues”
- Section 5.3.4, “Security-Related mysqld Options”
- Section 5.1.2, “Server Command Options”
- Section 2.12.1.1, “Upgrading from MySQL 5.1 to 5.4”
--old-protocol
--old-style-user-limits
--old_server
--one-database
--one-thread
--only-debug
--only-print
--open-files-limit
- Section B.5.2.18, “'
File' Not Found and Similar Errors” - Section 13.6.3, “
InnoDBStartup Options and System Variables” - Section 2.13.4.1, “FreeBSD Notes”
- Section 7.4.8, “How MySQL Opens and Closes Tables”
- Section 2.3.15, “MySQL on Windows Compared to MySQL on Unix”
- Section 5.1.4, “Server System Variables”
--open-files-limit=count
--opt
--opt_name
--opt_name=value
--optimize
--order-by-primary
--out_dir=path
--out_file=file_name
--packlength=len
--pager[=command]
--parallel-recover
--partition[=value]
--password
- Section 4.5.1.1, “mysql Options”
- Section 5.5.2, “Adding User Accounts”
- Section 5.4.7, “Causes of Access-Denied Errors”
- Section 4.2.2, “Connecting to the MySQL Server”
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Section 5.3.2.2, “End-User Guidelines for Password Security”
- Section 6.3, “Example Backup and Recovery Strategy”
- Section 4.2.1, “Invoking MySQL Programs”
- Section B.5.2.5, “Password Fails When Entered Interactively”
- Section 5.5.1, “User Names and Passwords”
- Section 4.2.3.1, “Using Options on the Command Line”
--password=
--password=pass_val
--password=password
--password=your_pass
--password[=pass_val]
--password[=password]
--pid-file=file_name
--pid-file=path
--pipe
--plan
--plugin-innodb_file_per_table
--plugin-load
--plugin-load=plugin_list
--plugin-sql-mode
--plugin-xxx
--plugin_dir=path
--plugin_name
--plugin_name=0
--plugin_name=1
--plugin_name=FORCE
--plugin_name=OFF
--plugin_name=ON
--plugin_name[=ON]
--plugindir
--port
- Section 5.4.7, “Causes of Access-Denied Errors”
- Section 4.2.2, “Connecting to the MySQL Server”
- Description
- Description
- Section 4.2.1, “Invoking MySQL Programs”
- Section 5.6, “Running Multiple MySQL Servers on the Same Machine”
- Section 5.6.2, “Running Multiple Servers on Unix”
- Section 5.1.4, “Server System Variables”
- Section 2.11.2.3, “Starting and Troubleshooting the MySQL Server”
- Section 5.6.3, “Using Client Programs in a Multiple-Server Environment”
--port-open-timeout=num
--port=port_num
- Section 4.5.1.1, “mysql Options”
- Section 4.2.2, “Connecting to the MySQL Server”
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Section 5.6, “Running Multiple MySQL Servers on the Same Machine”
- Section 5.1.2, “Server Command Options”
--port=port_number
--position=N
--post-query=value
--post-system=str
--pre-query=value
--pre-system=str
--prefix
--preserve-schema
--preview
--print-defaults
--prompt
--prompt=format_str
--protocol=MEMORY
--protocol=PIPE
--protocol=SOCKET
--protocol=TCP
--protocol={TCP|SOCKET|PIPE|MEMORY}
--query
--query-cache-size=0
--query=value
--quick
--quiet
--quote-names
--read-from-remote-server
--read-only
--reconnect
--record_log_pos
--record_log_pos=db_name.tbl_name
--recover
--regexp=expr
--regexp=pattern
--relative
--relay-log
--relay-log-index
--relay-log-index=file_name
--relay-log-info-file
--relay-log-info-file=file_name
--relay-log-purge={0|1}
--relay-log-recovery
--relay-log-recovery={0|1}
--relay-log-space-limit
--relay-log-space-limit=size
--relay-log=file_name
--relay-log=myhost-bin
--relay-log=relay_log_index
--relnotes
--remove
--repair
--replace
--replicate-*
--replicate-*-db
--replicate-*-do-*
--replicate-*-ignore-*
--replicate-*-table
--replicate-[do|ignore]-table
--replicate-do-db
- Section 12.4.5.35, “
SHOW SLAVE STATUSSyntax” - Section 12.3.1, “
START TRANSACTION,COMMIT, andROLLBACKSyntax” - Section 16.1.3.4, “Binary Log Options and Variables”
- Section 16.2.3.1, “Evaluation of Database-Level Replication and Binary Logging Options”
- Section 16.2.3, “How Servers Evaluate Replication Filtering Rules”
- Section 16.4.1, “Replication Features and Issues”
- Section 16.1.3.3, “Replication Slave Options and Variables”
- Section 16.4.1.21, “Replication and Reserved Words”
- Section 16.4.1.25, “Replication and Temporary Tables”
- Section 5.2.4, “The Binary Log”
--replicate-do-db=db1
--replicate-do-db=db_name
--replicate-do-db=sales
--replicate-do-table
- Section 12.4.5.35, “
SHOW SLAVE STATUSSyntax” - Section 16.2.3.2, “Evaluation of Table-Level Replication Options”
- Section 16.4.1, “Replication Features and Issues”
- Section 16.2.3.3, “Replication Rule Application”
- Section 16.4.1.21, “Replication and Reserved Words”
- Section 16.4.1.25, “Replication and Temporary Tables”
--replicate-do-table=db_name.tbl_name
--replicate-ignore-db
- Section 12.4.5.35, “
SHOW SLAVE STATUSSyntax” - Section 12.3.1, “
START TRANSACTION,COMMIT, andROLLBACKSyntax” - Section 16.1.3.4, “Binary Log Options and Variables”
- Section 16.2.3.1, “Evaluation of Database-Level Replication and Binary Logging Options”
- Section 16.2.3, “How Servers Evaluate Replication Filtering Rules”
- Section 16.4.1, “Replication Features and Issues”
- Section 16.2.3.3, “Replication Rule Application”
- Section 16.1.3.3, “Replication Slave Options and Variables”
- Section 16.4.1.21, “Replication and Reserved Words”
- Section 5.2.4, “The Binary Log”
--replicate-ignore-db=db_name
--replicate-ignore-db=sales
--replicate-ignore-table
--replicate-ignore-table=db_name.tbl_name
--replicate-rewrite-db
--replicate-rewrite-db="db1->db3"
--replicate-rewrite-db="db2->db3"
--replicate-rewrite-db=from_name->to_name
--replicate-same-server-id
--replicate-wild-do-table
--replicate-wild-do-table=db_name.%
--replicate-wild-do-table=db_name.tbl_name
--replicate-wild-do-table=foo%.%
--replicate-wild-do-table=foo%.bar%
--replicate-wild-do-table=my\\_own\\%db
--replicate-wild-do-table=my\_own\%db
--replicate-wild-ignore-table
--replicate-wild-ignore-table=db_name.%
--replicate-wild-ignore-table=db_name.tbl_name
--replicate-wild-ignore-table=foo%.bar%
--replicate-wild-ignore-table=mysql.%
--replicate-wild-ignore-table=norep%
--report-host
--report-host=host_name
--report-password
--report-password=password
--report-port
--report-port=slave_port_num
--report-user
--report-user=user_name
--resetmaster
--resetslave
--result-file=file_name
--result-file=name
--rhost=host_name
--rollback
--routines
--rows=N
--rpm
--safe-mode
--safe-recover
--safe-show-database
--safe-updates
--safe-user-create
--secure-auth
--secure-backup-file-priv
--secure-backup-file-priv=path
--secure-file-priv
--secure-file-priv=path
--select_limit
--server-id
--server-id=id
--server-id=value
--service-startup-timeout=file_name
--set-auto-increment[=value]
--set-character-set=name
--set-charset
--set-charset=charset_name
--set-collation
--set-collation=name
--set-random-seed=value
--set-variable
--set-variable=option=value
--set-variable=var_name=value
--shared-memory
--shared-memory-base-name
--shared-memory-base-name=name
--short-form
--show-slave-auth-info
--show-table-type
--show-warnings
--sigint-ignore
--silent
--single-transaction
--skip
--skip-add-drop-table
--skip-add-locks
--skip-auto-rehash
--skip-base64-output
--skip-bdb
--skip-character-set-client-handshake
--skip-column-names
--skip-comments
--skip-compact
--skip-concurrent-insert
--skip-delay-key-write
--skip-disable-keys
--skip-dump-date
--skip-engine_name
--skip-event-scheduler
--skip-events
--skip-extended-insert
--skip-external-locking
- Section 7.3.4, “External Locking”
- Section 7.5.6.2, “General Thread States”
- Section 2.8, “Installing MySQL on NetWare”
- Section 1.5, “What Is New in MySQL 5.4”
- Section 5.1.2, “Server Command Options”
- Section 7.5.2, “System Factors and Startup Parameter Tuning”
- Section B.5.4.2, “What to Do If MySQL Keeps Crashing”
--skip-grant-tables
- Section 12.4.3.2, “
CREATE FUNCTIONSyntax” - Section 12.4.3.4, “
INSTALL PLUGINSyntax” - Section 2.10.6.1, “Building MySQL from Source Using CMake and Visual Studio”
- Section 5.4.7, “Causes of Access-Denied Errors”
- Section 21.3.2.5, “Compiling and Installing User-Defined Functions”
- Description
- Description
- Section 2.12.2.1, “Downgrading to MySQL 5.1”
- Section 12.4.3.1, “Installing and Uninstalling Plugins”
- Section 2.11.2.1, “Problems Running mysql_install_db”
- Section B.5.4.1.2, “Resetting the Root Password on Unix Systems”
- Section 5.3.4, “Security-Related mysqld Options”
- Section 5.1.2, “Server Command Options”
- Section 2.10.2, “Typical configure Options”
- Section 4.2.3.1, “Using Options on the Command Line”
- Section 5.4.6, “When Privilege Changes Take Effect”
--skip-host-cache
--skip-innodb
- Section 13.6.2, “
InnoDBConfiguration” - Section 13.6.3, “
InnoDBStartup Options and System Variables” - Section 12.4.5.17, “
SHOW ENGINESSyntax” - Section 16.4.4, “Replication FAQ”
- Section 5.1.2, “Server Command Options”
- Section 5.1.4, “Server System Variables”
- The mysqld-max Extended MySQL Server
- Section 2.12.1.1, “Upgrading from MySQL 5.1 to 5.4”
--skip-innodb-checksums
--skip-innodb_adaptive_hash_index
--skip-innodb_checksums
--skip-innodb_doublewrite
--skip-kill-mysqld
--skip-line-numbers
--skip-lock-tables
--skip-log-warnings
--skip-merge
--skip-mutex-deadlock-detector
--skip-name-resolve
--skip-named-commands
--skip-networking
- Section B.5.2.2, “
Can't connect to [local] MySQL server” - Section B.5.2.9, “
MySQL server has gone away” - Section 5.4.7, “Causes of Access-Denied Errors”
- Section 7.5.11, “How MySQL Uses DNS”
- Section 5.3.4, “Security-Related mysqld Options”
- Section 5.1.2, “Server Command Options”
- Section 5.1.4, “Server System Variables”
- Section 16.4.3, “Upgrading a Replication Setup”
--skip-new
--skip-partition
--skip-plugin-innodb_file_per_table
--skip-plugin_name
--skip-quick
--skip-quote-names
--skip-reconnect
--skip-routines
--skip-safemalloc
--skip-set-charset
--skip-show-database
--skip-slave-start
- Section 12.5.2.1, “
CHANGE MASTER TOSyntax” - Section 12.5.2.7, “
START SLAVESyntax” - Section 16.1.1, “How to Set Up Replication”
- Section 16.1.3.3, “Replication Slave Options and Variables”
- Section 16.1.1.8, “Setting Up Replication with Existing Data”
- Section 16.4.5, “Troubleshooting Replication”
- Section 16.4.3, “Upgrading a Replication Setup”
--skip-ssl
--skip-stack-trace
--skip-super-large-pages
--skip-symbolic-links
--skip-syslog
--skip-thread-priority
--skip-triggers
--skip-tz-utc
--skip-use-db
--skip-write-binlog
--skip-xxx
--skip_grant_tables
--slave
--slave-load-tmpdir
--slave-load-tmpdir=file_name
--slave-net-timeout
--slave-net-timeout=seconds
--slave-skip-errors
--slave-skip-errors=[err_code1,err_code2,...|all]
--slave_compressed_protocol={0|1}
--sleep
--sleep=delay
--slow-query-log
--slow-query-log[={0|1}]
--slow_query_log
--slow_query_log[={0|1}]
--slow_query_log_file
--slow_query_log_file=file_name
--socket
- Section B.5.2.2, “
Can't connect to [local] MySQL server” - Section 5.4.7, “Causes of Access-Denied Errors”
- Section 4.2.2, “Connecting to the MySQL Server”
- Description
- Description
- Section B.5.4.5, “How to Protect or Change the MySQL Unix Socket File”
- Section 4.2.1, “Invoking MySQL Programs”
- Section 5.6, “Running Multiple MySQL Servers on the Same Machine”
- Section 5.6.2, “Running Multiple Servers on Unix”
- Section 2.3.12, “Testing The MySQL Installation”
- Section 5.6.3, “Using Client Programs in a Multiple-Server Environment”
--socket=/path/to/socket
--socket=file_name
--socket=path
--sort-records=N
--sort-records=index_num
--sort-recover
--sort_buffer_size=16M
--spassword
--spassword[=password]
--sporadic-binlog-dump-fail
--sql-bin-update-same
--sql-mode
--sql-mode=""
--sql-mode="mode_value"
--sql-mode="modes"
--sql-mode=IGNORE_SPACE
--sql-mode=MAXDB
--sql-mode=NO_UNSIGNED_SUBTRACTION
--sql-mode=value[,value[,value...]]
--sql_mode="TRADITIONAL,ALLOW_INVALID_DATES"
--srcdir=path
--ssl
- Section 4.5.1.1, “mysql Options”
- Section 4.2.2, “Connecting to the MySQL Server”
- Description
- Description
- Description
- Description
- Description
- Description
- Section 16.1.3.3, “Replication Slave Options and Variables”
- Section 5.5.6.3, “SSL Command Options”
- Section 5.3.4, “Security-Related mysqld Options”
- Section 5.1.2, “Server Command Options”
- Section 5.5.6.2, “Using SSL Connections”
--ssl*
--ssl-ca
--ssl-ca=file_name
--ssl-capath
--ssl-capath=directory_name
--ssl-cert
--ssl-cert=file_name
--ssl-cipher=cipher_list
--ssl-key
--ssl-key=file_name
--ssl-verify-server-cert
--standalone
--start-datetime
--start-datetime=datetime
--start-position
--start-position=N
--start_row=N
--statefile=file_name
--static
--stats
--status
--stop-datetime
--stop-datetime=datetime
--stop-position
--stop-position=N
--suffix=str
--super-large-pages
--superuser=user_name
--symbolic-links
--symbols-file=file_name
--sysdate-is-now
--syslog
--syslog-tag=tag
--tab
--tab=path
--table_cache
--table_open_cache
--tables
--tc-heuristic-recover={COMMIT|ROLLBACK}
--tcp-ip
--tee=file_name
--temp-pool
--test
--thread-stack=192K
--thread_cache_size=5'
--thread_handling=no-threads
--thread_handling=one-thread-per-connection
--thread_handling=pool-of-threads
--thread_pool_size=N
--thread_stack=N
--timer-length=N
--timezone
--timezone=timezone
--timezone=timezone_name
--tmp_table_size=val
--tmpdir
--tmpdir=path
--to-last-log
--transaction-isolation
--transaction-isolation=SERIALIZABLE
--transaction-isolation=level
--type=engine_name
--tz-utc
--unbuffered
--unpack
--update-state
--upgrade-system-tables
--use-frm
--use-manager
--use-mysqld_safe
--use-symbolic-links
--use-threads
--use-threads=N
--user
- Section B.5.2.18, “'
File' Not Found and Similar Errors” - Description
- Description
- Description
- Section 6.3, “Example Backup and Recovery Strategy”
- Section 2.9, “Installing MySQL from
tar.gzPackages on Other Unix-Like Systems” - Section 2.7, “Installing MySQL on i5/OS”
- Section 4.2.1, “Invoking MySQL Programs”
- Section 2.13.1.2, “Linux Binary Distribution Notes”
- Section 4.2.3.5, “Option Defaults, Options Expecting Values, and the
=Sign” - Section 5.1.2, “Server Command Options”
- Section 2.13.3, “Solaris Notes”
- Section 2.10.1, “Source Installation Overview”
- Section 2.11.2, “Unix Post-Installation Procedures”
- Section 5.5.1, “User Names and Passwords”
- Section 4.2.3.3, “Using Option Files”
--user=root
--user=user_name
- Section 4.5.1.1, “mysql Options”
- Section 4.2.2, “Connecting to the MySQL Server”
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Section 5.3.6, “How to Run MySQL as a Normal User”
--user={user_name|user_id}
--var_name=value
--verbose
- Section 4.6.3.1, “myisamchk General Options”
- Section 4.5.1.1, “mysql Options”
- Section 4.6.7.2, “mysqlbinlog Row Event Display”
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Section 4.5.1.4, “Executing SQL Statements from a Text File”
- Section 4.6.3.4, “Other
myisamchkOptions” - Section 5.1.2, “Server Command Options”
- Section 5.1.4, “Server System Variables”
- Section 2.3.10, “Starting MySQL from the Windows Command Line”
- Section 2.11.2.3, “Starting and Troubleshooting the MySQL Server”
- Section 7.5.3, “Tuning Server Parameters”
- Section 4.2.3.3, “Using Option Files”
- Section 4.2.3.1, “Using Options on the Command Line”
--version
- Section 4.6.3.1, “myisamchk General Options”
- Section 4.5.1.1, “mysql Options”
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Section 5.1.2, “Server Command Options”
- Section 4.2.3.1, “Using Options on the Command Line”
--vertical
--wait[=count]
--warnings
--where='where_condition'
--windows
--with-archive-storage-engine
--with-bdb
--with-berkeley-db
--with-big-tables
--with-blackhole-storage-engine
--with-charset
--with-charset=MYSET
--with-charset=charset_name
--with-collation
--with-comment
--with-csv-storage-engine
--with-debug
- Section 21.5.1.1, “Compiling MySQL for Debugging”
- Section 2.10.4, “Dealing with Problems Compiling MySQL”
- Section 21.5.2, “Debugging a MySQL Client”
- Section 7.5.1, “How Compiling and Linking Affects the Speed of MySQL”
- Section 2.9, “Installing MySQL from
tar.gzPackages on Other Unix-Like Systems” - Section 2.1.2.4, “MySQL Binaries Compiled by Oracle Corporation”
- Section 5.1.2, “Server Command Options”
- Section 2.10.2, “Typical configure Options”
- Section B.5.4.2, “What to Do If MySQL Keeps Crashing”
--with-debug=full
- Section 21.5.1.1, “Compiling MySQL for Debugging”
- Section 21.5.2, “Debugging a MySQL Client”
- Description
- Section 7.5.1, “How Compiling and Linking Affects the Speed of MySQL”
- Section 2.9, “Installing MySQL from
tar.gzPackages on Other Unix-Like Systems” - Section 2.1.2.4, “MySQL Binaries Compiled by Oracle Corporation”
- Section 5.1.2, “Server Command Options”
- Section B.5.4.2, “What to Do If MySQL Keeps Crashing”
--with-debug[=full]
--with-embedded-privilege-control
--with-embedded-server
--with-example-storage-engine
--with-extra-charsets=LIST
--with-extra-charsets=charset_name
--with-extra-charsets=complex
--with-federated-storage-engine
--with-innodb
--with-libevent
--with-libwrap
--with-low-memory
--with-max-indexes=N
--with-mit-threads
--with-mysqld-ldflags=-all-static
--with-mysqld-ldflags=-rdynamic
--with-named-thread-libs="-lpthread -lmach -lexc -lc"
--with-named-z-libs
--with-named-z-libs=no
--with-ndbcluster
--with-openssl
--with-partition
--with-plugin-PLUGIN
--with-plugins
--with-pstack
--with-raid
--with-server-suffix=-max
--with-ssl
--with-ssl=path
--with-tcp-port
--with-unix-socket-path
--with-vio
--with-yassl
--with-zlib-dir=no|bundled|DIR
--without-libevent
--without-plugin-PLUGIN
--without-query-cache
--write-binlog
-1
- Section 1.8.5.6, “'
--' as the Start of a Comment” - Section 11.12.1, “
GROUP BY(Aggregate) Functions” - Section 17.2.3, “
HASHPartitioning” - Section 11.2.3, “Comparison Functions and Operators”
- Description
- Section 11.5.2, “Mathematical Functions”
- Section 11.11.4, “Miscellaneous Functions”
- Section 11.4.1, “String Comparison Functions”
- Section 2.12.1.1, “Upgrading from MySQL 5.1 to 5.4”
-?
- Section 4.6.3.1, “myisamchk General Options”
- Section 4.5.1.1, “mysql Options”
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Section 5.1.2, “Server Command Options”
- Section 4.2.3.1, “Using Options on the Command Line”
-B
-C
-C charset_name
-C path
-D db_name
-D path
-DBIG_TABLES
-DHAVE_rts_threads
-DUSE_ALARM_THREAD
-F
-F file_name
-F str
-H file_name
-H host_name
-I
-I/usr/local/mysql/include
-K
-L
-L/usr/lib/gcc-lib/... -lgcc
-L/usr/local/mysql/lib -lmysqlclient -lz
-N file_name
-O var_name=value
-O back_log=50
-O file_name
-O0
-O3
-O6
-P port_num
-P[password]
-Q
-R index_num
-R record_pos_file record_pos
-RELEASE
-S
-S path
-T
-T [flags]
-T path
-U user_name
-V
- Section 4.6.3.1, “myisamchk General Options”
- Section 4.5.1.1, “mysql Options”
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Section 5.1.2, “Server Command Options”
- Section 4.2.3.1, “Using Options on the Command Line”
-W
-W [level]
-Wa,-many
-Wl,r/full/path/to/libmysqlclient.so
-a
-arch generic
-arch generic
-c
-c column_list
-c file_name
-d
-d db_name
-e
-e engine_name
-e file_name
-e num
-e statement
-f
-f N
-felide-constructors
-fno-exceptions
-fomit-frame-pointer
-fomit-frame-pointer -ffixed-ebp
-g pattern
-g suffix
-h
-h host_name
-h localhost
-i
-i N
-i delay
-i name
-j N
-j big_tbl_name
-k
-l
-l path
-lgthreads -lsocket -lgthreads
-libmysqlclient
-libmysqld
-lmach -lexc
-lmysqlclient
-lmysqlclient -lz
-lmysqld
-lz
-mcpu=v8 -Wa,-xarch=v8plusa
-mcpu=v8 -Wa,-xarch=v8plusa
-mcpu=xxx
-n
-n N
-n file_name
-o
-o async
-o N
-o noatime
-o offset
-o udf_example.so
-p
- Section 4.6.3.3, “myisamchk Repair Options”
- Section 4.5.1.1, “mysql Options”
- Section 5.5.2, “Adding User Accounts”
- Section 5.4.7, “Causes of Access-Denied Errors”
- Section 4.2.2, “Connecting to the MySQL Server”
- Section 3.3.1, “Creating and Selecting a Database”
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Section 5.3.2.2, “End-User Guidelines for Password Security”
- Section 2.8, “Installing MySQL on NetWare”
- Section 4.2.1, “Invoking MySQL Programs”
- Section B.5.2.5, “Password Fails When Entered Interactively”
- Section 2.3.11, “Starting MySQL as a Windows Service”
- Section 2.3.10, “Starting MySQL from the Windows Command Line”
- Section 2.3.12, “Testing The MySQL Installation”
- Section 2.3.14, “Upgrading MySQL on Windows”
- Section 5.5.1, “User Names and Passwords”
- Section 4.2.3.1, “Using Options on the Command Line”
- Section 2.11.1, “Windows Post-Installation Procedures”
-p N
-p len
-p num
-p[pass_val]
-p[password]
-ppassword
-q
-q value
-qstrict
-r
-r file_name
-r name
-s
- Section 4.6.3.1, “myisamchk General Options”
- Section 4.5.1.1, “mysql Options”
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Section 6.6.2, “How to Check
MyISAMTables for Errors” - Section 6.6.3, “How to Repair
MyISAMTables” - Section 6.6.5, “Setting Up a
MyISAMTable Maintenance Schedule”
-s file_name
-s num
-s sort_type
-signal
-skip-auto-rehash
-slow_query_log_file
-static
-t
-t N
-t path
-u
-u {user_name|user_id}
-u user_name
-v
- Section 4.6.3.1, “myisamchk General Options”
- Section 4.6.3.5, “myisamchk Table Information”
- Section 4.5.1.1, “mysql Options”
- Section 4.6.7.2, “mysqlbinlog Row Event Display”
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Section 6.6.2, “How to Check
MyISAMTables for Errors” - Section 5.1.2, “Server Command Options”
- Section 4.2.3.1, “Using Options on the Command Line”
-v -v -v
-w 'where_condition'
-w write_file
-w[count]
-x
-x N
-y N
Aborted_connects
Checksum
Com_dealloc_sql
Com_delete
Com_execute_sql
Com_insert
Com_prepare_sql
Com_select
Com_stmt_close
Com_stmt_execute
Com_stmt_fetch
Com_stmt_prepare
Com_stmt_reprepare
Com_stmt_reset
Com_stmt_send_long_data
DataMemory
Id
- Section 12.4.5.5, “
SHOW COLLATIONSyntax” - Section 12.4.5.31, “
SHOW PROCESSLISTSyntax” - Section 20.9.1, “C API Data Types”
- Section 9.4.2, “Choosing a Collation ID”
- Section 7.5.6, “Examining Thread Information”
- Section 19.10, “The
INFORMATION_SCHEMA COLLATIONSTable” - Section 19.22, “The
INFORMATION_SCHEMA PROCESSLISTTable”
IndexMemory
Name
- Section 12.4.5.1, “
SHOW AUTHORSSyntax” - Section 12.4.5.7, “
SHOW CONTRIBUTORSSyntax” - Section 12.4.5.16, “
SHOW ENGINESyntax” - Section 12.4.5.19, “
SHOW EVENTSSyntax” - Section 12.4.5.27, “
SHOW PLUGINSSyntax” - Section 12.4.5.37, “
SHOW TABLE STATUSSyntax” - Section 19.20, “The
INFORMATION_SCHEMA EVENTSTable” - Section 19.17, “The
INFORMATION_SCHEMA PLUGINSTable”
Questions
Slave_running
Text in this style
TransactionDeadlockDetectionTimeout
TransactionInactiveTimeout
\G
\s
\t
all
ansi
automatic_sp_privileges
basedir
c
character_set_client
collation_connection
compress
connect_timeout
count
d
data
datadir
db
- Section 12.4.1.3, “
GRANTSyntax” - Section 12.4.5.31, “
SHOW PROCESSLISTSyntax” - Section 20.9.3.3, “
mysql_change_user()” - Section 20.9.3.8, “
mysql_create_db()” - Section 20.9.3.11, “
mysql_drop_db()” - Section 20.9.3.52, “
mysql_real_connect()” - Section 20.9.3.60, “
mysql_select_db()” - Section 5.4.5, “Access Control, Stage 2: Request Verification”
- Section 5.5.2, “Adding User Accounts”
- Section 20.9.1, “C API Data Types”
- Section 5.4.7, “Causes of Access-Denied Errors”
- Section 2.12.5, “Copying MySQL Databases to Another Machine”
- Description
- Section 7.5.6, “Examining Thread Information”
- Section 5.4.2, “Privilege System Grant Tables”
- Section 5.4.1, “Privileges Provided by MySQL”
- Section D.6, “Restrictions on Character Sets”
- Section 19.22, “The
INFORMATION_SCHEMA PROCESSLISTTable” - Section 19.14, “The
INFORMATION_SCHEMA ROUTINESTable” - Section 2.11.2, “Unix Post-Installation Procedures”
decode_bits
default-storage-engine
default-table-type
defaults-extra-file
delimiter
description
e
extended-status
flush-backup-logs
flush-hosts
flush-logs
flush-privileges
flush-status
flush-tables
flush-threads
forcedirectio
ft_max_word_len
ft_min_word_len
ft_stopword_file
general_log
have_partition_engine
have_profiling
help
host
- Section 12.4.1.3, “
GRANTSyntax” - Section 20.9.3.7, “
mysql_connect()” - Section 20.9.3.52, “
mysql_real_connect()” - Section 5.4.5, “Access Control, Stage 2: Request Verification”
- Section 5.4.7, “Causes of Access-Denied Errors”
- Section 3.1, “Connecting to and Disconnecting from the Server”
- Section 13.6.4.2, “Converting Tables from Other Storage Engines to
InnoDB” - Section 2.12.5, “Copying MySQL Databases to Another Machine”
- Description
- Section 5.4.2, “Privilege System Grant Tables”
- Section 5.4.1, “Privileges Provided by MySQL”
- Section 2.11.2, “Unix Post-Installation Procedures”
ibmdb2i_assume_exclusive_use
ibmdb2i_async_enabled
ibmdb2i_compat_opt_allow_zero_date_vals
ibmdb2i_compat_opt_blob_cols
ibmdb2i_compat_opt_time_as_duration
ibmdb2i_compat_opt_year_as_int
ibmdb2i_create_index_option
ibmdb2i_create_time_columns_as_tod
ibmdb2i_lob_alloc_size
ibmdb2i_map_blob_to_varchar
ibmdb2i_max_read_buffer_size
ibmdb2i_max_write_buffer_size
ibmdb2i_propagate_default_col_val
ibmdb2i_propagate_default_col_vals
ibmdb2i_system_trace_level
ibmdb2i_transaction_unsafe
ignore-builtin-innodb
init-file
innodb
innodb_file_per_table
innodb_safe_binlog
innodb_status_file=1
innodb_support_xa
innodb_table_locks
interactive_timeout
key_buffer_size
ledir
length
- Section 20.9.3.34, “
mysql_hex_string()” - Section 20.9.3.53, “
mysql_real_escape_string()” - Section 20.9.3.54, “
mysql_real_query()” - Section 20.9.7.11, “
mysql_stmt_fetch()” - Section 20.9.7.20, “
mysql_stmt_prepare()” - Section 20.9.7.25, “
mysql_stmt_send_long_data()” - Section 20.9.1, “C API Data Types”
- Section 20.9.5, “C API Prepared Statement Data types”
- Section 21.2.4.2.1, “Full-Text Parser Plugin Data Structures and Functions”
- Section 21.2.5, “Writing Plugins”
log_backup_output
log_bin_trust_routine_creators
max_allowed_packet
max_connections
max_user_connections
multi_range_count
myisam_block_size
myisam_max_extra_sort_file_size
myisam_stats_method
mysql
- Section 4.5.1.1, “mysql Options”
- Section 4.5.1.3, “mysql Server-Side Help”
- Section 12.4.3.2, “
CREATE FUNCTIONSyntax” - Section 12.1.13, “
CREATE SERVERSyntax” - Section 12.4.1.1, “
CREATE USERSyntax” - Section B.5.2.4, “
Client does not support authentication protocol” - Section 12.4.3.3, “
DROP FUNCTIONSyntax” - Section 12.4.1.2, “
DROP USERSyntax” - Section 12.4.6.3, “
FLUSHSyntax” - Section 12.4.1.3, “
GRANTSyntax” - Section 12.8.3, “
HELPSyntax” - Section 12.5.2.2, “
LOAD DATA FROM MASTERSyntax” - Section B.5.2.9, “
MySQL server has gone away” - Section 12.4.1.4, “
RENAME USERSyntax” - Section 12.4.1.5, “
REVOKESyntax” - Section 12.4.1.6, “
SET PASSWORDSyntax” - Section 12.4.5.22, “
SHOW GRANTSSyntax” - Section 20.9.3.3, “
mysql_change_user()” - Section 20.9.3.5, “
mysql_close()” - Section 20.9.3.14, “
mysql_errno()” - Section 20.9.3.15, “
mysql_error()” - Section 20.9.3.33, “
mysql_get_ssl_cipher()” - Section 20.9.3.36, “
mysql_init()” - Section 20.9.3.53, “
mysql_real_escape_string()” - Section 20.9.3.60, “
mysql_select_db()” - Section 20.9.3.67, “
mysql_ssl_set()” - Section 20.9.7.10, “
mysql_stmt_execute()” - Section 20.9.7.11, “
mysql_stmt_fetch()” - Section 20.9.7.25, “
mysql_stmt_send_long_data()” - Section 5.4.4, “Access Control, Stage 1: Connection Verification”
- Section 12.4.1, “Account Management Statements”
- Section 5.5.2, “Adding User Accounts”
- Section 5.3.2.1, “Administrator Guidelines for Password Security”
- Section 5.5.5, “Assigning Account Passwords”
- Section 6.3.1, “Backup Policy”
- Section 20.9.14, “C API Prepared Statement Handling of Date and Time Values”
- Section 5.4.7, “Causes of Access-Denied Errors”
- Section 21.3.2.5, “Compiling and Installing User-Defined Functions”
- Section 9.1.4, “Connection Character Sets and Collations”
- Chapter 20, Connectors and APIs
- Section 13.6.4.2, “Converting Tables from Other Storage Engines to
InnoDB” - Section 2.12.5, “Copying MySQL Databases to Another Machine”
- Section 13.11.2.1, “Creating a
FEDERATEDTable UsingCONNECTION” - Section 16.1.1.6, “Creating a Data Snapshot Using Raw Data Files”
- Section 3.3, “Creating and Using a Database”
- Section 8.2, “Schema Object Names”
- Description
- Description
- Description
- Section 2.12.2, “Downgrading MySQL”
- Section 7.5.9, “Enabling Large Page Support”
- Section 5.3.1, “General Security Guidelines”
- Section 7.5.5.1, “How the Query Cache Operates”
- Section 16.1.1, “How to Set Up Replication”
- Section 2.9, “Installing MySQL from
tar.gzPackages on Other Unix-Like Systems” - Section 2.4, “Installing MySQL from RPM Packages on Linux”
- Section 2.5, “Installing MySQL on Mac OS X”
- Section 2.6, “Installing MySQL on Solaris”
- Section 5.2.4.4, “Logging Format for Changes to
mysqlDatabase Tables” - Section 5.3.3, “Making MySQL Secure Against Attackers”
- Section 5.2.4.3, “Mixed Binary Logging Format”
- Section 1.5, “What Is New in MySQL 5.4”
- Section 20.10, “MySQL PHP API”
- Section 9.6, “MySQL Server Time Zone Support”
- Section 12.3.5.3, “Other Table-Locking Notes”
- Section 4.1, “Overview of MySQL Programs”
- Section 5.3.2.3, “Password Hashing in MySQL”
- Section 5.4.2, “Privilege System Grant Tables”
- Section 5.4.1, “Privileges Provided by MySQL”
- Section 2.11.2.1, “Problems Running mysql_install_db”
- Section 16.4.4, “Replication FAQ”
- Section 16.4.1, “Replication Features and Issues”
- Section 16.4.1.10, “Replication and
FLUSH” - Section 16.4.1.19, “Replication of the System
mysqlDatabase” - Section B.5.4.1.2, “Resetting the Root Password on Unix Systems”
- Section 13.6.14, “Restrictions on
InnoDBTables” - Section D.6, “Restrictions on Character Sets”
- Section D.1, “Restrictions on Stored Routines, Triggers, and Events”
- Section 2.13.5.9, “SCO OpenServer 6.0.x Notes”
- Section 2.11.3, “Securing the Initial MySQL Accounts”
- Section 5.2.1, “Selecting General Query and Slow Query Log Output Destinations”
- Section 5.1.2, “Server Command Options”
- Section 5.1.9, “Server-Side Help”
- Section 5.5.4, “Setting Account Resource Limits”
- Section 2.10.1, “Source Installation Overview”
- Section 5.6.1.1, “Starting Multiple Windows Servers at the Command Line”
- Section 2.11.2.2, “Starting and Stopping MySQL Automatically”
- Section 2.11.2.3, “Starting and Troubleshooting the MySQL Server”
- Section 12.3.3, “Statements That Cause an Implicit Commit”
- Section 9.6.1, “Staying Current with Time Zone Changes”
- Section 5.4, “The MySQL Access Privilege System”
- Section 21.2, “The MySQL Plugin API”
- Section 2.3.13, “Troubleshooting a MySQL Installation Under Windows”
- Section 2.11.2, “Unix Post-Installation Procedures”
- Section 2.12.1, “Upgrading MySQL”
- Section 2.12.1.1, “Upgrading from MySQL 5.1 to 5.4”
- Section 5.5.1, “User Names and Passwords”
- Section 4.2.3.1, “Using Options on the Command Line”
- Section 13.6.2.2, “Using Raw Devices for the Shared Tablespace”
- Section 5.5.6.2, “Using SSL Connections”
- Section 21.5.1.6, “Using Server Logs to Find Causes of Errors in mysqld”
- Section 18.2, “Using Stored Routines (Procedures and Functions)”
- Section 2.11.1, “Windows Post-Installation Procedures”
mysqlaccess
mysqlbinlog
mysqld
- Section B.5.2.2, “
Can't connect to [local] MySQL server” - Section 20.9.2, “C API Function Overview”
- Description
- Description
- Section 13.11.1, “
FEDERATEDStorage Engine Overview” - Section 2.7, “Installing MySQL on i5/OS”
- Section 5.2.4.3, “Mixed Binary Logging Format”
- Section 5.1.1, “Server Option and Variable Reference”
- Section 5.2.2, “The Error Log”
- Section 16.2.2.2, “The Slave Status Files”
- Section 21.5.1.3, “Using
pdbto create a Windows crashdump”
mysqld_safe
mysqldump
mysqldumpslow
mysqlhotcopy
mysqlslap
ndb_optimization_delay
net_retry_count
net_write_timeout
nice
offset
old-alter-table
open-files-limit
open_files_limit
p
partition
password
performance_schema
pid-file
pipe
plugin
plugin-load
processlist
purge-backup-logs
query_cache_type
read_buffer_size
reconnect
record_buffer
replication-ignore-table
resolve_stack_dump
rows
select_limit
server-id
- Section 16.1.1, “How to Set Up Replication”
- Section 16.1.1.9, “Introducing Additional Slaves to an Existing Replication Environment”
- Section 16.1.3.2, “Replication Master Options and Variables”
- Section 16.1.3.3, “Replication Slave Options and Variables”
- Section 16.1.1.8, “Setting Up Replication with Existing Data”
- Section 16.1.1.1, “Setting the Replication Master Configuration”
- Section 16.1.1.2, “Setting the Replication Slave Configuration”
set-variable
set-variable=option=value
shutdown_timeout
skip-innodb
skip-networking
slave_type_conversions
slow_query_log
sort_buffer_size
sort_key_blocks
source
sql-mode=""
sql-mode="modes"
sql_big_tables
sql_log_update
sql_low_priority_updates
sql_max_join_size
start-slave
stats_method
status
stop-slave
syslog
table
table_type
test
- Section 12.2.2, “
DELETESyntax” - Section 7.2.21, “
INFORMATION_SCHEMAOptimization” - Section 13.6.13.2.3, “
InnoDBTable Monitor Output” - Section 12.4.5.19, “
SHOW EVENTSSyntax” - Section 9.1.7.8, “Collation and
INFORMATION_SCHEMASearches” - Section 11.3, “Control Flow Functions”
- Section 13.6.4, “Creating and Using
InnoDBTables” - Section 3.3, “Creating and Using a Database”
- Description
- Description
- Section 6.4.5.4, “Dumping Table Definitions and Content Separately”
- Section 3.6, “Examples of Common Queries”
- Section 8.2.4, “Function Name Parsing and Resolution”
- Section 4.2.1, “Invoking MySQL Programs”
- Section 16.1.3.3, “Replication Slave Options and Variables”
- Section 2.11.3, “Securing the Initial MySQL Accounts”
- Section 18.2.1, “Stored Routine Syntax”
- Section 19.19, “The
INFORMATION_SCHEMA PARTITIONSTable” - Section 2.11.2, “Unix Post-Installation Procedures”
- Section 4.2.3.1, “Using Options on the Command Line”
- Section 2.11.1, “Windows Post-Installation Procedures”
type
- Section 12.4.3.2, “
CREATE FUNCTIONSyntax” - Section 13.6.13.2.3, “
InnoDBTable Monitor Output” - Section 20.9.1, “C API Data Types”
- Section 21.2.4.2.1, “Full-Text Parser Plugin Data Structures and Functions”
- Section 21.2.4.1, “General Plugin Data Structures and Functions”
- Section 7.2.20, “How to Avoid Table Scans”
- Section 7.2.6, “Index Merge Optimization”
- Section 7.2.1, “Optimizing Queries with
EXPLAIN” - Section 21.2.4.3, “Plugin Status and System Variables”
- Section 19.14, “The
INFORMATION_SCHEMA ROUTINESTable”
update
user
- Section 12.4.1.2, “
DROP USERSyntax” - Section B.5.2.15, “
Ignoring user” - Section 20.9.3.49, “
mysql_options()” - Section 20.9.3.52, “
mysql_real_connect()” - Section 5.4.4, “Access Control, Stage 1: Connection Verification”
- Section 5.4.5, “Access Control, Stage 2: Request Verification”
- Section 5.5.2, “Adding User Accounts”
- Section 5.3.2.1, “Administrator Guidelines for Password Security”
- Section 5.5.5, “Assigning Account Passwords”
- Section 5.5.8, “Auditing MySQL Account Activity”
- Section 5.4.7, “Causes of Access-Denied Errors”
- Section 3.1, “Connecting to and Disconnecting from the Server”
- Section 13.6.4.2, “Converting Tables from Other Storage Engines to
InnoDB” - Section 2.12.5, “Copying MySQL Databases to Another Machine”
- Description
- Section 11.11.2, “Encryption and Compression Functions”
- Section 5.3.1, “General Security Guidelines”
- Section 5.3.6, “How to Run MySQL as a Normal User”
- Section 5.3.3, “Making MySQL Secure Against Attackers”
- Section 5.3.2.3, “Password Hashing in MySQL”
- Section 5.4.2, “Privilege System Grant Tables”
- Section 5.4.1, “Privileges Provided by MySQL”
- Section D.6, “Restrictions on Character Sets”
- Section 2.11.3, “Securing the Initial MySQL Accounts”
- Section 5.1.2, “Server Command Options”
- Section 5.5.4, “Setting Account Resource Limits”
- Section 5.4.3, “Specifying Account Names”
- Section 2.11.2.2, “Starting and Stopping MySQL Automatically”
- Section 2.11.2, “Unix Post-Installation Procedures”
- Section 2.12.1.1, “Upgrading from MySQL 5.1 to 5.4”
- Section 5.5.1, “User Names and Passwords”
- Section 5.5.6.2, “Using SSL Connections”
- Section 11.10, “XML Functions”
User Comments
Add your own comment.