mariadb-show & mysqlshow for MariaDB Community Server 10.4
This page is part of MariaDB's Documentation.
The parent of this page is: Command-Line Interfaces for MariaDB Community Server 10.4
Topics on this page:
Overview
The mysqlshow
utility is used to show details about databases, tables, table columns, indexes, and other database objects with MariaDB Community Server 10.4.
MariaDB Community Server 10.4 also provides a symbolic link to the utility's new name (mariadb-show
).
mysqlshow Options for MariaDB Community Server 10.4
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_ | |
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. |
To see options supported in other versions, see "mariadb-show & mysqlshow Options by MariaDB Server Version".