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 HolmesSep 7, 2012 at 13:02
I'm sorry but I sincerely don't understand your comment.– drake035Sep 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.– OttoSep 7, 2012 at 14:50
3I 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.– hereswhatididSep 7, 2012 at 17:42
6How 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, 2012 at 3:20
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 '
Link to current documentation:
It worked thx !! (I'm still struggling with understanding how my question and your answer to it have « nothing to do with WordPress » ...)– drake035Sep 7, 2012 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 Sep 7, 2012 at 18:27
Thanks, I missed that part. I've updated my answer to point to the correct user info page. Sep 7, 2012 at 18:29
This was super helpful and worked to solve an issue my work was having with the "admin" user not actually being an admin and nobody having admin permissions to fix it. Mar 18, 2021 at 14:53
Get access with phpMyAdmin to your WordPress database.
In phpMyAdmin, click on the tab "SQL" in the top tab bar.
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" )
You will see a single-cell table with a
meta_valuecolumn. Double-click that cell and change its value to
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" )
Again you will see a single-cell table with a meta_value column. Double-click that cell and change its value to
(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..)