4

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 ?

  • 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
  • 1
    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
  • 2
    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. – fuxia Sep 8 '12 at 3:20
6

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.

It is also required to update the 'wp_capabilities' meta_key value to 'a:1:{s:13:"administrator";s:1:"1";}'

Link to current documentation:

http://codex.wordpress.org/Roles_and_Capabilities#User_Levels

  • 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
1
  1. Get access with phpMyAdmin to your WordPress database.

  2. In phpMyAdmin, click on the tab "SQL" in the top tab bar.

  3. Enter this SQL command (with your actual WordPress username instead of your_username) and click "Go" to execute it:

    SELECT meta_value FROM wp_usermeta 
    WHERE meta_key = "wp_user_level" AND user_id = (
      SELECT user_id FROM wp_usermeta 
      WHERE meta_key = "nickname" AND meta_value = "your_username"
    )
    
  4. You will see a single-cell table with a meta_value column. Double-click that cell and change its value to 10.

  5. Again click the SQL tab, enter this SQL command (with your username instead of username) and click "Go" to execute it:

    SELECT meta_value FROM wp_usermeta 
    WHERE meta_key = "wp_capabilities" AND user_id = (
      SELECT user_id FROM wp_usermeta 
      WHERE meta_key = "nickname" AND meta_value = "your_username"
    )
    
  6. Again you will see a single-cell table with a meta_value column. Double-click that cell and change its value to a:1:{s:13:"administrator";b:1;}.

(There is a more automated way with SQL UPDATE commands instead of the above. Welcome to add it. However, sometimes only executing SELECTs and doing the updates manually will feel safer … no strict need for a database backup etc..)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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