Making someone a WordPress administrator using PhpMyAdmin

Question

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 ?

Answer 1

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

Answer 2

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