How to reset the admin password if you've forgotten it

Problem

You've forgotten the admin password to your installation

Fix

1) Try the forgot password form on yoursite.com/account/forgot_password

2) If you can't remember the email address or it's invalid, you can reset it directly via the database.

- Login via your MySQL client such as phpMyAdmin.
- Execute the following sql on your database, replace ADMIN_USER with your admin username (usually 'admin') and NEW_PASSWORD with your new password.

UPDATE users SET password = MD5('NEW_PASSWORD') WHERE username='ADMIN_USER';

For example:

UPDATE users SET password = MD5('myp455w0rd') WHERE username='admin';