Magento:SQLSTATE[42000]:语法错误或访问冲突:1044 用户“DBUSER"@“%"对数据库“DBNAME"的访问被拒绝 [英] Magento: SQLSTATE[42000]: Syntax error or access violation: 1044 Access denied for user 'DBUSER'@'%' to database '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'

在我看来这是一个权限问题，但不知道如何解决.该站点托管在 heart internet 上，我找不到如何管理权限.但令我困惑的是，为什么它允许我添加简单的产品但不能添加可配置的产品.

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

解决问题.

这篇关于Magento:SQLSTATE[42000]:语法错误或访问冲突:1044 用户“DBUSER"@“%"对数据库“DBNAME"的访问被拒绝的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！