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