Localhost install: Administrator lost administrator access; cannot access Dashboard

The {$table_prefix}user_roles entry in the options table must begin with the actual table prefix.

Your website was with a prefix of wp_ so the entry was called wp_user_roles. When modifying the table prefix you need to change it with the new one:

dzup_wp_user_roles

Hope it works !

Related Posts:

  1. Make sub menu items a main link in the admin menu using fuctions.php
  2. How do I set the homepage to the WordPress Admin Dashboard login?
  3. How to remove dashboard access (wp-admin) for author but not disable the capabilities?
  4. Admin top level menu, pointing to an external url
  5. Dashboard : remove Safari navigator message
  6. Is it possible to tell if a user is logged into WordPress from looking at the cookies which are set?
  7. How to make the Panel // WP-Admin lighter via Mobile
  8. Organizing Code in your WordPress Theme's functions.php File?
  9. Changing Admin Menu Labels
  10. Disable dragging of meta boxes?
  11. How to Change the Default Home Page for the WordPress Dashboard?
  12. How to remove screen options and help links in the admin area?
  13. Remove dashboard, use Pages tab as default
  14. Can an admin check passwords of registered users?
  15. Add “external” link to admin menu in the backend
  16. 3.3: How do you hide the new dashboard welcome panel?
  17. Only allow administrators and editors to access wp-admin
  18. How to remove items from +New admin menu?
  19. Appearance->Editor not visible
  20. How to disable or hide “collapse menu”
  21. Add column to pages table
  22. Dashboard links not working
  23. Can initial focus be set to search field in WordPress Media Library?
  24. wp-admin – save options without refreshing?
  25. Removing admin bar from wordpress dashboard
  26. How to display only logged in user’s post comments in comments area
  27. How to Change the Title of a Meta Box on a Specified Custom Post Type? [duplicate]
  28. How do you modify CSS files via admin panel?
  29. Can’t access dashboard, connection times out (other pages work fine)
  30. How to prevent parent admin page from appearring as a child admin page
  31. Custom Dashboard Home Screen Options
  32. wp-admin does not redirect to dashboard
  33. Cannot log into WordPress Dashboard after removing/adding .htaccess
  34. Custom WordPress Dashboard for Specific user role
  35. Change WP-Login or WP-Admin
  36. How to inhibit dashboard and profile management access to normal users?
  37. SSL Partially breaking admin panel and elementor
  38. Only allow administrators and editors to access wp-admin
  39. Show Welcome Panel on Dashboard for every user
  40. What is the practical difference between is_admin() and is_blog_admin()?
  41. Create a admin page in wordpress without admin menus (“wordpress sidebars”)
  42. How to hide wordpress default description box?
  43. Create a fullwidth dashboard widget
  44. Can’t access WordPress as an admin – but I can log in as a user!
  45. Locked Out Of WordPress Admin Dashboard After Server Move
  46. I want to disable login of admin (/wp-admin) with email and make it accessible only with username
  47. How to make the front-end RTL without changing the admin panel language?
  48. admin_post action not usable if admin access denied to user
  49. Restrict Author role to only 3 wp-admin pages
  50. Wp-admin is giving me an error “Sorry, you are not allowed to access this page.”. I do have access to the wp-admin besides the dashboard itself
  51. WP-Admin shows (1) update but there is no update for plugin, theme or WordPress
  52. What are the requirements to make the admin toolbar show up on the front end
  53. White screen of death in Dashboard after clean installation
  54. Remove bulk option row
  55. How can I replace dashboard.css and dashboard.min.css (not add new css)
  56. WP admin user search doesn’t return all users
  57. I can´t access my admin panel. I tried all possible solutions
  58. can not access wp-admin after migrating to openshift
  59. Lost administrator privileges and can’t find a fix
  60. Grabbing how Many Posts by Month for a Dashboard Widget
  61. How do you force the wordpress dashboard to be 1 coulmn by default?
  62. How to replace “Password Protected” text with icon in Admin
  63. always by default show welcome panel in the dashboard
  64. Hooks: admin_footer and admin_print_footer_scripts not working?
  65. What is the correct way to get only display plugin for Administrator Only
  66. Dashboard Widget CSS
  67. Browse Happy in 3.2
  68. How to break line / add to ADMIN menu
  69. How to Find The Email of a WP Admin Account
  70. how can I change the font on Edit Post area (admin dashboard)
  71. External HTTP API calls slowing down WordPress admin [closed]
  72. Outputting something based on the presence of post variable in admin screens
  73. Creating custom admin panel pages without making a plugin?
  74. Move WooCommerce menu entries to top of dashboard
  75. Available resources for learning WordPress 4.7.2 from the ground up?
  76. Is WordPress secure enough for a multi-user article directory?
  77. Uncaught SyntaxError: Unexpected Token Illegal
  78. Change maxlength of link_description in dashbord link section?
  79. define two login page url
  80. Trying to create a page as a menu item in the admin while keeping the admen panel visible
  81. Broken Customizer page
  82. Admin Page access
  83. I can’t access my wp admin dashboard
  84. How to logout the current user without notices and warnings?
  85. Step by step guide for new users on how to post content?
  86. Accessing wordpress tool in local MAMP Site
  87. How to create custom backend admin menu in different languages?
  88. restrict admin panel sections to users
  89. Failed to load resource: the server responded with a status of 431 ()
  90. Dashboard controls have all stopped working
  91. When installing wordpress through WP CLI mysite.com/admin not working
  92. Trying to list user and post information from (wp_includes/post.php ) causes Fatal error
  93. Getting 404s in wp-admin after logged in
  94. Unable to render Admin Notices
  95. Launch wordpress site to local computer from live website backed-up
  96. All of my WordPress sites have Bold Open Sans
  97. You do not have permission to access this document on form submit
  98. Why when I click on a link into the WP admin panel I am redirected to a link that doesn’t contains wp-admin prefix, so I obtain 404 error
  99. Override WordPress Core File?
  100. After Upgrade: $user becomes unknown (id: 0) after successful login?