mysqlcheck — A Table Maintenance Program The password of the MySQL account used for connecting to the server. The password value is optional. If not given,  mysqlcheck  prompts for one. If given, there must be  no space  between  --password=  or -p  and the password following it. If no password option is specified, the default is to send no password. Specifying a password on the command line should be considered insecure. To avoid giving the password on the command line, use an option file. See Section 6.1.2.1, “End-User Guidelines for Password Security” . To explicitly specify that there is no password and that  mysqlcheck  should not prompt for one, use the --skip-password  option. • --pipe ,  -W • --plugin-dir= dir_name On Windows, connect to the server using a named pipe. This option applies only if the server was started with the  named_pipe  system variable enabled to support named-pipe connections. In addition, the user making the connection must be a member of the Windows group specified by the named_pipe_full_access_group  system variable. The directory in which to look for plugins. Specify this option if the  --default-auth  option is used to specify an authentication plugin but  mysqlcheck  does not find it. See Section 6.2.17, “Pluggable Authentication” . For TCP/IP connections, the port number to use. Print the program name and all options that it gets from option files. For additional information about this and other option-file options, see Section 4.2.2.3, “Command-Line Options that Affect Option-File Handling” . • --print-defaults • --port= port_num ,  -P  port_num The transport protocol to use for connecting to the server. It is useful when the other connection parameters normally result in use of a protocol other than the one you want. For details on the permissible values, see Section 4.2.7, “Connection Transport Protocols” . If you are using this option to check tables, it prevents the check from scanning the rows to check for incorrect links. This is the fastest check method. If you are using this option to repair tables, it tries to repair only the index tree. This is the fastest repair method. • --quick ,  -q • --protocol={TCP|SOCKET|PIPE|MEMORY} • --repair ,  -r • --server-public-key-path= file_name Perform a repair that can fix almost anything except unique keys that are not unique. The path name to a file in PEM format containing a client-side copy of the public key required by the server for RSA key pair-based password exchange. This option applies to clients that authenticate with 469