Unable to login admin account

Get help with installation and running phpBB 3.2.x here. Please do not post bug reports, feature requests, or extension related questions here.
Post Reply
lalit1983
Registered User
Posts: 15
Joined: Wed Oct 04, 2017 10:14 am

Unable to login admin account

Post by lalit1983 » Tue Feb 13, 2018 6:35 am

admin.png
please give any solution for change password from phpmyadmin

Thanks

User avatar
kinerity
Community Team Member
Community Team Member
Posts: 1757
Joined: Mon Sep 01, 2014 1:00 am
Location: sudo rm -rf /
Name: Kailey Truscott
Contact:

Re: Unable to login admin account

Post by kinerity » Tue Feb 13, 2018 6:41 am

You are using a one-click installer. Try installing the files directly from the download available here.
Kailey Truscott - Community Team

lalit1983
Registered User
Posts: 15
Joined: Wed Oct 04, 2017 10:14 am

Re: Unable to login admin account

Post by lalit1983 » Tue Feb 13, 2018 6:49 am

is there not any option to change password
and if i install new setup
then all data and users will lost ??

Thanks

User avatar
kinerity
Community Team Member
Community Team Member
Posts: 1757
Joined: Mon Sep 01, 2014 1:00 am
Location: sudo rm -rf /
Name: Kailey Truscott
Contact:

Re: Unable to login admin account

Post by kinerity » Tue Feb 13, 2018 6:59 am

Not through modifying the database, no. All passwords are hashed. You can do a file replacement - Knowledge Base - Updating 3.2.x.
Kailey Truscott - Community Team

User avatar
RMcGirr83
Recognised Extension Developer
Posts: 20855
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr
Contact:

Re: Unable to login admin account

Post by RMcGirr83 » Tue Feb 13, 2018 10:52 am

kinerity wrote:
Tue Feb 13, 2018 6:59 am
Not through modifying the database, no. All passwords are hashed.
This is incorrect, the password can be changed in the database using an MD5 hash, the system will then salt the password on the next login.

You can use this tool to generate an MD5 hash of the password you want to use. Then simply copy /paste it into the password field for the user in the users table in the database.
In times of change, learners inherit the earth, while the learned find themselves beautifully equipped to deal with a world that no longer exists - Eric Hoffer
Former Modifications/Extensions Team Member | My extensions
Appreciate the extensions/mods/support then buy me a beer
All requests for support via PM will be ignored

lalit1983
Registered User
Posts: 15
Joined: Wed Oct 04, 2017 10:14 am

Re: Unable to login admin account

Post by lalit1983 » Tue Feb 13, 2018 1:37 pm

i try with http://www.miraclesalad.com/webtools/md5.php
but not get solution
also i install new setup and copy that password in myphpadmin
same unable to login

User avatar
KevC
Support Team Member
Support Team Member
Posts: 68152
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: Unable to login admin account

Post by KevC » Tue Feb 13, 2018 1:40 pm

In phpMyAdmin, run the following, 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', 'admin@example.com', 'en', 1, 1, 'AA0000', 1, '', '', '', '', '', 't', 'a', 't', 'd', '', '', '', '', '', '');
Change your table prefix if it is not phpbb_

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:
  1. anyone could use that account to log in to your board if you didn't change the password.
  2. 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 tab > Manage Users > Admin1 > Overview > Founder = No
-:|:- Support Request Template -:|:-
Image
Cheap UK Hosting
"In the land of the blind the little green bloke with no pupils is king - init!"

lalit1983
Registered User
Posts: 15
Joined: Wed Oct 04, 2017 10:14 am

Re: Unable to login admin account

Post by lalit1983 » Tue Feb 13, 2018 1:45 pm

can i make other user as founder in phpmyadmin
the user is admin (not founder)

lalit1983
Registered User
Posts: 15
Joined: Wed Oct 04, 2017 10:14 am

Re: Unable to login admin account

Post by lalit1983 » Tue Feb 13, 2018 2:26 pm

i have create a user admin1 login from admin1 is ok now
the after that login with admin1
i have change the password of admin
but after change password the admin user is not login now too

lalit1983
Registered User
Posts: 15
Joined: Wed Oct 04, 2017 10:14 am

Re: Unable to login admin account

Post by lalit1983 » Tue Feb 13, 2018 4:23 pm

KevC wrote:
Tue Feb 13, 2018 1:40 pm
In phpMyAdmin, run the following, 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', 'admin@example.com', 'en', 1, 1, 'AA0000', 1, '', '', '', '', '', 't', 'a', 't', 'd', '', '', '', '', '', '');
Change your table prefix if it is not phpbb_

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:
  1. anyone could use that account to log in to your board if you didn't change the password.
  2. 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 tab > Manage Users > Admin1 > Overview > Founder = No
Thanks it works
one more sir
i have changed user name email id and password for user created via SQL query
now i have change "admin" password but same not able to login with "admin"
please help sir

User avatar
RMcGirr83
Recognised Extension Developer
Posts: 20855
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr
Contact:

Re: Unable to login admin account

Post by RMcGirr83 » Tue Feb 13, 2018 5:13 pm

lalit1983 wrote:
Tue Feb 13, 2018 1:37 pm
i try with http://www.miraclesalad.com/webtools/md5.php
but not get solution
also i install new setup and copy that password in myphpadmin
same unable to login
I just did it and it worked fine on a 3.2.2 forum.
In times of change, learners inherit the earth, while the learned find themselves beautifully equipped to deal with a world that no longer exists - Eric Hoffer
Former Modifications/Extensions Team Member | My extensions
Appreciate the extensions/mods/support then buy me a beer
All requests for support via PM will be ignored

User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 49340
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: Unable to login admin account

Post by stevemaury » Tue Feb 13, 2018 8:02 pm

How did you change the admin password?
For REALLY good and VERY inexpensive hosting CLICK HERE

I can stop all your spam. PM or email me.

All unsolicited PMs will be ignored.

lalit1983
Registered User
Posts: 15
Joined: Wed Oct 04, 2017 10:14 am

Re: Unable to login admin account

Post by lalit1983 » Wed Feb 14, 2018 11:43 am

from SQL query i create a user that one is founder of site
and founder can change the password of admin
Attachments
phpbb.png

Post Reply

Return to “[3.2.x] Support Forum”