Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

SQLSTATE[28000] [1045] Access denied for user ‘root’@’localhost’ (using password: YES)
 
mpekala
Jr. Member
 
Total Posts:  2
Joined:  2010-02-22
 

Hello,

Hoping one of you guys ran into this problem before. I’ve installed Mangento successfully and started adding products thru ADMIN just fine. During this process I’ve had to change the root mySQL password for security reasons. Once I’ve done that my store no longer worked and showed this error instead. Makes sense since I’ve changed the mySQL pass.

There has been an error processing your request

There has been an error processing your requestSQLSTATE[28000] [1045] Access denied for user ‘root’@’localhost’ (using password: YES)
Trace:
#0 /var/www/html/magento2/lib/Zend/Db/Adapter/Pdo/Mysql.php(96): Zend_Db_Adapter_Pdo_Abstract->_connect()
#1 /var/www/html/magento2/lib/Varien/Db/Adapter/Pdo/Mysql.php(251): Zend_Db_Adapter_Pdo_Mysql->_connect()
#2 /var/www/html/magento2/lib/Zend/Db/Adapter/Abstract.php(448): Varien_Db_Adapter_Pdo_Mysql->_connect()
............................................

Reading the forum I read that you can go to you app/etc/local.xml and adjust your db password.

So this is the line of code that I changed to my new password.

<host><![CDATA[localhost]]></host>
<
username><![CDATA[root]]></username>
-----> <
password><![CDATA[xxxxxxxx]]></password>
<
dbname><![CDATA[database3]]></dbname>
<
active>1</active>

Nothing changed.. Still same error.

 
Magento Community Magento Community
Magento Community
Magento Community
 
adtorial
Jr. Member
 
Total Posts:  1
Joined:  2011-04-11
 

Open magento/lib/Zend/Cache/Backend/File.php and look for:

protected $_options = array(
\'cache_dir\' => \'null\',

Change it to:

protected $_options = array(
\'cache_dir\' => \'tmp/\',

Save it.

Now the final step is to go create a tmp folder in the root Magento folder.

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top