错误代码： 1449 The user specified as a definer ('root'@'%') does not exist

来源：互联网发布：域名的价格top 编辑：程序博客网时间：2024/06/09 22:55

1、错误描述

1 queries executed, 0 success, 1 errors, 0 warnings查询：call insertDate()错误代码： 1449The user specified as a definer ('root'@'%') does not exist执行耗时   : 0 sec传送时间   : 0 sec总耗时      : 0.175 sec

C:\Users\Administrator>d:D:\>cd MySQL\Program Files\MySQL\MySQL Server 5.6\binD:\MySQL\Program Files\MySQL\MySQL Server 5.6\bin>mysqldump --all-databases -uroot -p > all_databases.sqlEnter password: **************mysqldump: Got error: 1449: The user specified as a definer ('root'@'%') does not exist when using LOCK TABLESD:\MySQL\Program Files\MySQL\MySQL Server 5.6\bin>D:\MySQL\Program Files\MySQL\MySQL Server 5.6\bin>D:\MySQL\Program Files\MySQL\MySQL Server 5.6\bin>D:\MySQL\Program Files\MySQL\MySQL Server 5.6\bin>D:\MySQL\Program Files\MySQL\MySQL Server 5.6\bin>D:\MySQL\Program Files\MySQL\MySQL Server 5.6\bin>D:\MySQL\Program Files\MySQL\MySQL Server 5.6\bin>

2、错误原因

这是权限问题，授权给root的所有的SQL语句

3、解决办法

GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY ".";FLUSH PRIVILEGES;

1 0