Options for mariadb-show & mysqlshow in 10.5 ES
The mariadb-show
utility is the newer name for mysqlshow
, though you can still run it using either name.
Option |
Description |
---|---|
Directory for character set files. |
|
Use compression in server/client protocol. |
|
Show number of rows per table (may be slow for non-MyISAM tables). |
|
Output debug log. Often this is 'd:t:o,filename'. |
|
Check memory and open file usage at exit. |
|
Print some debug info at exit. |
|
Default authentication client-side plugin to use. |
|
Set the default character set. |
|
Read this file after the global files are read. |
|
Only read default options from the given file #. |
|
Additionally read default groups with # appended as a suffix. |
|
Display this help and exit. |
|
Connect to host. |
|
Show keys for table. |
|
Don't read default options from any option file. |
|
Password to use when connecting to server. If password is not given, it's solicited on the tty. |
|
Directory for client-side plugins. |
|
Port number to use for connection or 0 for default to, in order of preference, my.cnf, $MYSQL_TCP_PORT, /etc/services, built-in default (3306). |
|
Print the program argument list and exit. |
|
The protocol to use for connection (tcp, socket, pipe). |
|
Show table type column. |
|
The socket file to use for connection. |
|
Enable SSL for connection (automatically enabled with other flags). |
|
CA file in PEM format (check OpenSSL docs, implies --ssl). |
|
CA directory (check OpenSSL docs, implies --ssl). |
|
X509 cert in PEM format (implies --ssl). |
|
SSL cipher to use (implies --ssl). |
|
Certificate revocation list (implies --ssl). |
|
Certificate revocation list path (implies --ssl). |
|
X509 key in PEM format (implies --ssl). |
|
Verify server's "Common Name" in its cert against hostname used when connecting. This option is disabled by default. |
|
Shows a lot of extra information about each table. |
|
TLS protocol version for secure connection. |
|
User for login if not current user. |
|
More verbose output; you can use this multiple times to get even more verbose output. |
|
Output version information and exit. |