Title

Thursday, 5 February 2015

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


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.

Any idea what the problem could be?

Answer

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' 
Answer2

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

No comments:

Post a Comment