MENU


Connections

CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name
[create_specification] ...

create_specification:
[DEFAULT] CHARACTER SET [=] charset_name
| [DEFAULT] COLLATE [=] collation_name
ALTER {DATABASE | SCHEMA} [db_name]
alter_specification ...
ALTER {DATABASE | SCHEMA} db_name
UPGRADE DATA DIRECTORY NAME

alter_specification:
[DEFAULT] CHARACTER SET [=] charset_name
| [DEFAULT] COLLATE [=] collation_name
DROP {DATABASE | SCHEMA} [IF EXISTS] db_name
USE db_name
CREATE SERVER server_name
FOREIGN DATA WRAPPER wrapper_name
OPTIONS (option [, option] ...)

option:
{ HOST character-literal
| DATABASE character-literal
| USER character-literal
| PASSWORD character-literal
| SOCKET character-literal
| OWNER character-literal
| PORT numeric-literal }
ALTER SERVER  server_name
OPTIONS (option [, option] ...)
DROP SERVER [ IF EXISTS ] server_name
This defines a server for use with the FEDERATED storage engine.
Currently ‘mysql’ is the only supported wrapper_name. 

CREATE SERVER s
FOREIGN DATA WRAPPER mysql
OPTIONS (
   USER 'Remote', 
   HOST '192.168.1.106', 
   DATABASE 'test');

CREATE TABLE t (s1 INT) 
   ENGINE=FEDERATED 
   CONNECTION='s';
INSTALL PLUGIN plugin_name SONAME 'shared_library_name'
UNINSTALL PLUGIN plugin_name
The shared library must be located in the plugin directory, as indicated by the plugin_dir system variable.
Refer to the online official documentation for more information about using plugins.