Creating Admin user through phpMyAdmin

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Anti-Spam Guide
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Registered User
Posts: 6
Joined: Sat May 02, 2009 7:20 pm

Creating Admin user through phpMyAdmin

Post by nicksource »

Hi there,

I'm developing a site with PHPBB3 integration, rather simply:

What do I need to edit to create an Admin user in phpmyadmin?

I've tried editing the "usergroup" field in `users` and also adding them to the `acl_users` table but no luck?


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

Re: Creating Admin user through phpMyAdmin

Post by stevemaury »

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 not phpbb_.

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', '', 'en', 1, 1, 'AA0000', 1, '', '', '', '', '', 't', 'a', 't', 'd', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
For REALLY good and VERY inexpensive hosting CLICK HERE

I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)


Return to “[3.0.x] Support Forum”