Magento:未捕获的异常“异常”,消息为“无法连接到mysql:用户”用户名“@”本地主机“(使用密码:否)的访问被


Magento: Uncaught exception 'Exception' with message 'Can't connect to mysql: Access denied for user 'username'@'localhost' (using password: NO)'

您好,我在尝试安装新主题时遇到了 magento 的奇怪问题。它说使用密码不,但我提供了正确的密码。我将非常感谢您帮助解决此问题。

未捕获的异常"异常",在/home/mdayurve/public_html/letterfloret/install.lib 中显示消息"无法连接到 mysql:用户 'mdayurve_letr885'@'localhost' (使用密码:否)的访问被拒绝.php:30

堆栈跟踪:

#0 /home/mdayurve/public_html/letterfloret/install-em0022.php(34): open_db(string, string, string, string, string)
#1 {main}
  thrown in /home/mdayurve/public_html/letterfloret/install.lib.php on line 30

检查您的本地.xml并查看数据库的配置

请检查您的旧主题是否正常工作,因此您在 local.xml 中没有错误,但如果不是这样,请确保更正本地数据库的信息.xml

有关此内容的更多信息,请参阅此链接。

http://inchoo.net/ecommerce/magento/using-local-xml-for-overriding-or-updating-xml-structure/ http://magebase.com/magento-tutorials/5-useful-tricks-for-your-magento-local-xml/

听起来创建

主题的人也创建了一个单独的数据库方法。 Magento在无法连接到数据库时抛出的错误消息如下所示

Access denied for user 'username'@'localhost' (using password: YES)";i:1;s:3152:"#0 /Users/alanstorm/Sites2012/magento1point7pointzeropoint1.dev/lib/Zend/Db/Adapter/Pdo/Mysql.php(96): Zend_Db_Adapter_Pdo_Abstract->_connect()

错误消息的措辞

Uncaught exception 'Exception' with message 'Can't connect to mysql: Access denied for user 'mdayurve_letr885'@'localhost' (using password: NO)' in /home/mdayurve/public_html/letterfloret/install.lib.php:30
Uncaught exception 'Exception' with message 'Can't connect to mysql: Access denied for user 'username'@'localhost' (using password: NO)'

我会在主题文件中查找建立第二个数据库连接的 PHP 函数调用。

发布install.lib.phpinstall-em0022.php的内容将有助于人们为您调试问题。

更新:如果您查看install-em0022.php,则文件顶部包含以下内容

/**
 * USER INSTRUCTION:
 *
 * 1. upload em0022-theme-package.zip, install-em0022.php and install.lib.php to your magento folder (/public_html)
 * 2. configure install-em0022.php at CONFIGURE HERE section
 * 3. run install-em0022.php from your web browser: http://www.yourdomain.com/install-em0022.php
 * 4. delete em0022-theme-package.zip, install-em0022.php and install.lib.php
 */

################################################################################
### CONFIGURE HERE
################################################################################
$dbhost = "localhost";  # Database host name
$dbname = ""; # Database name
$dbuser = "root"; # Database username
$dbpass = ""; # Database password
$dbport = ""; # Database port
$adminuser = 'admin'; // magento admin username
$adminpass = ''; // magento admin password

显然,您需要在此处复制数据库凭据才能"安装"此主题。