Adding prefix to WordPress database tables breaks admin capabilities?

In the $wpdb->prefix_usermeta table, there is a meta key called $wpdb->prefix_capabilities.

When users are created, the $prefix is hard-coded. You have to also edit the $prefix to the new one there.

So in your example

wp_capabilties becomes stx_capabilities. You must update it for all users.

Related Posts:

  1. MySQL Database User: Which Privileges are needed?
  2. Can’t update database after wordpress update from 3.8.1 to 4.4.1
  3. Where is custom template file chosen for a post stored in the DB?
  4. Add search Value to wp_list_table pagination
  5. Why are no posts showing despite my apparently correct DB restoration?
  6. SQL Query to Update Admin Email
  7. Two websites one database, administrator not working on second website
  8. Use mulitple usernames?
  9. Retrieve data from the database to table such as comments in the admin control panel
  10. Unable to Access WP Admin or Login buttons after Migration
  11. Is my way to change WordPress server is correct?
  12. Custom Post Type not showing anything added by code anymore?
  13. Wp-Admin FTPS Connection Error unlike Filezilla
  14. WordPress has been updated! Before we send you on your way, we have to update your database to the newest version
  15. WordPress site migration – locked out of admin area
  16. Editing the term_order field
  17. A WP dev site that displays content from a live site’s database but cannot write to wp_posts?
  18. WordPress users table missing indexes
  19. WordPress Migration – Issue with admin panel changes
  20. WordPress URL error for links
  21. Migrate not successful, DB is broken. How to fix, or at least output static HTML without plugins?
  22. Correct permissions for SQLite database
  23. How to change the publishing date of each posts?
  24. MySQL Database User: Which Privileges are needed?
  25. Recover Same WordPress Admin Password
  26. cannot access wp-admin after options table crash and repair
  27. Database Queries are crashing the server
  28. How to protect my credentials on my clients website
  29. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  30. How to remove admin menu pages inserted by plugins?
  31. Solution for database version control and deployment?
  32. How to Change the Default Home Page for the WordPress Dashboard?
  33. WordPress Database lost auto increment
  34. Count & Display Database Queries
  35. 3.3: How do you hide the new dashboard welcome panel?
  36. Slow wp_term_relationships query
  37. How to use “TRUNCATE TABLE” MySQL statement?
  38. Meta query interfering with orderby relevance
  39. Pagination Error on Admin (You do not have sufficient permissions)
  40. Strange Deadlock database error for the query “Delete From wp_options”
  41. WooCommerce – Query for ordered products
  42. PHP variable in WordPress database query
  43. Differences between add_post_meta and update_post_meta
  44. WordPress User Roles, Custom Post Types, and Admin views
  45. Is a direct or import approach safer for migration into WordPress?
  46. How can I restrict a user to a specific item in the WordPress Admin? [closed]
  47. How to disable automatic excerpt generation *in admin*?
  48. Select Multiple meta_value from WP DB; Single Query
  49. One post carries 30 postmeta values, is this too much?
  50. Associating custom submenu item with post type of top level menu item
  51. Is it possible to split database tables using HyperDB?
  52. What happens if I overwrite the current wp_options table with a backup from a week ago?
  53. Critical error in final stage of website launch – URLs are BROKEN!
  54. How do I get WordPress login to ignore the password input if a particular username is used?
  55. Migrating WordPress from DreamHost to Azure WordPress Resource via UpdraftPlus “wp_options table does not exist…” error
  56. Taxonomies image
  57. How to Mirror WordPress database from Remote server to Local server
  58. How to add a custom-post-type post within another custom-post-type post edit screen using AJAX?
  59. WordPress is not creating table in database after activating plugin,
  60. How do I delete these post types in my WordPress database?
  61. How do I query wp_options for expired transient pairs with MySQL commands?
  62. data (html) migration to posts
  63. Change options table prefix only
  64. What’s the proper way to sanitize checkbox value sent to the database
  65. Problems with moving my WordPress site to another domain/server
  66. Is it important to have integers inserted using %d rather than %s?
  67. Export a custom Mysql database product catalog to WordPress
  68. Any risk to changing WP table col CHARACTER_MAXIMUM_LENGTH?
  69. Trouble running $wpdb->query() with last_insert_id
  70. Using $wpdb | checking entered email against existing emails in db
  71. wp-cli: Error establishing a database connection: undefined constant DB_USER
  72. Can I customised default WP table
  73. Woocommerce – Check product stock availability from external database
  74. Get results from wordpress data custom table
  75. Outputting query results
  76. Help With a Large WordPress Based MySQL Database on Shared Hosting
  77. Having problem creating local instance of wordpress site
  78. Database migration issues – Error #1046 No database selected
  79. Search Character Set Problem
  80. Custom user tables not working after migration
  81. How to get the full stack trace for WordPress “table doesn’t exist” error in debug.log?
  82. How to fix Uploaded to this post option to see group of images uploaded to a post?
  83. How to access a table in a wordpress database using REST API?
  84. User saved through WordPress backend does not show up in database table users
  85. When installing wordpress through WP CLI mysite.com/admin not working
  86. Missing latest posts and options after DB migration via phpMyAdmin
  87. get_the_terms is not working
  88. Restoring .sql backup results in “Error establishing a database connection”
  89. Link to handle $_GET request
  90. WordPress sync with phpbb
  91. Group Pages based on Parent in Admin Area
  92. “MySQL server has gone away” since update to 3.8
  93. How to remove menu from WP-Admin menu
  94. Getting deleted users in database
  95. plugin to upload to youtube via wordpress [closed]
  96. Options of accessing wordpress data from mobile app
  97. My Account Lost Administrator permission
  98. Getting data from a table using a query
  99. Database interaction (private-public) [closed]
  100. SQL Query to get post_id from wp_posts and and meta_key(s) from wp_postmeta