You do not have sufficient permissions to access this page without any change [closed]

I'm dealing with Wordpress and I finished my undertaking locally. I then moved it to my live server and changed nothing, I just made changes in the config record (data set name, username and secret key).

Presently my site is turned out great toward the front however I can't gain admittance to the administrator board as each time it gives me the blunder message:

You don't have adequate authorizations to get to this page.

Google look show that the greater part of the blunders happened because of an adjustment of the prefix however for my situation its equivalent to on neighborhood. Likewise, the consents of my catalogs are 755 and that of records is 644 yet am confronting a similar issue.

How should I approach fixing this?

Solutions

Have you changed the prefix of your data set tables? I'm 90% certain, that this is your concern.

Indeed WordPress utilizes the $table_prefix variable for framing the choice and usermeta keys names, where it's putting away the jobs and capacities data. So when you change the prefix, however don't refresh your db, you get this mistake. This is the way to fix it - execute this SQL order through phpMyAdmin, or an alternate connection point for collaborating with your DB(you can do it with PHP too):

UPDATE `{%TABLE_PREFIX%}usermeta` SET `meta_key` = replace(`meta_key`, '{%OLD_TABLE_PREFIX%}', '{%NEW_TABLE_PREFIX%}') WHERE option_name like '{%OLD_TABLE_PREFIX%}%';
UPDATE `{%TABLE_PREFIX%}options` SET `option_name` = replace(`option_name`, '{%OLD_TABLE_PREFIX%}', '{%NEW_TABLE_PREFIX%}') WHERE option_name like '{%OLD_TABLE_PREFIX%}%';

Where:

{%TABLE_PREFIX%} is your current $table_prefix(as set in wp-config.php)

{%OLD_TABLE_PREFIX%} is your past $table_prefix

{%NEW_TABLE_PREFIX%} is your new(current) $table_prefix - it will in all likelihood be equivalent to your {%TABLE_PREFIX%}.

So if your old $table_prefix was wp_test_ and your new one is wp_, you would do this question:

UPDATE `wp_usermeta` SET `meta_key` = replace(`meta_key`, 'wp_test_', 'wp_') WHERE option_name like 'wp_test_%';
UPDATE `wp_options` SET `option_name` = replace(`option_name`, 'wp_test_', 'wp_') WHERE option_name like 'wp_test_%';