• --defaults-file= file_name 

Use only the given option file. If the file does not exist or is otherwise inaccessible, an error occurs. If file_name  is not an absolute path name, it is interpreted relative to the current directory. 

Exception: Even with --defaults-file , client programs read .mylogin.cnf . 

For additional information about this and other option-file options, see Section 4.2.2.3, “Command-Line Options that Affect Option-File Handling” . 

• --defaults-group-suffix= str 

Read not only the usual option groups, but also groups with the usual names and a suffix of str . For example, mysqlslap  normally reads the [client]  and [mysqlslap]  groups. If this option is given as --defaults-group-suffix=_other , mysqlslap  also reads the [client_other]  and [mysqlslap_other]  groups. 

For additional information about this and other option-file options, see Section 4.2.2.3, “Command-Line Options that Affect Option-File Handling” . 

• --delimiter= str , -F str 

The delimiter to use in SQL statements supplied in files or using command options. 

• --detach= N 

Detach (close and reopen) each connection after each N  statements. The default is 0 (connections are not detached). 

• --enable-cleartext-plugin 

Enable the mysql_clear_password  cleartext authentication plugin. (See Section 6.4.1.4, “Client-Side Cleartext Pluggable Authentication” .) 

• --engine= engine_name , -e engine_name 

The storage engine to use for creating tables. 

• --get-server-public-key 

Request from the server the RSA public key that it uses for key pair-based password exchange. This option applies to clients that connect to the server using an account that authenticates with the caching_sha2_password  authentication plugin. For connections by such accounts, the server does not send the public key to the client unless requested. The option is ignored for accounts that do not authenticate with that plugin. It is also ignored if RSA-based password exchange is not needed, 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” . 

• --host= host_name , -h host_name 

Connect to the MySQL server on the given host. 

• --iterations= N , -i N 

