Magento – How to change SQL server password in Magento

password-recovery

I would like to change the password for my sql server but I got the access denied message from Magento once I changed the password. So how can I change the setting in Magento to reflect the password change? Thanks.

Best Answer

In order ,to change MySQL password of a Magento system,you need go Magento main configuration file local.xml at yourMagentodir>app/etc/

Open local.xml and here your find below setting

<password><![CDATA[YOUR_DB_PASSWORD]]></password>

just change YOUR_DB_PASSWORD to your password

Under CDATA[] ,you need to put password