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:
- MySQL Database User: Which Privileges are needed?
- Can’t update database after wordpress update from 3.8.1 to 4.4.1
- Where is custom template file chosen for a post stored in the DB?
- Add search Value to wp_list_table pagination
- Why are no posts showing despite my apparently correct DB restoration?
- SQL Query to Update Admin Email
- Two websites one database, administrator not working on second website
- Use mulitple usernames?
- Retrieve data from the database to table such as comments in the admin control panel
- Unable to Access WP Admin or Login buttons after Migration
- Is my way to change WordPress server is correct?
- Custom Post Type not showing anything added by code anymore?
- Wp-Admin FTPS Connection Error unlike Filezilla
- WordPress has been updated! Before we send you on your way, we have to update your database to the newest version
- WordPress site migration – locked out of admin area
- Editing the term_order field
- A WP dev site that displays content from a live site’s database but cannot write to wp_posts?
- WordPress users table missing indexes
- WordPress Migration – Issue with admin panel changes
- WordPress URL error for links
- Migrate not successful, DB is broken. How to fix, or at least output static HTML without plugins?
- Correct permissions for SQLite database
- How to change the publishing date of each posts?
- MySQL Database User: Which Privileges are needed?
- Recover Same WordPress Admin Password
- cannot access wp-admin after options table crash and repair
- Database Queries are crashing the server
- How to protect my credentials on my clients website
- WordPress Admin login problems- PLEASE HELP [closed]
- What is an ORM, how does it work, and how should I use one? [closed]
- What is the difference between an ORM and an ODM?
- What is this JavaScript “require”?
- Rename a table in MySQL
- How should I tackle –secure-file-priv in MySQL?
- What is this JavaScript “require”?
- What is “Advanced” SQL?
- What’s the difference between identifying and non-identifying relationships?
- Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
- Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
- Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
- What are the differences between B trees and B+ trees?
- MySQL SELECT increment counter
- How to resolve ORA-011033: ORACLE initialization or shutdown in progress
- Example of a strong and weak entity types
- Oracle SQL query for Date format
- phpMyAdmin – Error > Incorrect format parameter?
- Strange Characters in database text: Ã, Ã, ¢, â‚ €,
- Difference between partition key, composite key and clustering key in Cassandra?
- How SID is different from Service name in Oracle tnsnames.ora
- What is a relation in database terminology?
- Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)
- Database vs File system storage
- Can I have multiple primary keys in a single table?
- Exclude Statement in SQL
- How do you query for “is not null” in Mongo?
- What is a file based database?
- Is it fine to have foreign key as primary key?
- Storing Images in DB – Yea or Nay?
- You require permission from “Myself” to delete folder – how to fix
- Organizing Code in your WordPress Theme's functions.php File?
- Using wpdb to connect to a separate database
- how to Optimize WordPress database for 10 million post? [duplicate]
- What are the standard admin CSS id/class tags?
- How to remove admin menu pages inserted by plugins?
- Why is my database import losing text widget data?
- Database synchronization between dev/staging and production
- Keeping WP database synced across multiple developers using git
- Changing the Order of Admin Menu Sections?
- WPDB Insert or if exists Update
- Multiple developers / editors working on a site in progress
- How can I make updates to a site, on a development copy, but then move updates back without overriding live site’s evolving database?
- Modal window from within WordPress admin
- Placing a Custom Post Type Menu Above the Posts Menu Using menu_position?
- Admin Page Redirect
- Disable dragging of meta boxes?
- Setting $_SERVER[‘HTTPS’]=’on’ prevents access to wp-admin
- get_results using wpdb
- Will it break my site if I delete all transient records in wp_options table?
- Checking if Database Table exists
- Why WordPress choose data serialization over json_encode?
- Loading External Scripts in Admin but ONLY for a Specific Post Type?
- What’s the simplest way to backup my WordPress database?
- WordPress (MyISAM) database is slow, should I switch to InnoDB?
- $wpdb won’t insert NULL into table column
- Relaunch 4.2 utf8mb4 database upgrade
- Fastest way (least amount of steps) to locally import a remote database using WP-CLI
- Safest way to bulk delete post revisions
- Please explain how WordPress works with MySQL character set and collation at a low level
- Solution for database version control and deployment?
- The MySQL alternatives: Do Percona Server and MariaDB work well with WordPress, and do they make WordPress go better?
- How many users can WordPress handle?
- Get error messages when $wpdb->insert() returns false?
- How to Add a Third Level Sub Menu to the WordPress Admin Menu
- Detecting errors generated by $wpdb->get_results()
- How to Change the Default Home Page for the WordPress Dashboard?
- Staging sites, how do you manage synchronising updates in the DB?
- How To Remove WordPress Version From The Admin Footer
- Does dbDelta delete columns as well?
- How to get the post publish date outside the loop?
- MariaDB as a backend database