Documentation Home
MySQL 8.4 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 40.2Mb
PDF (A4) - 40.3Mb
Man Pages (TGZ) - 262.1Kb
Man Pages (Zip) - 367.6Kb
Info (Gzip) - 4.0Mb
Info (Zip) - 4.0Mb


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

15.1.30 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 15.1.18, “CREATE SERVER Statement”.

DROP SERVER causes an implicit commit. SeeSection 15.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.