tapdata：2024年Top10国产数据库迁移与同步指南（203页）.pdf

1、rootCREATE USER username IDENTIFIED BY password;1GRANT ALL ON database_name.*TO username;1tapdata tapdatatestserver_id =223344log_bin =mysql-binexpire_logs_days =1binlog_format =rowbinlog_row_image =full12345/etc/inint.d/mysqld restart1show variables like binlog_format;1show variables like binlog_ro

2、w_image;1create user usernamelocalhost identified by password;1/create user usernamelocalhost identified with mysql_native_password by password;/alter user usernamelocalhost identified with mysql_native_password by password;1234GRANT SELECT,SHOW VIEW,CREATE ROUTINE,LOCK TABLES ON.TO tapdata IDENTIFI

3、ED BY password;1GRANT RELOAD,SHOW DATABASES,REPLICATION SLAVE,REPLICATION CLIENT ON*.*TO tapdata IDENTIFIED BY password;1SET GLOBAL tidb_gc_life_time=24hCREATE USER usernamehost IDENTIFIED BY password;1CREATE USER tapdata%IDENTIFIED BY your_passwd;1-GRANT SELECT,INSERT,UPDATE,DELETE,ALTER,CREATE,CRE

4、ATE ROUTINE,CREATE TEMPORARY TABLES,DROP ON database_name.*TO username;-GRANT SELECT,INSERT,UPDATE,DELETE,ALTER,CREATE,CREATE ROUTINE,CREATE TEMPORARY TABLES,DROP ON*.*TO username;12345CREATE USER username IDENTIFIED BY password DEFAULT TABLESPACE table_space_name;1-username GRANT CREATE TABLE,DELET

5、E TABLE,INSERT TABLE,SELECT TABLE,UPDATE TABLE,CREATE INDEX TO username;12dbtool-loadserver -load-retryclusterid=1 tablename=db01.tb01dbtool loadserver-load-retry clusterid=1-importdate=2017-07-07 tablename=db01.tb01dbtool-loadserver-type=in -loadin-support-null=1-clusterid=1dbtool-loadserver-conver

6、t-to-insert-tablename|-importdirdbtool-loadserver-type=out-clusterid=1 -user=xxxx-password=xxxxdbtool-loadserver-type=in-clusterid=1-skip-ok-check-set-unique-column=unique_c#time interval for report statistic to metadataserver;unit:s;0:means timing report been closed;recommended value range:0172800s