1、错误描述
1 queries executed, 0 success, 1 errors, 0 warnings
查询:call insertDate()
错误代码: 1449
The 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\bin
D:\MySQL\Program Files\MySQL\MySQL Server 5.6\bin>mysqldump --all-databases -uro
ot -p > all_databases.sql
Enter password: **************
mysqldump: Got error: 1449: The user specified as a definer ('root'@'%') doe
s not exist when using LOCK TABLES
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>
D:\MySQL\Program Files\MySQL\MySQL Server 5.6\bin>
2、错误原因
这是权限问题,授权给root的所有的SQL语句
3、解决办法
GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY ".";
FLUSH PRIVILEGES;