Adam D wrote:Took me a little bit to figure out exactly how to run that query
Since you were already messing around in the database I assumed you knew how to at least run a query. You shouldn't make any changes directly to the database unless you know precisely what you are doing and the ramifications, because you can do serious damage to the board.
Provided you are using the username Adam
and the email address is correct then the I forgot my password function should work.
If not, you can use this 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. Change your table prefix if it is not phpbb_.
- 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_from, user_icq, user_aim, user_yim, user_msnm, user_jabber, user_website, user_occ, user_interests, user_actkey, user_newpasswd) VALUES (3, 5, 'Admin1', 'admin1', 0, '21232f297a57a5a743894a0e4a801fc3', 'email@example.com', 'en', 1, 1, 'AA0000', 1, '', '', '', '', '', 't', 'a', 't', 'd', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
As soon as you have done this, use the temporary admin account to update 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).