This document describes how to create a data subscription task in DTS for TencentDB for MySQL or TDSQL-C for MySQL.
create user 'migration account' IDENTIFIED BY 'account password';
grant SELECT, REPLICATION CLIENT,REPLICATION SLAVE,PROCESS on *.* to 'migration account'@'%';
flush privileges;
Operation Type | Supported SQL Operations |
---|---|
DML | INSERT, UPDATE, and DELETE |
DDL | CREATE DATABASE, DROP DATABASE, CREATE TABLE, ALTER TABLE, DROP TABLE, and RENAME TABLE |
Note:If the verification fails, fix the problem as instructed in Database Connection Check and initiate the verification again.
Was this page helpful?