MySQL :: MySQL 8.4 Reference Manual :: 15.1.30 DROP SERVER Statement (original) (raw)

15.1.30 DROP SERVER Statement

DROP SERVER [ IF EXISTS ] server_name

Drops the server definition for the server named_`servername`_. The corresponding row in the mysql.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.