The user specified as a definer (''@'') does not exist 关于数据库权限 Mysql权限

插入数据时出现错误

The user specified as a definer (''@'') does not exist

网上一查是权限问题，赋权就好

mysql > grant all privileges on *.* to ''@'' identified by '.';

mysql > flush privileges;

这里注意一下,如果你的错误是

The user specified as a definer ('root'@'%') does not exist

那么你执行就应该是

mysql > grant all privileges on *.* to 'root'@'%' identified by '.';

具体情况看你的错误，请不要直接复制代码