MyBB Community Forums

sorry I have a problem, since the super administrator has been converted into registered user now want to put administrator but says that I can not change it because super administrator. What can I do to ensure that becomes an administrator?

Run this SQL query in phpMyAdmin:

UPDATE mybb_users SET usergroup=4 WHERE uid='X'

You must change "X" to the user ID of the super admin you want to promote.

I have gone into mysqladmin and all i get when I try to run the query is:-

You have to choose at least one column to display