Installing and Uninstalling Loadable Functions •MySQL Enterprise Edition includes a firewall capability that implements an application-level firewall to enable database administrators to permit or deny SQL statement execution based on matching against patterns for accepted statement. See Section 6.4.7, “MySQL Enterprise Firewall” . •A query rewriter examines statements received by MySQL Server and possibly rewrites them before the server executes them. See Section 5.6.4, “The Rewriter Query Rewrite Plugin” •Version Tokens enables creation of and synchronization around server tokens that applications can use to prevent accessing incorrect or out-of-date data. See Section 5.6.6, “Version Tokens” . •The MySQL Keyring provides secure storage for sensitive information. See Section 6.4.4, “The MySQL Keyring” . •A locking service provides a locking interface for application use. See Section 5.6.9.1, “The Locking Service” . •A function provides access to query attributes. See Section 9.6, “Query Attributes” . The following sections describe how to install and uninstall loadable functions, and how to determine at runtime which loadable functions are installed and obtain information about them. In some cases, a loadable function is loaded by installing the component that implements the function, rather than by loading the function directly. For details about a particular loadable function, see the installation instructions for the server feature that includes it. For information about writing loadable functions, see Adding Functions to MySQL. 5.7.1 Installing and Uninstalling Loadable Functions Loadable functions, as the name implies, must be loaded into the server before they can be used. MySQL supports automatic function loading during server startup and manual loading thereafter. While a loadable function is loaded, information about it is available as described in Section 5.7.2, “Obtaining Information About Loadable Functions” . •Installing Loadable Functions •Uninstalling Loadable Functions •Reinstalling or Upgrading Loadable Functions Installing Loadable Functions To load a loadable function manually, use the  CREATE FUNCTION  statement. For example: CREATE FUNCTION metaphon RETURNS STRING SONAME ’udf_example.so’; The file base name depends on your platform. Common suffixes are  .so  for Unix and Unix-like systems, .dll  for Windows. CREATE FUNCTION  has these effects: •It loads the function into the server to make it available immediately. •It registers the function in the  mysql.func  system table to make it persistent across server restarts. For this reason,  CREATE FUNCTION  requires the  INSERT  privilege for the  mysql  system database. 1144