[TUT]Change Member Group in MYSQL

[Lease]

Remember to always back up first!

Problem: You need to move your account back into the root admin position, but you are locked out of the admin cp by accident.

Solution: Open phpMyAdmin or somthing similar. Run the query:

UPDATE ibf_members SET mgroup = X WHERE id = Y LIMIT 1

You need to change the variables X and Y
X -> The member group to move to. Root admin default is 4, but you may have changed it.
Y -> Your member ID. Find it by browsing ibf_members or by going to your profile on your forum and looking at the number where it says showuser=*

You can also use this approach to mass move groups.

UPDATE ibf_members SET mgroup = X WHERE mgroup = Y

X -> The member group to move to.
Y -> The old member group
* this idea from yellow_spider

Lease Reviewed by Lease on 13th Jan 2008. [TUT]Change Member Group in MYSQL Remember to always back up first! Problem: You need to move your account back into the root admin position, but you are locked out of the admin cp by accident. Solution: Open phpMyAdmin or somthing similar. Run the query: UPDATE ibf_members SET mgroup = X WHERE id = Y LIMIT 1 You need to change the variables X and Y X -> The member group to move to. Root admin default is 4, but you may have changed it. Y -> Your member ID. Find it by browsing ibf_members or by going to your Rating: 5