需要权限

授权语句

GRANT SELECT, SHOW DATABASES, SUPER, REPLICATION SLAVE, EVENT ON . TO ‘xxtest’@‘%’

RDS云产品数据库云产品权限,可能不是按 MySQL 开源权限来的,请自行确认是否有足够权限

需要执行以下SQL权限

SELECT COLUMN_NAME,COLUMN_DEFAULT,IS_NULLABLE,COLUMN_TYPE,COLUMN_KEY,EXTRA,COLUMN_COMMENT,DATA_TYPE,NUMERIC_PRECISION,NUMERIC_SCALE FROM information_schema.columns WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ?

SELECT COLUMN_NAME,COLUMN_KEY,COLUMN_TYPE,CHARACTER_SET_NAME,COLLATION_NAME,NUMERIC_SCALE,EXTRA,COLUMN_DEFAULT,DATA_TYPE,CHARACTER_OCTET_LENGTH FROM information_schema.columns WHERE table_schema= ? AND table_name= ? ORDER BY ORDINAL_POSITION ASC

SELECT SCHEMA_NAME FROM information_schema.SCHEMATA

SELECT TABLE_NAME,TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = ?

SHOW GLOBAL VARIABLES LIKE ‘BINLOG_CHECKSUM’

SHOW MASTER STATUS

SHOW VARIABLES LIKE ‘server_id’

SHOW VARIABLES LIKE ‘binlog_format’

SELECT connection_id()

SELECT TIME,STATE FROM information_schema.PROCESSLIST WHERE ID = ?’

KILL 当前帐号binlog监控的异常连接

备注

如果是RDS等云产品,请自行确认是否有 监听Binlog的权限，KILL 当前帐号连接的权限,SET 权限

在 binlog 解析过程中,会对需要同步的表进行结构查询, 所以请事先给帐号设置好对需要同步的表的查询权限，并且添加数据源 CheckPrivilege 的时候是检测不出来的，需要用户自行关注