DROP SERVER [ IF EXISTS ]
Drops the server definition for the server named
. The corresponding row in the
mysql.servers table is deleted. This statement requires the
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.13,
CREATE SERVER Syntax".
DROP SERVER does not cause an automatic commit.
In MySQL 5.7,
DROP SERVER is not written to the binary log, regardless of the
logging format that is in use.
In MySQL 5.7.1,
must be set to
AUTOMATIC before issuing this statement. This restriction does not
apply in MySQL 5.7.2 or later. (Bug #16062608, Bug #16715809, Bug #69045)