mysql_upgrade — Check and Upgrade MySQL Tables • --net-buffer-length= value • --no-defaults • --password[= password ] ,  -p[ password ] • --pipe ,  -W • --plugin-dir= dir_name • --port= port_num ,  -P  port_num • --print-defaults • --protocol={TCP|SOCKET|PIPE|MEMORY} 411 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” . Print the program name and all options that it gets from option files. For TCP/IP connections, the port number to use. The directory in which to look for plugins. Specify this option if the  --default-auth  option is used to specify an authentication plugin but  mysql_upgrade  does not find it. See Section 6.2.17, “Pluggable Authentication” . 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. To explicitly specify that there is no password and that  mysql_upgrade  should not prompt for one, use the  --skip-password  option. 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” . The password of the MySQL account used for connecting to the server. The password value is optional. If not given,  mysql_upgrade  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. For additional information about this and other option-file options, see Section 4.2.2.3, “Command-Line Options that Affect Option-File Handling” . 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” . 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 initial size of the buffer for client/server communication. The default value is 1MB  −  1KB. The minimum and maximum values are 4KB and 16MB.