版本信息:TiDB v4.0.1 DM v1.0.6
反复尝试了十几次,都不行。
执行mysql -h db-60.net -P 3306 -u'dm-xx' -p
,输入密码 可以连上。
通过 ./dmctl --encrypt 'aIxxxxxx'
就不行 ,看到最近有改动…把密码换成 'zx@alxxxxx'
重试也不行。
一直报如下错误:
[2020/06/18 09:45:15.597 +08:00] [ERROR] [relay.go:173] ["process error"] [component="relay holder"] [type="msg:\"start reader for UUID 784b7fc9-xx.000001: start sync from GTID set 777234c5-xx:1-37696471,784b7fc9-xx:1-60183626: ERROR 1045 (28000): Access denied for user 'dm-xx'@'%!!(MISSING)'(MISSING) (using password: YES)\" error:<ErrCode:30014 ErrClass:8 ErrScope:1 ErrLevel:3 Message:\"start reader for UUID 784b7fc9-xx.000001: start sync from GTID set 777234c5-xx:1-37696471,784b7fc9-xx:1-60183626: ERROR 1045 (28000): Access denied for user 'dm-xx'@'%!!(MISSING)'(MISSING) (using password: YES)\" RawCause:\"ERROR 1045 (28000): Access denied for user 'dm-xx'@'%' (using password: YES)\" > "]
inventory.ini配置:
[dm_worker_servers]
dm-worker1 ansible_host=172.xx.xx.94 source_id="mysql-replica4-01" dm_worker_port=8262 deploy_dir=/data1/deploy/dm/dm_worker1 server_id=10401 enable_gtid=true relay_binlog_gtid="784b7fc9-xx:1-60183626,777234c5-xx:1-37696471" mysql_host="db-60.net" mysql_user='dm-xx' mysql_password="5QcsxxxxxxxQ==" mysql_port=3306
做过deploy.yaml,确认没有遗漏步骤。也尝试 过v1.0.3, V1.0.5版本,都是一样的问题。
PS 上游MySQL是阿里云RDS