Magento:SQLSTATE [42000]:语法错误或访问冲突:1044访问被拒绝用户'DBUSER'@'%'到数据库'DBNAME'
在这个问题上,我一直把我的头撞到墙上几个小时。任何人都可以帮助吗?我在网上找不到任何内容。
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.
我安装了最新版本的magento,并添加了几个商店和简单的产品,工作正常,直到尝试将关联产品添加到可配置产品。它允许我添加可配置的产品,但是当我尝试添加关联产品到它,它显示以下错误:
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]:语法错误或访问冲突: 1044用户DBUSER的访问被拒绝@'%'到数据库'DBNAME'
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.
任何帮助将非常感激。
感谢。
汤姆
权限问题。
grant_create_temporary_tables,
grant_create_view,
grant_create_routine,
grant_trigger
grant_create_temporary_tables, grant_create_view, grant_create_routine, grant_trigger
排序问题。