If you don't get the activation email, the system mailer was not able to deliver it. There are two common reasons:

1) the registration email is marked by your email-program (i.e. thunderbird) as spam (or "junk"). In this case simply look into your spam folder.

2) your email server is blocking the mail. Some email services like AT&T or Comcast block registration emails because they think it's spam. In this case, you can either contact your email provider ( i.e. http://att.net/blocks ) or use another free email service like Gmail, GMX etc. There's no way to manually activate an account, the password is encrypted (even for me!) and you need a working email address.

I delete non-activated accounts regularly to free the database.