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.

Solutions

Go to file path loction.:

app\etc\ local.xml

Step 1

Open file

local

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>
Replace
  1. <frontName><![CDATA[ Enter Your admin name]]></frontName>
www.mydomin.com/ Enter Your admin name.