468 mysqlcheck — A Table Maintenance Program Check only tables that have not been closed properly. Continue even if an SQL error occurs. 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” . Connect to the MySQL server on the given host. 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” . Do a check that is faster than an  --extended  operation. This finds only 99.99% of all errors, which should be good enough in most cases. Do not read any option files. If program startup fails due to reading unknown options from an option file, --no-defaults  can be used to prevent them from being read. The exception is that the  .mylogin.cnf  file is read in all cases, if it exists. This permits passwords to be specified in a safer way than on the command line even when  --no-defaults  is used. To create .mylogin.cnf , 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” . Optimize the tables. • --password[= password ] ,  -p[ password ] • --optimize ,  -o • --no-defaults • --medium-check ,  -m • --login-path= name • --host= host_name ,  -h  host_name • --get-server-public-key • --force ,  -f