Recommended Servers for MySQLThe world's most popular open source database
- Documentation Library
- Table of Contents
- MySQL 5.4 Reference Manual
- MySQL 5.1 Reference Manual
- MySQL 5.0 Reference Manual
- MySQL 3.23/4.0/4.1 Manual
- Table of Contents
Additional languages
MySQL 5.1 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 MySQL Cluster NDB 6.X/7.X
- 18 Partitioning
- 19 Stored Programs and Views
- 20 INFORMATION_SCHEMA Tables
- 21 Connectors and APIs
- 22 Extending MySQL
- A MySQL 5.1 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.5.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 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
--all-databases
--all-in-1
--all-tablespaces
--allow-keywords
--allow-suspicious-udfs
--allowold
--analyze
--angel-pid-file
--angel-pid-file=file_name
--ansi
--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-unique-query-number=N
--auto-generate-sql-unique-write-number=N
--auto-generate-sql-write-number
--auto-generate-sql-write-number=N
--auto-repair
--autoclose
--base64-output
--base64-output=DECODE-ROWS
--base64-output=NEVER
--base64-output[=value]
--basedir
- Section 2.3.6.1, “Building MySQL from Source Using CMake and Visual Studio”
- Description
- Section 17.1.5.11, “Previous MySQL Cluster Issues Resolved in MySQL 5.1 and MySQL Cluster NDB 6.x”
- Section 5.6, “Running Multiple MySQL Servers on the Same Machine”
- Section 5.1.4, “Server System Variables”
- Section 2.13.2.3, “Starting and Troubleshooting the MySQL Server”
- Section 2.3.2, “Typical configure Options”
- Section 2.13.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
--bind-address=127.0.0.1
--bind-address=IP
--binlog-do-db
- Section 16.1.3.4, “Binary Log Options and Variables”
- Section 16.4.3.1, “Evaluation of Database-Level Replication and Binary Logging Options”
- Section 16.4.3, “How Servers Evaluate Replication Filtering Rules”
- Section 16.3.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
--cflags
--character-set-client-handshake
--character-set-filesystem=charset_name
--character-set-server
- Section 9.1.5, “Configuring the Character Set and Collation for Applications”
- Section 16.3.1, “Replication Features and Issues”
- Section 16.3.1.2, “Replication and Character Sets”
- Section 9.1.3.1, “Server Character Set and Collation”
- Section 5.1.2, “Server Command Options”
- Section 9.2, “The Character Set Used for Data and Sorting”
- 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-password-file
--check-upgrade
--checkpoint
--checkpoint=db_name.tbl_name
--chroot
--chroot=path
--clean-password-file
--collation-server
- Section 9.1.5, “Configuring the Character Set and Collation for Applications”
- Section 16.3.1, “Replication Features and Issues”
- Section 16.3.1.2, “Replication and Character Sets”
- Section 9.1.3.1, “Server Character Set and Collation”
- Section 5.1.2, “Server Command Options”
- Section 9.2, “The Character Set Used for Data and Sorting”
--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
--config-file=path_name
--configdir
--configinfo
--configinfo --xml
--connect-string
--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.1.4.1.1, “Resetting the Root Password on Windows Systems”
- Section 5.1.2, “Server Command Options”
- Section 2.5.5.4, “Starting the Server for the First Time”
- Section 5.2.2, “The Error Log”
--copy
--core-file-size
--core-file-size=size
--correct-checksum
--count
--count=N
--create
--create-options
--create-schema=value
--create=value
--csv[=file_name]
--daemon
--data-file-length=len
--database
--database=db_name
--databases
--datadir
- Section 2.3.6.1, “Building MySQL from Source Using CMake and Visual Studio”
- Section 2.5.5.2, “Creating an Option File”
- Description
- Description
- Section 5.1.4, “Server System Variables”
- Section 2.13.2.3, “Starting and Troubleshooting the MySQL Server”
- Section 2.3.2, “Typical configure Options”
- Section 2.13.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 5.1.4, “Server System Variables”
- Section 9.2, “The Character Set Used for Data and Sorting”
- Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”
- Section 8.4, “User-Defined Variables”
--default-character-set=charset_name
--default-character-set=utf8
--default-collation=collation_name
--default-mysqld-path=/usr/sbin/mysqld
--default-mysqld-path=path
--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 4.6.10.1, “MySQL Instance Manager Command Options”
- Section 4.6.10.7, “MySQL Instance Manager Commands”
- Section 4.6.10.2, “MySQL Instance Manager Configuration Files”
- Section 21.8.3, “Options with the Embedded Server”
- Section B.1.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.5.5.6, “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
--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
--embedded
--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-condition-pushdown=1
--engine=engine_name
--err-log=file_name
--event-scheduler
--event-scheduler=DISABLED
--event-scheduler[=value]
--events
--example
--exclude-databases
--exclude-missing-columns
--exclude-tables
--exe-suffix=suffix
--execute
--execute=statement
--exit-info[=flags]
--extend-check
--extended
--extended-insert
--external-locking
--extra-file=file_name
--federated
--fields-enclosed-by=...
--fields-escaped-by=...
--fields-optionally-enclosed-by=...
--fields-terminated-by=...
--fields-xxx
--first-slave
--fix-db-names
--fix-table-names
--flush
--flush-logs
--flush-logs
--flush-privileges
--flush_time=val
--flushlog
--force
--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.6.10.1, “MySQL Instance Manager Command Options”
- Section 4.1, “Overview of MySQL Programs”
- Section 5.1.2, “Server Command Options”
- Section 2.13.2.3, “Starting and Troubleshooting the MySQL Server”
- Section 7.5.3, “Tuning Server Parameters”
- Chapter 3, Tutorial
- Section 2.13.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.3.5, “MIT-pthreads Notes”
- Section 4.2.3.5, “Option Defaults, Options Expecting Values, and the
=Sign” - Section 5.6.3, “Using Client Programs in a Multiple-Server Environment”
--host=127.0.0.1
--host=host_name
--host=localhost
--howto
--i-am-a-dummy
--ignore
--ignore-builtin-innodb
--ignore-lines=N
--ignore-spaces
--ignore-table=db_name.tbl_name
--in_file=file_name
--include
--include-databases
--include-tables
--info
--information
--init-file
- Section 2.3.6.1, “Building MySQL from Source Using CMake and Visual Studio”
- Section B.1.4.1.2, “Resetting the Root Password on Unix Systems”
- Section B.1.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.3.2, “Typical configure Options”
--init-file=file_name
--init_connect="SET NAMES 'utf8'"
--initial
- Section 17.5.10.2, “Adding MySQL Cluster Data Nodes Online: Basic procedure”
- Section 17.5.10.3, “Adding MySQL Cluster Data Nodes Online: Detailed Example”
- Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
- Description
- Section 17.1.4.5, “Features Added in MySQL Cluster NDB 7.0”
- MySQL 4.1 FAQ — MySQL Cluster
- Section 17.2.6.2, “MySQL Cluster 5.1 and MySQL Cluster NDB 6.x/7.x Upgrade and Downgrade Compatibility”
- Section 17.3.2, “MySQL Cluster Configuration Files”
- Section 17.3.3.1, “MySQL Cluster Data Node Configuration Parameters”
- Section 17.5.9.3, “MySQL Cluster Disk Data Storage Requirements”
- Section 17.3.3, “Overview of MySQL Cluster Configuration Parameters”
- Section 17.2.6.1, “Performing a Rolling Restart of a MySQL Cluster”
- Section 17.5.1, “Summary of MySQL Cluster Start Phases”
--initial-start
--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
--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=...
--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 22.5.1.7, “Making a Test Case If You Experience Table Corruption”
- Section 4.6.10.1, “MySQL Instance Manager Command Options”
- 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 22.5.1.6, “Using Server Logs to Find Causes of Errors in mysqld”
--log-bin
- Section 12.6.2.1, “
CHANGE MASTER TOSyntax” - Section 12.6.1.1, “
PURGE BINARY LOGSSyntax” - Section 6.2.1, “Backup Policy”
- Section 6.2.3, “Backup Strategy Summary”
- Section 16.1.3.4, “Binary Log Options and Variables”
- Section 19.6, “Binary Logging of Stored Programs”
- Section 6.1, “Database Backup Methods”
- Section 16.3.6, “How to Report Replication Bugs or Problems”
- Section 22.5.1.7, “Making a Test Case If You Experience Table Corruption”
- Section 6.3, “Point-in-Time Recovery”
- Section 16.3.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.3.5, “Troubleshooting Replication”
- Section 16.3.3, “Upgrading a Replication Setup”
- Section 6.2.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 22.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
--log-update[=file_name]
--log-warnings
--log-warnings=0
--log-warnings=2
--log-warnings[=level]
--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.5.5.36, “
SHOW SLAVE STATUSSyntax” - Section 1.4.1, “What Is New in MySQL 5.1”
- Section 16.3.1.16, “Replication During a Master Shutdown”
- Section 16.3.1, “Replication Features and Issues”
- Section 16.4, “Replication Implementation”
- Section 7.5.6.5, “Replication Slave I/O Thread States”
- Section 16.1.3.3, “Replication Slave Options and Variables”
- Section 1.4.2, “What Is Planned for MySQL 5.4”
--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
--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
--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
--monitoring-interval=seconds
--mutex-deadlock-detector
--myisam-block-size
--myisam-block-size=N
--myisam-recover
- Section 13.5.1, “
MyISAMStartup Options” - Section 7.2.24, “Other Optimization Tips”
- Section 5.1.4, “Server System Variables”
- Section 6.4.5, “Setting Up a Table Maintenance Schedule”
- Section B.1.2.19, “Table-Corruption Issues”
- Section 13.5, “The
MyISAMStorage Engine” - Section 22.5.1.6, “Using Server Logs to Find Causes of Errors in mysqld”
--myisam-recover=BACKUP,FORCE
--myisam-recover=mode
--myisam-recover[=option[,option]...]]
--mysqladmin=prog_name
--mysqld-safe-compatible
--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-batch-size
--ndb-batch-size=#
--ndb-cluster
--ndb-cluster-connection-pool
--ndb-cluster-connection-pool=#
--ndb-cluster-connection-pool=4
--ndb-connectstring
--ndb-connectstring=connect_string
--ndb-force-send=1
--ndb-index-stat-enable=0
--ndb-log-empty-epochs
--ndb-log-orig
--ndb-nodeid=#
--ndb-use-exact-count=0
--ndb_optimized_node_selection
--ndbcluster
- Section 17.3.4.2, “mysqld Command Options for MySQL Cluster”
- Section 12.5.5.17, “
SHOW ENGINESSyntax” - MySQL 4.1 FAQ — MySQL Cluster
- Section 17.3, “MySQL Cluster Configuration”
- Section 17.1.1, “MySQL Cluster Core Concepts”
- Section 17.4.1, “MySQL Server Usage for MySQL Cluster”
- Section 17.3.2.2, “Recommended Starting Configurations for MySQL Cluster NDB 6.2 and Later”
- The mysqld-max Extended MySQL Server
--ndbcluster --ndb-connectstring=management_host
--new
--nice=priority
--no-auto-rehash
--no-autocommit
--no-beep
--no-create-db
--no-create-info
--no-data
--no-debug
--no-defaults
--no-embedded
--no-log
--no-named-commands
--no-pager
--no-set-names
--no-symlinks
--no-tee
--nodaemon
--noindices
--nostart
--nowait-nodes
--nowait-nodes=3
--nowait-nodes=3,5
--nowait-nodes=node_id_1[, node_id_2[, ...]]
--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.1.2.4, “
Client does not support authentication protocol” - Section 5.5.6.3, “Password Hashing in MySQL”
- Section 16.3.1, “Replication Features and Issues”
- Section 5.3.3, “Security-Related mysqld Options”
- Section 5.1.2, “Server Command Options”
- Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”
--old-protocol
--old-style-user-limits
--old_server
--one-database
--one-thread
--only-debug
--only-print
--open-files-limit
--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]
--passwd
--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.5.6.2, “End-User Guidelines for Password Security”
- Section 6.2, “Example Backup and Recovery Strategy”
- Section 4.6.10.4, “Instance Manager User and Password Management”
- Section 4.2.1, “Invoking MySQL Programs”
- Section 4.6.10.1, “MySQL Instance Manager Command Options”
- Section B.1.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-file=file_name
--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_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
--plugins=max-no-innodb
--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.13.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 4.6.10.1, “MySQL Instance Manager Command Options”
- Section 5.6, “Running Multiple MySQL Servers on the Same Machine”
- Section 5.1.2, “Server Command Options”
--port=port_number
--position
--position=N
--post-query=value
--post-system=str
--pre-query=value
--pre-system=str
--prefix
--preserve-schema
--preview
--print-defaults
--print-password-line
--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
--relnotes
--reload
--remove
--repair
--replace
--replicate-*
--replicate-*-db
--replicate-*-do-*
--replicate-*-ignore-*
--replicate-*-table
--replicate-do-db
- Section 12.5.5.36, “
SHOW SLAVE STATUSSyntax” - Section 12.4.1, “
START TRANSACTION,COMMIT, andROLLBACKSyntax” - Section 16.1.3.4, “Binary Log Options and Variables”
- Section 16.4.3.1, “Evaluation of Database-Level Replication and Binary Logging Options”
- Section 16.4.3, “How Servers Evaluate Replication Filtering Rules”
- Section 16.3.1, “Replication Features and Issues”
- Section 16.1.3.3, “Replication Slave Options and Variables”
- Section 16.3.1.21, “Replication and Reserved Words”
- Section 16.3.1.24, “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.5.5.36, “
SHOW SLAVE STATUSSyntax” - Section 16.4.3.2, “Evaluation of Table-Level Replication Options”
- Section 16.3.1, “Replication Features and Issues”
- Section 16.4.3.3, “Replication Rule Application”
- Section 16.3.1.21, “Replication and Reserved Words”
- Section 16.3.1.24, “Replication and Temporary Tables”
--replicate-do-table=db_name.tbl_name
--replicate-ignore-db
- Section 12.5.5.36, “
SHOW SLAVE STATUSSyntax” - Section 12.4.1, “
START TRANSACTION,COMMIT, andROLLBACKSyntax” - Section 16.1.3.4, “Binary Log Options and Variables”
- Section 16.4.3.1, “Evaluation of Database-Level Replication and Binary Logging Options”
- Section 16.4.3, “How Servers Evaluate Replication Filtering Rules”
- Section 16.3.1, “Replication Features and Issues”
- Section 16.4.3.3, “Replication Rule Application”
- Section 16.1.3.3, “Replication Slave Options and Variables”
- Section 16.3.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
--rows=N
--rpm
--run-as-service
--safe-mode
--safe-recover
--safe-show-database
--safe-updates
--safe-user-create
--secure-auth
--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-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
--skip-grant-tables
- Section 12.5.3.1, “
CREATE FUNCTIONSyntax” - Section 12.5.3.3, “
INSTALL PLUGINSyntax” - Section 2.3.6.1, “Building MySQL from Source Using CMake and Visual Studio”
- Section 5.4.7, “Causes of Access-Denied Errors”
- Section 22.3.2.5, “Compiling and Installing User-Defined Functions”
- Description
- Description
- Section 2.13.2.1, “Problems Running mysql_install_db”
- Section B.1.4.1.2, “Resetting the Root Password on Unix Systems”
- Section 5.3.3, “Security-Related mysqld Options”
- Section 5.1.2, “Server Command Options”
- Section 2.3.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.5.5.17, “
SHOW ENGINESSyntax” - Section 16.3.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.4.1.1, “Upgrading from MySQL 5.0 to 5.1”
--skip-innodb-checksums
--skip-innodb_adaptive_hash_index
--skip-innodb_checksums
--skip-innodb_doublewrite
--skip-kill-mysqld
--skip-line-numbers
--skip-locking
--skip-log-warnings
--skip-merge
--skip-mutex-deadlock-detector
--skip-name-resolve
--skip-named-commands
--skip-ndbcluster
--skip-networking
- Section B.1.2.2, “
Can't connect to [local] MySQL server” - Section B.1.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.3, “Security-Related mysqld Options”
- Section 5.1.2, “Server Command Options”
- Section 5.1.4, “Server System Variables”
- Section 16.3.3, “Upgrading a Replication Setup”
--skip-new
--skip-pager
--skip-partition
--skip-plugin-innodb_file_per_table
--skip-plugin_name
--skip-quick
--skip-quote-names
--skip-reconnect
--skip-safemalloc
--skip-set-charset
--skip-show-database
--skip-slave-start
- Section 12.6.2.1, “
CHANGE MASTER TOSyntax” - Section 12.6.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.3.5, “Troubleshooting Replication”
- Section 16.3.3, “Upgrading a Replication Setup”
--skip-ssl
--skip-stack-trace
--skip-super-large-pages
--skip-symbolic-links
--skip-symlink
--skip-syslog
--skip-thread-priority
--skip-triggers
--skip-tz-utc
--skip-use-db
--skip-write-binlog
--skip-xxx
--skip_grant_tables
--slave
--slave-allow-batching
--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.1.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.1.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.5.5.7, “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
- Section 4.5.1.1, “mysql Options”
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Section 4.6.10.1, “MySQL Instance Manager Command Options”
- Section 5.6, “Running Multiple MySQL Servers on the Same Machine”
- Section 5.1.2, “Server Command Options”
--sort-records=N
--sort-records=index_num
--sort-recover
--sort_buffer_size=16M
--spassword[=password]
--sporadic-binlog-dump-fail
--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 5.3.2, “Making MySQL Secure Against Attackers”
- Section 16.1.3.3, “Replication Slave Options and Variables”
- Section 5.5.7.3, “SSL Command Options”
- Section 5.3.3, “Security-Related mysqld Options”
- Section 5.1.2, “Server Command Options”
- Section 5.5.7.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
--ssl-xxx
--standalone
--start-datetime
--start-datetime=datetime
--start-position=N
--start_row=N
--statefile=file_name
--stats
--status
--stop-datetime=datetime
--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=path
--table_cache
--table_open_cache
--tables
--tc-heuristic-recover={COMMIT|ROLLBACK}
--tcp-ip
--tee=file_name
--temp-pool
--test
--thread_cache_size=5'
--thread_handling=no-threads
--thread_stack=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
--triggers
--type=engine_name
--tz-utc
--unbuffered
--unpack
--update-state
--upgrade-system-tables
--use-frm
--use-manager
--use-mysqld_safe
--use-threads
--use-threads=N
--user
- Section B.1.2.18, “'
File' Not Found and Similar Errors” - Description
- Description
- Description
- Section 6.2, “Example Backup and Recovery Strategy”
- Section 2.2, “Installing MySQL from Generic Binaries on Unix/Linux”
- Section 2.9, “Installing MySQL on i5/OS”
- Section 4.2.1, “Invoking MySQL Programs”
- Section 4.2.3.5, “Option Defaults, Options Expecting Values, and the
=Sign” - Section 5.1.2, “Server Command Options”
- Section 2.3.1, “Source Installation Overview”
- Section 2.13.2, “Unix Post-Installation Procedures”
- Section 5.5.1, “User Names and Passwords”
- Section 4.2.3.3, “Using Option Files”
--user=mysql
--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.5, “How to Run MySQL as a Normal User”
- Section 4.6.10.1, “MySQL Instance Manager Command Options”
--user={user_name|user_id}
--username
--username=user_name
--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.5.5.5, “Starting MySQL from the Windows Command Line”
- Section 2.13.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 4.6.10.1, “MySQL Instance Manager Command Options”
- Section 5.1.2, “Server Command Options”
- Section 4.2.3.1, “Using Options on the Command Line”
--vertical
--wait-timeout=N
--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 22.5.1.1, “Compiling MySQL for Debugging”
- Section 2.3.4, “Dealing with Problems Compiling MySQL”
- Section 22.5.2, “Debugging a MySQL Client”
- Section 7.5.1, “How Compiling and Linking Affects the Speed of MySQL”
- Section 2.2, “Installing MySQL from Generic Binaries on Unix/Linux”
- Section 5.1.2, “Server Command Options”
- Section 2.3.2, “Typical configure Options”
- Section B.1.4.2, “What to Do If MySQL Keeps Crashing”
--with-debug=full
- Section 22.5.1.1, “Compiling MySQL for Debugging”
- Section 22.5.2, “Debugging a MySQL Client”
- Description
- Section 7.5.1, “How Compiling and Linking Affects the Speed of MySQL”
- Section 2.2, “Installing MySQL from Generic Binaries on Unix/Linux”
- Section 5.1.2, “Server Command Options”
- Section B.1.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-extra-charsets=list-of-charsets | complex | all | none
--with-federated-storage-engine
--with-innodb
--with-libwrap
--with-low-memory
--with-max-indexes=N
--with-mit-threads
--with-mysqld-ldflags=-all-static
--with-mysqld-ldflags=-rdynamic
--with-named-z-libs
--with-ndb-sci=/opt/DIS
--with-ndb-sci=/your/path/to/SCI
--with-ndb-shm
--with-ndbcluster
--with-openssl
--with-partition
--with-plugin-PLUGIN
--with-plugins
--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-plugin-PLUGIN
--without-query-cache
--write-binlog
--xml
-1
- Section 1.7.5.6, “'
--' as the Start of a Comment” - Section 11.12.1, “
GROUP BY(Aggregate) Functions” - Section 18.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.4.1.1, “Upgrading from MySQL 5.0 to 5.1”
-?
- 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 4.6.10.1, “MySQL Instance Manager Command Options”
- 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 file_name
-P
-P port_num
-P[password]
-Q
-R index_num
-R record_pos_file record_pos
-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 4.6.10.1, “MySQL Instance Manager Command Options”
- Section 5.1.2, “Server Command Options”
- Section 4.2.3.1, “Using Options on the Command Line”
-W
-W [level]
-a
-c
-c column_list
-c file_name
-d
-d db_name
-e
- Section 4.6.3.2, “myisamchk Check Options”
- Section 4.6.3.1, “myisamchk General Options”
- Section 4.6.3.3, “myisamchk Repair Options”
- Description
- Description
- Section 6.4.2, “How to Check
MyISAMTables for Errors” - MySQL 4.1 FAQ — MySQL Cluster
- Section 17.2.5, “Safe Shutdown and Restart of MySQL Cluster”
- Section 4.2.3.1, “Using Options on the Command Line”
- Section 17.5.3.2, “Using The MySQL Cluster Management Client to Create a Backup”
-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
- Section 4.6.3.2, “myisamchk Check Options”
- Section 4.5.1.1, “mysql Options”
- Section 17.5.2, “Commands in the MySQL Cluster Management Client”
- Description
- Description
- Description
- Description
- Description
- Section 6.4.2, “How to Check
MyISAMTables for Errors” - Section 22.5.1.3, “Using
pdbto create a Windows crashdump”
-i N
-i delay
-i name
-j N
-j big_tbl_name
-k
-l
-l path
-libmysqlclient
-libmysqld
-lmysqlclient
-lmysqlclient -lz
-lmysqld
-lz
-mcpu=v8 -Wa,-xarch=v8plusa
-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 17.5.10.3, “Adding MySQL Cluster Data Nodes Online: Detailed Example”
- 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.5.6.2, “End-User Guidelines for Password Security”
- Section 4.6.10.4, “Instance Manager User and Password Management”
- Section 4.2.1, “Invoking MySQL Programs”
- Section B.1.2.5, “Password Fails When Entered Interactively”
- Section 2.5.5.6, “Starting MySQL as a Windows Service”
- Section 2.5.5.5, “Starting MySQL from the Windows Command Line”
- Section 2.5.5.7, “Testing The MySQL Installation”
- Section 2.5.7, “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.13.1, “Windows Post-Installation Procedures”
-p N
-p len
-p num
-p[pass_val]
-p[password]
-ppassword
-q
-q value
-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.4.2, “How to Check
MyISAMTables for Errors” - Section 6.4.3, “How to Repair Tables”
- Section 6.4.5, “Setting Up a Table Maintenance Schedule”
-s file_name
-s num
-s sort_type
-signal
-skip-auto-rehash
-slow_query_log_file
-t
-t N
-t path
-u
- Section 4.6.3.3, “myisamchk Repair Options”
- Description
- Section 4.6.10.4, “Instance Manager User and Password Management”
- Section 4.2.1, “Invoking MySQL Programs”
- Section 2.5.5.7, “Testing The MySQL Installation”
- Section 5.5.1, “User Names and Passwords”
- Section 2.13.1, “Windows Post-Installation Procedures”
-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.4.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
Arbitration
ArbitrationDelay
ArbitrationRank
ArbitrationTimeout
BackupDataBufferSize
BackupDataDir
BackupLogBufferSize
BackupMaxWriteSize
BackupMemory
BackupReportFrequency
BackupWriteSize
BatchSizePerLocalScan
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
CompressedBackup
CompressedLCP
DataDir
- Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
- Section 17.3.2.5, “Defining a MySQL Cluster Management Server”
- Description
- Section 17.5.4, “Event Reports Generated in MySQL Cluster”
- Section 17.5, “Management of MySQL Cluster”
- Section 17.5.9.1, “MySQL Cluster Disk Data Objects”
- Section 17.5.8.3, “MySQL Cluster and MySQL Security Procedures”
- Section 17.3.1, “Quick Test Setup of MySQL Cluster”
- Section 17.5.9.2, “Using Symbolic Links with Disk Data Objects”
- Section 17.5.3.2, “Using The MySQL Cluster Management Client to Create a Backup”
DataMemory
- Section B.1.2.12, “
The table is full” - Section 17.3.2.12, “Configuring MySQL Cluster Parameters for Local Checkpoints”
- Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
- Section 17.1.5.2, “Limits and Differences of MySQL Cluster from Standard MySQL Limits”
- MySQL 4.1 FAQ — MySQL Cluster
- Section 17.3.2.1, “MySQL Cluster Configuration — Basic Example”
- Section 17.5.9.3, “MySQL Cluster Disk Data Storage Requirements”
DiskCheckpointSpeed
DiskCheckpointSpeedInRestart
DiskIOThreadPool
DiskPageBufferMemory
DiskSyncSize
ExecuteOnComputer
FileSystemPath
FileSystemPathDD
FileSystemPathDataFiles
FileSystemPathUndoFiles
FragmentLogFileSize
HeartbeatIntervalDbApi
HeartbeatIntervalDbDb
HostName
- Section 17.3.2.4, “Defining Computers in a MySQL Cluster”
- Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
- Section 17.3.2.7, “Defining SQL and Other API Nodes in a MySQL Cluster”
- Section 17.3.2.5, “Defining a MySQL Cluster Management Server”
- Section 17.2, “MySQL Cluster Multi-Computer How-To”
- Section 17.5.8.1, “MySQL Cluster Security and Networking Issues”
- Section 17.3.1, “Quick Test Setup of MySQL Cluster”
Id
- Section 17.3.4.2, “mysqld Command Options for MySQL Cluster”
- Section 12.5.5.5, “
SHOW COLLATIONSyntax” - Section 12.5.5.31, “
SHOW PROCESSLISTSyntax” - Section 21.9.1, “C API Data Types”
- Section 9.5.2, “Choosing a Collation ID”
- Section 17.3.2.4, “Defining Computers in a MySQL Cluster”
- Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
- Section 17.3.2.7, “Defining SQL and Other API Nodes in a MySQL Cluster”
- Section 17.3.2.5, “Defining a MySQL Cluster Management Server”
- Section 7.5.6, “Examining Thread Information”
- Section 17.3.2.8, “MySQL Cluster TCP/IP Connections”
- Section 20.10, “The
INFORMATION_SCHEMA COLLATIONSTable” - Section 20.22, “The
INFORMATION_SCHEMA PROCESSLISTTable”
IndexMemory
InitFragmentLogFiles
InitialLogFileGroup
InitialNoOfOpenFiles
InitialTablespace
LockExecuteThreadToCPU
LockMaintThreadsToCPU
LockPagesInMainMemory
LogDestination
LogLevelCheckpoint
LogLevelCongestion
LogLevelConnection
LogLevelError
LogLevelNodeRestart
LogLevelShutdown
LogLevelStartup
LogLevelStatistic
LongMessageBuffer
MaxAllocate
MaxBufferedEpochs
MaxLCPStartDelay
MaxNoOfAttributes
MaxNoOfConcurrentIndexOperations
MaxNoOfConcurrentOperations
MaxNoOfConcurrentScans
MaxNoOfConcurrentSubOperations
MaxNoOfConcurrentTransactions
MaxNoOfExecutionThreads
MaxNoOfFiredTriggers
MaxNoOfLocalOperations
MaxNoOfLocalScans
MaxNoOfOpenFiles
MaxNoOfOrderedIndexes
MaxNoOfSavedMessages
MaxNoOfSubscribers
MaxNoOfSubscriptions
MaxNoOfTables
MaxNoOfTriggers
MaxNoOfUniqueHashIndexes
MemReportFrequency
Name
- Section 12.5.5.1, “
SHOW AUTHORSSyntax” - Section 12.5.5.7, “
SHOW CONTRIBUTORSSyntax” - Section 12.5.5.16, “
SHOW ENGINESyntax” - Section 12.5.5.19, “
SHOW EVENTSSyntax” - Section 12.5.5.38, “
SHOW TABLE STATUSSyntax” - Section 20.20, “The
INFORMATION_SCHEMA EVENTSTable” - Section 20.17, “The
INFORMATION_SCHEMA PLUGINSTable”
Ndb_cluster_node_id
NoOfDiskPagesToDiskAfterRestartACC
NoOfDiskPagesToDiskAfterRestartTUP
NoOfDiskPagesToDiskDuringRestartACC
NoOfDiskPagesToDiskDuringRestartTUP
NoOfFragmentLogFiles
NoOfReplicas
NodeGroup
NodeId1
NodeId2
OverloadLimit
PortNumber
Questions
RealtimeScheduler
ReceiveBufferMemory
ReservedSendBufferMemory
RestartOnErrorInsert
SchedulerExecutionTimer
SchedulerSpinTimer
SendBufferMemory
SendLimit
SendSignalId
SharedBufferSize
SharedGlobalMemory
StartFailureTimeout
StartPartialTimeout
StartPartitionedTimeout
StartupStatusReportFrequency
TcpBind_INADDR_ANY
TimeBetweenEpochs
TimeBetweenEpochsTimeout
TimeBetweenGlobalCheckpoints
TimeBetweenInactiveTransactionAbortCheck
TimeBetweenLocalCheckpoints
TimeBetweenWatchDogCheck
TimeBetweenWatchDogCheckInitial
TotalSendBufferMemory
- Section 17.3.2.13, “Configuring MySQL Cluster Send Buffer Parameters”
- Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
- Section 17.3.2.7, “Defining SQL and Other API Nodes in a MySQL Cluster”
- Section 17.3.2.5, “Defining a MySQL Cluster Management Server”
- Section 17.1.4.5, “Features Added in MySQL Cluster NDB 7.0”
- Section 17.3.2.8, “MySQL Cluster TCP/IP Connections”
TransactionBufferMemory
TransactionDeadlockDetectionTimeout
TransactionInactiveTimeout
UndoDataBuffer
UndoIndexBuffer
\G
\s
\t
all
ansi
basedir
c
compress
connect_timeout
count
d
data
datadir
- Section 2.5.5.2, “Creating an Option File”
- Section 2.7.5, “MySQL Installation on Mac OS X Notes”
- Section 2.13.2.2, “Starting and Stopping MySQL Automatically”
- Section 4.6.10.3, “Starting the MySQL Server with MySQL Instance Manager”
- Section 2.5.6, “Troubleshooting a MySQL Installation Under Windows”
- Section D.7.3, “Windows Platform Limitations”
db
- Section 12.5.1.3, “
GRANTSyntax” - Section 12.5.5.31, “
SHOW PROCESSLISTSyntax” - Section 21.9.3.3, “
mysql_change_user()” - Section 21.9.3.8, “
mysql_create_db()” - Section 21.9.3.11, “
mysql_drop_db()” - Section 21.9.3.52, “
mysql_real_connect()” - Section 21.9.3.60, “
mysql_select_db()” - Section 5.4.5, “Access Control, Stage 2: Request Verification”
- Section 5.5.2, “Adding User Accounts”
- Section 21.9.1, “C API Data Types”
- Section 5.4.7, “Causes of Access-Denied Errors”
- Section 2.4.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 20.22, “The
INFORMATION_SCHEMA PROCESSLISTTable” - Section 20.14, “The
INFORMATION_SCHEMA ROUTINESTable” - Section 2.13.2, “Unix Post-Installation Procedures”
decode_bits
default-storage-engine
default-table-type
defaults-extra-file
delimiter
description
extended-status
flush-hosts
flush-logs
flush-privileges
flush-status
flush-tables
flush-threads
ft_max_word_len
ft_min_word_len
ft_stopword_file
general_log
have_partition_engine
have_profiling
help
host
- Section 12.5.1.3, “
GRANTSyntax” - Section 21.9.3.7, “
mysql_connect()” - Section 21.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.4.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.13.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
init-file
innodb
innodb_file_per_table
innodb_safe_binlog
innodb_status_file=1
innodb_support_xa
innodb_table_locks
key_buffer_size
ledir
length
- Section 21.9.3.34, “
mysql_hex_string()” - Section 21.9.3.53, “
mysql_real_escape_string()” - Section 21.9.3.54, “
mysql_real_query()” - Section 21.9.7.11, “
mysql_stmt_fetch()” - Section 21.9.7.20, “
mysql_stmt_prepare()” - Section 21.9.7.25, “
mysql_stmt_send_long_data()” - Section 21.9.1, “C API Data Types”
- Section 21.9.5, “C API Prepared Statement Data types”
- Section 22.2.3.3, “Creating a Plugin Library”
- Section 22.2.3.2, “Type-Specific Plugin Structures and Functions”
log_bin_trust_routine_creators
max_allowed_packet
multi_range_count
myisam_block_size
myisam_stats_method
mysql
- Section 4.5.1.1, “mysql Options”
- Section 4.5.1.3, “mysql Server-Side Help”
- Section 12.5.3.1, “
CREATE FUNCTIONSyntax” - Section 12.1.16, “
CREATE SERVERSyntax” - Section 12.5.1.1, “
CREATE USERSyntax” - Section B.1.2.4, “
Client does not support authentication protocol” - Section 12.5.3.2, “
DROP FUNCTIONSyntax” - Section 12.5.1.2, “
DROP USERSyntax” - Section 12.5.6.3, “
FLUSHSyntax” - Section 12.5.1.3, “
GRANTSyntax” - Section 12.3.3, “
HELPSyntax” - Section 12.6.2.2, “
LOAD DATA FROM MASTERSyntax” - Section B.1.2.9, “
MySQL server has gone away” - Section 12.5.1.4, “
RENAME USERSyntax” - Section 12.5.1.5, “
REVOKESyntax” - Section 12.5.1.6, “
SET PASSWORDSyntax” - Section 12.5.5.22, “
SHOW GRANTSSyntax” - Section 21.9.3.3, “
mysql_change_user()” - Section 21.9.3.5, “
mysql_close()” - Section 21.9.3.14, “
mysql_errno()” - Section 21.9.3.15, “
mysql_error()” - Section 21.9.3.33, “
mysql_get_ssl_cipher()” - Section 21.9.3.36, “
mysql_init()” - Section 21.9.3.53, “
mysql_real_escape_string()” - Section 21.9.3.60, “
mysql_select_db()” - Section 21.9.3.67, “
mysql_ssl_set()” - Section 21.9.7.10, “
mysql_stmt_execute()” - Section 21.9.7.11, “
mysql_stmt_fetch()” - Section 21.9.7.25, “
mysql_stmt_send_long_data()” - Section 5.4.4, “Access Control, Stage 1: Connection Verification”
- Section 12.5.1, “Account Management Statements”
- Section 5.5.2, “Adding User Accounts”
- Section 5.5.6.1, “Administrator Guidelines for Password Security”
- Section 5.5.5, “Assigning Account Passwords”
- Section 6.2.1, “Backup Policy”
- Section 21.9.14, “C API Prepared Statement Handling of Date and Time Values”
- Section 5.4.7, “Causes of Access-Denied Errors”
- Section 22.2.1, “Characteristics of the Plugin Interface”
- Section 22.3.2.5, “Compiling and Installing User-Defined Functions”
- Section 9.1.4, “Connection Character Sets and Collations”
- Chapter 21, Connectors and APIs
- Section 13.6.4.2, “Converting Tables from Other Storage Engines to
InnoDB” - Section 2.4.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”
- Section 17.3.2.7, “Defining SQL and Other API Nodes in a MySQL Cluster”
- Description
- Description
- Description
- Description
- Section 2.4.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.2, “Installing MySQL from Generic Binaries on Unix/Linux”
- Section 2.6.1, “Installing MySQL from RPM Packages on Linux”
- Section 2.7, “Installing MySQL on Mac OS X”
- Section 2.8, “Installing MySQL on Solaris”
- Section 5.5.4, “Limiting Account Resources”
- Section 5.2.4.4, “Logging Format for Changes to
mysqlDatabase Tables” - Section 5.3.2, “Making MySQL Secure Against Attackers”
- Section 5.2.4.3, “Mixed Binary Logging Format”
- Section 1.4.1, “What Is New in MySQL 5.1”
- Section 17.2.1, “MySQL Cluster Multi-Computer Installation”
- Section 17.5.8.2, “MySQL Cluster and MySQL Privileges”
- Section 17.5.8.3, “MySQL Cluster and MySQL Security Procedures”
- Section 2.7.5, “MySQL Installation on Mac OS X Notes”
- Section 21.10, “MySQL PHP API”
- Section 9.7, “MySQL Server Time Zone Support”
- Section 12.4.5.3, “Other Table-Locking Notes”
- Section 4.1, “Overview of MySQL Programs”
- Section 5.5.6.3, “Password Hashing in MySQL”
- Section 5.4.2, “Privilege System Grant Tables”
- Section 5.4.1, “Privileges Provided by MySQL”
- Section 2.13.2.1, “Problems Running mysql_install_db”
- Section 16.3.1, “Replication Features and Issues”
- Section 16.3.1.10, “Replication and
FLUSH” - Section 16.3.1.19, “Replication of the System
mysqlDatabase” - Section B.1.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.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 2.3.1, “Source Installation Overview”
- Section 5.6.1.1, “Starting Multiple Windows Servers at the Command Line”
- Section 2.13.2.2, “Starting and Stopping MySQL Automatically”
- Section 2.13.2.3, “Starting and Troubleshooting the MySQL Server”
- Section 12.4.3, “Statements That Cause an Implicit Commit”
- Section 9.7.1, “Staying Current with Time Zone Changes”
- Section 5.4, “The MySQL Access Privilege System”
- Section 22.2, “The MySQL Plugin Interface”
- Section 2.5.6, “Troubleshooting a MySQL Installation Under Windows”
- Section 2.13.2, “Unix Post-Installation Procedures”
- Section 2.4.1, “Upgrading MySQL”
- Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”
- 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.7.2, “Using SSL Connections”
- Section 22.5.1.6, “Using Server Logs to Find Causes of Errors in mysqld”
- Section 19.2, “Using Stored Routines (Procedures and Functions)”
- Section 2.13.1, “Windows Post-Installation Procedures”
mysql.server
mysqlaccess
mysqlbinlog
mysqld
- Section B.1.2.2, “
Can't connect to [local] MySQL server” - Section 21.9.2, “C API Function Overview”
- Description
- Description
- Section 13.11.1, “
FEDERATEDStorage Engine Overview” - Section 2.9, “Installing MySQL on i5/OS”
- Section 5.2.4.3, “Mixed Binary Logging Format”
- Section 17.3.4.1, “MySQL Cluster Server Option and Variable Reference”
- Section 4.6.10.7, “MySQL Instance Manager Commands”
- Section 16.4.2, “Replication Relay and Status Files”
- Section 5.1.1, “Server Option and Variable Reference”
- Section 4.6.10.3, “Starting the MySQL Server with MySQL Instance Manager”
- Section 5.2.2, “The Error Log”
- Section 16.4.2.2, “The Slave Status Files”
- Section 22.5.1.3, “Using
pdbto create a Windows crashdump”
mysqld-path=path-to-mysqld-binary
mysqld_safe
mysqldump
mysqldumpslow
mysqlhotcopy
mysqlslap
ndb-connectstring
ndb_optimization_delay
ndb_table_no_logging
ndb_table_temporary
net_retry_count
net_write_timeout
nice
nonguarded
offset
old-alter-table
open-files-limit
open_files_limit
p
partition
password
pid-file
pipe
plugin
plugin-load
port
processlist
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.2, “Setting the Replication Master Configuration”
- Section 16.1.1.3, “Setting the Replication Slave Configuration”
set-variable
set-variable=option=value
shutdown
shutdown_timeout
skip-innodb
skip-networking
slow_query_log
socket
sort_buffer_size
sort_key_blocks
source
sql-mode=""
sql-mode="modes"
sql_big_tables
sql_low_priority_updates
sql_max_join_size
start-slave
stats_method
status
- Section 4.5.1.2, “mysql Commands”
- Section 12.5.2.1, “
ANALYZE TABLESyntax” - Section 12.5.2.2, “
BACKUP TABLESyntax” - Section 12.5.2.3, “
CHECK TABLESyntax” - Section 12.5.2.5, “
OPTIMIZE TABLESyntax” - Section 12.5.2.6, “
REPAIR TABLESyntax” - Section 12.5.2.7, “
RESTORE TABLESyntax” - Description
- Section 4.6.10.5, “MySQL Server Instance Status Monitoring”
stop-slave
syslog
table
test
- Section 12.2.2, “
DELETESyntax” - Section 7.2.20, “
INFORMATION_SCHEMAOptimization” - Section 13.6.13.2.3, “
InnoDBTable Monitor Output” - Section 12.5.5.19, “
SHOW EVENTSSyntax” - 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 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.13.3, “Securing the Initial MySQL Accounts”
- Section 19.2.1, “Stored Routine Syntax”
- Section 20.19, “The
INFORMATION_SCHEMA PARTITIONSTable” - Section 2.13.2, “Unix Post-Installation Procedures”
- Section 4.2.3.1, “Using Options on the Command Line”
tmpdir
- Section 4.6.3.3, “myisamchk Repair Options”
- Section B.1.2.13, “
Can't create/write to file” - Section 7.2.13, “
ORDER BYOptimization” - Section 6.1, “Database Backup Methods”
- Section 2.5, “Installing MySQL on Windows”
- Section 16.4.2, “Replication Relay and Status Files”
- Section 16.1.3.3, “Replication Slave Options and Variables”
- Section 5.1.4, “Server System Variables”
transaction_allow_batching
type
- Section 12.5.3.1, “
CREATE FUNCTIONSyntax” - Section 13.6.13.2.3, “
InnoDBTable Monitor Output” - Section 21.9.1, “C API Data Types”
- Section 22.2.3.1, “General Plugin Structures and Functions”
- Section 7.2.19, “How to Avoid Table Scans”
- Section 7.2.6, “Index Merge Optimization”
- Section 7.2.1, “Optimizing Queries with
EXPLAIN” - Section 20.14, “The
INFORMATION_SCHEMA ROUTINESTable” - Section 22.2.3.2, “Type-Specific Plugin Structures and Functions”
user
- Section 12.5.1.2, “
DROP USERSyntax” - Section B.1.2.15, “
Ignoring user” - Section 21.9.3.49, “
mysql_options()” - Section 21.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.5.6.1, “Administrator Guidelines for Password Security”
- Section 5.5.5, “Assigning Account Passwords”
- Section 5.5.9, “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.4.5, “Copying MySQL Databases to Another Machine”
- Section 17.3.2.5, “Defining a MySQL Cluster Management Server”
- Description
- Section 11.11.2, “Encryption and Compression Functions”
- Section 5.3.1, “General Security Guidelines”
- Section 5.3.5, “How to Run MySQL as a Normal User”
- Section 5.5.4, “Limiting Account Resources”
- Section 5.3.2, “Making MySQL Secure Against Attackers”
- Section 5.5.6.3, “Password Hashing in MySQL”
- Section 5.4.2, “Privilege System Grant Tables”
- Section 5.4.1, “Privileges Provided by MySQL”
- Section D.6, “Restrictions on Character Sets”
- Section 2.13.3, “Securing the Initial MySQL Accounts”
- Section 5.1.2, “Server Command Options”
- Section 5.4.3, “Specifying Account Names”
- Section 2.13.2.2, “Starting and Stopping MySQL Automatically”
- Section 2.13.2, “Unix Post-Installation Procedures”
- Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”
- Section 5.5.1, “User Names and Passwords”
- Section 5.5.7.2, “Using SSL Connections”
- Section 11.10, “XML Functions”
variables
version
write_buffer_size
© 1995-2008 MySQL AB, 2008-2009 Sun Microsystems, Inc.
User Comments
Add your own comment.