Do you have a problem getting in to your word press blog?
Do you get this message -
“You do not have sufficient permissions to access this page”
because -
- you have changed the domain name of your blog?
- you have moved your blog from multi-blog database domain to self hosted domain?
I had similar problem on one of my sites.
NOTE: Make sure you take a FULL backup of your database.
1) Assuming you have a new domain name and its pointing to the correct word press folder.
2) Once you have created a blank database, import the backup taken earlier.
3) If you know MySql commands to change all the old table names from OLDwp_ to NEWwp_ and the entries within the tables then it should be straight forward. If not like me, you need to follow these steps to complete the move successfully.
Manuall changes into the database :
- if the old table names are – OLDwp_ , rename all of them to NEWwp_
- have a look at the _options and _usermeta tables
- change all the fields that are showing as OLD_ entries to the NEW_
Now try accessing your blog …/wp-admin/login.php. You should now get the error message – “You do not have sufficient permissions to access this page”
4) Follow the instructions of force-upgrade.php as suggested by markjaquith.
5) Once you have done as instructed above, you can try logging in again as admin.
6) For some people it straight away takes you into the admin dashboard, but for some it takes into the subscribers dashboard – this is what happened to me. To resolve this -
- go in to the MySql database -> _usermeta table
On the right column you should now see the this ” a:1:{s:10:”subscriber”;b:1;} ” (without double quotes). Replace this with the admin persmissions – ” a:1:{s:13:”administrator”;b:1;} ” (again without double quotes).
Now try login to your Admin account again, you should be able to login in to the Admin Dashboard.
One this I noticed in my situation, after doing all the above, I found that I couldn’t upgrade any plugins, themes, WP upgrades, etc, I could do that by manual ftp though, but the “Add New” button was missing from “Appeareance and Plugins” section.
Ok, since you are now able to login as Admin, its time to fix the upgrade problem.
Login into the MySql database -> _options table and look for “db_version”, this should be most likely on the second page. In my case the db_version was 11548, so I changed this to 8204, as described in here.
Now, when you try to login as Admin, it will ask you whether you would like to upgrade the database. In my case I chose to go ahead and took a risk – don’t worry you still had a backup in case if something would go wrong here. It did something inside the database and WOW, I could now see all the options in the dashboard that were missing earlier.
If you check the db_version again, it should now read as 11548.
See this wasn’t too difficult to move the wordpress blog from one domain name to another 
Related items
