DM Access denied for user

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。

  • 【TiDB 版本】:tidb v4.0.1 dm v1.0.6
  • 【问题描述】:

已确认 同步账号权限没问题,mysql命令 可以连接。

+---------------------------------------------------------------------------------+
| Grants for dm-syncer@%                                                          |
+---------------------------------------------------------------------------------+
| GRANT SELECT, RELOAD, LOCK TABLES, REPLICATION CLIENT ON *.* TO 'dm-syncer'@'%' |
+---------------------------------------------------------------------------------+
1 row in set (

使用dmctl 加密 或者 写明文,都无法连接MySQL,报Access denied for user

附配置:

## DM modules
[dm_master_servers]
dm_master ansible_host=172.xx.xx.94 deploy_dir=/data1/deploy/dm/master

[dm_worker_servers]
dm-worker1 ansible_host=172.xx.xx.94 source_id="mysql-replica4-01" server_id=4001 mysql_host=stg-db.xx.xx.net mysql_user=dm-syncer mysql_password="wYVCZyz/Bz52hwj0/K/WCUCL.xx.xx." mysql_port=3306  relay_binlog_name="mysql-bin.009535"  deploy_dir=/data1/deploy/dm/dm-worker1

[dm_portal_servers]
dm_portal ansible_host=172..xx.xx.94

## Monitoring modules
[prometheus_servers]
prometheus ansible_host=172..xx.xx..92

[grafana_servers]
grafana ansible_host=172.xx.xx.92

[alertmanager_servers]
alertmanager ansible_host=172.xx.xx.92

## Global variables
[all:vars]
cluster_name = dm4-cluster

ansible_user = tidb

dm_version = v1.0.6

deploy_dir = /data1/deploy/dm

grafana_admin_user = "admin"
grafana_admin_password = "admin"

ok,这边反馈下,辛苦私信将明文密码完成发给我,这边再测试下。

此问题已通过私信解决,问题定论为: replica slave 权限缺少,导致同步报错。

Access denied for user 报错也未预期

此话题已在最后回复的 1 分钟后被自动关闭。不再允许新回复。