为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
- 【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"