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.

对于这个问题,我已经把头撞了几个小时。有人可以帮忙吗?我无法在网上找到任何关于它的信息。

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:

我已经安装了最新版本的magento并添加了一些商店和简单的产品,在尝试将相关产品添加到可配置产品之前,一切似乎都运行正常。它允许我添加可配置产品,但是当我尝试向其添加相关产品时,它会显示以下错误:

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

SQLSTATE [42000]:语法错误或访问冲突:1044用户“DBUSER”@“%”访问被拒绝到数据库“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

2 个解决方案

#1

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

转到magento dir / app / etc /并打开local.xml。这里检查数据库用户名,数据库名,数据库用户密码

#2

It was a privileges issue.

这是一个特权问题。

grant_create_temporary_tables, grant_create_view, grant_create_routine, grant_trigger

grant_create_temporary_tables,grant_create_view,grant_create_routine,grant_trigger

sorted the problem.

排序问题。