返回资讯中心
外部精选
软件工程
#开发者实时流

MariaDB Fork

Modify server definitions. Update connection information for external servers defined with CREATE SERVER, primarily used by the Federated engine.

Hacker News 最新lufxen2026/10/18 · 2026/10/182 分钟阅读

以下正文同步自 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 同步,内容未经改写;遇到排版缺失或需要图片、视频时请以原文为准。

打开原文
去社区讨论 →