Magento is a most popular eCommerce software program. In this article you will get details about Magento database configuration file. To change your Magento database server hostname, database username, password or database name, you need to edit below file.
/<Magento Install Dir>/app/etc/local.xml
Navigate to your Magento installation directory and edit local.xml configuration file in your favorite editor and search for following settings.
<connection> <host><![CDATA[localhost ]]></host> <username><![CDATA[database_username ]]></username> <password><![CDATA[database_password ]]></password> <dbname><![CDATA[database_name ]]></dbname> <active>1</active> </connection>
Now update the orange highlighted values as following
localhost : Mysql server hostname.database_username : Mysql user to connect database server.database_password : Mysql user password .database_name : Mysql database name of magento.