mysqldump — A Database Backup Program The permitted compression algorithms for connections to the server. The available algorithms are the same as for the  protocol_compression_algorithms  system variable. The default value is uncompressed . For more information, see Section 4.2.8, “Connection Compression Control” . This option was added in MySQL 8.0.18. A hint about which client-side authentication plugin to use. See Section 6.2.17, “Pluggable Authentication” . Enable the  mysql_clear_password  cleartext authentication plugin. (See Section 6.4.1.4, “Client-Side Cleartext Pluggable Authentication” .) 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” . Dump data from the MySQL server on the given host. The default host is  localhost . Read options from the named login path in the  .mylogin.cnf  login path file. A “login path”  is an option group containing options that specify which MySQL server to connect to and which account to authenticate as. To create or modify a login path file, use the  mysql_config_editor  utility. See Section 4.6.7, “mysql_config_editor — MySQL Configuration Utility” . For additional information about this and other option-file options, see Section 4.2.2.3, “Command-Line Options that Affect Option-File Handling” . • --login-path= name • --host= host_name ,  -h  host_name • --get-server-public-key • --enable-cleartext-plugin • --default-auth= plugin