I am getting this error from a webpage when trying to insert into a table in the 'databasename'
INSERT command denied to user 'theuser'@'localhost' for table 'thetable'
However when i do a show grants on the database i get this
GRANT USAGE ON *.* TO 'theuser'@'%' IDENTIFIED BY PASSWORD 'xxxx'
GRANT ALL PRIVILEGES ON `databasename`.* TO 'theuser'@'%'
I'm not sure what the first line means but surely the second line means the user has all privileges on that database and should be able to insert?