Error in loading Website due to Database

[swords_kingdom]

Hey Guys!

I recently change database username password from c-panel and now when i open website or admin panel it shows error.how to resolve this issue? how can i add new password in magento database? or what can i do?

[Mukesh Tiwari]

Hi @swords_kingdom 

You should change the database password for Magento in the following file also
app/etc/local.xml

<connection>
    <host><![CDATA[xyz]]></host>
    <username><![CDATA[xyz]]></username>
    <password><![CDATA[xyz]]></password>
    <dbname><![CDATA[xyz]]></dbname>
    <initStatements><![CDATA[SET NAMES utf8]]></initStatements>
    <model><![CDATA[mysql4]]></model>
    <type><![CDATA[pdo_mysql]]></type>
    <pdoType><![CDATA[]]></pdoType>
    <active>1</active>
</connection>

Replace the xyz value with the values of your database connection.

[Sunil Patel]

Hello @swords_kingdom 

you need do into app/etc/local.xml

after did change, you must need to remove cache and you can find it

var/cache folder and you need to do delete it.

If works then mark as solution

[swords_kingdom]

thanks for your reply , I did as you mention, add new details in app/etc/local.xml with new password and delete cache folder but unfortunately i am still unable to access my site 

is ther anyother way to resolve this ? 

[swords_kingdom]

@Sunil Patel . @Mukesh Tiwari ,  guys now i am getting these errors

Trace:
#0/home2/cheredes/public_html/lib/Zend/Controller/Response/Abstract.php(115): Zend_Controller_Response_Abstract->canSendHeaders(true)
#1/home2/cheredes/public_html/app/code/core/Mage/Core/Model/App.php(1246): Zend_Controller_Response_Abstract->setHeader('Content-Type', 'text/html; char...')
#2/home2/cheredes/public_html/app/code/core/Mage/Core/Controller/Varien/Front.php(80): Mage_Core_Model_App->getResponse()
#3/home2/cheredes/public_html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(202): Mage_Core_Controller_Varien_Front->getResponse()
#4/home2/cheredes/public_html/app/code/core/Mage/Core/Controller/Varien/Front.php(172): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#5/home2/cheredes/public_html/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch()
#6 /home2/cheredes/public_html/app/Mage.php(684): Mage_Core_Model_App->run(Array)
#7 /home2/cheredes/public_html/index.php(86): Mage::run('', 'store')
#8 {main}

[Sunil Patel]

Hello @swords_kingdom 

somewhere into code space added or echo added and you need to find it