Change Magento database information

If you want to change the MySQL database connection details such as hostname, database name, username etc of a Magento Store, you need to edit the following file for that. If its in a web server, connect using a FTP software and download the file, edit it and upload back.

/app/etc/local.xml

<connection>

<host><![CDATA[hostname]]></host>

<username><![CDATA[DB username]]></username>

<password><![CDATA[DB pwd]]></password>

<dbname><![CDATA[DB name]]></dbname>

<active>1</active>

</connection>