MAgento change Database Settings

First you will need to open your FTP and navigate to the following folder.

 

/app/etc/

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>