[wp-hackers] How do I reset all roles and capabilities?
blogger at steffensenfamily.com
Tue Nov 13 17:29:59 GMT 2007
Try this using phpmyadmin:
1. Go to your WordPress database.
2. Select the wp_usermeta table.
3. Click on "Browse" at the top of the right-hand panel.
4. For each user (login username = nickname in this table), you'll have a
wp_capabilities row. Click on the pencil in that row to enter edit mode.
5. Replace the contents of the meta_value with
This will reset that user to purely an administrator.
6. In wp_options, do the same thing to "active_plugins", resetting it to
This will deactivate all of your plugins, including Role Manager, and should
let you login.
On 11/11/07, Viper007Bond <wplists at viper007bond.com> wrote:
> By stupidly screwing around with the Role Manager plugins over the years
> (renaming roles, creating custom roles for others, etc.), I've slowly
> one of my sites and finally sealed the deal a few minutes ago by
> locking myself out of my blog when I tried to rename my current role.
> Is there any way (or plugin) to reset all roles and capabilities to as if
> had just installed WordPress? I can deal with everyone getting the
> Administrator role or whatever as I can move them back to editors.
> I'm thinking I do a fresh install of WordPress can copy over the row in
> options table that lists the roles and then copying over the usermeta row
> for capabilities, but I'm a bit of a noob when it comes to roles and caps,
> so suggestions welcome.
> Viper007Bond | http://www.viper007bond.com/
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
More information about the wp-hackers