Dm同步查询状态时dump报错

还是那个问题,我密码设置为空,还是报错,我用的是root账号,密码设置为空 [2019/11/24 21:52:04.548 +08:00] [INFO] [worker.go:883] [“end to execute operation”] [component=“worker controller”] [“oplog ID”=58] [] [2019/11/24 21:52:04.640 +08:00] [INFO] [mydumper.go:158] [“Server version reported as: 5.7.28-log”] [task=chuanshu] [unit=dump] [2019/11/24 21:52:04.640 +08:00] [INFO] [mydumper.go:158] [“Connected to a MySQL server”] [task=chuanshu] [unit=dump] [2019/11/24 21:52:04.641 +08:00] [INFO] [mydumper.go:158] [“Started dump at: 2019-11-24 21:52:04”] [task=chuanshu] [unit=dump] [2019/11/24 21:52:04.642 +08:00] [INFO] [mydumper.go:158] [“Written master status”] [task=chuanshu] [unit=dump] [2019/11/24 21:52:04.685 +08:00] [INFO] [mydumper.go:158] [“Thread 1 connected using MySQL connection ID 1115”] [task=chuanshu] [unit=dump] [2019/11/24 21:52:04.733 +08:00] [INFO] [mydumper.go:158] [“Thread 2 connected using MySQL connection ID 1116”] [task=chuanshu] [unit=dump] [2019/11/24 21:52:04.782 +08:00] [INFO] [mydumper.go:158] [“Thread 3 connected using MySQL connection ID 1117”] [task=chuanshu] [unit=dump] [2019/11/24 21:52:04.826 +08:00] [INFO] [mydumper.go:158] [“Thread 4 connected using MySQL connection ID 1118”] [task=chuanshu] [unit=dump] [2019/11/24 21:52:04.826 +08:00] [ERROR] [mydumper.go:164] [“Error: DB: --password - Could not execute query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘–password LIKE ‘(null)’’ at line 1”] [task=chuanshu] [unit=dump] [2019/11/24 21:52:04.826 +08:00] [INFO] [mydumper.go:158] [“Non-InnoDB dump complete, unlocking tables”] [task=chuanshu] [unit=dump] [2019/11/24 21:52:04.827 +08:00] [INFO] [mydumper.go:158] [“Thread 2 shutting down”] [task=chuanshu] [unit=dump] [2019/11/24 21:52:04.827 +08:00] [INFO] [mydumper.go:158] [“Thread 3 shutting down”] [task=chuanshu] [unit=dump] [2019/11/24 21:52:04.827 +08:00] [INFO] [mydumper.go:158] [“Thread 4 shutting down”] [task=chuanshu] [unit=dump] [2019/11/24 21:52:04.827 +08:00] [INFO] [mydumper.go:158] [“Thread 1 shutting down”] [task=chuanshu] [unit=dump] [2019/11/24 21:52:04.827 +08:00] [INFO] [mydumper.go:158] [“Finished dump at: 2019-11-24 21:52:04”] [task=chuanshu] [unit=dump] [2019/11/24 21:52:04.827 +08:00] [INFO] [mydumper.go:114] [“dump data finished”] [task=chuanshu] [unit=dump] [“cost time”=278.707122ms] [2019/11/24 21:52:04.827 +08:00] [INFO] [subtask.go:232] [“unit process returned”] [subtask=chuanshu] [unit=Dump] [stage=Paused] [status={}]

还是说我不能把密码设置为空,但是我看到官方文档有说置空的举例

https://pingcap.com/docs-cn/stable/how-to/get-started/data-migration/

知道原因了,dm portal生成的模板有问题

:+1::+1::+1:

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