mariadb-show & mysqlshow for MariaDB Enterprise Server 10.6


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

MariaDB Enterprise Server 10.6 also provides a symbolic link to the utility's legacy name (mysqlshow).

mariadb-show Options for MariaDB Enterprise Server 10.6



--character-sets-dir (-c)

Directory for character set files.

--compress (-C)

Use compression in server/client protocol.


Show number of rows per table (may be slow for non-MyISAM tables).

--debug (-#)

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.

--help (-?)

Display this help and exit.

--host (-h)

Connect to host.

--keys (-k)

Show keys for table.


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.


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 the program argument list and exit.


The protocol to use for connection (tcp, socket, pipe).

--show-table-type (-t)

Show table type column.

--socket (-S)

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.

--status (-i)

Shows a lot of extra information about each table.


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