I use a file manager through the webhost
You should use a proper FTP client like Filezilla, host file managers are also fraught with danger.
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', '[email protected]', 'en', 1, 1, 'AA0000', 1, '', '', '', '', '', 't', 'a', 't', 'd', '', '', '', '', '', '');
phpbb_
I will keep this in mind if I lose access to my Administrator account again... How would I go about fixing the login problem?Mick wrote: ↑Sun Dec 09, 2018 9:50 am Registration is working and the password reset appears to be as well although I didn't actually reset my password.
You can try this:
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.Change your table prefix if it is notCode: 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', '[email protected]', 'en', 1, 1, 'AA0000', 1, '', '', '', '', '', 't', 'a', 't', 'd', '', '', '', '', '', '');
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: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
- 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).
You should use a proper FTP client like Filezilla, host file managers are also fraught with danger.
I have made some non googleable Q&A . I will now attempt to make the official Admin account so I can always log in/out if need be and access ACPMick wrote: ↑Sun Dec 09, 2018 9:56 amYou should use a proper FTP client like Filezilla, host file managers are also fraught with danger.
Math questions can be beaten by spam bots, you should use a non Googleable Q&A as I said before.
Registration is working and the password reset appears to be as well although I didn't actually reset my password.
Are you saying you're back in the ACP now, otherwise you can use the query to create the admin1 account to reset your existing admin credentials to sort out you're admin log in problems?
Mick wrote: ↑Sun Dec 09, 2018 9:50 amAs 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: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
- 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).
http://prntscr.com/lsmd67