Database Configuration File and Change Admin Url using Magento

Magento was built using the Zend Framework. It uses the entity-attribute-value (EAV) database model to store data. If you want to change the MySQL database details such as hostname, database name, username of Magento Store.


Go to file path loction.:

app\etc\ local.xml

Step 1

Open file


Find xml code and change host , username , password and database name

  1. <default_setup>  
  2. <connection>  
  3. <host><![CDATA[enter host name]]></host>  
  4. <username><![CDATA[enter database user name]]></username>  
  5. <password><![CDATA[enter database password ]]></password>  
  6. <dbname><![CDATA[enter database name]]></dbname>  
  7. <initStatements><![CDATA[SET NAMES utf8]]></initStatements>  
  8. <model><![CDATA[mysql4]]></model>  
  9. <type><![CDATA[pdo_mysql]]></type>  
  10. <pdoType><![CDATA[]]></pdoType>  
  11. <active>1</active>  
  12. </connection>  
  13. </default_setup>  
xml code

Above maintain database connection.

if you want to session save into table:
  1. <session_save><![CDATA[db]]></session_save>  
Admin Path Change

If you want to change admin URL. You can change admin url because protect Magento backend store against hackers.

Step 2

Go to file path loction:

app\etc\ local.xml

local xml
  1. <frontName><![CDATA[admin]]></frontName>  
  1. <frontName><![CDATA[ Enter Your admin name]]></frontName> Enter Your admin name.