Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 35.1Mb
PDF (A4) - 35.2Mb
Man Pages (TGZ) - 256.3Kb
Man Pages (Zip) - 361.2Kb
Info (Gzip) - 3.4Mb
Info (Zip) - 3.4Mb
Excerpts from this Manual

MySQL 5.7 Reference Manual  / ...  / SQL Statements  / Data Definition Statements  /  DROP SERVER Statement

13.1.28 DROP SERVER Statement

DROP SERVER [ IF EXISTS ]server_name

Drops the server definition for the server namedserver_name. The corresponding row in themysql.servers table is deleted. This statement requires theSUPER privilege.

Dropping a server for a table does not affect anyFEDERATED tables that used this connection information when they were created. SeeSection 13.1.17, “CREATE SERVER Statement”.

DROP SERVER causes an implicit commit. SeeSection 13.3.3, “Statements That Cause an Implicit Commit”.

DROP SERVER is not written to the binary log, regardless of the logging format that is in use.