Title: Admin capabilities lost! Help!
Last modified: December 23, 2023

---

# Admin capabilities lost! Help!

 *  Resolved [Gerdski](https://wordpress.org/support/users/gerdski/)
 * (@gerdski)
 * [2 years, 5 months ago](https://wordpress.org/support/topic/admin-capabilities-lost-help/)
 * Hi,
 * we have installed the plugin and something went wrong when trying to copy the
   administrator role (to edit it later). Since then login as admin is not possible,
   we arrive at a shop admin page and have no access to the dashboard.
 * I’ve found this:
   [https://wordpress.org/support/topic/ive-lost-my-administrator-role/](https://wordpress.org/support/topic/ive-lost-my-administrator-role/)
 * and later it says 
   “`select * from wp_options where option_name='wp_backup_user_roles';`”
   and “`select * from wp_options where option_name='wp_user_roles';`“
 * But in both cases we get no result from the SQL query.
 * The admin user has the capabilities ‘a:1:{s:13:”administrator”;b:1;}’
 * What to do now?
 * Can I manually add another Admin via SQL and give him the capabilities ‘a:1:{
   s:13:”administrator”;b:1;}’ and then he would have Dashboard access?
 * Thanks!

Viewing 2 replies - 1 through 2 (of 2 total)

 *  Plugin Author [Vladimir Garagulya](https://wordpress.org/support/users/shinephp/)
 * (@shinephp)
 * [2 years, 5 months ago](https://wordpress.org/support/topic/admin-capabilities-lost-help/#post-17300508)
 * wp_ in select commands above is the database prefix from wp-config.php file. 
   Look what real database prefix your site has in wp-config.php.
 * The detailed article on the subject is available here: [https://www.role-editor.com/restore-lost-wordpress-admin-permissions/](https://www.role-editor.com/restore-lost-wordpress-admin-permissions/)
    -  This reply was modified 2 years, 5 months ago by [Vladimir Garagulya](https://wordpress.org/support/users/shinephp/).
 *  Thread Starter [Gerdski](https://wordpress.org/support/users/gerdski/)
 * (@gerdski)
 * [2 years, 5 months ago](https://wordpress.org/support/topic/admin-capabilities-lost-help/#post-17301218)
 * Hi,
 * at last I could restore the old settings, replacing user_roles with backup_user_roles
   in the options table. Your support web site was right, it was me who used the
   wrong prefix.
 * Thanks!

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Admin capabilities lost! Help!’ is closed to new replies.

 * ![](https://ps.w.org/user-role-editor/assets/icon-256x256.jpg?rev=1020390)
 * [User Role Editor](https://wordpress.org/plugins/user-role-editor/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/user-role-editor/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/user-role-editor/)
 * [Active Topics](https://wordpress.org/support/plugin/user-role-editor/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/user-role-editor/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/user-role-editor/reviews/)

 * 2 replies
 * 2 participants
 * Last reply from: [Gerdski](https://wordpress.org/support/users/gerdski/)
 * Last activity: [2 years, 5 months ago](https://wordpress.org/support/topic/admin-capabilities-lost-help/#post-17301218)
 * Status: resolved