Title: Admin problems after moving wordpress
Last modified: August 19, 2016

---

# Admin problems after moving wordpress

 *  [svenjick](https://wordpress.org/support/users/svenjick/)
 * (@svenjick)
 * [18 years ago](https://wordpress.org/support/topic/admin-problems-after-moving-wordpress/)
 * Hi,
 * I just moved my wordpress from one place to another. I followed the steps in 
   the Advanced Topics of the documentation on wordpress.org. The move was successful
   because the website displays properly, but unsuccessul in the sense that I can’t
   log in to the wp-admin anymore. I get the following error message:
 * > You do not have sufficient permissions to access this page.
 * This is strange as I previously had administrator rights. I tried creating a 
   new user but the problem remains. I have found a few unofficial posts on the 
   same error, but in only mildly similar cases, which I only half trust to try 
   out. Can anybody help me, or guide me to a place where I might find ideas / help
   on the topic?
 * Kindly,
 * Svenjick

Viewing 5 replies - 1 through 5 (of 5 total)

 *  Thread Starter [svenjick](https://wordpress.org/support/users/svenjick/)
 * (@svenjick)
 * [18 years ago](https://wordpress.org/support/topic/admin-problems-after-moving-wordpress/#post-756489)
 * OK, I’ve solved my problem – but don’t ask me to explain the logic / thinking,
   as I myself don’t understand what I have changed.
 * This is how I proceeded. Inspired by [http://beconfused.com/blog/2007/08/28/how-to-solve-you-do-not-have-sufficient-permissions-to-access-this-page-in-wordpress/](http://beconfused.com/blog/2007/08/28/how-to-solve-you-do-not-have-sufficient-permissions-to-access-this-page-in-wordpress/)
   but reticent to write sql queries, I looked around for similar things in my db.
   I assumed that my problem was the same since I changed the wp_ prefix when moving
   my site to wp08_ . (it must be said that this reference article concerns earlier
   version of WordPress, not 2.5.1). So what did I do? I did 2 main things:
    1. In my table, wp08_usermeta, I changed all occurrences of wp_capabilities, wp_user_level,
       and wp_autosave_draft_ids to wp08_capabilities, wp08_user_level and wp08_autosave_draft_ids
    2. Then in table wp08_options I changed wp_user_roles to wp08_user_roles
 * This, for reasons that I don’t fully understand, resolved my problem. Can anybody
   explain this, and could this error be taken into account for future WordPress
   releases?
 * Kindly, Svenjick
 *  [skepchick](https://wordpress.org/support/users/skepchick/)
 * (@skepchick)
 * [17 years, 11 months ago](https://wordpress.org/support/topic/admin-problems-after-moving-wordpress/#post-756729)
 * Hi, I’m facing the same problem thanks to adding a 2nd blog on my site and changing
   the wp_ prefix. I wanted the user tables to be shared, which it appears they 
   are (yay) but now my permissions are screwy and I can’t access the admin panel.
 * I’d like to do the fix above, but I’m baffled as to where to find the usermeta,
   user_roles, user_level etc. lines to adjust them to the new prefix. Can anyone
   help a n00b?
 * Thanks!
 *  [skepchick](https://wordpress.org/support/users/skepchick/)
 * (@skepchick)
 * [17 years, 11 months ago](https://wordpress.org/support/topic/admin-problems-after-moving-wordpress/#post-756731)
 * Okay, update, I’ve figured out to use phpmyadmin to see the databases and make
   changes, but it appears as though when I set the new prefix for the new blog,
   it automatically put the correct prefix before capabilities, user_level, etc.
   But, I still get a permissions error when trying to access the new blog’s admin
   panel. 🙁 Help?
 *  [lambs](https://wordpress.org/support/users/lambs/)
 * (@lambs)
 * [17 years, 3 months ago](https://wordpress.org/support/topic/admin-problems-after-moving-wordpress/#post-756799)
 * I know its late reply but I tried everything, then went to phpmyadmin went to
   the wp_table then wp_user roles opened that up and compared it with my other 
   working blogs found a difference changed it and it worked!!!! ok in the text 
   on the second line it should be a:53: INSTEAS of a:51: simple now everything 
   works!!!!
 *  [jamesbloor](https://wordpress.org/support/users/jamesbloor/)
 * (@jamesbloor)
 * [17 years, 1 month ago](https://wordpress.org/support/topic/admin-problems-after-moving-wordpress/#post-756804)
 * Thanks svenjick – that worked for me!

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Admin problems after moving wordpress’ is closed to new replies.

## Tags

 * [moving](https://wordpress.org/support/topic-tag/moving/)
 * [permissions](https://wordpress.org/support/topic-tag/permissions/)
 * [prefix](https://wordpress.org/support/topic-tag/prefix/)
 * [problem](https://wordpress.org/support/topic-tag/problem/)
 * [solution](https://wordpress.org/support/topic-tag/solution/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 5 replies
 * 4 participants
 * Last reply from: [jamesbloor](https://wordpress.org/support/users/jamesbloor/)
 * Last activity: [17 years, 1 month ago](https://wordpress.org/support/topic/admin-problems-after-moving-wordpress/#post-756804)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics