• --execute= statement , -e statement 

Execute the statement and quit. The default output format is like that produced with --batch . See Section 4.2.2.1, “Using Options on the Command Line” , for some examples. With this option, mysql does not use the history file. 

• --force , -f 

Continue even if an SQL error occurs. 

• --get-server-public-key 

Request from the server the public key required for RSA key pair-based password exchange. This option applies to clients that authenticate with the caching_sha2_password  authentication plugin. For that plugin, the server does not send the public key unless requested. This option is ignored for accounts that do not authenticate with that plugin. It is also ignored if RSA-based password exchange is not used, as is the case when the client connects to the server using a secure connection. 

If --server-public-key-path= file_name  is given and specifies a valid public key file, it takes precedence over --get-server-public-key . 

For information about the caching_sha2_password  plugin, see Section 6.4.1.2, “Caching SHA-2 Pluggable Authentication” . 

• --histignore 

A list of one or more colon-separated patterns specifying statements to ignore for logging purposes. These patterns are added to the default pattern list ( "*IDENTIFIED*:*PASSWORD*" ). The value specified for this option affects logging of statements written to the history file, and to syslog  if the -- syslog  option is given. For more information, see Section 4.5.1.3, “mysql Client Logging” . 

• --host= host_name , -h host_name 

Connect to the MySQL server on the given host. 

The --dns-srv-name  option takes precedence over the --host  option if both are given. --dns-srv- name  causes connection establishment to use the mysql_real_connect_dns_srv() C API function rather than mysql_real_connect() . However, if the connect  command is subsequently used at runtime and specifies a host name argument, that host name takes precedence over any --dns-srv- name  option given at mysql  startup to specify a DNS SRV record. 

• --html , -H 

Produce HTML output. 

• --ignore-spaces , -i 

Ignore spaces after function names. The effect of this is described in the discussion for the IGNORE_SPACE  SQL mode (see Section 5.1.11, “Server SQL Modes” ). 

• --init-command=str 

SQL statement to execute after connecting to the server. If auto-reconnect is enabled, the statement is executed again after reconnection occurs. 

• --line-numbers 

Write line numbers for errors. Disable this with --skip-line-numbers . 

