Library: NULL License: GPL *************************** 4. row *************************** Name: MyISAM  Status: ACTIVE Type: STORAGE ENGINE Library: NULL License: GPL ... 

SHOW PLUGINS  output has these columns: 

## • Name 

The name used to refer to the plugin in statements such as INSTALL PLUGIN  and UNINSTALL PLUGIN . 

## • Status 

The plugin status, one of ACTIVE , INACTIVE , DISABLED , DELETING , or DELETED . 

## • Type 

The type of plugin, such as STORAGE ENGINE , INFORMATION_SCHEMA , or AUTHENTICATION . 

## • Library 

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 . 

## • License 

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

## 13.7.7.26 SHOW PRIVILEGES Statement 

SHOW PRIVILEGES 

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. 

mysql> SHOW PRIVILEGES\G *************************** 1. row *************************** Privilege: Alter Context: Tables Comment: To alter the table *************************** 2. row *************************** Privilege: Alter routine Context: Functions,Procedures 

