Navigation

    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Groups

    MySQL 数据源需要哪些权限

    官方FAQ
    mysql所需权限
    1
    1
    156
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • junyu-cloudcanal
      junyu-cloudcanal last edited by

      简述

      CloudCanal 在做 MySQL 源端或对端的数据迁移同步时,需要提供的账号有一些赋权。

      描述

      • MySQL 源端
        • 全量迁移:迁移库表的 SELECT 权限,information_schema SELECT 权限
        • 增量同步:SELECT ,REPLICATION SLAVE,REPLICATION CLIENT 权限,information_schema SELECT 权限
      • MySQL 对端
        • 全量迁移/增量同步:迁移库表的 INSERT/UPDATE/DELETE/DDL 权限, information_schema SELECT 权限
      • 系统自动心跳(可选)
        • 默认心跳语句: CREATE DATABASE 权限
      1 Reply Last reply Reply Quote 0
      • 1 / 1
      • First post
        Last post
      Copyright © 2020 ClouGence, Inc.备案号:浙ICP备20007605号-2