mysqlshow — Display Database, Table, and Column Information mysqlshow  supports the following options, which can be specified on the command line or in the [mysqlshow]  and  [client]  groups of an option file. For information about option files used by MySQL programs, see Section 4.2.2.2, “Using Option Files” . Table 4.17 mysqlshow Options 532 Option Name Description Introduced Deprecated --bind-address Use specified network interface to connect to MySQL Server --compress Compress all information sent between client and server 8.0.18 --compression-algorithms Permitted compression algorithms for connections to server 8.0.18 --count Show the number of rows per table --debug Write debugging log --debug-check Print debugging information when program exits --debug-info Print debugging information, memory, and CPU statistics when program exits --default-auth Authentication plugin to use --default-character-set Specify default character set --defaults-extra-file Read named option file in addition to usual option files --defaults-file Read only named option file --defaults-group-suffix Option group suffix value --enable-cleartext-plugin Enable cleartext authentication plugin --get-server-public-key Request RSA public key from server --help Display help message and exit --host Host on which MySQL server is located --keys Show table indexes --login-path Read login path options from .mylogin.cnf