Simply run the following query in phpMyAdmin;
UPDATE `mybb_users` SET `usergroup` = '4' WHERE `uid` = 'X';
Where X is the UserID of that user.