---
title: "修改mysql配置"
method: POST
path: "/mysql/mycnf-change"
tags: ["mysql"]
---

# 修改mysql配置

`POST /mysql/mycnf-change`

修改mysql配置

## Request body

- DbmServicesMysqlDbToolsDbactuatorPkgComponentsMysqlMycnfChangeComp
  - `extend` DbmServicesMysqlDbToolsDbactuatorPkgComponentsMysqlMycnfChangeParam
    - `items` object, required
    - `persistent` -1 | 1 | 2, required — 是否持久化到 my.cnf 文件，-1: 不持久化，1: 持久化, 2: 仅持久化但不修改运行时
    - `restart` -1 | 1 | 2, required — 指定是否 允许重启, -1:不重启, 1: 重启, 2:根据 items need_restart 自动判断是否重启
    - `tgt_instance` DbmServicesMysqlDbToolsDbactuatorPkgNativeInsObject, required
      - `charset` string — 连接字符集
      - `host` string — 当前实例的主机地址
      - `options` string — 其它选项
      - `port` integer — 当前实例的端口
      - `pwd` string — 连接当前实例的User Pwd
      - `socket` string — 连接socket
      - `user` string — 连接当前实例的User
  - `general` DbmServicesMysqlDbToolsDbactuatorPkgComponentsGeneralParam
    - `runtime_account` DbmServicesMysqlDbToolsDbactuatorPkgComponentsRuntimeAccountParam
      - `admin_pwd` string — mysql admin 密码，环境变量 GENERAL_ACCOUNT_admin_pwd
      - `admin_user` string — mysql admin 账户，环境变量 GENERAL_ACCOUNT_admin_user
      - `backup_pwd` string — dbbackup pwd
      - `backup_user` string — dbbackup user
      - `monitor_access_all_pwd` string — mysql monitor@% 密码
      - `monitor_access_all_user` string — mysql monitor@%
      - `monitor_pwd` string — mysql monitor 密码，环境变量 GENERAL_ACCOUNT_monitor_pwd
      - `monitor_user` string — mysql monitor 账户，环境变量 GENERAL_ACCOUNT_monitor_user
      - `proxy_admin_pwd` string — proxy admin pwd
      - `proxy_admin_user` string — proxy admin user
      - `repl_pwd` string — repl pwd, 环境变量 GENERAL_ACCOUNT_repl_pwd
      - `repl_user` string — repl user, 环境变量 GENERAL_ACCOUNT_repl_user
      - `tdbctl_pwd` string
      - `tdbctl_user` string
      - `yw_pwd` string — yw pwd
      - `yw_user` string — yw user
    - `runtime_extend` DbmServicesMysqlDbToolsDbactuatorPkgComponentsRuntimeExtend
      - `mysql_sys_users` string[]

---

[API](https://skmtc.net/tencentblueking/apis/dbactuator-api.md) · [All operations](https://skmtc.net/tencentblueking/apis/dbactuator-api/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/tencentblueking/dbactuator-api/versions/dc22dd49fd50/schema)