How to create new admin accounts via phpMyAdmin (phpBB) - Webmaster

George

Hello,

This has happened to me before while modifying/editing things, and is very handy if you lock yourself out of the admin panel or forget your password.

You will need:

25g whole wheat flour
An egg :cool:

Just kidding :P

1: Login to your cPanel and go to phpMyAdmin

2: Click the SQL tab.
http://www.cmxmods.net/images/mod_team/phpmyadmin_1.JPG

3: Copy and paste the following query into the box titled "Run SQL
query/queries on database".

    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', 'admin@yourdomain&#46;com', 'en', 1, 1, 'AA0000', 1, '', '', '', '', '', 't', 'a', 't', 'd', '', '', '', '', '', '', '', '', '', '', '', '', '', '');

You should then end up with something like this, this means it was sucessful, please note, yours won't be the same as this because the query shown below wasn't for the guide took above.
http://www.cmxmods.net/images/mod_team/phpmyadmin_3.JPG
Now go to your forum and try to login using the following details:

Username: admin1
Password: admin

Make sure you change the password after.

More tutorials & Guides Coming Soon!

Regards,
George, Firewire-Security Staff.

Xin

Nice tutorial George thanks! :D, i need to speak to ya get on msn ;).

Howdy, Stranger!

Top Posters

Who's Online (0)