mysqldump备份报错:1449

问题

在进行mysqldump备份时报以下错误:

mysqldump: Got error: 1449: The user specified as a definer ('root'@'%') does not exist when using LOCK TABLES


解决


mysql> grant all privileges on *.* to root@"%"identified by "你的密码";

Query OK, 0 rows affected (0.11 sec)

mysql> flush privileges;

Query OK, 0 rows affected (0.07 sec)

`
再次执行mysqldump命令即可.