dm 2.0 check-task时报lack of RELOAD,SELECT privilege

[brightwen]

Found dmctl newer version:

The latest version:         v2.0.6
Local installed version:    v2.0.1
Update current component:   tiup update dmctl
Update all components:      tiup update --all

Starting component dmctl: /home/tidb/.tiup/components/dmctl/v2.0.1/dmctl/dmctl --master-addr 172.31.0.5:8261 check-task task-uc-moments.yml
{
“result”: false,
“msg”: “[code=26005:class=dm-master:scope=internal:level=medium], Message: fail to check synchronization configuration with type: check was failed, please see detail
detail: {
“results”: [
{
“id”: 5,
“name”: “source db dump privilege checker”,
“desc”: “check dump privileges of source DB”,
“state”: “fail”,
“errorMsg”: “lack of RELOAD,SELECT privilege”,
“instruction”: “GRANT RELOAD,SELECT ON . TO ‘repl’@‘%’;”,
“extra”: “address of db instance - 10.10.26.10:3307”
}
],
“summary”: {
“passed”: false,
“total”: 8,
“successful”: 7,
“failed”: 1,
“warning”: 0
}
}”
}

但repl账号是有对应权限的，即使加上all privileges权限也不行：

---

若提问为性能优化、故障排查类问题，请下载脚本运行。终端输出的打印结果，请务必全选并复制粘贴上传。

[songxuecheng (小白)]

配置文件发一下

[brightwen]

task配置文件吗？

[brightwen]

task 配置文件：

[songxuecheng (小白)]

10.10.26.10:3307 确定是这个实例的用户权限对吧

[brightwen]

是的 ！

[brightwen]

已解决

[小王同学Plus]

请问是权限的问题嘛 ？ 可以分享下解决方案～ 如果报错不清晰，可以提需求优化下

[brightwen]

嗯，权限问题，有两个同名的账号，一个是@‘%’，一个是@‘IP’,授权搞错对象了