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
- What is the difference between an ORM and an ODM?
- Rename a table in MySQL
- How should I tackle –secure-file-priv in MySQL?
- Keeping WP database synced across multiple developers using git
- Setting $_SERVER[‘HTTPS’]=’on’ prevents access to wp-admin
- How To Export/Import WordPress (MySQL) Database Properly Via Command-Line?
- Is it possible to define two databases for one installation?
- Connect forms in WP to external database
- Hook into $wpdb
- Is it wise to delete post revisions and autosaves from database?
- Improve or optimize a very slow query
- Make “Post published. View post” Open in a New Tab
- “MySQL server has gone away” since update to 3.8
- Using two different DB users on one WP install
- Usage of Direct Database Call Without Caching Error
- How to add a column to the Trash page?
- Can I transfer a mysql database to another site?
- Add tabbed menu to admin page
- MySQL Syntax Error upon restoring database from backup [closed]
- Merge two databases: OLD SITE -> NEW SITE
- How to edit/delete single row items in a table on my own menu page
- Backup another database with BackUpWordPress plugin [closed]
- Easiest Way to Authenticate WP Users Using an External DB?
- How to check if a core update, like 4.9.8 → 5.0, involves a database update (migration)?
- How do I find out the full path of a page’s template?
- I need to get an array from the wordpress database
- Moving minor updates between local and live sites – just database?
- what is the best way to store user created data?
- Fatal error: Exception thrown without a stack frame in Unknown on line 0
- Apply permissions per post
- “The link you followed has expired” & “Error while saving” messages when adding new post
- input data and output table [closed]
- Sending data with multi step form to wp database
- How to be able to edit custom address fields in WooCommerce admin?
- What are the requirements to make the admin toolbar show up on the front end
- WordPress and user security
- WP admin broken. Not saving catgories or adding categories to menu
- Lost administrator privileges and can’t find a fix
- Migrating from PDO using SQLite to clean new install using MySQL
- Change WordPress URL in sql file via Terminal
- $wpdb->insert Giving duplicates
- Where is phpMyAdmin inside WordPress?
- How to properly check if a table exists in WordPress Database using Show Tables Query
- How to delete database without using any plugin?
- Delete/Replace words from X to Y in post content
- Location of image metadata on my server
- How to create more than one new wpdb object?
- Admin user lacks admin permissions after hack and can’t reinstate
- Multiple WordPress sites installs sharing the same database but with different content and domains
- Remote database -> massive response time increase?
- “sufficient permissions” error for admin after duplicating WP database to new install
- Database tables for sports betting integrated in WordPress
- How can I put content before my custom post type default pages?
- How we can create menu from Appearance > Menu and use as a add-submenu-page for admin menu?
- How to edit custom table data in frontend
- Unable to login to a https website via the app after changing from http
- mysqli_query(): MySQL server has gone away for Curl Request
- WP website showing blank page after moving from subdomain to main domain
- create a table using user meta custom data
- WPCLI search and replace in a particlar site dir effect another site-dir
- How to create a database table?
- Trying to list user and post information from (wp_includes/post.php ) causes Fatal error
- Database error after importing WordPress
- Send data to database after redirect (and popping out of iframe)
- Pulling values from a sepcific row in table
- import (migration) user database to wp-users
- Create hundreds of users with just ID in phpMyAdmin
- What is best for saving lot of extra detail of user?
- Insert Extra fields added in the front end registration form to DB
- Making plugin to use different table prefix cause permission problem
- How to create a table [closed]
- Query a meta key using an array of values where the database value is a string