MySQL #1142 - 表 ___ 的 INSERT 命令拒绝用户 ___
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/7301093/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
#1142 - INSERT command denied to user ___ for table ___
提问by Sebastian
Apparently this is usually to do with size, but I only have one table with six columns.
显然这通常与大小有关，但我只有一张六列的表。
The only thing that has changed recently is that today I installed a forum but I've removed it again and the problem persists.
最近唯一改变的是今天我安装了一个论坛，但我又删除了它，问题仍然存在。
I am entering the SQL manually in PHPmyAdmin.
我正在 PHPmyAdmin 中手动输入 SQL。
Any idea what the problem could be?
知道可能是什么问题吗？
回答by Rhak Kahr
I just faced that ERROR, and found that my QUERY state incorrect spelled DATABASE name. :(
我刚刚遇到那个错误，发现我的 QUERY 状态拼写错误的 DATABASE 名称。:(
回答by Rok Kralj
Your user doesn't have INSERT privilege.Check user database privileges.
您的用户没有INSERT 权限。检查用户数据库权限。
Maybe you changed user, maybe you just changed the HOST or the IP from where you are connecting.
也许您更改了用户，也许您只是更改了连接的主机或 IP。
Use this statement to grant the privilege.
使用此语句授予权限。
GRANT INSERT ON databaseName TO 'user'@'66.40.52.21'
