WordPress Development Stack Exchange is a question and answer site for WordPress developers and administrators. 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

After database problems on my provider side, I had to reset my admin user password. But then this user was not an admin anymore. In PhpMyAdmin I see that it has a user_status value of 0. How can I make this user an amin in WP dashboard ?

share|improve this question
This is a hosting issue, not a WordPress Issue. – Eric Holmes Sep 7 '12 at 13:02
I'm sorry but I sincerely don't understand your comment. – drake035 Sep 7 '12 at 13:28
@drake035 His comment means that this has nothing to do with WordPress and should not be asked on this website. This question should be moved to another of the stackexchange sites, where it can be answered. We know WordPress around here, we have no special knowledge of PHPMyAdmin or MySQL or general hosting questions. – Otto Sep 7 '12 at 14:50
I think the question may have been worded a little off but I would say it's definitely a Wordpress-specific question as it's about the organization of the Wordpress user tables. – hereswhatidid Sep 7 '12 at 17:42
How WordPress roles are stored in the database is very WordPress specific. I don’t see how anyone could give an answer without WordPress knowledge. – toscho Sep 8 '12 at 3:20
up vote 2 down vote accepted

You actually want to look in the wp_usermeta table. Once in there, look for the entry that has 'wp_user_level' in it's 'meta_key' column and has the matching 'user_id' that you would like to update. Then change that 'meta_value' to 9 or 10.

EDIT: updated link to current documentation:


share|improve this answer
It worked thx !! (I'm still struggling with understanding how my question and your answer to it have « nothing to do with WordPress » ...) – drake035 Sep 7 '12 at 17:20
Note at the top: "This article, written to accord with WordPress 1.5, is now obsolete." Roles and capabilities now codex.wordpress.org/Roles_and_Capabilities – chrisguitarguy Sep 7 '12 at 18:27
Thanks, I missed that part. I've updated my answer to point to the correct user info page. – hereswhatidid Sep 7 '12 at 18:29
I think it is also required to update the 'wp_capabilities' meta_key value to 'a:1:{s:13:"administrator";s:1:"1";}' – shasi kanth Jun 19 '15 at 11:45

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.