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?
Users browsing this forum: No registered users and 22 guests