There's nothing you can do with the hashes as it's a security feature. The passwords are hashed which is a one way process. Presumably you can't use the
I forgot my password
link? You can create a temporary admin account to help reset your account. Don't forget to backup the database before running the query.
In phpMyAdmin run the following SQL query, which will create an admin user named Admin1
with a password of admin
. From that point you should be able to get into the ACP.
Code: Select all
INSERT INTO phpbb_users (user_type, group_id, username, username_clean, user_regdate, user_password, user_email, user_lang, user_style, user_rank, user_colour, user_posts, user_permissions, user_ip, user_birthday, user_lastpage, user_last_confirm_key, user_post_sortby_type, user_post_sortby_dir, user_topic_sortby_type, user_topic_sortby_dir, user_avatar, user_sig, user_sig_bbcode_uid, user_jabber, user_actkey, user_newpasswd) VALUES (3, 5, 'Admin1', 'admin1', 0, '21232f297a57a5a743894a0e4a801fc3', 'firstname.lastname@example.org', 'en', 1, 1, 'AA0000', 1, '', '', '', '', '', 't', 'a', 't', 'd', '', '', '', '', '', '');
Change your table prefix if it is not
See Executing SQL Queries in phpMyAdmin
if you are unfamiliar with running database queries.
As soon as you have done this, use the temporary admin account to change the details on the original admin account, then delete the temporary account.
This is because:
- anyone could use that account to log in to your board if you didn’t change the password.
- this temporary user has not been fully set up (e.g. it is not a member of the “Registered users” group, so it won’t have normal access to your forums).
To remove the account you will first need to remove “founder” status from it: ACP> Users and groups> Manage Users> Admin1> Overview> Founder = No