How to Recover a Lost Administrator Account
Have you locked yourself out of the WordPress admin area by using the PublishPress Capabilities plugin?
Don't worry, the PublishPress Capabilities plugin stores a backup of WordPress role definitions. You can use this recover access to your site.
Those who are comfortable using phpMyAdmin or another database query tool can do the following:
- Locate the wp_options table, where “wp_” is your customized database prefix.
- Search for option_name LIKE ‘capsman_backup%’
- Use capsman_backup if available, otherwise capsman_backup_initial. Ensure that you are seeing the entire option_value of this row (not just a snippet of it ending in “…”. In phpMyAdmin, click in to “Edit” the row to see the entire option_value.
- In another window, search for option_name LIKE ‘%user_roles’
- Update this wp_user_roles record with the option_value from the capsman_backup row. In phpMyAdmin, this can be done with the “edit” link. Be sure to clear the entire option_value entry box before pasting in the capsman_backup value.
For future versions, we will also apply role editing safeguards to make it impossible for the Administrator role to be locked out.