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

Question

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?

Afflux

Could it be that vBulletin changes the permissions of the user? – Afflux

Have a look at this it solved my problem may your too https://mcmap.net/q/180212/-1142-select-command-denied-to-user-39-39-39-localhost-39-for-table-39-pma_table_uiprefs-39 – Loafer

Answer 1

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

Gaga

Answer 2

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:

Kentish

Answer 3

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' 

Demello

It DID say 'user'@'66.40.52.21' - how can I set it back to what it was if it's changed, and how do I check db privileges. – Afflux

GRANT statement. GRANT INSERT ON databaseName TO 'user'@'66.40.52.21' – Demello

#1142 - INSERT,GRANT command denied to 'user'@'66.40.52.21' for table 'table' How can my privileges be so messed up?! – Afflux

You have to GRANT from the root user. It is logical you can't grant privilege to yourself. – Demello

To my knowledge I only have one user, or is the root user created by default? – Afflux

If you are using hosting, message your hosting provider, he'll grant you that privilege. – Demello

Answer 4

DB quota limit reached = out of MB space.

Attraction