This is the H2

HowTo Modify My Password Using PHPMyAdmin

Question: I’m unable to remember my password, and I’m not getting my Forgot Password email to get a new one. How can I figure out what my password is?

Answer: Passwords are encrypted using SHA1, so you’ll need to replace your password with a known SHA1’d password.

In this case, I use the password of password, which is set to:

5baa61e4c9b93f3f0682250b6cf8331b7ee68fd8 

Using a MySQL tool such as PHPMyAdmin (or something similar) replace the value of password with the text string listed above.

NOTE: Once you log into the EE backend, make sure to change your password to something else.

phpmyadmin, password

HowTo Change Membership Preferences to use Default instead of Agile

Question: How can I change the Membership preferences to use Default instead of Agile?

Answer: Log into your control panel backend and browse to CP Home > Members > Membership Preferences > General Configuration

and set Default Member Profile Theme to Default.

Change Membership Preferences

HowTo Add an Edit This Link in EE2

Question: How can I add an Edit This Link in EE2?

Answer: You can use the following snippet:

{if author_id == logged_in_member_id OR logged_in_group_id == "1"}•
 <
a href="{cp_url}?S=0&D=cp&C=content_publish&M=entry_form&channel_id={channel_id}&entry_id={entry_id}">Edit This</a>{/if} 

NOTE: Make sure you have your Control Panel Session Type is set to Cookies Only. You may also want to make sure you set a Cookie Domain.

Creating an Edit This Link

Increase PHP Memory Limit on MAMP Pro

By default PHP has either 8MB (for PHP4) or 16MB (for PHP5) of memory on MAMP PRO (version 1.8.2). 16MB is certainly enough to run a basic install of ExpressionEngine but advanced image manipulation or use of the IP to Nation module will require more.

In MAMP PRO go to the File > Edit Template menu and then select the version of PHP you are working with. This will open the php.ini file in an editor window. Scroll down to find or search for ‘memory_limit’. This will be under the ‘Resource Limits’ heading on about line 230. It will look something like this (for PHP5):

memory_limit 16MMaximum amount of memory a script may consume 

To change the limit to 32MB we can edit it like this:

memory_limit 32MMaximum amount of memory a script may consume 

Select File > Save. Now you will have to restart the server for the change to take place.

EE2 Video: Cookies Only

Setting your control panel to use Cookies Only.