开发者

#1142 - INSERT command denied to user ___ for table ___

Apparently this is usua开发者_运维知识库lly 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.

Any idea what the problem could be?


I just faced that ERROR, and found that my QUERY state incorrect spelled DATABASE name. :(


The problem is about the user session cookies, so all you need to do is to delete those cookies by clicking on the icon at the top right below phpMyAdmin as mentioned in this mage:

#1142 - INSERT command denied to user ___ for table ___


Your user doesn't have INSERT privilege. Check user database privileges.

Maybe you changed user, maybe you just changed the HOST or the IP from where you are connecting.

Use this statement to grant the privilege.

GRANT INSERT ON databaseName TO 'user'@'66.40.52.21' 
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜