mariadb-show & mysqlshow for MariaDB Enterprise Server 10.3

This page is part of MariaDB's Documentation.

The parent of this page is: Command-Line Interfaces for MariaDB Enterprise Server 10.3

Topics on this page:

Overview
mysqlshow Options for MariaDB Enterprise Server 10.3

Overview

The mysqlshow utility is used to show details about databases, tables, table columns, indexes, and other database objects with MariaDB Enterprise Server 10.3.

MariaDB Enterprise Server 10.3 does not provide a symbolic link to the utility's new name (mariadb-show), so the legacy name must be used.

mysqlshow Options for MariaDB Enterprise Server 10.3

Option	Description
--character-sets-dir (-c)	Directory for character set files.
--compress (-C)	Use compression in server/client protocol.
--count	Show number of rows per table (may be slow for non-MyISAM tables).
--debug (-#)	Output debug log. Often this is 'd:t:o,filename'.
--debug-check	Check memory and open file usage at exit.
--debug-info	Print some debug info at exit.
--default-auth	Default authentication client-side plugin to use.
--default-character-set	Set the default character set.
--defaults-extra-file	Read this file after the global files are read.
--defaults-file	Only read default options from the given file #.
--defaults-group-suffix	Additionally read default groups with # appended as a suffix.
--help (-?)	Display this help and exit.
--host (-h)	Connect to host.
--keys (-k)	Show keys for table.
--no-defaults	Don't read default options from any option file.
--password (-p)	Password to use when connecting to server. If password is not given, it's solicited on the tty.
--plugin-dir	Directory for client-side plugins.
--port (-P)	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-defaults	Print the program argument list and exit.
--protocol	The protocol to use for connection (tcp, socket, pipe, memory).
--show-table-type (-t)	Show table type column.
--socket (-S)	The socket file to use for connection.
--ssl	Enable SSL for connection (automatically enabled with other flags).
--ssl-ca	CA file in PEM format (check OpenSSL docs, implies --ssl).
--ssl-capath	CA directory (check OpenSSL docs, implies --ssl).
--ssl-cert	X509 cert in PEM format (implies --ssl).
--ssl-cipher	SSL cipher to use (implies --ssl).
--ssl-crl	Certificate revocation list (implies --ssl).
--ssl-crlpath	Certificate revocation list path (implies --ssl).
--ssl-key	X509 key in PEM format (implies --ssl).
--ssl-verify-server-cert	Verify server's "Common Name" in its cert against hostname used when connecting. This option is disabled by default.
--status (-i)	Shows a lot of extra information about each table.
--tls-version	TLS protocol version for secure connection.
--user (-u)	User for login if not current user.
--verbose (-v)	More verbose output; you can use this multiple times to get even more verbose output.
--version (-V)	Output version information and exit.

To see options supported in other versions, see "mariadb-show & mysqlshow Options by MariaDB Server Version".