{"id":2361,"date":"2019-07-24T11:55:12","date_gmt":"2019-07-24T11:55:12","guid":{"rendered":"https:\/\/chemicloud.com\/kb\/?post_type=ht_kb&p=2361"},"modified":"2024-10-16T09:42:05","modified_gmt":"2024-10-16T09:42:05","slug":"sorry-you-are-not-allowed-to-access-this-page-wordpress","status":"publish","type":"ht_kb","link":"https:\/\/chemicloud.com\/kb\/article\/sorry-you-are-not-allowed-to-access-this-page-wordpress\/","title":{"rendered":"\u201cSorry, You Are Not Allowed to Access This Page\u201d Error in WordPress? Here’s How to Fix It!"},"content":{"rendered":"

While trying to access your WordPress admin panel, you may be encountering the \u201cSorry, you are not allowed to access this page\u201d error. This error will be preventing you from accessing your dashboard and making important changes to your site.<\/p>\n

What Causes the \u201cSorry, You Are Not Allowed to Access This Page\u201d Error<\/h3>\n

Fundamentally, this error occurs as a result of a username role issue. To be more specific, the username that you were using to access your WordPress dashboard, doesn’t have an administrator role.<\/p>\n

How to Fix the \u201cSorry, You Are Not Allowed to Access This Page\u201d Error for WordPress Dashboard<\/h3>\n \t\t
\r\n \t\t\t \t\t\t \t\t\t\t

\r\n \t\t\t\t\tBefore going further, it\u2019s highly recommended that you back up your WordPress database. This will ensure that you can easily restore your database in case something goes wrong while troubleshooting this issue.\u00a0 \t\t\t\t<\/p>\r\n \t\t\t \t\t\t\r\n \t\t<\/div>\r\n \t\t\n

In order to fix the aforementioned error, you’ll need to set an administrator role to your WordPress admin panel username. You can easily do so using phpMyAdmin or WP-CLI<\/a>, which is the command-line interface for WordPress. We’ll explore both options.<\/p>\n

Struggling with WordPress troubleshooting? ChemiCloud is the hosting solution designed to save you time and money! <\/b>\ud83e\udd13<\/span> Try our <\/b>Managed WordPress Hosting<\/b><\/a> plans for just $1!<\/b><\/p>\n

How to change WordPress user roles in MySQL database using PhpMyAdmin?<\/h4>\n

We’ll assume that you’re already logged into your phpMyAdmin.<\/p>\n

1)<\/strong> You’ll have to locate first the ID number for your WordPress admin username. Open the wp_users or xxx_users table in the database as highlighted. (wp_ is just the prefix, your table prefix may be different)<\/p>\n

\"\"<\/p>\n

2)<\/strong> Once you’ll open the wp_users table, you will see a list with the existing usernames which are created on your WordPress site. Locate the username that you were using to log in as an admin and look up after the ID. In our case, the ID is “1” as can be seen in the screenshot below.<\/p>\n

\"\"<\/p>\n

3)<\/strong> Now that we know the ID for the admin username, the next thing to do is to open the wp_usermeta or xxx_usermeta table in the database as highlighted. (wp_ is just the prefix, your table prefix may be different)<\/p>\n

\"\"<\/p>\n

4)<\/strong> In the wp_usermeta table, you can find wp_capabilities<\/em> under meta_key column.<\/p>\n

\"\"<\/p>\n

If the meta_value is empty, you will need to add the following value:<\/p>\n

a:1:{s:13:\"administrator\";b:1;}<\/pre>\n
The roles are saved in the form of a serialized PHP array. Change the user role you want to assign to the current user by changing the meta_value as:<\/p>\n
Administrator\na:1:{s:13:\"administrator\";b:1;}\n\nSubscriber\na:1:{s:10:\"subscriber\";b:1;}\n\nContributor\na:1:{s:11:\"contributor\";b:1;}\n\nAuthor\na:1:{s:6:\"author\";b:1;}\n\nEditor\na:1:{s:6:\"editor\";b:1;}<\/pre>\n
That’s it, now that you’ve added administrator role to your username, you should clear the cache and cookies for your web browser and try again to log in.<\/p>\n
How to change WordPress user roles in MySQL database using WP-CLI<\/h4>\n
This tutorial assumes that your web hosting provides you with access to WP-CLI<\/a> which is the WordPress command-line interface for your WordPress website.<\/p>\n    \t\t
\r\n    \t\t\t    \t\t\t    \t\t\t\t
\r\n    \t\t\t\t\tDon\u2019t forget that ChemiCloud\u2019s infrastructure supports WP-CLI out of the box. If you\u2019d like to experience top speed and reliability and have access to great tools like WP-CLI, try our\u00a0WordPress hosting<\/a><\/strong>    \t\t\t\t<\/p>\r\n    \t\t\t    \t\t\t\r\n    \t\t<\/div>\r\n    \t\t\n
1) Once you’ve accessed WP-CLI via SSH, navigate to the directory where your WordPress site is installed.<\/p>\n
2) You’ll have to locate first the ID number for your WordPress admin username by using the following command line:<\/p>\n
wp user list<\/span><\/pre>\n
This command will display all the existing usernames and the role for each:<\/p>\n
+—-+————+————–+———————–+———————+—————+
\n| ID | user_login | display_name | user_email | user_registered | roles |
\n+—-+————+————–+———————–+———————+—————+
\n| 1 | cch | cch | admin@chemiccloud.com | 2019-07-24 11:06:17 |
\n+—-+————+————–+———————–+———————+—————+<\/p>\n
As you can see, the role of our username is missing.<\/p>\n
3) The next step is to change the role of our username, which is using “1” as the ID, as can be seen in the first column. The command line that we’ll use is:<\/p>\n
wp user set-role 1 administrator\n\nSuccess: Added cch (1) as administrator.<\/pre>\n
This command will attribute an administrator role to the username.<\/p>\n
Available WordPress users roles:<\/strong><\/p>\n