{"id":76,"date":"2011-03-30T08:08:46","date_gmt":"2011-03-30T08:08:46","guid":{"rendered":"http:\/\/pixert.com\/blog\/?p=76"},"modified":"2013-09-03T06:56:42","modified_gmt":"2013-09-03T06:56:42","slug":"how-to-get-administrator-access-back-in-wordpress","status":"publish","type":"post","link":"https:\/\/pixert.com\/blog\/how-to-get-administrator-access-back-in-wordpress\/","title":{"rendered":"How to get Administrator access back in WordPress?"},"content":{"rendered":"

\"\"<\/a>Your role was Administrator. Suddenly, someone has changed your role in WordPress.
\nYou login to WordPress admin as a subscriber,you see \u00a0Profile page\u00a0instead getting fully-functional Admin page. \u00a0 How to get your role as an Administrator back?<\/p>\n

1. Get help from another Administrator<\/strong><\/p>\n

You can ask another Administrator to switch your current role back to Administrator.
\nLogin to WordPress Admin. \u00a0Go to Users section on the left sidebar of WordPress Dashboard page.
\nClick Users. \u00a0Edit your username. Change your current role from Subscriber to Administrator.
\nClick Update Profile button. Logout from WordPress Admin. Login again with your username.<\/p>\n

2. PhpMyAdmin<\/strong><\/p>\n

Most Control Panel has PhpMyAdmin feature in it. Open PhpMyAdmin.
\nFind wp_usermeta table in the left sidebar of PhpMyAdmin. Click it.
\nClick Browse tab, you’ll get all content of the table.<\/p>\n

See your nickname, there’s meta_key name wp_capabilities under that nickname.
\nChange meta_value from<\/p>\n

a:1:{s:10:"subscriber";s:1:"1";}<\/pre>\n
to<\/p>\n
a:1:{s:13:"administrator";b:1;}<\/pre>\n
Save the new meta value .<\/p>\n","protected":false},"excerpt":{"rendered":"
Your role was Administrator. Suddenly, someone has changed your role in WordPress. You login to WordPress admin as a subscriber,you see \u00a0Profile page\u00a0instead getting fully-functional Admin page. \u00a0 How to get your role as an Administrator back? 1. Get help from another Administrator You can ask another Administrator to switch your current role back to […]<\/p>\n","protected":false},"author":1,"featured_media":79,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[5],"tags":[6,45,44],"class_list":["post-76","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-wordpress","tag-wordpress-2","tag-wordpress-roles","tag-wp-admin"],"aioseo_notices":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/pixert.com\/blog\/wp-content\/uploads\/2011\/03\/wprole.jpg?fit=151%2C119&ssl=1","jetpack_shortlink":"https:\/\/wp.me\/p1pvi1-1e","jetpack-related-posts":[{"id":170,"url":"https:\/\/pixert.com\/blog\/repair-wordpress-database\/","url_meta":{"origin":76,"position":0},"title":"Repair WordPress Database","author":"Pixel Insert \/ Pixert","date":"December 10, 2011","format":false,"excerpt":"When a WordPress table crash, one symptom might be that all of your posts seem to have disappeared, or perhaps all of your drafts. You may even get a message in phpMyAdmin telling you that one of your tables haves crashed. No need to worry. Repairing tables is very easy.\u2026","rel":"","context":"In "CentOS"","block_context":{"text":"CentOS","link":"https:\/\/pixert.com\/blog\/category\/centos\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/pixert.com\/blog\/wp-content\/uploads\/2011\/12\/phpmyadminrepair.jpg?fit=1064%2C640&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/pixert.com\/blog\/wp-content\/uploads\/2011\/12\/phpmyadminrepair.jpg?fit=1064%2C640&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/pixert.com\/blog\/wp-content\/uploads\/2011\/12\/phpmyadminrepair.jpg?fit=1064%2C640&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/pixert.com\/blog\/wp-content\/uploads\/2011\/12\/phpmyadminrepair.jpg?fit=1064%2C640&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/pixert.com\/blog\/wp-content\/uploads\/2011\/12\/phpmyadminrepair.jpg?fit=1064%2C640&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":157,"url":"https:\/\/pixert.com\/blog\/wordpress-database-optimization\/","url_meta":{"origin":76,"position":1},"title":"WordPress Database Optimization","author":"Pixel Insert \/ Pixert","date":"December 9, 2011","format":false,"excerpt":"WordPress is powered by PHP and depends on MySQL database; in fact, all the content, including the website settings, are stored in it. When your WordPress site is visited, the web server will query the database to retrieve all the necessary information to display. However, over time, the speed required\u2026","rel":"","context":"In "CentOS"","block_context":{"text":"CentOS","link":"https:\/\/pixert.com\/blog\/category\/centos\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/pixert.com\/blog\/wp-content\/uploads\/2011\/12\/wpoptimize.jpg?fit=1009%2C895&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/pixert.com\/blog\/wp-content\/uploads\/2011\/12\/wpoptimize.jpg?fit=1009%2C895&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/pixert.com\/blog\/wp-content\/uploads\/2011\/12\/wpoptimize.jpg?fit=1009%2C895&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/pixert.com\/blog\/wp-content\/uploads\/2011\/12\/wpoptimize.jpg?fit=1009%2C895&ssl=1&resize=700%2C400 2x"},"classes":[]},{"id":201,"url":"https:\/\/pixert.com\/blog\/remove-wordpress-revisions\/","url_meta":{"origin":76,"position":2},"title":"Remove WordPress Revisions","author":"Pixel Insert \/ Pixert","date":"February 16, 2012","format":false,"excerpt":"WordPress Posts Revisions are useful especially in the case of a multi author blog. However, There is a cost to having all these saved revisions of your posts in the aspect of database entries. Instead of having a single MySQL database record for your post you will have multiple records\u2026","rel":"","context":"In "WordPress"","block_context":{"text":"WordPress","link":"https:\/\/pixert.com\/blog\/category\/wordpress\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/pixert.com\/blog\/wp-content\/uploads\/2011\/03\/wordpresslogo-300x68.png?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":46,"url":"https:\/\/pixert.com\/blog\/change-mamp-mysql-password\/","url_meta":{"origin":76,"position":3},"title":"Change MAMP MySQL password","author":"Pixel Insert \/ Pixert","date":"March 12, 2011","format":false,"excerpt":"MAMP creates a local server environment on Mac OS X by installing Apache, PHP and MySQL right out of the box. The default username\/password for MySQL install is root\/root. That's not safe. For security purposes, in our case we want sync between our WAMP and MAMP , it's best to\u2026","rel":"","context":"In "Mac OS"","block_context":{"text":"Mac OS","link":"https:\/\/pixert.com\/blog\/category\/mac-os\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/pixert.com\/blog\/wp-content\/uploads\/2011\/03\/mamplogo.png?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":22,"url":"https:\/\/pixert.com\/blog\/how-to-upgrade-wordpress\/","url_meta":{"origin":76,"position":4},"title":"How to Upgrade WordPress","author":"Pixel Insert \/ Pixert","date":"March 6, 2011","format":false,"excerpt":"A few steps to upgrade WordPress 1. Backup WordPress database with phpmyadmin or WordPress Database Backup plugin 2. Deactivate any plugins 3. Delete files and folders, except wp-config.php files and wp-content folder 4. Upload the latest WordPress, except wp-config.php files and wp-content folder 5. Type in domain_name\/wp-admin\/upgrade.php\u00a0 or domain_name\/wp-admin on\u2026","rel":"","context":"In "WordPress"","block_context":{"text":"WordPress","link":"https:\/\/pixert.com\/blog\/category\/wordpress\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/pixert.com\/blog\/wp-content\/uploads\/2011\/03\/wordpresslogo-300x68.png?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":186,"url":"https:\/\/pixert.com\/blog\/block-distracting-websites-with-cold-turkey\/","url_meta":{"origin":76,"position":5},"title":"Block Distracting Websites with Cold Turkey","author":"Pixel Insert \/ Pixert","date":"January 8, 2012","format":false,"excerpt":"Whenever you are working on PC, everything else suddenly starts seeming a lot more interesting than the actual work. Facebook and numerous other \u00a0 websites provide you with a constant source of distraction. An app called Cold Turkey presents a solution for this problem. Cold Turkey is a free\/open- source\u2026","rel":"","context":"In "Windows"","block_context":{"text":"Windows","link":"https:\/\/pixert.com\/blog\/category\/windows\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/pixert.com\/blog\/wp-content\/uploads\/2012\/01\/coldturkey1.jpg?fit=450%2C638&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]}],"jetpack_sharing_enabled":true,"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/pixert.com\/blog\/wp-json\/wp\/v2\/posts\/76","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pixert.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pixert.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pixert.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pixert.com\/blog\/wp-json\/wp\/v2\/comments?post=76"}],"version-history":[{"count":0,"href":"https:\/\/pixert.com\/blog\/wp-json\/wp\/v2\/posts\/76\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/pixert.com\/blog\/wp-json\/wp\/v2\/media\/79"}],"wp:attachment":[{"href":"https:\/\/pixert.com\/blog\/wp-json\/wp\/v2\/media?parent=76"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pixert.com\/blog\/wp-json\/wp\/v2\/categories?post=76"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pixert.com\/blog\/wp-json\/wp\/v2\/tags?post=76"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}