[wp-hackers] How do I reset all roles and capabilities?

[Stephen Rider]

You might first do this JUST for the admin user, then see if you can  
fix some things once you're logged back in.  I don't know how badly  
you hosed your tables, but the smaller step might save some hassle. :)

On Nov 11, 2007, at 12:03 AM, Matt wrote:

> You could probably just make a fresh install of WordPress  
> elsewhere, then
> copy over the row wp_user_roles in the table wp_options, and copy  
> over the
> rows wp_capabilities and wp_user_level for each user
>
> On Nov 10, 2007 9:16 PM, 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
>> broken
>> one of my sites and finally sealed the deal a few minutes ago by
>> completely
>> locking myself out of my blog when I tried to rename my current role.