Sanjoy Roy

[MCM, MCP, SCJP] – Senior PHP Programmer

Monthly Archives: March 2011

Magento – Where is the mysql configuration file?


C:\wamp\www\www.authsafe.com\public_html\app\etc\local.xml
<config>
<global>
<install>
<date><![CDATA[Wed, 07 Jul 2010 05:17:40 +0000]]></date>
</install>
<crypt>
<key><![CDATA[d9eb10937b98aed1a0b8911c0fbc52fa]]></key>
</crypt>
<disable_local_modules>false</disable_local_modules>
<resources>
<db>
<table_prefix><![CDATA[]]></table_prefix>
</db>
<default_setup>
<connection>
<host><![CDATA[localhost]]></host>
<username><![CDATA[a39085_user]]></username>
<password><![CDATA[se5y45]]></password>
<dbname><![CDATA[a39085_db]]></dbname>
<active>1</active>
</connection>
</default_setup>
</resources>
<session_save><![CDATA[files]]></session_save>
</global>
<admin>
<routers>
<adminhtml>
<args>
<frontName><![CDATA[admin]]></frontName>
</args>
</adminhtml>
</routers>
</admin>
</config>

Magento – How to Enable or Disable Developer’s “Template Path Hints” using phpmyadmin with admin access?


Template Path Hints:

SELECT *
FROM `a39085_db`.`core_config_data`
WHERE (
`config_id` LIKE ‘dev_debug_template_hints’
OR `scope` LIKE ‘dev_debug_template_hints’
OR `scope_id` LIKE ‘dev_debug_template_hints’
OR `path` LIKE ‘dev_debug_template_hints’
OR `value` LIKE ‘dev_debug_template_hints’
)
LIMIT 0 , 30
UPDATE `a39085_db`.`core_config_data` SET `value` = ‘0’ WHERE `core_config_data`.`config_id` = 467 LIMIT 1