Page 1 of 2

Forgot admin password, please help

Posted: Mon Feb 02, 2015 8:46 pm
by djorlando
Hi. I forgot the admin password and i tried changing manually the encrypted pw from phpmyadmin but is not working. I tried even to run a query that creates a temporary admin account taken from here: viewtopic.php?f=46&t=2145919 ..Not working either , does not create the user inside phpbb_users table. And yes the class prefix is phpbb_ .Thank you.

Re: Forgot admin password, please help

Posted: Mon Feb 02, 2015 8:47 pm
by KevC
Why not click the 'I forgot my password' link?

Re: Forgot admin password, please help

Posted: Mon Feb 02, 2015 9:12 pm
by djorlando
i did but i have problems with my server email system also :( .Any other method please?

Re: Forgot admin password, please help

Posted: Mon Feb 02, 2015 9:24 pm
by KevC
Register a new account.
In the users table of the database, make the user_type 3
Open the board’s /cache folder on the server and delete everything except index.htm and .htaccess.

You should be ale to log in with that account and reset your own password.

Re: Forgot admin password, please help

Posted: Mon Feb 02, 2015 9:49 pm
by djorlando
Ok, i will. But why this query does not work on phpbb 3.1 also?

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', 'admin@yourdomain.com', 'en', 1, 1, 'AA0000', 1, '', '', '', '', '', 't', 'a', 't', 'd', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
And also every change i make inside phpbb_users table like password or email ,is like they are not updated at all ( i have deleted the cache files also after every change )

Re: Forgot admin password, please help

Posted: Mon Feb 02, 2015 9:51 pm
by Lumpy Burgertushie
because the files in 3.1 are different from 3.0
very little from 3.0 will work with 3.1


robert

Re: Forgot admin password, please help

Posted: Mon Feb 02, 2015 9:52 pm
by djorlando
Then can you please tell me a similar sql query like the one above for 3.1 ?

Re: Forgot admin password, please help

Posted: Mon Feb 02, 2015 9:59 pm
by Oyabun1

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', 'admin@example.com', 'en', 1, 1, 'AA0000', 1, '', '', '', '', '', 't', 'a', 't', 'd', '', '', '', '', '', '');
djkomi wrote:And also every change i make inside phpbb_users table like password or email ,is like they are not updated at all ( i have deleted the cache files also after every change )
Don't change data directly in the database unless you know what you are doing and understand the ramifications. User passwords are not stored in the database only a salted hash of them is. There are controls in the ACP and UCP for properly changing user passwords and email addresses.

Re: Forgot admin password, please help

Posted: Mon Feb 02, 2015 10:03 pm
by Lumpy Burgertushie
this should work:

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', 'admin@yourdomain.com', 'en', 1, 1, 'AA0000', 1, '', '', '', '', '', 't', 'a', 't', 'd', '', '', '', '', '', '');

Re: Forgot admin password, please help

Posted: Mon Feb 02, 2015 10:22 pm
by djorlando
Great ,sql created..but now it says wrong password/user.
What are exactly the username and password? i tried username: Admin1 password: admin

Re: Forgot admin password, please help

Posted: Mon Feb 02, 2015 10:24 pm
by Lumpy Burgertushie
did you check to see if your table prefix is phpbb_

are you accessing the correct datbase that your board is actually using?

robert

Re: Forgot admin password, please help

Posted: Mon Feb 02, 2015 10:25 pm
by david63
Password is admin1

Re: Forgot admin password, please help

Posted: Mon Feb 02, 2015 10:28 pm
by Lumpy Burgertushie
david63 wrote:Password is admin1
not in the query I posted above. it is supposed to be admin

OP, remember, the password is case sensitive. admin is correct. Admin is not.


robert

Re: Forgot admin password, please help

Posted: Mon Feb 02, 2015 10:33 pm
by djorlando
Thanks a lot for your great help guys, is ok now. Yes the password is admin .It was because of the cache files,soon as i have deleted them was ok.

Re: Forgot admin password, please help

Posted: Mon Feb 02, 2015 11:19 pm
by Lumpy Burgertushie
be sure to change the password for that account or simply delete it once you get your main admin account working properly.

if you do NOT at least change the password from admin to something else, anyone reading this will be able to log into your board as admin.

don't want that.

robert