How to change you database or mysql settings for Magento?

 

First you will need to open your FTP or SHELL client and navigate to the following folder. Open the folder and edit the code.

/app/etc/local.xml

The code you see should look very similar to the following. Simply modify the settings and save.

<connection>
   <host><![CDATA[localhost]]></host>
   <username><![CDATA[database_username]]></username>
   <password><![CDATA[database_password]]></password>
   <dbname><![CDATA[database_name]]></dbname>
   <active>1</active>
</connection>

Important: Only change the values within the CDATA brackets.