Making someone a WordPress administrator using PhpMyAdmin

admin管理员组

文章数量:1426224

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 ?

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 ?

• phpmyadmin

Share Improve this question edited Sep 7, 2012 at 18:14 Ben HartLenn 2,4351818 silver badges1919 bronze badges asked Sep 7, 2012 at 12:27 drake035drake035 1,21777 gold badges3434 silver badges5757 bronze badges 5

• This is a hosting issue, not a WordPress Issue. – Eric Holmes Commented Sep 7, 2012 at 13:02
• I'm sorry but I sincerely don't understand your comment. – drake035 Commented Sep 7, 2012 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 Commented Sep 7, 2012 at 14:50
• 3 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 Commented Sep 7, 2012 at 17:42
• 6 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 ♦ Commented Sep 8, 2012 at 3:20

Add a comment  | 

2 Answers 2

Sorted by: Reset to default 23

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/Roles_and_Capabilities#User_Levels

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..)

本文标签： Making someone a WordPress administrator using PhpMyAdmin