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. Administrator user cannot access dashboard after localwp import
  9. Organizing Code in your WordPress Theme's functions.php File?
  10. Changing Admin Menu Labels
  11. Admin Page Redirect
  12. Disable dragging of meta boxes?
  13. How to Change the Default Home Page for the WordPress Dashboard?
  14. How to remove screen options and help links in the admin area?
  15. Sort admin menu items
  16. Remove dashboard, use Pages tab as default
  17. Can an admin check passwords of registered users?
  18. Add “external” link to admin menu in the backend
  19. Custom column for changing post status via ajax
  20. 3.3: How do you hide the new dashboard welcome panel?
  21. Make fonts.com font work in TinyMCE (iframe referrer issue)
  22. How to display the user that published a pending post?
  23. How to remove the site health dashboard widget?
  24. Only allow administrators and editors to access wp-admin
  25. How to remove items from +New admin menu?
  26. Copy my user account’s wp-admin dashboard layout to other users?
  27. Appearance->Editor not visible
  28. How to disable or hide “collapse menu”
  29. Add column to pages table
  30. Admin account only shows Profile and Dashboard with no activity
  31. Dashboard links not working
  32. Can initial focus be set to search field in WordPress Media Library?
  33. Moving wordpress from localhost to server throws admin panel access error?
  34. wp-admin – save options without refreshing?
  35. Removing admin bar from wordpress dashboard
  36. How to display only logged in user’s post comments in comments area
  37. How to Change the Title of a Meta Box on a Specified Custom Post Type? [duplicate]
  38. How do you modify CSS files via admin panel?
  39. Can’t access dashboard, connection times out (other pages work fine)
  40. How to prevent parent admin page from appearring as a child admin page
  41. Custom Dashboard Home Screen Options
  42. wp-admin does not redirect to dashboard
  43. Cannot log into WordPress Dashboard after removing/adding .htaccess
  44. Custom WordPress Dashboard for Specific user role
  45. Change WP-Login or WP-Admin
  46. How to inhibit dashboard and profile management access to normal users?
  47. SSL Partially breaking admin panel and elementor
  48. Only allow administrators and editors to access wp-admin
  49. Show Welcome Panel on Dashboard for every user
  50. Prevent /wp-admin/ from redirecting to homepage?
  51. What is the practical difference between is_admin() and is_blog_admin()?
  52. Create a admin page in wordpress without admin menus (“wordpress sidebars”)
  53. How to hide wordpress default description box?
  54. Create a fullwidth dashboard widget
  55. Can’t access WordPress as an admin – but I can log in as a user!
  56. Locked Out Of WordPress Admin Dashboard After Server Move
  57. Redirect non-admin users away from wp-admin/index.php (main dashboard page) to wp-admin/profile.php
  58. I want to disable login of admin (/wp-admin) with email and make it accessible only with username
  59. Allow administrators to pick post author on custom post type edit screen
  60. How to make the front-end RTL without changing the admin panel language?
  61. admin_post action not usable if admin access denied to user
  62. Restrict Author role to only 3 wp-admin pages
  63. Add column to pages table
  64. 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
  65. WP-Admin shows (1) update but there is no update for plugin, theme or WordPress
  66. What are the requirements to make the admin toolbar show up on the front end
  67. White screen of death in Dashboard after clean installation
  68. Remove bulk option row
  69. How do I let logged out users see the dashboard?
  70. How can I replace dashboard.css and dashboard.min.css (not add new css)
  71. WP admin user search doesn’t return all users
  72. I can´t access my admin panel. I tried all possible solutions
  73. can not access wp-admin after migrating to openshift
  74. Lost administrator privileges and can’t find a fix
  75. Grabbing how Many Posts by Month for a Dashboard Widget
  76. How do you force the wordpress dashboard to be 1 coulmn by default?
  77. How to replace “Password Protected” text with icon in Admin
  78. always by default show welcome panel in the dashboard
  79. Deploying WordPress for clients – what do they have access to?
  80. Hooks: admin_footer and admin_print_footer_scripts not working?
  81. Can’t access wp-admin, redirects to http://%24domain/wp-admin/
  82. What is the correct way to get only display plugin for Administrator Only
  83. Dashboard Widget CSS
  84. Browse Happy in 3.2
  85. How to break line / add to ADMIN menu
  86. How to Find The Email of a WP Admin Account
  87. how can I change the font on Edit Post area (admin dashboard)
  88. External HTTP API calls slowing down WordPress admin [closed]
  89. Outputting something based on the presence of post variable in admin screens
  90. Creating custom admin panel pages without making a plugin?
  91. Move WooCommerce menu entries to top of dashboard
  92. Available resources for learning WordPress 4.7.2 from the ground up?
  93. Is WordPress secure enough for a multi-user article directory?
  94. Uncaught SyntaxError: Unexpected Token Illegal
  95. Change maxlength of link_description in dashbord link section?
  96. define two login page url
  97. Trying to create a page as a menu item in the admin while keeping the admen panel visible
  98. Newly created user role not displaying on users screen
  99. WordPress Admin extremely slow when other admin logged in
  100. Broken Customizer page
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)