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

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权限也不行:

image


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

配置文件发一下

task配置文件吗?

task 配置文件:

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

是的 !

已解决

:+1: 请问是权限的问题嘛 ? 可以分享下解决方案~ 如果报错不清晰,可以提需求优化下

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