Studyon Minte9.com
Magento




Change database



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>

Do it carefully without changing the structure of the code. 
Make sure you only change the values that are inside the CDATA brackets. 
Please keep in mind that removing or renaming the file will trigger the reinstall procedure 
of the Magento Store.


http://blog.ecommercesoftwaresolutionsonline.com/archives/193/
mysql-database-connection-setting-for-magento-store.html