windows 下使用 zip安装包安装MySQL 5.7

以下内容参考官方文档：http://dev.mysql.com/doc/refman/5.7/en/windows-start-command-line.html

解压缩zip到D:\mysql-5.7.13-winx64，建立data目录D:\mysql-5.7.13-winx64\data，

在D:\mysql-5.7.13-winx64创建配置文件my.ini，详见：

[mysqld]
# set basedir to your installation path
basedir=D:\mysql-5.7.13-winx64
# set datadir to the location of your data directory
datadir=D:\mysql-5.7.13-winx64\data

初始化数据目录：

bin\mysqld --initialize --产生随机密码
bin\mysqld --initialize-insecure --密码为空

连接服务端

D:\mysql-5.7.13-winx64\bin>mysql -u root -p
Enter password: *********
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 18
Server version: 5.7.13 MySQL Community Server (GPL)

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

 

修改用户密码

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';

方法一: 
(适用于管理员或者有全局权限的用户重设其它用户的密码)
进入命令行模式
mysql -u root -p
 
mysql>use mysql;
mysql> UPDATE user SET password=PASSWORD("new password") WHERE user='username';
mysql> FLUSH PRIVILEGES;
mysql> quit;
 
方法二:
mysql -u root -p 
mysql>use mysql; 
mysql> SET PASSWORD FOR   username=PASSWORD('new password');
mysql> QUIT

 

update mysql.user set authentication_string=password('root') where user='root' and Host = 'localhost';

 

 

以控制台方式启动MySQL服务

mysqld --console

将MySQL安装成Windows服务

mysqld --install 

mysqld命令参数详解

mysqld  Ver 5.7.13 for Win64 on x86_64 (MySQL Community Server (GPL))
Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Starts the MySQL database server.

Usage: mysqld [OPTIONS]
NT and Win32 specific options:
  --install                     Install the default service (NT).
  --install-manual              Install the default service started manually (NT).
  --install service_name        Install an optional service (NT).
  --install-manual service_name Install an optional service started manually (NT).
  --remove                      Remove the default service from the service list (NT).
  --remove service_name         Remove the service_name from the service list (NT).
  --enable-named-pipe           Only to be used for the default server (NT).
  --standalone                  Dummy option to start as a standalone server (NT).


Default options are read from the following files in the given order:
C:\Windows\my.ini C:\Windows\my.cnf C:\my.ini C:\my.cnf F:\temp\20160708\mysql-5.7.13-winx64\mysql-5.7.13-winx64\my.ini F:\temp\20160708\mysql-5.7.13-winx64\mysql-5.7.13-winx64\my.cnf 
The following groups are read: mysqld server mysqld-5.7
The following options may be given as the first argument:
--print-defaults        Print the program argument list and exit.
--no-defaults           Don't read default options from any option file,
                        except for login file.
--defaults-file=#       Only read default options from the given file #.
--defaults-extra-file=# Read this file after the global files are read.
--defaults-group-suffix=#
                        Also read groups with concat(group, suffix)
--login-path=#          Read this path from the login file.

  --abort-slave-event-count=# 
                      Option used by mysql-test for debugging and testing of
                      replication.
  --allow-suspicious-udfs 
                      Allows use of UDFs consisting of only one symbol xxx()
                      without corresponding xxx_init() or xxx_deinit(). That
                      also means that one can load any function from any
                      library, for example exit() from libc.so
  -a, --ansi          Use ANSI SQL syntax instead of MySQL syntax. This mode
                      will also set transaction isolation level 'serializable'.
  --archive[=name]    Enable or disable ARCHIVE plugin. Possible values are ON,
                      OFF, FORCE (don't start if the plugin fails to load).
  --auto-increment-increment[=#] 
                      Auto-increment columns are incremented by this
  --auto-increment-offset[=#] 
                      Offset added to Auto-increment columns. Used when
                      auto-increment-increment != 1
  --autocommit        Set default value for autocommit (0 or 1)
                      (Defaults to on; use --skip-autocommit to disable.)
  --automatic-sp-privileges 
                      Creating and dropping stored procedures alters ACLs
                      (Defaults to on; use --skip-automatic-sp-privileges to disable.)
  --avoid-temporal-upgrade 
                      When this option is enabled, the pre-5.6.4 temporal types
                      are not upgraded to the new format for ALTER TABLE
                      requests ADD/CHANGE/MODIFY COLUMN, ADD INDEX or FORCE
                      operation. This variable is deprecated and will be
                      removed in a future release.
  --back-log=#        The number of outstanding connection requests MySQL can
                      have. This comes into play when the main MySQL thread
                      gets very many connection requests in a very short time
  -b, --basedir=name  Path to installation directory. All paths are usually
                      resolved relative to this
  --big-tables        Allow big result sets by saving all temporary sets on
                      file (Solves most 'table full' errors)
  --bind-address=name IP address to bind to.
  --binlog-cache-size=# 
                      The size of the transactional cache for updates to
                      transactional engines for the binary log. If you often
                      use transactions containing many statements, you can
                      increase this to get more performance
  --binlog-checksum=name 
                      Type of BINLOG_CHECKSUM_ALG. Include checksum for log
                      events in the binary log. Possible values are NONE and
                      CRC32; default is CRC32.
  --binlog-direct-non-transactional-updates 
                      Causes updates to non-transactional engines using
                      statement format to be written directly to binary log.
                      Before using this option make sure that there are no
                      dependencies between transactional and non-transactional
                      tables such as in the statement INSERT INTO t_myisam
                      SELECT * FROM t_innodb; otherwise, slaves may diverge
                      from the master.
  --binlog-do-db=name Tells the master it should log updates for the specified
                      database, and exclude all others not explicitly
                      mentioned.
  --binlog-error-action=name 
                      When statements cannot be written to the binary log due
                      to a fatal error, the server can either ignore the error
                      and let the master continue, or abort.
  --binlog-format=name 
                      What form of binary logging the master will use: either
                      ROW for row-based binary logging, STATEMENT for
                      statement-based binary logging, or MIXED. MIXED is
                      statement-based binary logging except for those
                      statements where only row-based is correct: those which
                      involve user-defined functions (i.e. UDFs) or the UUID()
                      function; for those, row-based binary logging is
                      automatically used. If NDBCLUSTER is enabled and
                      binlog-format is MIXED, the format switches to row-based
                      and back implicitly per each query accessing an
                      NDBCLUSTER table
  --binlog-group-commit-sync-delay=# 
                      The number of microseconds the server waits for the
                      binary log group commit sync queue to fill before
                      continuing. Default: 0. Min: 0. Max: 1000000.
  --binlog-group-commit-sync-no-delay-count=# 
                      If there are this many transactions in the commit sync
                      queue and the server is waiting for more transactions to
                      be enqueued (as set using
                      --binlog-group-commit-sync-delay), the commit procedure
                      resumes.
  --binlog-gtid-simple-recovery 
                      If this option is enabled, the server does not open more
                      than two binary logs when initializing GTID_PURGED and
                      GTID_EXECUTED, either during server restart or when
                      binary logs are being purged. Enabling this option is
                      useful when the server has already generated many binary
                      logs without GTID events (e.g., having GTID_MODE = OFF).
                      Note: If this option is enabled, GLOBAL.GTID_EXECUTED and
                      GLOBAL.GTID_PURGED may be initialized wrongly in two
                      cases: (1) All binary logs were generated by MySQL 5.7.5
                      or older, and GTID_MODE was ON for some binary logs but
                      OFF for the newest binary log. (2) The oldest existing
                      binary log was generated by MySQL 5.7.5 or older, and SET
                      GTID_PURGED was issued after the oldest binary log was
                      generated. If a wrong set is computed in one of case (1)
                      or case (2), it will remain wrong even if the server is
                      later restarted with this option disabled.
                      (Defaults to on; use --skip-binlog-gtid-simple-recovery to disable.)
  --binlog-ignore-db=name 
                      Tells the master that updates to the given database
                      should not be logged to the binary log.
  --binlog-max-flush-queue-time=# 
                      The maximum time that the binary log group commit will
                      keep reading transactions before it flush the
                      transactions to the binary log (and optionally sync,
                      depending on the value of sync_binlog).
  --binlog-order-commits 
                      Issue internal commit calls in the same order as
                      transactions are written to the binary log. Default is to
                      order commits.
                      (Defaults to on; use --skip-binlog-order-commits to disable.)
  --binlog-row-event-max-size=# 
                      The maximum size of a row-based binary log event in
                      bytes. Rows will be grouped into events smaller than this
                      size if possible. The value has to be a multiple of 256.
  --binlog-row-image=name 
                      Controls whether rows should be logged in 'FULL',
                      'NOBLOB' or 'MINIMAL' formats. 'FULL', means that all
                      columns in the before and after image are logged.
                      'NOBLOB', means that mysqld avoids logging blob columns
                      whenever possible (eg, blob column was not changed or is
                      not part of primary key). 'MINIMAL', means that a PK
                      equivalent (PK columns or full row if there is no PK in
                      the table) is logged in the before image, and only
                      changed columns are logged in the after image. (Default:
                      FULL).
  --binlog-rows-query-log-events 
                      Allow writing of Rows_query_log events into binary log.
  --binlog-stmt-cache-size=# 
                      The size of the statement cache for updates to
                      non-transactional engines for the binary log. If you
                      often use statements updating a great number of rows, you
                      can increase this to get more performance
  --blackhole[=name]  Enable or disable BLACKHOLE plugin. Possible values are
                      ON, OFF, FORCE (don't start if the plugin fails to load).
  --block-encryption-mode=name 
                      mode for AES_ENCRYPT/AES_DECRYPT
  --bootstrap         Used by mysql installation scripts.
  --bulk-insert-buffer-size=# 
                      Size of tree cache used in bulk insert optimisation. Note
                      that this is a limit per thread!
  --character-set-client-handshake 
                      Don't ignore client side character set value sent during
                      handshake.
                      (Defaults to on; use --skip-character-set-client-handshake to disable.)
  --character-set-filesystem=name 
                      Set the filesystem character set.
  -C, --character-set-server=name 
                      Set the default character set.
  --character-sets-dir=name 
                      Directory where character sets are
  --check-proxy-users If set to FALSE (the default), then proxy user identity
                      will not be mapped for authentication plugins which
                      support mapping from grant tables.  When set to TRUE,
                      users associated with authentication plugins which signal
                      proxy user mapping should be done according to GRANT
                      PROXY privilege definition.
  -r, --chroot=name   Chroot mysqld daemon during startup.
  --collation-server=name 
                      Set the default collation.
  --completion-type=name 
                      The transaction completion type, one of NO_CHAIN, CHAIN,
                      RELEASE
  --concurrent-insert[=name] 
                      Use concurrent insert with MyISAM. Possible values are
                      NEVER, AUTO, ALWAYS
  --connect-timeout=# The number of seconds the mysqld server is waiting for a
                      connect packet before responding with 'Bad handshake'
  --console           Write error output on screen; don't remove the console
                      window on windows.
  --core-file         Write core on errors.
  -h, --datadir=name  Path to the database root directory
  --date-format=name  The DATE format (ignored)
  --datetime-format=name 
                      The DATETIME format (ignored)
  --default-authentication-plugin=name 
                      The default authentication plugin used by the server to
                      hash the password.
  --default-password-lifetime=# 
                      The number of days after which the password will expire.
  --default-storage-engine=name 
                      The default storage engine for new tables
  --default-time-zone=name 
                      Set the default time zone.
  --default-tmp-storage-engine=name 
                      The default storage engine for new explict temporary
                      tables
  --default-week-format=# 
                      The default week format used by WEEK() functions
  --delay-key-write[=name] 
                      Type of DELAY_KEY_WRITE
  --delayed-insert-limit=# 
                      After inserting delayed_insert_limit rows, the INSERT
                      DELAYED handler will check if there are any SELECT
                      statements pending. If so, it allows these to execute
                      before continuing. This variable is deprecated along with
                      INSERT DELAYED.
  --delayed-insert-timeout=# 
                      How long a INSERT DELAYED thread should wait for INSERT
                      statements before terminating. This variable is
                      deprecated along with INSERT DELAYED.
  --delayed-queue-size=# 
                      What size queue (in rows) should be allocated for
                      handling INSERT DELAYED. If the queue becomes full, any
                      client that does INSERT DELAYED will wait until there is
                      room in the queue again. This variable is deprecated
                      along with INSERT DELAYED.
  --des-key-file=name Load keys for des_encrypt() and des_encrypt from given
                      file.
  --disabled-storage-engines=name 
                      Limit CREATE TABLE for the storage engines listed
  --disconnect-on-expired-password 
                      Give clients that don't signal password expiration
                      support execution time error(s) instead of connection
                      error
                      (Defaults to on; use --skip-disconnect-on-expired-password to disable.)
  --disconnect-slave-event-count=# 
                      Option used by mysql-test for debugging and testing of
                      replication.
  --div-precision-increment=# 
                      Precision of the result of '/' operator will be increased
                      on that value
  --early-plugin-load=name 
                      Optional semicolon-separated list of plugins to load
                      before storage engine initialization, where each plugin
                      is identified as name=library, where name is the plugin
                      name and library is the plugin library in plugin_dir.
  --end-markers-in-json 
                      In JSON output ("EXPLAIN FORMAT=JSON" and optimizer
                      trace), if variable is set to 1, repeats the structure's
                      key (if it has one) near the closing bracket
  --enforce-gtid-consistency[=name] 
                      Prevents execution of statements that would be impossible
                      to log in a transactionally safe manner. Currently, the
                      disallowed statements include CREATE TEMPORARY TABLE
                      inside transactions, all updates to non-transactional
                      tables, and CREATE TABLE ... SELECT.
  --eq-range-index-dive-limit=# 
                      The optimizer will use existing index statistics instead
                      of doing index dives for equality ranges if the number of
                      equality ranges for the index is larger than or equal to
                      this number. If set to 0, index dives are always used.
  --event-scheduler[=name] 
                      Enable the event scheduler. Possible values are ON, OFF,
                      and DISABLED (keep the event scheduler completely
                      deactivated, it cannot be activated run-time)
  -T, --exit-info[=#] Used for debugging. Use at your own risk.
  --expire-logs-days=# 
                      If non-zero, binary logs will be purged after
                      expire_logs_days days; possible purges happen at startup
                      and at binary log rotation
  --explicit-defaults-for-timestamp 
                      This option causes CREATE TABLE to create all TIMESTAMP
                      columns as NULL with DEFAULT NULL attribute, Without this
                      option, TIMESTAMP columns are NOT NULL and have implicit
                      DEFAULT clauses. The old behavior is deprecated. The
                      variable can only be set by users having the SUPER
                      privilege.
  --external-locking  Use system (external) locking (disabled by default). 
                      With this option enabled you can run myisamchk to test
                      (not repair) tables while the MySQL server is running.
                      Disable with --skip-external-locking.
  --federated[=name]  Enable or disable FEDERATED plugin. Possible values are
                      ON, OFF, FORCE (don't start if the plugin fails to load).
  --flush             Flush MyISAM tables to disk between SQL commands
  --flush-time=#      A dedicated thread is created to flush all tables at the
                      given interval
  --ft-boolean-syntax=name 
                      List of operators for MATCH ... AGAINST ( ... IN BOOLEAN
                      MODE)
  --ft-max-word-len=# The maximum length of the word to be included in a
                      FULLTEXT index. Note: FULLTEXT indexes must be rebuilt
                      after changing this variable
  --ft-min-word-len=# The minimum length of the word to be included in a
                      FULLTEXT index. Note: FULLTEXT indexes must be rebuilt
                      after changing this variable
  --ft-query-expansion-limit=# 
                      Number of best matches to use for query expansion
  --ft-stopword-file=name 
                      Use stopwords from this file instead of built-in list
  --gdb               Set up signals usable for debugging.
  --general-log       Log connections and queries to a table or log file.
                      Defaults to logging to a file hostname.log, or if
                      --log-output=TABLE is used, to a table mysql.general_log.
  --general-log-file=name 
                      Log connections and queries to given file
  --group-concat-max-len=# 
                      The maximum length of the result of function 
                      GROUP_CONCAT()
  --gtid-executed-compression-period[=#] 
                      When binlog is disabled, a background thread wakes up to
                      compress the gtid_executed table every
                      gtid_executed_compression_period transactions, as a
                      special case, if variable is 0, the thread never wakes up
                      to compress the gtid_executed table.
  --gtid-mode=name    Controls whether Global Transaction Identifiers (GTIDs)
                      are enabled. Can be OFF, OFF_PERMISSIVE, ON_PERMISSIVE,
                      or ON. OFF means that no transaction has a GTID.
                      OFF_PERMISSIVE means that new transactions (committed in
                      a client session using GTID_NEXT='AUTOMATIC') are not
                      assigned any GTID, and replicated transactions are
                      allowed to have or not have a GTID. ON_PERMISSIVE means
                      that new transactions are assigned a GTID, and replicated
                      transactions are allowed to have or not have a GTID. ON
                      means that all transactions have a GTID. ON is required
                      on a master before any slave can use
                      MASTER_AUTO_POSITION=1. To safely switch from OFF to ON,
                      first set all servers to OFF_PERMISSIVE, then set all
                      servers to ON_PERMISSIVE, then wait for all transactions
                      without a GTID to be replicated and executed on all
                      servers, and finally set all servers to GTID_MODE = ON.
  -?, --help          Display this help and exit.
  --host-cache-size=# How many host names should be cached to avoid resolving.
  --ignore-builtin-innodb 
                      IGNORED. This option will be removed in future releases.
                      Disable initialization of builtin InnoDB plugin
  --ignore-db-dir=name 
                      Specifies a directory to add to the ignore list when
                      collecting database names from the datadir. Put a blank
                      argument to reset the list accumulated so far.
  --init-connect=name Command(s) that are executed for each new connection
  --init-file=name    Read SQL commands from this file at startup
  --init-slave=name   Command(s) that are executed by a slave server each time
                      the SQL thread starts
  --initialize        Create the default database and exit. Create a super user
                      with a random expired password and store it into the log.
  --initialize-insecure 
                      Create the default database and exit. Create a super user
                      with empty password.
  --innodb            Deprecated option. Provided for backward compatibility
                      only. The option has no effect on the server behaviour.
                      InnoDB is always enabled. The option will be removed in a
                      future release.
  --innodb-adaptive-flushing 
                      Attempt flushing dirty pages to avoid IO bursts at
                      checkpoints.
                      (Defaults to on; use --skip-innodb-adaptive-flushing to disable.)
  --innodb-adaptive-flushing-lwm=# 
                      Percentage of log capacity below which no adaptive
                      flushing happens.
  --innodb-adaptive-hash-index 
                      Enable InnoDB adaptive hash index (enabled by default). 
                      Disable with --skip-innodb-adaptive-hash-index.
                      (Defaults to on; use --skip-innodb-adaptive-hash-index to disable.)
  --innodb-adaptive-hash-index-parts[=#] 
                      Number of InnoDB Adapative Hash Index Partitions.
                      (default = 8). 
  --innodb-adaptive-max-sleep-delay=# 
                      The upper limit of the sleep delay in usec. Value of 0
                      disables it.
  --innodb-api-bk-commit-interval[=#] 
                      Background commit interval in seconds
  --innodb-api-disable-rowlock 
                      Disable row lock when direct access InnoDB through InnoDB
                      APIs
  --innodb-api-enable-binlog 
                      Enable binlog for applications direct access InnoDB
                      through InnoDB APIs
  --innodb-api-enable-mdl 
                      Enable MDL for applications direct access InnoDB through
                      InnoDB APIs
  --innodb-api-trx-level[=#] 
                      InnoDB API transaction isolation level
  --innodb-autoextend-increment=# 
                      Data file autoextend increment in megabytes
  --innodb-autoinc-lock-mode=# 
                      The AUTOINC lock modes supported by InnoDB: 0 => Old
                      style AUTOINC locking (for backward compatibility); 1 =>
                      New style AUTOINC locking; 2 => No AUTOINC locking
                      (unsafe for SBR)
  --innodb-buffer-pool-chunk-size=# 
                      Size of a single memory chunk within each buffer pool
                      instance for resizing buffer pool. Online buffer pool
                      resizing happens at this granularity. 0 means disable
                      resizing buffer pool.
  --innodb-buffer-pool-dump-at-shutdown 
                      Dump the buffer pool into a file named
                      @@innodb_buffer_pool_filename
                      (Defaults to on; use --skip-innodb-buffer-pool-dump-at-shutdown to disable.)
  --innodb-buffer-pool-dump-now 
                      Trigger an immediate dump of the buffer pool into a file
                      named @@innodb_buffer_pool_filename
  --innodb-buffer-pool-dump-pct=# 
                      Dump only the hottest N% of each buffer pool, defaults to
                      25
  --innodb-buffer-pool-filename=name 
                      Filename to/from which to dump/load the InnoDB buffer
                      pool
  --innodb-buffer-pool-instances=# 
                      Number of buffer pool instances, set to higher value on
                      high-end machines to increase scalability
  --innodb-buffer-pool-load-abort 
                      Abort a currently running load of the buffer pool
  --innodb-buffer-pool-load-at-startup 
                      Load the buffer pool from a file named
                      @@innodb_buffer_pool_filename
                      (Defaults to on; use --skip-innodb-buffer-pool-load-at-startup to disable.)
  --innodb-buffer-pool-load-now 
                      Trigger an immediate load of the buffer pool from a file
                      named @@innodb_buffer_pool_filename
  --innodb-buffer-pool-size=# 
                      The size of the memory buffer InnoDB uses to cache data
                      and indexes of its tables.
  --innodb-change-buffer-max-size=# 
                      Maximum on-disk size of change buffer in terms of
                      percentage of the buffer pool.
  --innodb-change-buffering=name 
                      Buffer changes to reduce random access: OFF, ON,
                      inserting, deleting, changing, or purging.
  --innodb-checksum-algorithm=name 
                      The algorithm InnoDB uses for page checksumming. Possible
                      values are CRC32 (hardware accelerated if the CPU
                      supports it) write crc32, allow any of the other
                      checksums to match when reading; STRICT_CRC32 write
                      crc32, do not allow other algorithms to match when
                      reading; INNODB write a software calculated checksum,
                      allow any other checksums to match when reading;
                      STRICT_INNODB write a software calculated checksum, do
                      not allow other algorithms to match when reading; NONE
                      write a constant magic number, do not do any checksum
                      verification when reading (same as innodb_checksums=OFF);
                      STRICT_NONE write a constant magic number, do not allow
                      values other than that magic number when reading; Files
                      updated when this option is set to crc32 or strict_crc32
                      will not be readable by MySQL versions older than 5.6.3
  --innodb-checksums  DEPRECATED. Use innodb_checksum_algorithm=NONE instead of
                      setting this to OFF. Enable InnoDB checksums validation
                      (enabled by default). Disable with
                      --skip-innodb-checksums.
                      (Defaults to on; use --skip-innodb-checksums to disable.)
  --innodb-cmp-per-index-enabled 
                      Enable INFORMATION_SCHEMA.innodb_cmp_per_index, may have
                      negative impact on performance (off by default)
  --innodb-commit-concurrency=# 
                      Helps in performance tuning in heavily concurrent
                      environments.
  --innodb-compression-failure-threshold-pct[=#] 
                      If the compression failure rate of a table is greater
                      than this number more padding is added to the pages to
                      reduce the failures. A value of zero implies no padding
  --innodb-compression-level=# 
                      Compression level used for compressed row format.  0 is
                      no compression, 1 is fastest, 9 is best compression and
                      default is 6.
  --innodb-compression-pad-pct-max[=#] 
                      Percentage of empty space on a data page that can be
                      reserved to make the page compressible.
  --innodb-concurrency-tickets=# 
                      Number of times a thread is allowed to enter InnoDB
                      within the same SQL query after it has once got the
                      ticket
  --innodb-data-file-path=name 
                      Path to individual files and their sizes.
  --innodb-data-home-dir=name 
                      The common part for InnoDB table spaces.
  --innodb-default-row-format=name 
                      The default ROW FORMAT for all innodb tables created
                      without explicit ROW_FORMAT. Possible values are
                      REDUNDANT, COMPACT, and DYNAMIC. The ROW_FORMAT value
                      COMPRESSED is not allowed
  --innodb-disable-sort-file-cache 
                      Whether to disable OS system file cache for sort I/O
  --innodb-doublewrite 
                      Enable InnoDB doublewrite buffer (enabled by default).
                      Disable with --skip-innodb-doublewrite.
                      (Defaults to on; use --skip-innodb-doublewrite to disable.)
  --innodb-fast-shutdown[=#] 
                      Speeds up the shutdown process of the InnoDB storage
                      engine. Possible values are 0, 1 (faster) or 2 (fastest -
                      crash-like).
  --innodb-file-format=name 
                      File format to use for new tables in .ibd files.
  --innodb-file-format-check 
                      Whether to perform system file format check.
                      (Defaults to on; use --skip-innodb-file-format-check to disable.)
  --innodb-file-format-max[=name] 
                      The highest file format in the tablespace.
  --innodb-file-per-table 
                      Stores each InnoDB table to an .ibd file in the database
                      dir.
                      (Defaults to on; use --skip-innodb-file-per-table to disable.)
  --innodb-fill-factor=# 
                      Percentage of B-tree page filled during bulk insert
  --innodb-flush-log-at-timeout[=#] 
                      Write and flush logs every (n) second.
  --innodb-flush-log-at-trx-commit[=#] 
                      Set to 0 (write and flush once per second), 1 (write and
                      flush at each commit) or 2 (write at commit, flush once
                      per second).
  --innodb-flush-method=name 
                      With which method to flush data.
  --innodb-flush-neighbors[=#] 
                      Set to 0 (don't flush neighbors from buffer pool), 1
                      (flush contiguous neighbors from buffer pool) or 2 (flush
                      neighbors from buffer pool), when flushing a block
  --innodb-flush-sync Allow IO bursts at the checkpoints ignoring io_capacity
                      setting.
                      (Defaults to on; use --skip-innodb-flush-sync to disable.)
  --innodb-flushing-avg-loops=# 
                      Number of iterations over which the background flushing
                      is averaged.
  --innodb-force-load-corrupted 
                      Force InnoDB to load metadata of corrupted table.
  --innodb-force-recovery=# 
                      Helps to save your data in case the disk image of the
                      database becomes corrupt.
  --innodb-ft-aux-table=name 
                      FTS internal auxiliary table to be checked
  --innodb-ft-cache-size=# 
                      InnoDB Fulltext search cache size in bytes
  --innodb-ft-enable-diag-print 
                      Whether to enable additional FTS diagnostic printout 
  --innodb-ft-enable-stopword 
                      Create FTS index with stopword.
                      (Defaults to on; use --skip-innodb-ft-enable-stopword to disable.)
  --innodb-ft-max-token-size=# 
                      InnoDB Fulltext search maximum token size in characters
  --innodb-ft-min-token-size=# 
                      InnoDB Fulltext search minimum token size in characters
  --innodb-ft-num-word-optimize[=#] 
                      InnoDB Fulltext search number of words to optimize for
                      each optimize table call 
  --innodb-ft-result-cache-limit=# 
                      InnoDB Fulltext search query result cache limit in bytes
  --innodb-ft-server-stopword-table[=name] 
                      The user supplied stopword table name.
  --innodb-ft-sort-pll-degree=# 
                      InnoDB Fulltext search parallel sort degree, will round
                      up to nearest power of 2 number
  --innodb-ft-total-cache-size=# 
                      Total memory allocated for InnoDB Fulltext Search cache
  --innodb-ft-user-stopword-table[=name] 
                      User supplied stopword table name, effective in the
                      session level.
  --innodb-io-capacity=# 
                      Number of IOPs the server can do. Tunes the background IO
                      rate
  --innodb-io-capacity-max=# 
                      Limit to which innodb_io_capacity can be inflated.
  --innodb-large-prefix 
                      Support large index prefix length of
                      REC_VERSION_56_MAX_INDEX_COL_LEN (3072) bytes.
                      (Defaults to on; use --skip-innodb-large-prefix to disable.)
  --innodb-lock-wait-timeout=# 
                      Timeout in seconds an InnoDB transaction may wait for a
                      lock before being rolled back. Values above 100000000
                      disable the timeout.
  --innodb-locks-unsafe-for-binlog 
                      DEPRECATED. This option may be removed in future
                      releases. Please use READ COMMITTED transaction isolation
                      level instead. Force InnoDB to not use next-key locking,
                      to use only row-level locking.
  --innodb-log-buffer-size=# 
                      The size of the buffer which InnoDB uses to write log to
                      the log files on disk.
  --innodb-log-checksums 
                      Whether to compute and require checksums for InnoDB redo
                      log blocks
                      (Defaults to on; use --skip-innodb-log-checksums to disable.)
  --innodb-log-compressed-pages 
                      Enables/disables the logging of entire compressed page
                      images. InnoDB logs the compressed pages to prevent
                      corruption if the zlib compression algorithm changes.
                      When turned OFF, InnoDB will assume that the zlib
                      compression algorithm doesn't change.
                      (Defaults to on; use --skip-innodb-log-compressed-pages to disable.)
  --innodb-log-file-size=# 
                      Size of each log file in a log group.
  --innodb-log-files-in-group=# 
                      Number of log files in the log group. InnoDB writes to
                      the files in a circular fashion.
  --innodb-log-group-home-dir=name 
                      Path to InnoDB log files.
  --innodb-log-write-ahead-size=# 
                      Redo log write ahead unit size to avoid read-on-write, it
                      should match the OS cache block IO size
  --innodb-lru-scan-depth=# 
                      How deep to scan LRU to keep it clean
  --innodb-max-dirty-pages-pct=# 
                      Percentage of dirty pages allowed in bufferpool.
  --innodb-max-dirty-pages-pct-lwm=# 
                      Percentage of dirty pages at which flushing kicks in.
  --innodb-max-purge-lag=# 
                      Desired maximum length of the purge queue (0 = no limit)
  --innodb-max-purge-lag-delay=# 
                      Maximum delay of user threads in micro-seconds
  --innodb-max-undo-log-size[=#] 
                      Maximum size of UNDO tablespace in MB (If UNDO tablespace
                      grows beyond this size it will be truncated in due
                      course). 
  --innodb-monitor-disable=name 
                      Turn off a monitor counter
  --innodb-monitor-enable=name 
                      Turn on a monitor counter
  --innodb-monitor-reset=name 
                      Reset a monitor counter
  --innodb-monitor-reset-all=name 
                      Reset all values for a monitor counter
  --innodb-old-blocks-pct=# 
                      Percentage of the buffer pool to reserve for 'old'
                      blocks.
  --innodb-old-blocks-time=# 
                      Move blocks to the 'new' end of the buffer pool if the
                      first access was at least this many milliseconds ago. The
                      timeout is disabled if 0.
  --innodb-online-alter-log-max-size=# 
                      Maximum modification log file size for online index
                      creation
  --innodb-open-files=# 
                      How many files at the maximum InnoDB keeps open at the
                      same time.
  --innodb-optimize-fulltext-only 
                      Only optimize the Fulltext index of the table
  --innodb-page-cleaners[=#] 
                      Page cleaner threads can be from 1 to 64. Default is 4.
  --innodb-page-size[=#] 
                      Page size to use for all InnoDB tablespaces.
  --innodb-print-all-deadlocks 
                      Print all deadlocks to MySQL error log (off by default)
  --innodb-purge-batch-size[=#] 
                      Number of UNDO log pages to purge in one batch from the
                      history list.
  --innodb-purge-rseg-truncate-frequency[=#] 
                      Dictates rate at which UNDO records are purged. Value N
                      means purge rollback segment(s) on every Nth iteration of
                      purge invocation
  --innodb-purge-threads[=#] 
                      Purge threads can be from 1 to 32. Default is 4.
  --innodb-random-read-ahead 
                      Whether to use read ahead for random access within an
                      extent.
  --innodb-read-ahead-threshold=# 
                      Number of pages that must be accessed sequentially for
                      InnoDB to trigger a readahead.
  --innodb-read-io-threads=# 
                      Number of background read I/O threads in InnoDB.
  --innodb-read-only  Start InnoDB in read only mode (off by default)
  --innodb-replication-delay=# 
                      Replication thread delay (ms) on the slave server if
                      innodb_thread_concurrency is reached (0 by default)
  --innodb-rollback-on-timeout 
                      Roll back the complete transaction on lock wait timeout,
                      for 4.x compatibility (disabled by default)
  --innodb-rollback-segments[=#] 
                      Number of undo logs to use (deprecated).
  --innodb-sort-buffer-size=# 
                      Memory buffer size for index creation
  --innodb-spin-wait-delay[=#] 
                      Maximum delay between polling for a spin lock (6 by
                      default)
  --innodb-stats-auto-recalc 
                      InnoDB automatic recalculation of persistent statistics
                      enabled for all tables unless overridden at table level
                      (automatic recalculation is only done when InnoDB decides
                      that the table has changed too much and needs a new
                      statistics)
                      (Defaults to on; use --skip-innodb-stats-auto-recalc to disable.)
  --innodb-stats-method=name 
                      Specifies how InnoDB index statistics collection code
                      should treat NULLs. Possible values are NULLS_EQUAL
                      (default), NULLS_UNEQUAL and NULLS_IGNORED
  --innodb-stats-on-metadata 
                      Enable statistics gathering for metadata commands such as
                      SHOW TABLE STATUS for tables that use transient
                      statistics (off by default)
  --innodb-stats-persistent 
                      InnoDB persistent statistics enabled for all tables
                      unless overridden at table level
                      (Defaults to on; use --skip-innodb-stats-persistent to disable.)
  --innodb-stats-persistent-sample-pages=# 
                      The number of leaf index pages to sample when calculating
                      persistent statistics (by ANALYZE, default 20)
  --innodb-stats-sample-pages=# 
                      Deprecated, use innodb_stats_transient_sample_pages
                      instead
  --innodb-stats-transient-sample-pages=# 
                      The number of leaf index pages to sample when calculating
                      transient statistics (if persistent statistics are not
                      used, default 8)
  --innodb-status-file 
                      Enable SHOW ENGINE INNODB STATUS output in the
                      innodb_status.<pid> file
  --innodb-status-output 
                      Enable InnoDB monitor output to the error log.
  --innodb-status-output-locks 
                      Enable InnoDB lock monitor output to the error log.
                      Requires innodb_status_output=ON.
  --innodb-strict-mode 
                      Use strict mode when evaluating create options.
                      (Defaults to on; use --skip-innodb-strict-mode to disable.)
  --innodb-support-xa Enable InnoDB support for the XA two-phase commit
                      (Defaults to on; use --skip-innodb-support-xa to disable.)
  --innodb-sync-array-size[=#] 
                      Size of the mutex/lock wait array.
  --innodb-sync-spin-loops=# 
                      Count of spin-loop rounds in InnoDB mutexes (30 by
                      default)
  --innodb-table-locks 
                      Enable InnoDB locking in LOCK TABLES
                      (Defaults to on; use --skip-innodb-table-locks to disable.)
  --innodb-temp-data-file-path=name 
                      Path to files and their sizes making temp-tablespace.
  --innodb-thread-concurrency=# 
                      Helps in performance tuning in heavily concurrent
                      environments. Sets the maximum number of threads allowed
                      inside InnoDB. Value 0 will disable the thread
                      throttling.
  --innodb-thread-sleep-delay=# 
                      Time of innodb thread sleeping before joining InnoDB
                      queue (usec). Value 0 disable a sleep
  --innodb-tmpdir[=name] 
                      Directory for temporary non-tablespace files.
  --innodb-undo-directory=name 
                      Directory where undo tablespace files live, this path can
                      be absolute.
  --innodb-undo-log-truncate 
                      Enable or Disable Truncate of UNDO tablespace.
  --innodb-undo-logs[=#] 
                      Number of undo logs to use.
  --innodb-undo-tablespaces=# 
                      Number of undo tablespaces to use. 
  --innodb-use-native-aio 
                      Use native AIO if supported on this platform.
                      (Defaults to on; use --skip-innodb-use-native-aio to disable.)
  --innodb-write-io-threads=# 
                      Number of background write I/O threads in InnoDB.
  --interactive-timeout=# 
                      The number of seconds the server waits for activity on an
                      interactive connection before closing it
  --internal-tmp-disk-storage-engine[=name] 
                      The default storage engine for on-disk internal tmp table
  --join-buffer-size=# 
                      The size of the buffer that is used for full joins
  --keep-files-on-create 
                      Don't overwrite stale .MYD and .MYI even if no directory
                      is specified
  --key-buffer-size=# The size of the buffer used for index blocks for MyISAM
                      tables. Increase this to get better index handling (for
                      all reads and multiple writes) to as much as you can
                      afford
  --key-cache-age-threshold=# 
                      This characterizes the number of hits a hot block has to
                      be untouched until it is considered aged enough to be
                      downgraded to a warm block. This specifies the percentage
                      ratio of that number of hits to the total number of
                      blocks in key cache
  --key-cache-block-size=# 
                      The default size of key cache blocks
  --key-cache-division-limit=# 
                      The minimum percentage of warm blocks in key cache
  -L, --language=name Client error messages in given language. May be given as
                      a full path. Deprecated. Use --lc-messages-dir instead.
  --lc-messages=name  Set the language used for the error messages.
  --lc-messages-dir=name 
                      Directory where error messages are
  --lc-time-names=name 
                      Set the language used for the month names and the days of
                      the week.
  --local-infile      Enable LOAD DATA LOCAL INFILE
                      (Defaults to on; use --skip-local-infile to disable.)
  --lock-wait-timeout=# 
                      Timeout in seconds to wait for a lock before returning an
                      error.
  --log-bin[=name]    Log update queries in binary format. Optional (but
                      strongly recommended to avoid replication problems if
                      server's hostname changes) argument should be the chosen
                      location for the binary log files.
  --log-bin-index=name 
                      File that holds the names for binary log files.
  --log-bin-trust-function-creators 
                      If set to FALSE (the default), then when --log-bin is
                      used, creation of a stored function (or trigger) is
                      allowed only to users having the SUPER privilege and only
                      if this stored function (trigger) may not break binary
                      logging. Note that if ALL connections to this server
                      ALWAYS use row-based binary logging, the security issues
                      do not exist and the binary logging cannot break, so you
                      can safely set this to TRUE
  --log-bin-use-v1-row-events 
                      If equal to 1 then version 1 row events are written to a
                      row based binary log.  If equal to 0, then the latest
                      version of events are written.  This option is useful
                      during some upgrades.
  --log-builtin-as-identified-by-password 
                      Controls logging of CREATE/ALTER/GRANT and SET PASSWORD
                      user statements in replication binlogs, general query
                      logs and audit logs.
  --log-error[=name]  Error log file
  --log-error-verbosity=# 
                      How detailed the error log should be. 1, log errors only.
                      2, log errors and warnings. 3, log errors, warnings, and
                      notes. Messages sent to the client are unaffected by this
                      setting.
  --log-isam[=name]   Log all MyISAM changes to file.
  --log-output=name   Syntax: log-output=value[,value...], where "value" could
                      be TABLE, FILE or NONE
  --log-queries-not-using-indexes 
                      Log queries that are executed without benefit of any
                      index to the slow log if it is open
  --log-raw           Log to general log before any rewriting of the query. For
                      use in debugging, not production as sensitive information
                      may be logged.
  --log-short-format  Don't log extra information to update and slow-query
                      logs.
  --log-slave-updates Tells the slave to log the updates from the slave thread
                      to the binary log. You will need to turn it on if you
                      plan to daisy-chain the slaves
  --log-slow-admin-statements 
                      Log slow OPTIMIZE, ANALYZE, ALTER and other
                      administrative statements to the slow log if it is open.
  --log-slow-slave-statements 
                      Log slow statements executed by slave thread to the slow
                      log if it is open.
  --log-statements-unsafe-for-binlog 
                      Log statements considered unsafe when using statement
                      based binary logging.
                      (Defaults to on; use --skip-log-statements-unsafe-for-binlog to disable.)
  --log-syslog        Errors, warnings, and similar issues eligible for MySQL's
                      error log file may additionally be sent to the host
                      operating system's system log ("syslog").
                      (Defaults to on; use --skip-log-syslog to disable.)
  --log-syslog-tag=name 
                      When logging issues using the host operating system's
                      syslog, tag the entries from this particular MySQL server
                      with this ident. This will help distinguish entries from
                      MySQL servers co-existing on the same host machine. A
                      non-empty tag will be appended to the default ident of
                      'mysqld', connected by a hyphen.
  --log-tc=name       Path to transaction coordinator log (used for
                      transactions that affect more than one storage engine,
                      when binary log is disabled).
  --log-tc-size=#     Size of transaction coordinator log.
  --log-throttle-queries-not-using-indexes=# 
                      Log at most this many 'not using index' warnings per
                      minute to the slow log. Any further warnings will be
                      condensed into a single summary line. A value of 0
                      disables throttling. Option has no effect unless
                      --log_queries_not_using_indexes is set.
  --log-timestamps=name 
                      UTC to timestamp log files in zulu time, for more concise
                      timestamps and easier correlation of logs from servers
                      from multiple time zones, or SYSTEM to use the system's
                      local time. This affects only log files, not log tables,
                      as the timestamp columns of the latter can be converted
                      at will.
  -W, --log-warnings[=#] 
                      Log some not critical warnings to the log file
  --long-query-time=# Log all queries that have taken more than long_query_time
                      seconds to execute to file. The argument will be treated
                      as a decimal value with microsecond precision
  --low-priority-updates 
                      INSERT/DELETE/UPDATE has lower priority than selects
  --lower-case-table-names[=#] 
                      If set to 1 table names are stored in lowercase on disk
                      and table names will be case-insensitive.  Should be set
                      to 2 if you are using a case insensitive file system
  --master-info-file=name 
                      The location and name of the file that remembers the
                      master and where the I/O replication thread is in the
                      master's binlogs.
  --master-info-repository=name 
                      Defines the type of the repository for the master
                      information.
  --master-retry-count=# 
                      The number of tries the slave will make to connect to the
                      master before giving up. Deprecated option, use 'CHANGE
                      MASTER TO master_retry_count = <num>' instead.
  --master-verify-checksum 
                      Force checksum verification of logged events in binary
                      log before sending them to slaves or printing them in
                      output of SHOW BINLOG EVENTS. Disabled by default.
  --max-allowed-packet=# 
                      Max packet length to send to or receive from the server
  --max-binlog-cache-size=# 
                      Sets the total size of the transactional cache
  --max-binlog-dump-events=# 
                      Option used by mysql-test for debugging and testing of
                      replication.
  --max-binlog-size=# Binary log will be rotated automatically when the size
                      exceeds this value. Will also apply to relay logs if
                      max_relay_log_size is 0
  --max-binlog-stmt-cache-size=# 
                      Sets the total size of the statement cache
  --max-connect-errors=# 
                      If there is more than this number of interrupted
                      connections from a host this host will be blocked from
                      further connections
  --max-connections=# The number of simultaneous clients allowed
  --max-delayed-threads=# 
                      Don't start more than this number of threads to handle
                      INSERT DELAYED statements. If set to zero INSERT DELAYED
                      will be not used. This variable is deprecated along with
                      INSERT DELAYED.
  --max-digest-length=# 
                      Maximum length considered for digest text.
  --max-error-count=# Max number of errors/warnings to store for a statement
  --max-execution-time=# 
                      Kill SELECT statement that takes over the specified
                      number of milliseconds
  --max-heap-table-size=# 
                      Don't allow creation of heap tables bigger than this
  --max-join-size=#   Joins that are probably going to read more than
                      max_join_size records return an error
  --max-length-for-sort-data=# 
                      Max number of bytes in sorted records
  --max-points-in-geometry[=#] 
                      Maximum number of points in a geometry
  --max-prepared-stmt-count=# 
                      Maximum number of prepared statements in the server
  --max-relay-log-size=# 
                      If non-zero: relay log will be rotated automatically when
                      the size exceeds this value; if zero: when the size
                      exceeds max_binlog_size
  --max-seeks-for-key=# 
                      Limit assumed max number of seeks when looking up rows
                      based on a key
  --max-sort-length=# The number of bytes to use when sorting BLOB or TEXT
                      values (only the first max_sort_length bytes of each
                      value are used; the rest are ignored)
  --max-sp-recursion-depth[=#] 
                      Maximum stored procedure recursion depth
  --max-tmp-tables=#  Maximum number of temporary tables a client can keep open
                      at a time
  --max-user-connections=# 
                      The maximum number of active connections for a single
                      user (0 = no limit)
  --max-write-lock-count=# 
                      After this many write locks, allow some read locks to run
                      in between
  --memlock           Lock mysqld in memory.
  --metadata-locks-cache-size=# 
                      Has no effect, deprecated
  --metadata-locks-hash-instances=# 
                      Has no effect, deprecated
  --min-examined-row-limit=# 
                      Don't write queries to slow log that examine fewer rows
                      than that
  --multi-range-count=# 
                      Number of key ranges to request at once. This variable
                      has no effect, and is deprecated. It will be removed in a
                      future release.
  --myisam-block-size=# 
                      Block size to be used for MyISAM index pages
  --myisam-data-pointer-size=# 
                      Default pointer size to be used for MyISAM tables
  --myisam-max-sort-file-size=# 
                      Don't use the fast sort index method to created index if
                      the temporary file would get bigger than this
  --myisam-mmap-size=# 
                      Restricts the total memory used for memory mapping of
                      MySQL tables
  --myisam-recover-options[=name] 
                      Syntax: myisam-recover-options[=option[,option...]],
                      where option can be DEFAULT, BACKUP, FORCE, QUICK, or OFF
  --myisam-repair-threads=# 
                      If larger than 1, when repairing a MyISAM table all
                      indexes will be created in parallel, with one thread per
                      index. The value of 1 disables parallel repair
  --myisam-sort-buffer-size=# 
                      The buffer that is allocated when sorting the index when
                      doing a REPAIR or when creating indexes with CREATE INDEX
                      or ALTER TABLE
  --myisam-stats-method=name 
                      Specifies how MyISAM index statistics collection code
                      should treat NULLs. Possible values of name are
                      NULLS_UNEQUAL (default behavior for 4.1 and later),
                      NULLS_EQUAL (emulate 4.0 behavior), and NULLS_IGNORED
  --myisam-use-mmap   Use memory mapping for reading and writing MyISAM tables
  --mysql-native-password-proxy-users 
                      If set to FALSE (the default), then the
                      mysql_native_password plugin will not signal for
                      authenticated users to be checked for mapping to proxy
                      users.  When set to TRUE, the plugin will flag associated
                      authenticated accounts to be mapped to proxy users when
                      the server option check_proxy_users is enabled.
  --named-pipe        Enable the named pipe (NT)
  --net-buffer-length=# 
                      Buffer length for TCP/IP and socket communication
  --net-read-timeout=# 
                      Number of seconds to wait for more data from a connection
                      before aborting the read
  --net-retry-count=# If a read on a communication port is interrupted, retry
                      this many times before giving up
  --net-write-timeout=# 
                      Number of seconds to wait for a block to be written to a
                      connection before aborting the write
  -n, --new           Use very new possible "unsafe" functions
  --ngram[=name]      Enable or disable ngram plugin. Possible values are ON,
                      OFF, FORCE (don't start if the plugin fails to load).
  --ngram-token-size=# 
                      InnoDB ngram full text plugin parser token size in
                      characters
  --offline-mode      Make the server into offline mode
  --old               Use compatible behavior
  --old-alter-table   Use old, non-optimized alter table
  --old-passwords=#   Determine which hash algorithm to use when generating
                      passwords using the PASSWORD() function
  --old-style-user-limits 
                      Enable old-style user limits (before 5.0.3, user
                      resources were counted per each user+host vs. per
                      account).
  --open-files-limit=# 
                      If this is not 0, then mysqld will use this value to
                      reserve file descriptors to use with setrlimit(). If this
                      value is 0 then mysqld will reserve max_connections*5 or
                      max_connections + table_open_cache*2 (whichever is
                      larger) number of file descriptors
  --optimizer-prune-level=# 
                      Controls the heuristic(s) applied during query
                      optimization to prune less-promising partial plans from
                      the optimizer search space. Meaning: 0 - do not apply any
                      heuristic, thus perform exhaustive search; 1 - prune
                      plans based on number of retrieved rows
  --optimizer-search-depth=# 
                      Maximum depth of search performed by the query optimizer.
                      Values larger than the number of relations in a query
                      result in better query plans, but take longer to compile
                      a query. Values smaller than the number of tables in a
                      relation result in faster optimization, but may produce
                      very bad query plans. If set to 0, the system will
                      automatically pick a reasonable value
  --optimizer-switch=name 
                      optimizer_switch=option=val[,option=val...], where option
                      is one of {index_merge, index_merge_union,
                      index_merge_sort_union, index_merge_intersection,
                      engine_condition_pushdown, index_condition_pushdown, mrr,
                      mrr_cost_based, materialization, semijoin, loosescan,
                      firstmatch, duplicateweedout,
                      subquery_materialization_cost_based, block_nested_loop,
                      batched_key_access, use_index_extensions,
                      condition_fanout_filter, derived_merge} and val is one of
                      {on, off, default}
  --optimizer-trace=name 
                      Controls tracing of the Optimizer:
                      optimizer_trace=option=val[,option=val...], where option
                      is one of {enabled, one_line} and val is one of {on,
                      default}
  --optimizer-trace-features=name 
                      Enables/disables tracing of selected features of the
                      Optimizer:
                      optimizer_trace_features=option=val[,option=val...],
                      where option is one of {greedy_search, range_optimizer,
                      dynamic_range, repeated_subselect} and val is one of {on,
                      off, default}
  --optimizer-trace-limit=# 
                      Maximum number of shown optimizer traces
  --optimizer-trace-max-mem-size=# 
                      Maximum allowed cumulated size of stored optimizer traces
  --optimizer-trace-offset=# 
                      Offset of first optimizer trace to show; see manual
  --parser-max-mem-size=# 
                      Maximum amount of memory available to the parser
  --partition[=name]  Enable or disable partition plugin. Possible values are
                      ON, OFF, FORCE (don't start if the plugin fails to load).
  --performance-schema 
                      Enable the performance schema.
                      (Defaults to on; use --skip-performance-schema to disable.)
  --performance-schema-accounts-size=# 
                      Maximum number of instrumented user@host accounts. Use 0
                      to disable, -1 for automated scaling.
  --performance-schema-consumer-events-stages-current 
                      Default startup value for the events_stages_current
                      consumer.
  --performance-schema-consumer-events-stages-history 
                      Default startup value for the events_stages_history
                      consumer.
  --performance-schema-consumer-events-stages-history-long 
                      Default startup value for the events_stages_history_long
                      consumer.
  --performance-schema-consumer-events-statements-current 
                      Default startup value for the events_statements_current
                      consumer.
                      (Defaults to on; use --skip-performance-schema-consumer-events-statements-current to disable.)
  --performance-schema-consumer-events-statements-history 
                      Default startup value for the events_statements_history
                      consumer.
                      (Defaults to on; use --skip-performance-schema-consumer-events-statements-history to disable.)
  --performance-schema-consumer-events-statements-history-long 
                      Default startup value for the
                      events_statements_history_long consumer.
  --performance-schema-consumer-events-transactions-current 
                      Default startup value for the events_transactions_current
                      consumer.
  --performance-schema-consumer-events-transactions-history 
                      Default startup value for the events_transactions_history
                      consumer.
  --performance-schema-consumer-events-transactions-history-long 
                      Default startup value for the
                      events_transactions_history_long consumer.
  --performance-schema-consumer-events-waits-current 
                      Default startup value for the events_waits_current
                      consumer.
  --performance-schema-consumer-events-waits-history 
                      Default startup value for the events_waits_history
                      consumer.
  --performance-schema-consumer-events-waits-history-long 
                      Default startup value for the events_waits_history_long
                      consumer.
  --performance-schema-consumer-global-instrumentation 
                      Default startup value for the global_instrumentation
                      consumer.
                      (Defaults to on; use --skip-performance-schema-consumer-global-instrumentation to disable.)
  --performance-schema-consumer-statements-digest 
                      Default startup value for the statements_digest consumer.
                      (Defaults to on; use --skip-performance-schema-consumer-statements-digest to disable.)
  --performance-schema-consumer-thread-instrumentation 
                      Default startup value for the thread_instrumentation
                      consumer.
                      (Defaults to on; use --skip-performance-schema-consumer-thread-instrumentation to disable.)
  --performance-schema-digests-size=# 
                      Size of the statement digest. Use 0 to disable, -1 for
                      automated sizing.
  --performance-schema-events-stages-history-long-size=# 
                      Number of rows in EVENTS_STAGES_HISTORY_LONG. Use 0 to
                      disable, -1 for automated sizing.
  --performance-schema-events-stages-history-size=# 
                      Number of rows per thread in EVENTS_STAGES_HISTORY. Use 0
                      to disable, -1 for automated sizing.
  --performance-schema-events-statements-history-long-size=# 
                      Number of rows in EVENTS_STATEMENTS_HISTORY_LONG. Use 0
                      to disable, -1 for automated sizing.
  --performance-schema-events-statements-history-size=# 
                      Number of rows per thread in EVENTS_STATEMENTS_HISTORY.
                      Use 0 to disable, -1 for automated sizing.
  --performance-schema-events-transactions-history-long-size=# 
                      Number of rows in EVENTS_TRANSACTIONS_HISTORY_LONG. Use 0
                      to disable, -1 for automated sizing.
  --performance-schema-events-transactions-history-size=# 
                      Number of rows per thread in EVENTS_TRANSACTIONS_HISTORY.
                      Use 0 to disable, -1 for automated sizing.
  --performance-schema-events-waits-history-long-size=# 
                      Number of rows in EVENTS_WAITS_HISTORY_LONG. Use 0 to
                      disable, -1 for automated sizing.
  --performance-schema-events-waits-history-size=# 
                      Number of rows per thread in EVENTS_WAITS_HISTORY. Use 0
                      to disable, -1 for automated sizing.
  --performance-schema-hosts-size=# 
                      Maximum number of instrumented hosts. Use 0 to disable,
                      -1 for automated scaling.
  --performance-schema-instrument[=name] 
                      Default startup value for a performance schema
                      instrument.
  --performance-schema-max-cond-classes=# 
                      Maximum number of condition instruments.
  --performance-schema-max-cond-instances=# 
                      Maximum number of instrumented condition objects. Use 0
                      to disable, -1 for automated scaling.
  --performance-schema-max-digest-length=# 
                      Maximum length considered for digest text, when stored in
                      performance_schema tables.
  --performance-schema-max-file-classes=# 
                      Maximum number of file instruments.
  --performance-schema-max-file-handles=# 
                      Maximum number of opened instrumented files.
  --performance-schema-max-file-instances=# 
                      Maximum number of instrumented files. Use 0 to disable,
                      -1 for automated scaling.
  --performance-schema-max-index-stat=# 
                      Maximum number of index statistics for instrumented
                      tables. Use 0 to disable, -1 for automated scaling.
  --performance-schema-max-memory-classes=# 
                      Maximum number of memory pool instruments.
  --performance-schema-max-metadata-locks=# 
                      Maximum number of metadata locks. Use 0 to disable, -1
                      for automated scaling.
  --performance-schema-max-mutex-classes=# 
                      Maximum number of mutex instruments.
  --performance-schema-max-mutex-instances=# 
                      Maximum number of instrumented MUTEX objects. Use 0 to
                      disable, -1 for automated scaling.
  --performance-schema-max-prepared-statements-instances=# 
                      Maximum number of instrumented prepared statements. Use 0
                      to disable, -1 for automated scaling.
  --performance-schema-max-program-instances=# 
                      Maximum number of instrumented programs. Use 0 to
                      disable, -1 for automated scaling.
  --performance-schema-max-rwlock-classes=# 
                      Maximum number of rwlock instruments.
  --performance-schema-max-rwlock-instances=# 
                      Maximum number of instrumented RWLOCK objects. Use 0 to
                      disable, -1 for automated scaling.
  --performance-schema-max-socket-classes=# 
                      Maximum number of socket instruments.
  --performance-schema-max-socket-instances=# 
                      Maximum number of opened instrumented sockets. Use 0 to
                      disable, -1 for automated scaling.
  --performance-schema-max-sql-text-length=# 
                      Maximum length of displayed sql text.
  --performance-schema-max-stage-classes=# 
                      Maximum number of stage instruments.
  --performance-schema-max-statement-classes=# 
                      Maximum number of statement instruments.
  --performance-schema-max-statement-stack=# 
                      Number of rows per thread in EVENTS_STATEMENTS_CURRENT.
  --performance-schema-max-table-handles=# 
                      Maximum number of opened instrumented tables. Use 0 to
                      disable, -1 for automated scaling.
  --performance-schema-max-table-instances=# 
                      Maximum number of instrumented tables. Use 0 to disable,
                      -1 for automated scaling.
  --performance-schema-max-table-lock-stat=# 
                      Maximum number of lock statistics for instrumented
                      tables. Use 0 to disable, -1 for automated scaling.
  --performance-schema-max-thread-classes=# 
                      Maximum number of thread instruments.
  --performance-schema-max-thread-instances=# 
                      Maximum number of instrumented threads. Use 0 to disable,
                      -1 for automated scaling.
  --performance-schema-session-connect-attrs-size=# 
                      Size of session attribute string buffer per thread. Use 0
                      to disable, -1 for automated sizing.
  --performance-schema-setup-actors-size=# 
                      Maximum number of rows in SETUP_ACTORS. Use 0 to disable,
                      -1 for automated scaling.
  --performance-schema-setup-objects-size=# 
                      Maximum number of rows in SETUP_OBJECTS. Use 0 to
                      disable, -1 for automated scaling.
  --performance-schema-users-size=# 
                      Maximum number of instrumented users. Use 0 to disable,
                      -1 for automated scaling.
  --pid-file=name     Pid file used by safe_mysqld
  --plugin-dir=name   Directory for plugins
  --plugin-load=name  Optional semicolon-separated list of plugins to load,
                      where each plugin is identified as name=library, where
                      name is the plugin name and library is the plugin library
                      in plugin_dir.
  --plugin-load-add=name 
                      Optional semicolon-separated list of plugins to load,
                      where each plugin is identified as name=library, where
                      name is the plugin name and library is the plugin library
                      in plugin_dir. This option adds to the list specified by
                      --plugin-load in an incremental way. Multiple
                      --plugin-load-add are supported.
  -P, --port=#        Port number to use for connection or 0 to default to,
                      my.cnf, $MYSQL_TCP_PORT, /etc/services, built-in default
                      (3306), whatever comes first
  --port-open-timeout=# 
                      Maximum time in seconds to wait for the port to become
                      free. (Default: No wait).
  --preload-buffer-size=# 
                      The size of the buffer that is allocated when preloading
                      indexes
  --profiling-history-size=# 
                      Limit of query profiling memory
  --query-alloc-block-size=# 
                      Allocation block size for query parsing and execution
  --query-cache-limit=# 
                      Don't cache results that are bigger than this
  --query-cache-min-res-unit=# 
                      The minimum size for blocks allocated by the query cache
  --query-cache-size=# 
                      The memory allocated to store results from old queries
  --query-cache-type=name 
                      OFF = Don't cache or retrieve results. ON = Cache all
                      results except SELECT SQL_NO_CACHE ... queries. DEMAND =
                      Cache only SELECT SQL_CACHE ... queries
  --query-cache-wlock-invalidate 
                      Invalidate queries in query cache on LOCK for write
  --query-prealloc-size=# 
                      Persistent buffer for query parsing and execution
  --range-alloc-block-size=# 
                      Allocation block size for storing ranges during
                      optimization
  --range-optimizer-max-mem-size=# 
                      Maximum amount of memory used by the range optimizer to
                      allocate predicates during range analysis. The larger the
                      number, more memory may be consumed during range
                      analysis. If the value is too low to completed range
                      optimization of a query, index range scan will not be
                      considered for this query. A value of 0 means range
                      optimizer does not have any cap on memory. 
  --read-buffer-size=# 
                      Each thread that does a sequential scan allocates a
                      buffer of this size for each table it scans. If you do
                      many sequential scans, you may want to increase this
                      value
  --read-only         Make all non-temporary tables read-only, with the
                      exception for replication (slave) threads and users with
                      the SUPER privilege
  --read-rnd-buffer-size=# 
                      When reading rows in sorted order after a sort, the rows
                      are read through this buffer to avoid a disk seeks
  --relay-log=name    The location and name to use for relay logs
  --relay-log-index=name 
                      File that holds the names for relay log files.
  --relay-log-info-file=name 
                      The location and name of the file that remembers where
                      the SQL replication thread is in the relay logs
  --relay-log-info-repository=name 
                      Defines the type of the repository for the relay log
                      information and associated workers.
  --relay-log-purge   if disabled - do not purge relay logs. if enabled - purge
                      them as soon as they are no more needed
                      (Defaults to on; use --skip-relay-log-purge to disable.)
  --relay-log-recovery 
                      Enables automatic relay log recovery right after the
                      database startup, which means that the IO Thread starts
                      re-fetching from the master right after the last
                      transaction processed
  --relay-log-space-limit=# 
                      Maximum space to use for all relay logs
  --replicate-do-db=name 
                      Tells the slave thread to restrict replication to the
                      specified database. To specify more than one database,
                      use the directive multiple times, once for each database.
                      Note that this will only work if you do not use
                      cross-database queries such as UPDATE some_db.some_table
                      SET foo='bar' while having selected a different or no
                      database. If you need cross database updates to work,
                      make sure you have 3.23.28 or later, and use
                      replicate-wild-do-table=db_name.%.
  --replicate-do-table=name 
                      Tells the slave thread to restrict replication to the
                      specified table. To specify more than one table, use the
                      directive multiple times, once for each table. This will
                      work for cross-database updates, in contrast to
                      replicate-do-db.
  --replicate-ignore-db=name 
                      Tells the slave thread to not replicate to the specified
                      database. To specify more than one database to ignore,
                      use the directive multiple times, once for each database.
                      This option will not work if you use cross database
                      updates. If you need cross database updates to work, make
                      sure you have 3.23.28 or later, and use
                      replicate-wild-ignore-table=db_name.%. 
  --replicate-ignore-table=name 
                      Tells the slave thread to not replicate to the specified
                      table. To specify more than one table to ignore, use the
                      directive multiple times, once for each table. This will
                      work for cross-database updates, in contrast to
                      replicate-ignore-db.
  --replicate-rewrite-db=name 
                      Updates to a database with a different name than the
                      original. Example:
                      replicate-rewrite-db=master_db_name->slave_db_name.
  --replicate-same-server-id 
                      In replication, if set to 1, do not skip events having
                      our server id. Default value is 0 (to break infinite
                      loops in circular replication). Can't be set to 1 if
                      --log-slave-updates is used.
  --replicate-wild-do-table=name 
                      Tells the slave thread to restrict replication to the
                      tables that match the specified wildcard pattern. To
                      specify more than one table, use the directive multiple
                      times, once for each table. This will work for
                      cross-database updates. Example:
                      replicate-wild-do-table=foo%.bar% will replicate only
                      updates to tables in all databases that start with foo
                      and whose table names start with bar.
  --replicate-wild-ignore-table=name 
                      Tells the slave thread to not replicate to the tables
                      that match the given wildcard pattern. To specify more
                      than one table to ignore, use the directive multiple
                      times, once for each table. This will work for
                      cross-database updates. Example:
                      replicate-wild-ignore-table=foo%.bar% will not do updates
                      to tables in databases that start with foo and whose
                      table names start with bar.
  --report-host=name  Hostname or IP of the slave to be reported to the master
                      during slave registration. Will appear in the output of
                      SHOW SLAVE HOSTS. Leave unset if you do not want the
                      slave to register itself with the master. Note that it is
                      not sufficient for the master to simply read the IP of
                      the slave off the socket once the slave connects. Due to
                      NAT and other routing issues, that IP may not be valid
                      for connecting to the slave from the master or other
                      hosts
  --report-password=name 
                      The account password of the slave to be reported to the
                      master during slave registration
  --report-port=#     Port for connecting to slave reported to the master
                      during slave registration. Set it only if the slave is
                      listening on a non-default port or if you have a special
                      tunnel from the master or other clients to the slave. If
                      not sure, leave this option unset
  --report-user=name  The account user name of the slave to be reported to the
                      master during slave registration
  --require-secure-transport 
                      When this option is enabled, connections attempted using
                      insecure transport will be rejected.  Secure transports
                      are SSL/TLS, Unix socket or Shared Memory (on Windows).
  --rpl-stop-slave-timeout=# 
                      Timeout in seconds to wait for slave to stop before
                      returning a warning.
  --safe-user-create  Don't allow new user creation by the user who has no
                      write privileges to the mysql.user table.
  --secure-auth       Disallow authentication for accounts that have old
                      (pre-4.1) passwords. Deprecated. Always TRUE.
                      (Defaults to on; use --skip-secure-auth to disable.)
  --secure-file-priv=name 
                      Limit LOAD DATA, SELECT ... OUTFILE, and LOAD_FILE() to
                      files within specified directory
  --server-id=#       Uniquely identifies the server instance in the community
                      of replication partners
  --server-id-bits=#  Set number of significant bits in server-id
  --session-track-gtids=name 
                      Controls the amount of global transaction ids to be
                      included in the response packet sent by the
                      server.(Default: OFF).
  --session-track-schema 
                      Track changes to the 'default schema'.
                      (Defaults to on; use --skip-session-track-schema to disable.)
  --session-track-state-change 
                      Track changes to the 'session state'.
  --session-track-system-variables=name 
                      Track changes in registered system variables.
  --session-track-transaction-info=name 
                      Track changes to the transaction attributes. OFF to
                      disable; STATE to track just transaction state (Is there
                      an active transaction? Does it have any data? etc.);
                      CHARACTERISTICS to track transaction state and report all
                      statements needed to start a transaction with the same
                      characteristics (isolation level, read only/read write,
                      snapshot - but not any work done / data modified within
                      the transaction).
  --sha256-password-proxy-users 
                      If set to FALSE (the default), then the sha256_password
                      authentication plugin will not signal for authenticated
                      users to be checked for mapping to proxy users.  When set
                      to TRUE, the plugin will flag associated authenticated
                      accounts to be mapped to proxy users when the server
                      option check_proxy_users is enabled.
  --shared-memory     Enable the shared memory
  --shared-memory-base-name=name 
                      Base name of shared memory
  --show-compatibility-56 
                      SHOW commands / INFORMATION_SCHEMA tables compatible with
                      MySQL 5.6
  --show-old-temporals 
                      When this option is enabled, the pre-5.6.4 temporal types
                      will be marked in the 'SHOW CREATE TABLE' and
                      'INFORMATION_SCHEMA.COLUMNS' table as a comment in
                      COLUMN_TYPE field. This variable is deprecated and will
                      be removed in a future release.
  --show-slave-auth-info 
                      Show user and password in SHOW SLAVE HOSTS on this
                      master.
  --skip-grant-tables Start without grant tables. This gives all users FULL
                      ACCESS to all tables.
  --skip-host-cache   Don't cache host names.
  --skip-name-resolve Don't resolve hostnames. All hostnames are IP's or
                      'localhost'.
  --skip-networking   Don't allow connection with TCP/IP
  --skip-new          Don't use new, possibly wrong routines.
  --skip-show-database 
                      Don't allow 'SHOW DATABASE' commands
  --skip-slave-start  If set, slave is not autostarted.
  --skip-stack-trace  Don't print a stack trace on failure.
  --slave-allow-batching 
                      Allow slave to batch requests
  --slave-checkpoint-group=# 
                      Maximum number of processed transactions by
                      Multi-threaded slave before a checkpoint operation is
                      called to update progress status.
  --slave-checkpoint-period=# 
                      Gather workers' activities to Update progress status of
                      Multi-threaded slave and flush the relay log info to disk
                      after every #th milli-seconds.
  --slave-compressed-protocol 
                      Use compression on master/slave protocol
  --slave-exec-mode=name 
                      Modes for how replication events should be executed.
                      Legal values are STRICT (default) and IDEMPOTENT. In
                      IDEMPOTENT mode, replication will not stop for operations
                      that are idempotent. In STRICT mode, replication will
                      stop on any unexpected difference between the master and
                      the slave
  --slave-load-tmpdir=name 
                      The location where the slave should put its temporary
                      files when replicating a LOAD DATA INFILE command
  --slave-max-allowed-packet=# 
                      The maximum packet length to sent successfully from the
                      master to slave.
  --slave-net-timeout=# 
                      Number of seconds to wait for more data from a
                      master/slave connection before aborting the read
  --slave-parallel-type=name 
                      Specifies if the slave will use database partitioning or
                      information from master to parallelize
                      transactions.(Default: DATABASE).
  --slave-parallel-workers=# 
                      Number of worker threads for executing events in parallel
                      
  --slave-pending-jobs-size-max=# 
                      Max size of Slave Worker queues holding yet not applied
                      events.The least possible value must be not less than the
                      master side max_allowed_packet.
  --slave-preserve-commit-order 
                      Force slave workers to make commits in the same order as
                      on the master. Disabled by default.
  --slave-rows-search-algorithms=name 
                      Set of searching algorithms that the slave will use while
                      searching for records from the storage engine to either
                      updated or deleted them. Possible values are: INDEX_SCAN,
                      TABLE_SCAN and HASH_SCAN. Any combination is allowed, and
                      the slave will always pick the most suitable algorithm
                      for any given scenario. (Default: INDEX_SCAN,
                      TABLE_SCAN).
  --slave-skip-errors=name 
                      Tells the slave thread to continue replication when a
                      query event returns an error from the provided list
  --slave-sql-verify-checksum 
                      Force checksum verification of replication events after
                      reading them from relay log. Note: Events are always
                      checksum-verified by slave on receiving them from the
                      network before writing them to the relay log. Enabled by
                      default.
                      (Defaults to on; use --skip-slave-sql-verify-checksum to disable.)
  --slave-transaction-retries=# 
                      Number of times the slave SQL thread will retry a
                      transaction in case it failed with a deadlock or elapsed
                      lock wait timeout, before giving up and stopping
  --slave-type-conversions=name 
                      Set of slave type conversions that are enabled. Legal
                      values are: ALL_LOSSY to enable lossy conversions,
                      ALL_NON_LOSSY to enable non-lossy conversions,
                      ALL_UNSIGNED to treat all integer column type data to be
                      unsigned values, and ALL_SIGNED to treat all integer
                      column type data to be signed values. Default treatment
                      is ALL_SIGNED. If ALL_SIGNED and ALL_UNSIGNED both are
                      specified, ALL_SIGNED will take higher priority than
                      ALL_UNSIGNED. If the variable is assigned the empty set,
                      no conversions are allowed and it is expected that the
                      types match exactly.
  --slow-launch-time=# 
                      If creating the thread takes longer than this value (in
                      seconds), the Slow_launch_threads counter will be
                      incremented
  --slow-query-log    Log slow queries to a table or log file. Defaults logging
                      to a file hostname-slow.log or a table mysql.slow_log if
                      --log-output=TABLE is used. Must be enabled to activate
                      other slow log options
  --slow-query-log-file=name 
                      Log slow queries to given log file. Defaults logging to
                      hostname-slow.log. Must be enabled to activate other slow
                      log options
  --slow-start-timeout=# 
                      Maximum number of milliseconds that the service control
                      manager should wait before trying to kill the windows
                      service during startup(Default: 15000).
  --socket=name       Socket file to use for connection
  --sort-buffer-size=# 
                      Each thread that needs to do a sort allocates a buffer of
                      this size
  --sporadic-binlog-dump-fail 
                      Option used by mysql-test for debugging and testing of
                      replication.
  --sql-mode=name     Syntax: sql-mode=mode[,mode[,mode...]]. See the manual
                      for the complete list of valid sql modes
  --ssl               Enable SSL for connection (automatically enabled with
                      other flags).
                      (Defaults to on; use --skip-ssl to disable.)
  --ssl-ca=name       CA file in PEM format (check OpenSSL docs, implies --ssl)
  --ssl-capath=name   CA directory (check OpenSSL docs, implies --ssl)
  --ssl-cert=name     X509 cert in PEM format (implies --ssl)
  --ssl-cipher=name   SSL cipher to use (implies --ssl)
  --ssl-crl=name      CRL file in PEM format (check OpenSSL docs, implies
                      --ssl)
  --ssl-crlpath=name  CRL directory (check OpenSSL docs, implies --ssl)
  --ssl-key=name      X509 key in PEM format (implies --ssl)
  --standalone        Dummy option to start as a standalone program (NT).
  --stored-program-cache=# 
                      The soft upper limit for number of cached stored routines
                      for one connection.
  --super-read-only   Make all non-temporary tables read-only, with the
                      exception for replication (slave) threads.  Users with
                      the SUPER privilege are affected, unlike read_only. 
                      Setting super_read_only to ON also sets read_only to ON.
  -s, --symbolic-links 
                      Enable symbolic link support.
                      (Defaults to on; use --skip-symbolic-links to disable.)
  --sync-binlog=#     Synchronously flush binary log to disk after every #th
                      write to the file. Use 0 to disable synchronous flushing
  --sync-frm          Sync .frm files to disk on creation
                      (Defaults to on; use --skip-sync-frm to disable.)
  --sync-master-info=# 
                      Synchronously flush master info to disk after every #th
                      event. Use 0 to disable synchronous flushing
  --sync-relay-log=#  Synchronously flush relay log to disk after every #th
                      event. Use 0 to disable synchronous flushing
  --sync-relay-log-info=# 
                      Synchronously flush relay log info to disk after every
                      #th transaction. Use 0 to disable synchronous flushing
  --sysdate-is-now    Non-default option to alias SYSDATE() to NOW() to make it
                      safe-replicable. Since 5.0, SYSDATE() returns a `dynamic'
                      value different for different invocations, even within
                      the same statement.
  --table-definition-cache=# 
                      The number of cached table definitions
  --table-open-cache=# 
                      The number of cached open tables (total for all table
                      cache instances)
  --table-open-cache-instances=# 
                      The number of table cache instances
  --tc-heuristic-recover=name 
                      Decision to use in heuristic recover process. Possible
                      values are OFF, COMMIT or ROLLBACK.
  --temp-pool         This option is ignored on this OS.
                      (Defaults to on; use --skip-temp-pool to disable.)
  --thread-cache-size=# 
                      How many threads we should keep in a cache for reuse
  --thread-handling=name 
                      Define threads usage for handling queries, one of
                      one-thread-per-connection, no-threads, loaded-dynamically
  --thread-stack=#    The stack size for each thread
  --time-format=name  The TIME format (ignored)
  --tls-version=name  TLS version, permitted values are TLSv1, TLSv1.1,
                      TLSv1.2(Only for openssl)
  --tmp-table-size=#  If an internal in-memory temporary table exceeds this
                      size, MySQL will automatically convert it to an on-disk
                      MyISAM table
  -t, --tmpdir=name   Path for temporary files. Several paths may be specified,
                      separated by a semicolon (;), in this case they are used
                      in a round-robin fashion
  --transaction-alloc-block-size=# 
                      Allocation block size for transactions to be stored in
                      binary log
  --transaction-isolation=name 
                      Default transaction isolation level.
  --transaction-prealloc-size=# 
                      Persistent buffer for transactions to be stored in binary
                      log
  --transaction-read-only 
                      Default transaction access mode. True if transactions are
                      read-only.
  --transaction-write-set-extraction[=name] 
                      This option is used to let the server know when to
                      extract the write set which will be used for various
                      purposes. 
  --updatable-views-with-limit=name 
                      YES = Don't issue an error message (warning only) if a
                      VIEW without presence of a key of the underlying table is
                      used in queries with a LIMIT clause for updating. NO =
                      Prohibit update of a VIEW, which does not contain a key
                      of the underlying table and the query uses a LIMIT clause
                      (usually get from GUI tools)
  -u, --user=name     Run mysqld daemon as user.
  --validate-user-plugins 
                      Turns on additional validation of authentication plugins
                      assigned to user accounts. 
                      (Defaults to on; use --skip-validate-user-plugins to disable.)
  -v, --verbose       Used with --help option for detailed help.
  -V, --version       Output version information and exit.
  --wait-timeout=#    The number of seconds the server waits for activity on a
                      connection before closing it

Variables (--variable-name=value)
and boolean options {FALSE|TRUE}                             Value (after reading options)
------------------------------------------------------------ -------------
abort-slave-event-count                                      0
allow-suspicious-udfs                                        FALSE
archive                                                      ON
auto-increment-increment                                     1
auto-increment-offset                                        1
autocommit                                                   TRUE
automatic-sp-privileges                                      TRUE
avoid-temporal-upgrade                                       FALSE
back-log                                                     80
basedir                                                      F:\temp\20160708\mysql-5.7.13-winx64\mysql-5.7.13-winx64\
big-tables                                                   FALSE
bind-address                                                 *
binlog-cache-size                                            32768
binlog-checksum                                              CRC32
binlog-direct-non-transactional-updates                      FALSE
binlog-error-action                                          ABORT_SERVER
binlog-format                                                ROW
binlog-group-commit-sync-delay                               0
binlog-group-commit-sync-no-delay-count                      0
binlog-gtid-simple-recovery                                  TRUE
binlog-max-flush-queue-time                                  0
binlog-order-commits                                         TRUE
binlog-row-event-max-size                                    8192
binlog-row-image                                             FULL
binlog-rows-query-log-events                                 FALSE
binlog-stmt-cache-size                                       32768
blackhole                                                    ON
block-encryption-mode                                        aes-128-ecb
bulk-insert-buffer-size                                      8388608
character-set-client-handshake                               TRUE
character-set-filesystem                                     binary
character-set-server                                         latin1
character-sets-dir                                           F:\temp\20160708\mysql-5.7.13-winx64\mysql-5.7.13-winx64\share\charsets\
check-proxy-users                                            FALSE
chroot                                                       (No default value)
collation-server                                             latin1_swedish_ci
completion-type                                              NO_CHAIN
concurrent-insert                                            AUTO
connect-timeout                                              10
console                                                      FALSE
datadir                                                      F:\temp\20160708\mysql-5.7.13-winx64\mysql-5.7.13-winx64\data\
date-format                                                  %Y-%m-%d
datetime-format                                              %Y-%m-%d %H:%i:%s
default-authentication-plugin                                mysql_native_password
default-password-lifetime                                    0
default-storage-engine                                       InnoDB
default-time-zone                                            (No default value)
default-tmp-storage-engine                                   InnoDB
default-week-format                                          0
delay-key-write                                              ON
delayed-insert-limit                                         100
delayed-insert-timeout                                       300
delayed-queue-size                                           1000
des-key-file                                                 (No default value)
disabled-storage-engines                                     
disconnect-on-expired-password                               TRUE
disconnect-slave-event-count                                 0
div-precision-increment                                      4
end-markers-in-json                                          FALSE
enforce-gtid-consistency                                     FALSE
eq-range-index-dive-limit                                    200
event-scheduler                                              OFF
expire-logs-days                                             0
explicit-defaults-for-timestamp                              FALSE
external-locking                                             FALSE
federated                                                    ON
flush                                                        FALSE
flush-time                                                   0
ft-boolean-syntax                                            + -><()~*:""&|
ft-max-word-len                                              84
ft-min-word-len                                              4
ft-query-expansion-limit                                     20
ft-stopword-file                                             (No default value)
gdb                                                          FALSE
general-log                                                  FALSE
general-log-file                                             F:\temp\20160708\mysql-5.7.13-winx64\mysql-5.7.13-winx64\data\TY1035.log
group-concat-max-len                                         1024
gtid-executed-compression-period                             1000
gtid-mode                                                    OFF
help                                                         TRUE
host-cache-size                                              279
ignore-builtin-innodb                                        FALSE
init-connect                                                 
init-file                                                    (No default value)
init-slave                                                   
initialize                                                   FALSE
initialize-insecure                                          FALSE
innodb-adaptive-flushing                                     TRUE
innodb-adaptive-flushing-lwm                                 10
innodb-adaptive-hash-index                                   TRUE
innodb-adaptive-hash-index-parts                             8
innodb-adaptive-max-sleep-delay                              150000
innodb-api-bk-commit-interval                                5
innodb-api-disable-rowlock                                   FALSE
innodb-api-enable-binlog                                     FALSE
innodb-api-enable-mdl                                        FALSE
innodb-api-trx-level                                         0
innodb-autoextend-increment                                  64
innodb-autoinc-lock-mode                                     1
innodb-buffer-pool-chunk-size                                134217728
innodb-buffer-pool-dump-at-shutdown                          TRUE
innodb-buffer-pool-dump-now                                  FALSE
innodb-buffer-pool-dump-pct                                  25
innodb-buffer-pool-filename                                  ib_buffer_pool
innodb-buffer-pool-instances                                 0
innodb-buffer-pool-load-abort                                FALSE
innodb-buffer-pool-load-at-startup                           TRUE
innodb-buffer-pool-load-now                                  FALSE
innodb-buffer-pool-size                                      134217728
innodb-change-buffer-max-size                                25
innodb-change-buffering                                      all
innodb-checksum-algorithm                                    crc32
innodb-checksums                                             TRUE
innodb-cmp-per-index-enabled                                 FALSE
innodb-commit-concurrency                                    0
innodb-compression-failure-threshold-pct                     5
innodb-compression-level                                     6
innodb-compression-pad-pct-max                               50
innodb-concurrency-tickets                                   5000
innodb-data-file-path                                        (No default value)
innodb-data-home-dir                                         (No default value)
innodb-default-row-format                                    dynamic
innodb-disable-sort-file-cache                               FALSE
innodb-doublewrite                                           TRUE
innodb-fast-shutdown                                         1
innodb-file-format                                           Barracuda
innodb-file-format-check                                     TRUE
innodb-file-format-max                                       Antelope
innodb-file-per-table                                        TRUE
innodb-fill-factor                                           100
innodb-flush-log-at-timeout                                  1
innodb-flush-log-at-trx-commit                               1
innodb-flush-method                                          (No default value)
innodb-flush-neighbors                                       1
innodb-flush-sync                                            TRUE
innodb-flushing-avg-loops                                    30
innodb-force-load-corrupted                                  FALSE
innodb-force-recovery                                        0
innodb-ft-aux-table                                          (No default value)
innodb-ft-cache-size                                         8000000
innodb-ft-enable-diag-print                                  FALSE
innodb-ft-enable-stopword                                    TRUE
innodb-ft-max-token-size                                     84
innodb-ft-min-token-size                                     3
innodb-ft-num-word-optimize                                  2000
innodb-ft-result-cache-limit                                 2000000000
innodb-ft-server-stopword-table                              (No default value)
innodb-ft-sort-pll-degree                                    2
innodb-ft-total-cache-size                                   640000000
innodb-ft-user-stopword-table                                (No default value)
innodb-io-capacity                                           200
innodb-io-capacity-max                                       4294967295
innodb-large-prefix                                          TRUE
innodb-lock-wait-timeout                                     50
innodb-locks-unsafe-for-binlog                               FALSE
innodb-log-buffer-size                                       16777216
innodb-log-checksums                                         TRUE
innodb-log-compressed-pages                                  TRUE
innodb-log-file-size                                         50331648
innodb-log-files-in-group                                    2
innodb-log-group-home-dir                                    (No default value)
innodb-log-write-ahead-size                                  8192
innodb-lru-scan-depth                                        1024
innodb-max-dirty-pages-pct                                   75
innodb-max-dirty-pages-pct-lwm                               0
innodb-max-purge-lag                                         0
innodb-max-purge-lag-delay                                   0
innodb-max-undo-log-size                                     1073741824
innodb-monitor-disable                                       (No default value)
innodb-monitor-enable                                        (No default value)
innodb-monitor-reset                                         (No default value)
innodb-monitor-reset-all                                     (No default value)
innodb-old-blocks-pct                                        37
innodb-old-blocks-time                                       1000
innodb-online-alter-log-max-size                             134217728
innodb-open-files                                            0
innodb-optimize-fulltext-only                                FALSE
innodb-page-cleaners                                         4
innodb-page-size                                             16384
innodb-print-all-deadlocks                                   FALSE
innodb-purge-batch-size                                      300
innodb-purge-rseg-truncate-frequency                         128
innodb-purge-threads                                         4
innodb-random-read-ahead                                     FALSE
innodb-read-ahead-threshold                                  56
innodb-read-io-threads                                       4
innodb-read-only                                             FALSE
innodb-replication-delay                                     0
innodb-rollback-on-timeout                                   FALSE
innodb-rollback-segments                                     128
innodb-sort-buffer-size                                      1048576
innodb-spin-wait-delay                                       6
innodb-stats-auto-recalc                                     TRUE
innodb-stats-method                                          nulls_equal
innodb-stats-on-metadata                                     FALSE
innodb-stats-persistent                                      TRUE
innodb-stats-persistent-sample-pages                         20
innodb-stats-sample-pages                                    8
innodb-stats-transient-sample-pages                          8
innodb-status-file                                           FALSE
innodb-status-output                                         FALSE
innodb-status-output-locks                                   FALSE
innodb-strict-mode                                           TRUE
innodb-support-xa                                            TRUE
innodb-sync-array-size                                       1
innodb-sync-spin-loops                                       30
innodb-table-locks                                           TRUE
innodb-temp-data-file-path                                   (No default value)
innodb-thread-concurrency                                    0
innodb-thread-sleep-delay                                    10000
innodb-tmpdir                                                (No default value)
innodb-undo-directory                                        (No default value)
innodb-undo-log-truncate                                     FALSE
innodb-undo-logs                                             128
innodb-undo-tablespaces                                      0
innodb-use-native-aio                                        TRUE
innodb-write-io-threads                                      4
interactive-timeout                                          28800
internal-tmp-disk-storage-engine                             InnoDB
join-buffer-size                                             262144
keep-files-on-create                                         FALSE
key-buffer-size                                              8388608
key-cache-age-threshold                                      300
key-cache-block-size                                         1024
key-cache-division-limit                                     100
language                                                     F:\temp\20160708\mysql-5.7.13-winx64\mysql-5.7.13-winx64\share\
lc-messages                                                  en_US
lc-messages-dir                                              F:\temp\20160708\mysql-5.7.13-winx64\mysql-5.7.13-winx64\share\
lc-time-names                                                en_US
local-infile                                                 TRUE
lock-wait-timeout                                            31536000
log-bin                                                      (No default value)
log-bin-index                                                (No default value)
log-bin-trust-function-creators                              FALSE
log-bin-use-v1-row-events                                    FALSE
log-builtin-as-identified-by-password                        FALSE
log-error                                                    stderr
log-error-verbosity                                          1
log-isam                                                     myisam.log
log-output                                                   FILE
log-queries-not-using-indexes                                FALSE
log-raw                                                      FALSE
log-short-format                                             FALSE
log-slave-updates                                            FALSE
log-slow-admin-statements                                    FALSE
log-slow-slave-statements                                    FALSE
log-statements-unsafe-for-binlog                             TRUE
log-syslog                                                   TRUE
log-syslog-tag                                               
log-tc                                                       tc.log
log-tc-size                                                  24576
log-throttle-queries-not-using-indexes                       0
log-timestamps                                               UTC
log-warnings                                                 0
long-query-time                                              10
low-priority-updates                                         FALSE
lower-case-table-names                                       1
master-info-file                                             master.info
master-info-repository                                       FILE
master-retry-count                                           86400
master-verify-checksum                                       FALSE
max-allowed-packet                                           4194304
max-binlog-cache-size                                        18446744073709547520
max-binlog-dump-events                                       0
max-binlog-size                                              1073741824
max-binlog-stmt-cache-size                                   18446744073709547520
max-connect-errors                                           100
max-connections                                              151
max-delayed-threads                                          20
max-digest-length                                            1024
max-error-count                                              64
max-execution-time                                           0
max-heap-table-size                                          16777216
max-join-size                                                18446744073709551615
max-length-for-sort-data                                     1024
max-points-in-geometry                                       65536
max-prepared-stmt-count                                      16382
max-relay-log-size                                           0
max-seeks-for-key                                            4294967295
max-sort-length                                              1024
max-sp-recursion-depth                                       0
max-tmp-tables                                               32
max-user-connections                                         0
max-write-lock-count                                         4294967295
memlock                                                      FALSE
metadata-locks-cache-size                                    1024
metadata-locks-hash-instances                                8
min-examined-row-limit                                       0
multi-range-count                                            256
myisam-block-size                                            1024
myisam-data-pointer-size                                     6
myisam-max-sort-file-size                                    2146435072
myisam-mmap-size                                             18446744073709551615
myisam-recover-options                                       OFF
myisam-repair-threads                                        1
myisam-sort-buffer-size                                      8388608
myisam-stats-method                                          nulls_unequal
myisam-use-mmap                                              FALSE
mysql-native-password-proxy-users                            FALSE
named-pipe                                                   FALSE
net-buffer-length                                            16384
net-read-timeout                                             30
net-retry-count                                              10
net-write-timeout                                            60
new                                                          FALSE
ngram                                                        ON
ngram-token-size                                             2
offline-mode                                                 FALSE
old                                                          FALSE
old-alter-table                                              FALSE
old-passwords                                                0
old-style-user-limits                                        FALSE
open-files-limit                                             7048
optimizer-prune-level                                        1
optimizer-search-depth                                       62
optimizer-switch                                             index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on,index_condition_pushdown=on,mrr=on,mrr_cost_based=on,block_nested_loop=on,batched_key_access=off,materialization=on,semijoin=on,loosescan=on,firstmatch=on,duplicateweedout=on,subquery_materialization_cost_based=on,use_index_extensions=on,condition_fanout_filter=on,derived_merge=on
optimizer-trace                                              
optimizer-trace-features                                     greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on
optimizer-trace-limit                                        1
optimizer-trace-max-mem-size                                 16384
optimizer-trace-offset                                       -1
parser-max-mem-size                                          18446744073709551615
partition                                                    ON
performance-schema                                           TRUE
performance-schema-accounts-size                             -1
performance-schema-consumer-events-stages-current            FALSE
performance-schema-consumer-events-stages-history            FALSE
performance-schema-consumer-events-stages-history-long       FALSE
performance-schema-consumer-events-statements-current        TRUE
performance-schema-consumer-events-statements-history        TRUE
performance-schema-consumer-events-statements-history-long   FALSE
performance-schema-consumer-events-transactions-current      FALSE
performance-schema-consumer-events-transactions-history      FALSE
performance-schema-consumer-events-transactions-history-long FALSE
performance-schema-consumer-events-waits-current             FALSE
performance-schema-consumer-events-waits-history             FALSE
performance-schema-consumer-events-waits-history-long        FALSE
performance-schema-consumer-global-instrumentation           TRUE
performance-schema-consumer-statements-digest                TRUE
performance-schema-consumer-thread-instrumentation           TRUE
performance-schema-digests-size                              -1
performance-schema-events-stages-history-long-size           -1
performance-schema-events-stages-history-size                -1
performance-schema-events-statements-history-long-size       -1
performance-schema-events-statements-history-size            -1
performance-schema-events-transactions-history-long-size     -1
performance-schema-events-transactions-history-size          -1
performance-schema-events-waits-history-long-size            -1
performance-schema-events-waits-history-size                 -1
performance-schema-hosts-size                                -1
performance-schema-instrument                                
performance-schema-max-cond-classes                          80
performance-schema-max-cond-instances                        -1
performance-schema-max-digest-length                         1024
performance-schema-max-file-classes                          80
performance-schema-max-file-handles                          32768
performance-schema-max-file-instances                        -1
performance-schema-max-index-stat                            -1
performance-schema-max-memory-classes                        320
performance-schema-max-metadata-locks                        -1
performance-schema-max-mutex-classes                         200
performance-schema-max-mutex-instances                       -1
performance-schema-max-prepared-statements-instances         -1
performance-schema-max-program-instances                     -1
performance-schema-max-rwlock-classes                        40
performance-schema-max-rwlock-instances                      -1
performance-schema-max-socket-classes                        10
performance-schema-max-socket-instances                      -1
performance-schema-max-sql-text-length                       1024
performance-schema-max-stage-classes                         150
performance-schema-max-statement-classes                     193
performance-schema-max-statement-stack                       10
performance-schema-max-table-handles                         -1
performance-schema-max-table-instances                       -1
performance-schema-max-table-lock-stat                       -1
performance-schema-max-thread-classes                        50
performance-schema-max-thread-instances                      -1
performance-schema-session-connect-attrs-size                -1
performance-schema-setup-actors-size                         -1
performance-schema-setup-objects-size                        -1
performance-schema-users-size                                -1
pid-file                                                     F:\temp\20160708\mysql-5.7.13-winx64\mysql-5.7.13-winx64\data\TY1035.pid
plugin-dir                                                   F:\temp\20160708\mysql-5.7.13-winx64\mysql-5.7.13-winx64\lib\plugin\
port                                                         3306
port-open-timeout                                            0
preload-buffer-size                                          32768
profiling-history-size                                       15
query-alloc-block-size                                       8192
query-cache-limit                                            1048576
query-cache-min-res-unit                                     4096
query-cache-size                                             1048576
query-cache-type                                             OFF
query-cache-wlock-invalidate                                 FALSE
query-prealloc-size                                          8192
range-alloc-block-size                                       4096
range-optimizer-max-mem-size                                 8388608
read-buffer-size                                             131072
read-only                                                    FALSE
read-rnd-buffer-size                                         262144
relay-log                                                    (No default value)
relay-log-index                                              (No default value)
relay-log-info-file                                          relay-log.info
relay-log-info-repository                                    FILE
relay-log-purge                                              TRUE
relay-log-recovery                                           FALSE
relay-log-space-limit                                        0
replicate-same-server-id                                     FALSE
report-host                                                  (No default value)
report-password                                              (No default value)
report-port                                                  0
report-user                                                  (No default value)
require-secure-transport                                     FALSE
rpl-stop-slave-timeout                                       31536000
safe-user-create                                             FALSE
secure-auth                                                  TRUE
secure-file-priv                                             
server-id                                                    0
server-id-bits                                               32
session-track-gtids                                          OFF
session-track-schema                                         TRUE
session-track-state-change                                   FALSE
session-track-system-variables                               time_zone,autocommit,character_set_client,character_set_results,character_set_connection
session-track-transaction-info                               OFF
sha256-password-proxy-users                                  FALSE
shared-memory                                                FALSE
shared-memory-base-name                                      MYSQL
show-compatibility-56                                        FALSE
show-old-temporals                                           FALSE
show-slave-auth-info                                         FALSE
skip-grant-tables                                            FALSE
skip-name-resolve                                            FALSE
skip-networking                                              FALSE
skip-show-database                                           FALSE
skip-slave-start                                             FALSE
slave-allow-batching                                         FALSE
slave-checkpoint-group                                       512
slave-checkpoint-period                                      300
slave-compressed-protocol                                    FALSE
slave-exec-mode                                              STRICT
slave-load-tmpdir                                            C:\Users\ADMINI~1\AppData\Local\Temp
slave-max-allowed-packet                                     1073741824
slave-net-timeout                                            60
slave-parallel-type                                          DATABASE
slave-parallel-workers                                       0
slave-pending-jobs-size-max                                  16777216
slave-preserve-commit-order                                  FALSE
slave-rows-search-algorithms                                 TABLE_SCAN,INDEX_SCAN
slave-skip-errors                                            (No default value)
slave-sql-verify-checksum                                    TRUE
slave-transaction-retries                                    10
slave-type-conversions                                       
slow-launch-time                                             2
slow-query-log                                               FALSE
slow-query-log-file                                          F:\temp\20160708\mysql-5.7.13-winx64\mysql-5.7.13-winx64\data\TY1035-slow.log
slow-start-timeout                                           15000
socket                                                       MySQL
sort-buffer-size                                             262144
sporadic-binlog-dump-fail                                    FALSE
sql-mode                                                     ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
ssl                                                          TRUE
ssl-ca                                                       (No default value)
ssl-capath                                                   (No default value)
ssl-cert                                                     (No default value)
ssl-cipher                                                   (No default value)
ssl-crl                                                      (No default value)
ssl-crlpath                                                  (No default value)
ssl-key                                                      (No default value)
stored-program-cache                                         256
super-read-only                                              FALSE
symbolic-links                                               TRUE
sync-binlog                                                  1
sync-frm                                                     TRUE
sync-master-info                                             10000
sync-relay-log                                               10000
sync-relay-log-info                                          10000
sysdate-is-now                                               FALSE
table-definition-cache                                       1400
table-open-cache                                             2000
table-open-cache-instances                                   16
tc-heuristic-recover                                         OFF
temp-pool                                                    FALSE
thread-cache-size                                            9
thread-handling                                              one-thread-per-connection
thread-stack                                                 262144
time-format                                                  %H:%i:%s
tls-version                                                  TLSv1,TLSv1.1
tmp-table-size                                               16777216
tmpdir                                                       C:\Users\ADMINI~1\AppData\Local\Temp
transaction-alloc-block-size                                 8192
transaction-isolation                                        REPEATABLE-READ
transaction-prealloc-size                                    4096
transaction-read-only                                        FALSE
transaction-write-set-extraction                             OFF
updatable-views-with-limit                                   YES
validate-user-plugins                                        TRUE
verbose                                                      TRUE
wait-timeout                                                 28800

To see what values a running MySQL server is using, type
'mysqladmin variables' instead of 'mysqld --verbose --help'.

mysql命令参数详解

mysql  Ver 14.14 Distrib 5.7.13, for Win64 (x86_64)
Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Usage: mysql [OPTIONS] [database]
  -?, --help          Display this help and exit.
  -I, --help          Synonym for -?
  --auto-rehash       Enable automatic rehashing. One doesn't need to use
                      'rehash' to get table and field completion, but startup
                      and reconnecting may take a longer time. Disable with
                      --disable-auto-rehash.
                      (Defaults to on; use --skip-auto-rehash to disable.)
  -A, --no-auto-rehash 
                      No automatic rehashing. One has to use 'rehash' to get
                      table and field completion. This gives a quicker start of
                      mysql and disables rehashing on reconnect.
  --auto-vertical-output 
                      Automatically switch to vertical output mode if the
                      result is wider than the terminal width.
  -B, --batch         Don't use history file. Disable interactive behavior.
                      (Enables --silent.)
  --bind-address=name IP address to bind to.
  --character-sets-dir=name 
                      Directory for character set files.
  --column-type-info  Display column type information.
  -c, --comments      Preserve comments. Send comments to the server. The
                      default is --skip-comments (discard comments), enable
                      with --comments.
  -C, --compress      Use compression in server/client protocol.
  -#, --debug[=#]     This is a non-debug version. Catch this and exit.
  --debug-check       This is a non-debug version. Catch this and exit.
  -T, --debug-info    This is a non-debug version. Catch this and exit.
  -D, --database=name Database to use.
  --default-character-set=name 
                      Set the default character set.
  --delimiter=name    Delimiter to be used.
  --enable-cleartext-plugin 
                      Enable/disable the clear text authentication plugin.
  -e, --execute=name  Execute command and quit. (Disables --force and history
                      file.)
  -E, --vertical      Print the output of a query (rows) vertically.
  -f, --force         Continue even if we get an SQL error.
  --histignore=name   A colon-separated list of patterns to keep statements
                      from getting logged into syslog and mysql history.
  -G, --named-commands 
                      Enable named commands. Named commands mean this program's
                      internal commands; see mysql> help . When enabled, the
                      named commands can be used from any line of the query,
                      otherwise only from the first line, before an enter.
                      Disable with --disable-named-commands. This option is
                      disabled by default.
  -i, --ignore-spaces Ignore space after function names.
  --init-command=name SQL Command to execute when connecting to MySQL server.
                      Will automatically be re-executed when reconnecting.
  --local-infile      Enable/disable LOAD DATA LOCAL INFILE.
  -b, --no-beep       Turn off beep on error.
  -h, --host=name     Connect to host.
  -H, --html          Produce HTML output.
  -X, --xml           Produce XML output.
  --line-numbers      Write line numbers for errors.
                      (Defaults to on; use --skip-line-numbers to disable.)
  -L, --skip-line-numbers 
                      Don't write line number for errors.
  -n, --unbuffered    Flush buffer after each query.
  --column-names      Write column names in results.
                      (Defaults to on; use --skip-column-names to disable.)
  -N, --skip-column-names 
                      Don't write column names in results.
  --sigint-ignore     Ignore SIGINT (CTRL-C).
  -o, --one-database  Ignore statements except those that occur while the
                      default database is the one named at the command line.
  -p, --password[=name] 
                      Password to use when connecting to server. If password is
                      not given it's asked from the tty.
  -W, --pipe          Use named pipes to connect to server.
  -P, --port=#        Port number to use for connection or 0 for default to, in
                      order of preference, my.cnf, $MYSQL_TCP_PORT,
                      /etc/services, built-in default (3306).
  --prompt=name       Set the mysql prompt to this value.
  --protocol=name     The protocol to use for connection (tcp, socket, pipe,
                      memory).
  -q, --quick         Don't cache result, print it row by row. This may slow
                      down the server if the output is suspended. Doesn't use
                      history file.
  -r, --raw           Write fields without conversion. Used with --batch.
  --reconnect         Reconnect if the connection is lost. Disable with
                      --disable-reconnect. This option is enabled by default.
                      (Defaults to on; use --skip-reconnect to disable.)
  -s, --silent        Be more silent. Print results with a tab as separator,
                      each row on new line.
  --shared-memory-base-name=name 
                      Base name of shared memory.
  -S, --socket=name   The socket file to use for connection.
  --ssl-mode=name     SSL connection mode.
  --ssl               Deprecated. Use --ssl-mode instead.
                      (Defaults to on; use --skip-ssl to disable.)
  --ssl-verify-server-cert 
                      Deprecated. Use --ssl-mode=VERIFY_IDENTITY instead.
  --ssl-ca=name       CA file in PEM format.
  --ssl-capath=name   CA directory.
  --ssl-cert=name     X509 cert in PEM format.
  --ssl-cipher=name   SSL cipher to use.
  --ssl-key=name      X509 key in PEM format.
  --ssl-crl=name      Certificate revocation list.
  --ssl-crlpath=name  Certificate revocation list path.
  --tls-version=name  TLS version to use, permitted values are: TLSv1, TLSv1.1
  -t, --table         Output in table format.
  --tee=name          Append everything into outfile. See interactive help (\h)
                      also. Does not work in batch mode. Disable with
                      --disable-tee. This option is disabled by default.
  -u, --user=name     User for login if not current user.
  -U, --safe-updates  Only allow UPDATE and DELETE that uses keys.
  -U, --i-am-a-dummy  Synonym for option --safe-updates, -U.
  -v, --verbose       Write more. (-v -v -v gives the table output format).
  -V, --version       Output version information and exit.
  -w, --wait          Wait and retry if connection is down.
  --connect-timeout=# Number of seconds before connection timeout.
  --max-allowed-packet=# 
                      The maximum packet length to send to or receive from
                      server.
  --net-buffer-length=# 
                      The buffer size for TCP/IP and socket communication.
  --select-limit=#    Automatic limit for SELECT when using --safe-updates.
  --max-join-size=#   Automatic limit for rows in a join when using
                      --safe-updates.
  --secure-auth       Refuse client connecting to server if it uses old
                      (pre-4.1.1) protocol. Deprecated. Always TRUE
  --server-arg=name   Send embedded server this as a parameter.
  --show-warnings     Show warnings after every statement.
  -j, --syslog        Log filtered interactive commands to syslog. Filtering of
                      commands depends on the patterns supplied via histignore
                      option besides the default patterns.
  --plugin-dir=name   Directory for client-side plugins.
  --default-auth=name Default authentication client-side plugin to use.
  --binary-mode       By default, ASCII '\0' is disallowed and '\r\n' is
                      translated to '\n'. This switch turns off both features,
                      and also turns off parsing of all clientcommands except
                      \C and DELIMITER, in non-interactive mode (for input
                      piped to mysql or loaded using the 'source' command).
                      This is necessary when processing output from mysqlbinlog
                      that may contain blobs.
  --connect-expired-password 
                      Notify the server that this client is prepared to handle
                      expired password sandbox mode.

Default options are read from the following files in the given order:
C:\Windows\my.ini C:\Windows\my.cnf C:\my.ini C:\my.cnf D:\mysql-5.7.13-winx64\my.ini D:\mysql-5.7.13-winx64\my.cnf 
The following groups are read: mysql client
The following options may be given as the first argument:
--print-defaults        Print the program argument list and exit.
--no-defaults           Don't read default options from any option file,
                        except for login file.
--defaults-file=#       Only read default options from the given file #.
--defaults-extra-file=# Read this file after the global files are read.
--defaults-group-suffix=#
                        Also read groups with concat(group, suffix)
--login-path=#          Read this path from the login file.

Variables (--variable-name=value)
and boolean options {FALSE|TRUE}  Value (after reading options)
--------------------------------- ----------------------------------------
auto-rehash                       TRUE
auto-vertical-output              FALSE
bind-address                      (No default value)
character-sets-dir                (No default value)
column-type-info                  FALSE
comments                          FALSE
compress                          FALSE
database                          (No default value)
default-character-set             auto
delimiter                         ;
enable-cleartext-plugin           FALSE
vertical                          FALSE
force                             FALSE
histignore                        (No default value)
named-commands                    FALSE
ignore-spaces                     FALSE
init-command                      (No default value)
local-infile                      FALSE
no-beep                           FALSE
host                              (No default value)
html                              FALSE
xml                               FALSE
line-numbers                      TRUE
unbuffered                        FALSE
column-names                      TRUE
sigint-ignore                     FALSE
port                              0
prompt                            mysql> 
quick                             FALSE
raw                               FALSE
reconnect                         TRUE
shared-memory-base-name           (No default value)
socket                            (No default value)
ssl                               TRUE
ssl-verify-server-cert            FALSE
ssl-ca                            (No default value)
ssl-capath                        (No default value)
ssl-cert                          (No default value)
ssl-cipher                        (No default value)
ssl-key                           (No default value)
ssl-crl                           (No default value)
ssl-crlpath                       (No default value)
tls-version                       (No default value)
table                             FALSE
user                              (No default value)
safe-updates                      FALSE
i-am-a-dummy                      FALSE
connect-timeout                   0
max-allowed-packet                16777216
net-buffer-length                 16384
select-limit                      1000
max-join-size                     1000000
secure-auth                       TRUE
show-warnings                     FALSE
plugin-dir                        (No default value)
default-auth                      (No default value)
binary-mode                       FALSE
connect-expired-password          FALSE

 

 运行远程访问

mysql -u root -pvmware
mysql>use mysql;
mysql>update user set host = '%' where user = 'root';
mysql>select host, user from user;   
flush privileges;