Magento database configuration file location

Should you need to change Magento database settings, for example when moving your Magento store to another server, you can find your database settings in:

\app\etc\local.xml


Starting from line 41 the Magento store database connection info looks like this

<default_setup>
<connection>
<host><![CDATA[your server address]]></host>
<username><![CDATA[your db username]]></username>
<password><![CDATA[your db users password]]></password>
<dbname><![CDATA[your database name]]></dbname>
<initStatements><![CDATA[SET NAMES utf8]]></initStatements>
<model><![CDATA[mysql4]]></model>
<type><![CDATA[pdo_mysql]]></type>
<pdoType><![CDATA[]]></pdoType>
<active>1</active>
</connection>
</default_setup>


ADs top-right (2)

About me

Iinstructor of robotics (LEGO Mindstorms), computer teacher, IT support, web dev, currently studying cyber-physical systems engineering.

If you found a solution here, would you consider donating $25,000 for my next project?

Just kidding, 1$ would do fine.

Hope you found what you needed. Thanks for stepping by.