Title: Moving WordPress Admin issue Help Please!
Last modified: August 19, 2016

---

# Moving WordPress Admin issue Help Please!

 *  Resolved [ODGraphics](https://wordpress.org/support/users/odgraphics/)
 * (@odgraphics)
 * [15 years, 2 months ago](https://wordpress.org/support/topic/moving-wordpress-admin-issue-help-please/)
 * Hi Guys
 * I posted this in another trend here on wordpress can someone have a look and 
   see if you can help below link to trend and also post
 * [http://wordpress.org/support/topic/moving-wordpress-admin-issue?replies=1](http://wordpress.org/support/topic/moving-wordpress-admin-issue?replies=1)
 * this is my first post for help on wordpress and i would really apperacate if 
   you could help me out.
    Below steps that I went through to move wordpress from
   my old site / provider to a new hosting provider. However i have run into a major
   issue with admin right changing to subscriber and non admin. I ran a force upgrade
   script but this is where im stuck, i was told that this could be overcome by 
   following the steps in the link below to add user through phpMyAdmin. [http://www.dnawebagency.com/how-to-add-an-admin-user-to-the-wordpress-database](http://www.dnawebagency.com/how-to-add-an-admin-user-to-the-wordpress-database)
 * HOWEVER when I went through the user rights steps as described above and logged
   in I only seem to have “basic” admin rights as in Plug-in tab does not appear
   and it asks me to contact administrator to upgrade plugins etc
 * Below are the steps i followed:
 * • Create new fresh database (DB) in your service providers phpMyAdmin with a 
   user who has full permissions
 * • import wordpress mySql file into fresh DB
 * • Inside in your old WordPress files change the wp-config.php file to the DB_username,
   DB_pass & DB_name that correspond to the new database you just created in your
   service providers phpMyAdmin.
 * • FTP SME WordPress file from local computer to wwwroot folder on your services
   provider.
 * • Go to [http://www.example.com/wp-admin](http://www.example.com/wp-admin)
    •
   Enter your SME username and password
 * After i did this I was presented with “you do not have permissions to access 
   this page” and i had to download and run the following:
 * Force Upgrade of WordPress ([http://txfx.net/files/wordpress/force-upgrade.phps](http://txfx.net/files/wordpress/force-upgrade.phps))
   for more information on this script see ([http://markjaquith.wordpress.com/2006/03/28/wordpress-error-you-do-not-have-sufficient-permissions-to-access-this-page/](http://markjaquith.wordpress.com/2006/03/28/wordpress-error-you-do-not-have-sufficient-permissions-to-access-this-page/))
 * the above reset the old user rights in mySQL file back to subscriber then i went
   into the phpMyAdmin -> WP_usermeta -> wp_capabilities back to a:1:{s:13:”administrator”;
   s:1:”1″;}
 * I then went back to the wp-admin logged in as admin and password the user rights
   changed alright from subscriber to admin BUT still the plug-ins tab is missing
   and its asking me to contact the administrator to upgrade plugins etc can anyone
   help please!

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

 *  [rayholt](https://wordpress.org/support/users/rayholt/)
 * (@rayholt)
 * [15 years, 2 months ago](https://wordpress.org/support/topic/moving-wordpress-admin-issue-help-please/#post-1865691)
 * The force upgrade looks like it’s supposed to be used to go from 1.5 to 2.0, 
   and you have 3.0? If you do not have the plugins menu item then it does not appear
   that you have full administrative privileges, but that of possibly an editor.
 * Try this for your wp_capabilities meta value for your admin user:
 * a:1:{s:13:”administrator”;b:1;}
 *  Thread Starter [ODGraphics](https://wordpress.org/support/users/odgraphics/)
 * (@odgraphics)
 * [15 years, 2 months ago](https://wordpress.org/support/topic/moving-wordpress-admin-issue-help-please/#post-1865736)
 * [@rayholt](https://wordpress.org/support/users/rayholt/) thanks for getting back
   to me on this regarding force upgrade script i checked this before i ran it and
   it works on all versions of wordpress as it just flushes various aspects of wordpress
   and db so i dont think that is causing the issue. regarding your suggestion for
   putting
 * a:1:{s:13:”administrator”;b:1;}
 * into the meta capabilities section can you advise where i can find more information
   on what this does is there codex on this as i think i have tried the above to
   no avail ill try this again and get back if im still having issues by the way
   is there an error log or something that wordpress creates that might help?
 *  Thread Starter [ODGraphics](https://wordpress.org/support/users/odgraphics/)
 * (@odgraphics)
 * [15 years, 2 months ago](https://wordpress.org/support/topic/moving-wordpress-admin-issue-help-please/#post-1865743)
 * [@rayholt](https://wordpress.org/support/users/rayholt/) thanks again for getting
   back to me on this i have just updated the wp_capabilities to a:1:{s:13:”administrator”;
   b:1;} butit still has not given me full admin rights any ideas?
 * Thanks again for looking at this issue
 *  Thread Starter [ODGraphics](https://wordpress.org/support/users/odgraphics/)
 * (@odgraphics)
 * [15 years, 2 months ago](https://wordpress.org/support/topic/moving-wordpress-admin-issue-help-please/#post-1865775)
 * Think I have sorted this i just replaced the wp_user_roles with a fresh version
   in from a fresh install of wordpress on my local machine and it seems to have
   resolved the issue for now i hope ……
 *  Thread Starter [ODGraphics](https://wordpress.org/support/users/odgraphics/)
 * (@odgraphics)
 * [15 years, 2 months ago](https://wordpress.org/support/topic/moving-wordpress-admin-issue-help-please/#post-1865785)
 * For those of you interested see below before and after wp-user-roles maybe you
   can spot what was causing the issue
 * ——————————————————————————
    ORIGNAL MYSQL wp_user_roles file ——————————————————————————
 * a:5:{s:13:”administrator”;a:2:{s:4:”name”;s:13:”Administrator”;s:12:”capabilities”;
   a:74:{s:13:”switch_themes”;b:1;s:11:”edit_themes”;b:1;s:16:”activate_plugins”;
   b:1;s:12:”edit_plugins”;b:1;s:10:”edit_users”;b:1;s:10:”edit_files”;b:1;s:14:”
   manage_options”;b:1;s:17:”moderate_comments”;b:1;s:17:”manage_categories”;b:1;
   s:12:”manage_links”;b:1;s:12:”upload_files”;b:1;s:6:”import”;b:1;s:15:”unfiltered_html”;
   b:1;s:10:”edit_posts”;b:1;s:17:”edit_others_posts”;b:1;s:20:”edit_published_posts”;
   b:1;s:13:”publish_posts”;b:1;s:10:”edit_pages”;b:1;s:4:”read”;b:1;s:8:”level_10″;
   b:1;s:7:”level_9″;b:1;s:7:”level_8″;b:1;s:7:”level_7″;b:1;s:7:”level_6″;b:1;s:
   7:”level_5″;b:1;s:7:”level_4″;b:1;s:7:”level_3″;b:1;s:7:”level_2″;b:1;s:7:”level_1″;
   b:1;s:7:”level_0″;b:1;s:17:”edit_others_pages”;b:1;s:20:”edit_published_pages”;
   b:1;s:13:”publish_pages”;b:1;s:12:”delete_pages”;b:1;s:19:”delete_others_pages”;
   b:1;s:22:”delete_published_pages”;b:1;s:12:”delete_posts”;b:1;s:19:”delete_others_posts”;
   b:1;s:22:”delete_published_posts”;b:1;s:20:”delete_private_posts”;b:1;s:18:”edit_private_posts”;
   b:1;s:18:”read_private_posts”;b:1;s:20:”delete_private_pages”;b:1;s:18:”edit_private_pages”;
   b:1;s:18:”read_private_pages”;b:1;s:12:”delete_users”;b:1;s:12:”create_users”;
   b:1;s:17:”unfiltered_upload”;b:1;s:14:”edit_dashboard”;b:1;s:14:”update_plugins”;
   b:1;s:14:”delete_plugins”;b:1;s:15:”install_plugins”;b:1;s:13:”update_themes”;
   b:1;s:14:”install_themes”;b:1;s:11:”update_core”;b:1;s:10:”list_users”;b:1;s:
   12:”remove_users”;b:1;s:9:”add_users”;b:1;s:13:”promote_users”;b:1;s:18:”edit_theme_options”;
   b:1;s:13:”delete_themes”;b:1;s:6:”export”;b:1;s:24:”NextGEN Gallery overview”;
   b:1;s:19:”NextGEN Use TinyMCE”;b:1;s:21:”NextGEN Upload images”;b:1;s:22:”NextGEN
   Manage gallery”;b:1;s:19:”NextGEN Manage tags”;b:1;s:29:”NextGEN Manage others
   gallery”;b:1;s:18:”NextGEN Edit album”;b:1;s:20:”NextGEN Change style”;b:1;s:
   22:”NextGEN Change options”;b:1;s:12:”manage bkpwp”;b:1;s:14:”manage_backups”;
   b:1;s:16:”download_backups”;b:1;}}s:6:”editor”;a:2:{s:4:”name”;s:6:”Editor”;s:
   12:”capabilities”;a:34:{s:17:”moderate_comments”;b:1;s:17:”manage_categories”;
   b:1;s:12:”manage_links”;b:1;s:12:”upload_files”;b:1;s:15:”unfiltered_html”;b:
   1;s:10:”edit_posts”;b:1;s:17:”edit_others_posts”;b:1;s:20:”edit_published_posts”;
   b:1;s:13:”publish_posts”;b:1;s:10:”edit_pages”;b:1;s:4:”read”;b:1;s:7:”level_7″;
   b:1;s:7:”level_6″;b:1;s:7:”level_5″;b:1;s:7:”level_4″;b:1;s:7:”level_3″;b:1;s:
   7:”level_2″;b:1;s:7:”level_1″;b:1;s:7:”level_0″;b:1;s:17:”edit_others_pages”;
   b:1;s:20:”edit_published_pages”;b:1;s:13:”publish_pages”;b:1;s:12:”delete_pages”;
   b:1;s:19:”delete_others_pages”;b:1;s:22:”delete_published_pages”;b:1;s:12:”delete_posts”;
   b:1;s:19:”delete_others_posts”;b:1;s:22:”delete_published_posts”;b:1;s:20:”delete_private_posts”;
   b:1;s:18:”edit_private_posts”;b:1;s:18:”read_private_posts”;b:1;s:20:”delete_private_pages”;
   b:1;s:18:”edit_private_pages”;b:1;s:18:”read_private_pages”;b:1;}}s:6:”author”;
   a:2:{s:4:”name”;s:6:”Author”;s:12:”capabilities”;a:10:{s:12:”upload_files”;b:
   1;s:10:”edit_posts”;b:1;s:20:”edit_published_posts”;b:1;s:13:”publish_posts”;
   b:1;s:4:”read”;b:1;s:7:”level_2″;b:1;s:7:”level_1″;b:1;s:7:”level_0″;b:1;s:12:”
   delete_posts”;b:1;s:22:”delete_published_posts”;b:1;}}s:11:”contributor”;a:2:{
   s:4:”name”;s:11:”Contributor”;s:12:”capabilities”;a:5:{s:10:”edit_posts”;b:1;
   s:4:”read”;b:1;s:7:”level_1″;b:1;s:7:”level_0″;b:1;s:12:”delete_posts”;b:1;}}
   s:10:”subscriber”;a:2:{s:4:”name”;s:10:”Subscriber”;s:12:”capabilities”;a:2:{
   s:4:”read”;b:1;s:7:”level_0″;b:1;}}}
 * ——————————————————————————
    FRESH INSTALLMYSQL wp_user_role file ——————————————————————————
 * a:5:{s:13:”administrator”;a:2:{s:4:”name”;s:13:”Administrator”;s:12:”capabilities”;
   a:63:{s:13:”switch_themes”;b:1;s:11:”edit_themes”;b:1;s:16:”activate_plugins”;
   b:1;s:12:”edit_plugins”;b:1;s:10:”edit_users”;b:1;s:10:”edit_files”;b:1;s:14:”
   manage_options”;b:1;s:17:”moderate_comments”;b:1;s:17:”manage_categories”;b:1;
   s:12:”manage_links”;b:1;s:12:”upload_files”;b:1;s:6:”import”;b:1;s:15:”unfiltered_html”;
   b:1;s:10:”edit_posts”;b:1;s:17:”edit_others_posts”;b:1;s:20:”edit_published_posts”;
   b:1;s:13:”publish_posts”;b:1;s:10:”edit_pages”;b:1;s:4:”read”;b:1;s:8:”level_10″;
   b:1;s:7:”level_9″;b:1;s:7:”level_8″;b:1;s:7:”level_7″;b:1;s:7:”level_6″;b:1;s:
   7:”level_5″;b:1;s:7:”level_4″;b:1;s:7:”level_3″;b:1;s:7:”level_2″;b:1;s:7:”level_1″;
   b:1;s:7:”level_0″;b:1;s:17:”edit_others_pages”;b:1;s:20:”edit_published_pages”;
   b:1;s:13:”publish_pages”;b:1;s:12:”delete_pages”;b:1;s:19:”delete_others_pages”;
   b:1;s:22:”delete_published_pages”;b:1;s:12:”delete_posts”;b:1;s:19:”delete_others_posts”;
   b:1;s:22:”delete_published_posts”;b:1;s:20:”delete_private_posts”;b:1;s:18:”edit_private_posts”;
   b:1;s:18:”read_private_posts”;b:1;s:20:”delete_private_pages”;b:1;s:18:”edit_private_pages”;
   b:1;s:18:”read_private_pages”;b:1;s:12:”delete_users”;b:1;s:12:”create_users”;
   b:1;s:17:”unfiltered_upload”;b:1;s:14:”edit_dashboard”;b:1;s:14:”update_plugins”;
   b:1;s:14:”delete_plugins”;b:1;s:15:”install_plugins”;b:1;s:13:”update_themes”;
   b:1;s:14:”install_themes”;b:1;s:11:”update_core”;b:1;s:10:”list_users”;b:1;s:
   12:”remove_users”;b:1;s:9:”add_users”;b:1;s:13:”promote_users”;b:1;s:18:”edit_theme_options”;
   b:1;s:13:”delete_themes”;b:1;s:6:”export”;b:1;s:12:”manage_roles”;b:1;}}s:6:”
   editor”;a:2:{s:4:”name”;s:6:”Editor”;s:12:”capabilities”;a:34:{s:17:”moderate_comments”;
   b:1;s:17:”manage_categories”;b:1;s:12:”manage_links”;b:1;s:12:”upload_files”;
   b:1;s:15:”unfiltered_html”;b:1;s:10:”edit_posts”;b:1;s:17:”edit_others_posts”;
   b:1;s:20:”edit_published_posts”;b:1;s:13:”publish_posts”;b:1;s:10:”edit_pages”;
   b:1;s:4:”read”;b:1;s:7:”level_7″;b:1;s:7:”level_6″;b:1;s:7:”level_5″;b:1;s:7:”
   level_4″;b:1;s:7:”level_3″;b:1;s:7:”level_2″;b:1;s:7:”level_1″;b:1;s:7:”level_0″;
   b:1;s:17:”edit_others_pages”;b:1;s:20:”edit_published_pages”;b:1;s:13:”publish_pages”;
   b:1;s:12:”delete_pages”;b:1;s:19:”delete_others_pages”;b:1;s:22:”delete_published_pages”;
   b:1;s:12:”delete_posts”;b:1;s:19:”delete_others_posts”;b:1;s:22:”delete_published_posts”;
   b:1;s:20:”delete_private_posts”;b:1;s:18:”edit_private_posts”;b:1;s:18:”read_private_posts”;
   b:1;s:20:”delete_private_pages”;b:1;s:18:”edit_private_pages”;b:1;s:18:”read_private_pages”;
   b:1;}}s:6:”author”;a:2:{s:4:”name”;s:6:”Author”;s:12:”capabilities”;a:10:{s:12:”
   upload_files”;b:1;s:10:”edit_posts”;b:1;s:20:”edit_published_posts”;b:1;s:13:”
   publish_posts”;b:1;s:4:”read”;b:1;s:7:”level_2″;b:1;s:7:”level_1″;b:1;s:7:”level_0″;
   b:1;s:12:”delete_posts”;b:1;s:22:”delete_published_posts”;b:1;}}s:11:”contributor”;
   a:2:{s:4:”name”;s:11:”Contributor”;s:12:”capabilities”;a:5:{s:10:”edit_posts”;
   b:1;s:4:”read”;b:1;s:7:”level_1″;b:1;s:7:”level_0″;b:1;s:12:”delete_posts”;b:
   1;}}s:10:”subscriber”;a:2:{s:4:”name”;s:10:”Subscriber”;s:12:”capabilities”;a:
   2:{s:4:”read”;b:1;s:7:”level_0″;b:1;}}}

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

The topic ‘Moving WordPress Admin issue Help Please!’ is closed to new replies.

## Tags

 * [administrator](https://wordpress.org/support/topic-tag/administrator/)
 * [moving](https://wordpress.org/support/topic-tag/moving/)
 * [phpmyadmin](https://wordpress.org/support/topic-tag/phpmyadmin/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 5 replies
 * 2 participants
 * Last reply from: [ODGraphics](https://wordpress.org/support/users/odgraphics/)
 * Last activity: [15 years, 2 months ago](https://wordpress.org/support/topic/moving-wordpress-admin-issue-help-please/#post-1865785)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics