This is pretty straight forward and this method is not preferred because, if you made the wrong modification, you might end up corrupting the database.  I would recommend you use the AdminCP to handle all vBulletin Administration and only use this method if you can’t get into AdminCP but have full access to the Database.

  • Login to phpMyAdmin and select the Database option…
  • Click on the table vb3_usergroup and Browse it.
  • Check which usergroupid represents Administrators (It is normally 6).
  • Now, Click on the table vb3_user  and Browse it.
  • Tick the User and Edit it, It will take you to another page…
  • Change the usergroupid 6 and Apply is by Clicking Go.

That’s it, You might need to add the userid to config.php to give the user Super Admin functions…

Popularity: 53% [?]