TRIGGER command denied to user 'root'@'LAPTOP-M7KUFN86' for table 'growtest' | Table 'MyDatabase.tmpIdentity_Invites' doesn't exist

是因为创建表的时候,用户权限不够

NaviCat for Mysql 用这个工具打开MYSQL

在用户 下找到 root@% 这个用户,双击打开 设置服务器权限,最后两个权限勾上就OK 了,需要把MYSQL重启。

表写入数据,提示  Table 'MyDatabase.tmpIdentity_Invites' doesn't exist ,是因为TRIGGER command denied to user 'root'@'LAPTOP-M7KUFN86' for table 'growtest' 导致的,需要配置好权限重建表呀

原文地址:https://www.cnblogs.com/nopassword/p/6144062.html