SHOW Statements Library: NULL License: GPL *************************** 4. row *************************** Name: MyISAM  Status: ACTIVE Type: STORAGE ENGINE Library: NULL License: GPL ... SHOW PLUGINS  output has these columns: The name used to refer to the plugin in statements such as  INSTALL PLUGIN  and  UNINSTALL PLUGIN . The plugin status, one of  ACTIVE ,  INACTIVE ,  DISABLED ,  DELETING , or  DELETED . The type of plugin, such as  STORAGE ENGINE ,  INFORMATION_SCHEMA , or  AUTHENTICATION . The name of the plugin shared library file. This is the name used to refer to the plugin file in statements such as  INSTALL PLUGIN  and  UNINSTALL PLUGIN . This file is located in the directory named by the  plugin_dir  system variable. If the library name is  NULL , the plugin is compiled in and cannot be uninstalled with  UNINSTALL PLUGIN . How the plugin is licensed (for example,  GPL ). For plugins installed with  INSTALL PLUGIN , the  Name  and  Library  values are also registered in the mysql.plugin  system table. For information about plugin data structures that form the basis of the information displayed by  SHOW PLUGINS , see The MySQL Plugin API. Plugin information is also available from the  INFORMATION_SCHEMA .PLUGINS  table. See Section 26.3.22, “The INFORMATION_SCHEMA PLUGINS Table” . SHOW PRIVILEGES  shows the list of system privileges that the MySQL server supports. The privileges displayed include all static privileges, and all currently registered dynamic privileges. SHOW PRIVILEGES mysql>  SHOW PRIVILEGES\G *************************** 1. row *************************** Privilege: Alter Context: Tables Comment: To alter the table *************************** 2. row *************************** Privilege: Alter routine Context: Functions,Procedures 13.7.7.26 SHOW PRIVILEGES Statement 2939 • Name • Status • Type • Library • License