1.tidb版本号：tidb_version = v3.0.12
2.使用binlog进行同步数据，drainer部署后，启动drainer，执行ansible-playbook start_drainer.yml，报错如下图；
3.在drainer部署的服务器上查看 drainer.log日志如下，
[tidb@tidb_test_5 log]$ vim drainer.log
[2020/05/28 14:32:36.709 +08:00] [INFO] [version.go:50] [“Welcome to Drainer”] [“Release Version”=v3.0.12] [“Git Commit Hash”=e4f2ba252977385faa32a0553808cc564d22929a] [“Build TS”=“2020-03-16 12:36:21”] [“Go Version”=go1.13] [“Go OS/Arch”=linux/amd64]
[2020/05/28 14:32:36.709 +08:00] [INFO] [main.go:46] [“start drainer…”] [config=“{"log-level":"info","node-id":"","addr":"http://192.168.15.122:8249","advertise-addr":"http://192.168.15.122:8249","data-dir":"/home/tidb/deploy/data.drainer","detect-interval":10,"pd-urls":"http://192.168.15.115:2379,http://192.168.15.118:2379,http://192.168.15.120:2379","log-file":"/home/tidb/deploy/log/drainer.log","initial-commit-ts":416956333467107331,"sycner":{"sql-mode":null,"ignore-txn-commit-ts":[],"ignore-schemas":"INFORMATION_SCHEMA,PERFORMANCE_SCHEMA,mysql","ignore-table":null,"txn-batch":20,"loopback-control":false,"sync-ddl":true,"channel-id":0,"worker-count":16,"to":{"host":"127.0.0.1","user":"root","password":"","encrypted_password":"","sync-mode":0,"port":3306,"checkpoint":{"type":"","schema":"","host":"","user":"","password":"","encrypted_password":"","port":0},"dir":"","zookeeper-addrs":"","kafka-addrs":"","kafka-version":"","kafka-max-messages":0,"kafka-client-id":"","topic-name":""},"replicate-do-table":null,"replicate-do-db":null,"db-type":"mysql","disable-dispatch":false,"relay":{"log-dir":"","max-file-size":10485760},"safe-mode":false,"disable-detect":false},"security":{"ssl-ca":"","ssl-cert":"","ssl-key":""},"synced-check-time":5,"compressor":"","EtcdTimeout":5000000000,"MetricsAddr":"","MetricsInterval":15}”]
[2020/05/28 14:32:36.710 +08:00] [INFO] [client.go:144] [“[pd] create pd client with endpoints”] [pd-address=“[http://192.168.15.115:2379,http://192.168.15.118:2379,http://192.168.15.120:2379]”]
[2020/05/28 14:32:36.714 +08:00] [INFO] [client.go:252] [“[pd] switch leader”] [new-leader=http://192.168.15.118:2379] [old-leader=]
[2020/05/28 14:32:36.714 +08:00] [INFO] [client.go:163] [“[pd] init cluster id”] [cluster-id=6815852588055789040]
[2020/05/28 14:32:36.714 +08:00] [INFO] [server.go:115] [“get cluster id from pd”] [id=6815852588055789040]
[2020/05/28 14:32:36.716 +08:00] [FATAL] [main.go:50] [“create drainer server failed”] [error=“initialize mysql type checkpoint with config &{CheckpointType:mysql Db:0xc0003cfcc0 Schema:tidb_binlog Table:checkpoint ClusterID:6815852588055789040 InitialCommitTS:416956333467107331 CheckPointFile:/home/tidb/deploy/data.drainer/savepoint}: exec failed, sql: create schema if not exists tidb_binlog: Error 1045: Access denied for user ‘root’@‘127.0.0.1’ (using password: NO)”] [errorVerbose=“Error 1045: Access denied for user ‘root’@‘127.0.0.1’ (using password: NO)
exec failed, sql: create schema if not exists tidb_binlog
github.com/pingcap/tidb-binlog/drainer/checkpoint.newMysql
\t/home/jenkins/agent/workspace/release_tidb_3.0/go/src/github.com/pingcap/tidb-binlog/drainer/checkpoint/mysql.go:69
github.com/pingcap/tidb-binlog/drainer/checkpoint.NewCheckPoint
\t/home/jenkins/agent/workspace/release_tidb_3.0/go/src/github.com/pingcap/tidb-binlog/drainer/checkpoint/checkpoint.go:54
github.com/pingcap/tidb-binlog/drainer.NewServer
\t/home/jenkins/agent/workspace/release_tidb_3.0/go/src/github.com/pingcap/tidb-binlog/drainer/server.go:136
main.main
\t/home/jenkins/agent/workspace/release_tidb_3.0/go/src/github.com/pingcap/tidb-binlog/cmd/drainer/main.go:48
runtime.main
\t/usr/local/go/src/runtime/proc.go:203
runtime.goexit
\t/usr/local/go/src/runtime/asm_amd64.s:1357
initialize mysql type checkpoint with config &{CheckpointType:mysql Db:0xc0003cfcc0 Schema:tidb_binlog Table:checkpoint ClusterID:6815852588055789040 InitialCommitTS:416956333467107331 CheckPointFile:/home/tidb/deploy/data.drainer/savepoint}”] [stack=“github.com/pingcap/log.Fatal
\t/home/jenkins/agent/workspace/release_tidb_3.0/go/pkg/mod/github.com/pingcap/log@v0.0.0-20190715063458-479153f07ebd/global.go:59
main.main
\t/home/jenkins/agent/workspace/release_tidb_3.0/go/src/github.com/pingcap/tidb-binlog/cmd/drainer/main.go:50
runtime.main
\t/usr/local/go/src/runtime/proc.go:203”]
[2020/05/28 14:32:51.956 +08:00] [INFO] [version.go:50] [“Welcome to Drainer”] [“Release Version”=v3.0.12] [“Git Commit Hash”=e4f2ba252977385faa32a0553808cc564d22929a] [“Build TS”=“2020-03-16 12:36:21”] [“Go Version”=go1.13] [“Go OS/Arch”=linux/amd64]
@
请教一下，如何处理？？谢谢
