
MariaDB Fork
Modify server definitions. Update connection information for external servers defined with CREATE SERVER, primarily used by the Federated engine.
以下正文同步自 Hacker News 最新,版权归原站所有,已转换为易读排版。
Edit
On this page
Server
Reference
SQL Statements
Data Definition (DDL)
ALTER
ALTER SERVER
Modify server definitions. Update connection information for external servers defined with CREATE SERVER, primarily used by the Federated engine.
Copy
ALTER SERVER server_name OPTIONS (option [, option] ...)
Description
Alters the server information for server_name, adjusting the specified options as per the CREATE SERVER command. The corresponding fields in the mysql.servers table are updated accordingly. This statement requires the SUPER privilege or the FEDERATED ADMIN privilege.
ALTER SERVER is not written to the binary log, irrespective of the binary log format being used. Galera replicates the CREATE SERVER, ALTER SERVER and DROP SERVER statements.
Copy
ALTER SERVER s OPTIONS (USER 'sally');
See Also
CREATE SERVER
This page is licensed: GPLv2, originally from fill_help_tables.sql
PreviousALTER LOGFILE GROUP
NextALTER TABLE
Last updated 16 days ago
正文由 探How 从来源站点 RSS 同步,内容未经改写;遇到排版缺失或需要图片、视频时请以原文为准。