How did you do the migration? Is the new site at a new web address? If so, did you use a tool like WP Migrate DB to search and replace any file paths or URLs that may now be different on the new site? If you’d like, please send a link that I could look at more carefully.
Here is the process I am running which is causing this issue on both of my Linux Environments.
1) I zip up my core files on the IIS Windows Server and move them over to the Linux run server.
2) I go into phpmyadmin and run a SQL Quick Export (or modified unchecking few fields).
3) I import the Database via phpmyadmin and or mysql workbench (i have fasthost account and linode)
4) I update the _options table with the new domain URL/IP
5) I remove themename in _options so I can log into the wp-admin
6) When logged in, I get just a blank admin bar and directing to wp-admin just gives me “You do not have sufficient permissions to access this page.”
7) I created a new admin user via SQL query called “developer” and same issue happens. The permission level is 10 with the standard permission line but nothing seems to be working.
Could it be because of utf8 and utf8mb4 difference or something? Here is a dropbox to the Database.
http://db.misterk.me/dbissue.sql
WordPress saves some urls in serialized arrays, so a standard search and replace is not sufficient. Use one of the tools suggested in Moving_WordPress.
I used Better Search Replace plugin to take all wp_post table urls that are pointing to the old server and replacing them with the new, still the same issue with permissions 🙁
Did you run it on any other tables – like wp_options?
No, I tried all tables, just wp_post and then only the siteurl and home rows in wp_options and all the same issue
Could a different MYSQL version cause this permission issue? Any way to forcefully add permissions to a user account via SQL query since i cant login to wp-admin?
Ok so, ladies and gentlemen, I have found an issue while going through each damn table on the DB.
The prefix for usermeta was y4Hv0RJ rather than all lowercase… While I updated the wp-config to support it all in lowercase, some of the tables were still in uppercase.
What a ridiculous thing… Guess UNIX does not like lowercase?
You guys have no idea how happy I am.
ANOTHER ISSUE:
It’s permalink structure. Could this be because of lack of .htaccess?
http://139.162.241.186 I can log into the admin fully now.
http://139.162.241.186/directory/the-wolesley/ it gives out Not Found error however the data is present in the backend.
