MySQL - INSTALL COMPONENT Statement

INSTALL COMPONENT Statement

MySQL components is that which provides services (to server and other components). You can install a MySQL component in MySQL using the INSTALL COMPONENT Statement. To execute this statement, you need INSERT privilege.

Syntax

Following is the syntax of the MySQL INSTALL COMPONENT statement −

INSTALL COMPONENT component_name [, component_name ] ...

Where, component_name is the name of the component you need to install.

Example

Following query installs the log_sink_syseventlog component in MySQL −

INSTALL COMPONENT 'file://component_log_sink_syseventlog';

Following query installs few more plugins in MySQL using the INSTALL COMPONENT statement −

INSTALL COMPONENT 'file://component_validate_password';

Install COMPONENT 'file://component_mysqlbackup';

Install COMPONENT 'file://component_log_sink_json';

Install COMPONENT 'file://component_log_filter_dragnet';

Installing multiple components

You can also install multiple components in MySQL server using the INSTALL COMPONENT statement. You just need to separate the names of the components using commas.

INSTALL COMPONENT 'file://component_validate_password', 
'file://component_mysqlbackup', 'file://component_log_sink_json', 
'file://component_log_filter_dragnet';