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', '', '', '', '', '', '');
Please fill out the Support Request Template and post it in a new topic of your own to enable us to assist you better.Clair wrote: ↑Sun Nov 19, 2017 10:40 amHi,
I've read this and understand it. I copied pitbul's query to gedit to look at it, but I cannot insert it into the SQL query window and am very unsure that I would be able to type all of that correctly.
If I have never logged into my newly install database as admin, can that query be shortened?
All I need is to reset user and pw to admin1 and admin as it says.
Only alternative is to delete phpBB and reinstall.
Can’t you copy and paste?