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” . 

• --query= value , -q value 

The file or string containing the SELECT  statement to use for retrieving data. 

• --server-public-key-path= file_name 

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 the sha256_password  or caching_sha2_password  authentication plugin. This option is ignored for accounts that do not authenticate with one of those plugins. 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 sha256_password , this option applies only if MySQL was built using OpenSSL. 

For information about the sha256_password  and caching_sha2_password  plugins, see Section 6.4.1.3, “SHA-256 Pluggable Authentication” , and Section 6.4.1.2, “Caching SHA-2 Pluggable Authentication” . 

• --shared-memory-base-name= name 

On Windows, the shared-memory name to use for connections made using shared memory to a local server. The default value is MYSQL . The shared-memory name is case-sensitive. 

This option applies only if the server was started with the shared_memory  system variable enabled to support shared-memory connections. 

• --silent , -s 

Silent mode. No output. 

• --socket= path , -S path 

For connections to localhost , the Unix socket file to use, or, on Windows, the name of the named pipe to use. 

On Windows, 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. 

• --sql-mode= mode 

Set the SQL mode for the client session. 

• --ssl* 

Options that begin with --ssl  specify whether to connect to the server using encryption and indicate where to find SSL keys and certificates. See Command Options for Encrypted Connections. 

