Magento: SQLSTATE[42000]: Syntax error or access v

Question

I've been banging my head off the wall for hours with this problem. Can anyone help please? I've not been able to find anything online about it.

I've installed the latest version of magento and added a few stores and simple products, and everything seems to be working fine until trying to add associated products to a configurable product. It lets me add the configurable product but then when I try to add associated products to it, it shows this error:

SQLSTATE[42000]: Syntax error or access violation: 1044 Access denied for user 'DBUSER'@'%' to database 'DBNAME'

It appears to me to be a privileges issue, but not sure how to resolve it. The site is hosted on heart internet and I can't find how to manage privileges. What's confusing me though is why it's letting me add simple products but not configurable ones.

Any help would be greatly appreciated.

Thanks.

Tom

Answer 1

It was a privileges issue.

grant_create_temporary_tables, grant_create_view, grant_create_routine, grant_trigger

sorted the problem.

Answer 2

Goto magento dir /app/etc/ and open local.xml. here check database username ,database name,database user password