The validate_password plugin can be used for
password strength checking. If the plugin is not installed,
mysql_secure_installation prompts the user
whether to install it. Any passwords entered later are checked
using the plugin if it is enabled.

Most of the usual MySQL client options such as
--host and
--port can be
used on the command line and in option files. For example, to
connect to the local server over IPv6 using port 3307, use this
command:

Read this option file after the global option file but (on
Unix) before the user option file. If the file does not
exist or is otherwise inaccessible, an error occurs.
file_name is interpreted relative
to the current directory if given as a relative path name
rather than a full path name.

Use only the given option file. If the file does not exist
or is otherwise inaccessible, an error occurs.
file_name is interpreted relative
to the current directory if given as a relative path name
rather than a full path name.

The connection protocol to use for connecting to the server.
It is useful when the other connection parameters normally
would cause a protocol to be used other than the one you
want. For details on the permissible values, see
Section 4.2.2, “Connecting to the MySQL Server”.

The protocols permitted by the client for encrypted
connections. The value is a comma-separated list containing
one or more protocol names. The protocols that can be named
for this option depend on the SSL library used to compile
MySQL. For details, see
Section 6.4.6, “Encrypted Connection Protocols and Ciphers”.