Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have inherited a broken phpBB installation. It has posts and forums, but the user table is a mess.

I need to know what columns I can change in which tables to give myself full administrator privileges so that I can start using the web interface to make appropriate changes to the user table.

So far I have tried

  user_permissions = 'a_'
  username LIKE ''

But when I log in I still cannot see any of the forums and there's no options on the phpBB web page to make changes.

How do I give myself full administrator privileges?phpBB

share|improve this question

closed as off topic by BinaryMisfit Mar 5 '10 at 13:37

Questions on Super User are expected to relate to computer software or computer hardware within the scope defined by the community. Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope. Read more about reopening questions here.If this question can be reworded to fit the rules in the help center, please edit the question.

I respect the moderator's decision to close the question, however I would argue that this is software related. It is not programming related and therefore does not belong on It is almost operations relation and could belong on serverfaultcom but I decided this was more of a super problem. Anyway. I found the answer I needed and it is now searchable should any one else have the same problem in the future and need to know the answer. – PP. Mar 7 '10 at 15:12
up vote 3 down vote accepted

Okay I had to do the following:

  user_permissions = ''
  ,user_type = '3'
  ,group_id = '5'
  username LIKE ''

Now I have access to the administrator control panel.

share|improve this answer

Not the answer you're looking for? Browse other questions tagged .