Magento - Common Fixes

1. I need to change the url that my site is defaulted to
1. in phpmyadmin go to table core_config_data and edit base url fields to what you want
2. A variety of Magento issues can be resolved by deleting cache
1. to easily delete cache go to the /var folder and delete the /cache folder
3. A variety of Magento issues can be resolved by fixing permissions
1. learn how to set magento permissions here
4. To reset Magento Admin PW
1.  go to your cPanel > phpMyAdmin, select your Magento database, click the SQL tab and paste this query:
2. UPDATE admin_user SET password=CONCAT(MD5('sGnewpass'), ':sG') WHERE username='AdminUsername';
3. Note: You have to change newpass in the MD5('sGnewpass') with your new password, and change *AdminUsername* to your Magento admin username.
5. How to set up a Blog in Magento
1. Use AheadWords extension see here -> http://www.magentocommerce.com/magento-connect/aheadWorks/extension/1516/blog-extension-by-aheadworks
6. How to setup a Contact Us Page
1. Paste this into a CMS page
1. <!– CONTACT FORM CODE BEGIN–>
2. {{block type='core/template' name='contactForm' template='contacts/form.phtml'}}
3. <!– CONTACT FORM CODE END–>
7. How to Change the database a Magento Install is pointing to
1. go to app/etc/local.xml
2. edit the information on this page, save and upload