13.1.27 DROP SERVER Syntax

DROP SERVER [ IF EXISTS ] server_name

Drops the server definition for the server named server_name. The corresponding row in the mysql.servers table is deleted. This statement requires the SUPER privilege.

Dropping a server for a table does not affect any FEDERATED tables that used this connection information when they were created. See Section 13.1.16, “CREATE SERVER Syntax”.

DROP SERVER does not cause an automatic commit.

In MySQL 5.1, DROP SERVER is written to the binary log only when using row-based logging. It is not logged when binlog_format is equal to STATEMENT or MIXED.

DROP SERVER was added in MySQL 5.1.15.

User Comments
Sign Up Login You must be logged in to post a comment.