Problem Description
- I can successfully login to WordPress with my username and password at the /wp-admin URL
- Once logged in, attempting to access the WordPress dashboard simply redirects me back to the homepage
- The admin bar is showing, but it's missing a bunch of options
- I can see administrator capabilities showing in the wp_usermeta database table for my user
- I'm 100% positive that I'm supposed to have administrator capabilities
Problem Resolution
This occurs when you have (at some point) changed the database prefix using a utility that also altered capability records in the database.
To repair it, make note of your current database prefix. The default is 'wp_' and for simplicity we're going to assume the target prefix is 'wp_'. If the database prefix you wish to use is different, make sure to replace all instances of 'wp_' with your new prefix.
Use phpMyAdmin in Plesk for the database and complete these searches (using LIKE %...%):
- In the wp_options table, look for the option_name that ends with "user_roles" and change its prefix so it reads "wp_user_roles"
- In the wp_usermeta table, look for all entries that begin with the wrong prefix and replace the incorrect prefix with wp_
Now login or refresh the page and you should find your user permissions have returned.
