Using the SHOW Command
There are several different uses of the SHOW command, which will produce output displaying a great deal of useful information about your MySQL database, users, and tables. Depending on your access level, some of the SHOW commands will not be available to you or will provide only minimal information. The root-level user has the capability to use all the SHOW commands, with the most comprehensive results.
The common uses of SHOW include the following, which you'll soon learn about in more detail:
SHOW GRANTS FOR user SHOW DATABASES [LIKE something] SHOW [OPEN] TABLES [FROM database_name] [LIKE something] SHOW CREATE TABLE table_name SHOW [FULL] COLUMNS FROM table_name [FROM database_name] [LIKE something] SHOW INDEX FROM ...