Lost administrator privileges and can’t find a fix

For anyone else running into a similar issue with Azure Cloud hosting and ClearDB … read below (even though this is very specific to my site and db config):

Fixed the issue. This was a database specific issue with Azure and ClearDB and not pointing to the correct database. I was using a free version of the ClearDB MySQL (20MB, up to 4 connections). Upgraded to the next paid version (1GB, up to 16 connections), but even though I was pointing to the new database tables were the old ones.

For the free version, ClearDB removes admin privileges when you reach the 20MB limit (which I did). That’s why I couldn’t save, publish or do anything a regular admin can do.

Fixing the database tables and making sure the site is pointing to the upgraded one fixed my issue.

Related Posts:

  1. Only allow administrators and editors to access wp-admin
  2. Moving wordpress from localhost to server throws admin panel access error?
  3. WP Database Error (Windows Server 2008 & SQL Server)
  4. js Conflict in admin panel – I guess it’s from the core WP installation
  5. How to inhibit dashboard and profile management access to normal users?
  6. Only allow administrators and editors to access wp-admin
  7. Can’t access WordPress as an admin – but I can log in as a user!
  8. Redirect non-admin users away from wp-admin/index.php (main dashboard page) to wp-admin/profile.php
  9. admin_post action not usable if admin access denied to user
  10. Restrict Author role to only 3 wp-admin pages
  11. I can´t access my admin panel. I tried all possible solutions
  12. How to remove dashboard access (wp-admin) for author but not disable the capabilities?
  13. Deploying WordPress for clients – what do they have access to?
  14. Removing Dashboard Menu Items Through The Database
  15. How to Find The Email of a WP Admin Account
  16. Is WordPress secure enough for a multi-user article directory?
  17. define two login page url
  18. Admin Page access
  19. Not able to access WP Admin, it says “Sorry, you are not allowed to access this page.”
  20. How to logout the current user without notices and warnings?
  21. restrict admin panel sections to users
  22. Localhost install: Administrator lost administrator access; cannot access Dashboard
  23. WordPress blog fails to open
  24. Is it possible to tell if a user is logged into WordPress from looking at the cookies which are set?
  25. After Upgrade: $user becomes unknown (id: 0) after successful login?
  26. Adding custom columns to custom post types
  27. Adding Fields to the Category, Tag and Custom Taxonomy Edit Screen in the WordPress Admin?
  28. When moving a WP site, why does wp-admin redirect to old site?
  29. do_shortcode() within Admin Page
  30. .htaccess in wp-admin produces a redirect loop
  31. How to Remove All Admin Bar Menu Items?
  32. Edit specific nodes in WP_Admin_Bar
  33. Filter Custom Post Type in Admin
  34. Using the loop inside admin
  35. Easiest way to make post private by default
  36. How can I make my Admin Icon SVG color correctly? [closed]
  37. Is there any filter to disable the total fronted in WordPress
  38. How to wrap admin menus and menu headers in additional divs without modifying the WordPress core?
  39. Display sortable User meta column in admin panel user’s page
  40. How to display only logged in user’s post comments in comments area
  41. Hooking into register_admin_color_schemes
  42. Which actions can update/change .php files?
  43. Blank page for edit.php
  44. Upload media file problem
  45. comment_form – show all fields when logged in
  46. How to change how long items are kept in the trash?
  47. Custom role based users are not able to access wp-admin
  48. How can I add ‘view mode’ to screen options for pages and cpts?
  49. Using List Table Filters for ALL Custom Post Types
  50. In the WordPress admin, how can I find out which page (themes.php, widgets.php, etc.) I’m on?
  51. My wp-admin stops working suddenly
  52. What is the practical difference between is_admin() and is_blog_admin()?
  53. How do I set the homepage to the WordPress Admin Dashboard login?
  54. Today, without warning, all admin panel logins redirect to home page after login. non-admin users logins work well
  55. Reusable content block
  56. What is wrong with this code to remove wp admin bar from one page
  57. Stopping user deletion from running on error
  58. Admin search not working for any type of post
  59. Adding Custom Capabilites
  60. Display checked in checkbox theme admin page when reloaded
  61. Why is unfiltered_upload not working despite being enabled?
  62. List All Enqueued Scripts and Styles
  63. Can I add my own profile.php?
  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. Custom Admin Pagination links
  66. Have different site location for wp-admin in IIS
  67. 100+ terms in any taxonomy slows down post updates?
  68. Is WordPress Suitable for my site?
  69. Disable or lock parent pages from being edited in wordpress admin
  70. How login is possible, if I deny login page via .htaccess with allow ip
  71. Unable to display WordPress admin bar in the frontend as an admin
  72. how can I change the font on Edit Post area (admin dashboard)
  73. External HTTP API calls slowing down WordPress admin [closed]
  74. how can provide access to wp_admin page for non wp_users?
  75. Why is my ‘export’ option missing?
  76. jQuery UI Datepicker error
  77. Can’t connect to WP-Admin, blank error message
  78. Custom Post Type not showing anything added by code anymore?
  79. WordPress /wp-admin redirect to wrong port in docker
  80. How do I fix the 403 error for wp-admin/admin-ajax.php?
  81. Strange Popup Ad on my WordPress Admin Dashboard
  82. WordPress switch domains
  83. Trying to list user and post information from (wp_includes/post.php ) causes Fatal error
  84. Unable to Add User after Site Migration
  85. Get Post ID in Admin Edit screen otherwise generate it?
  86. Cannot login in WordPress even after changing hash password in phpmyadmin
  87. WordPress User profile page fields missing
  88. Trying to use and understand JSON API and get_posts
  89. Creating your own options-general.php page
  90. I want to know if it’s good for SEO [closed]
  91. My website’s wp-admin redirects to another website’s wp-admin after pointing the site url to a subdirectiory
  92. Help please i cant login to wordpress panel [closed]
  93. Extend user search in the Wp backend area on the users.php page to allow for searching by email domain and role from the “users search” input box
  94. Cannot Access wp-admin
  95. wp-admin is opening but the site isn’t opening
  96. Can’t Access Wp-admin Login Page I get 500 error
  97. Unable to login or reset password via wp-admin
  98. Display Custom Text if date_picker date is expired
  99. admin showing Array() after adding exit() code
  100. How to prevent a user from updating other users in WordPress?