Moving wordpress from localhost to server throws admin panel access error?

I’ve a working version of wordpress in localhost and i tried to move them to the remote server.

As i’ve another wordpress installed in the same server and tried to rename the current tables to the prefix wp1_

I exported my local data to a sql file. After that i searched and renamed every table name with wp_ and changed them into wp1_ and imported to my server.

After that i tried to login in admin panel , it throws the following error

" You do not have sufficient permissions to access this page. "

I searched some forums and tried to change the values of meta key in the wp1_options and wp1_usermeta which was started with wp_

Still after this , i couldn’t login.

And ideas on this?

Note: I’ve changed the wp-config and related details and the front end is working fine.

This usually happens when the table prefix is manually changed but some changes have been overlooked.

Go to your user_meta table and have a look at the meta_key column. Check if fields like wp_capabilities have been changed to use the wp1_ prefix. Also look in your wp1_options table to check that user_roles has been changed to wp1_user_roles.

When the table prefix is manually changed, the prefixes on these fields in user_meta are often left unchanged:

capabilities

user_level

user_settings

user_settings_time

Check them all. You can quickly identify which ones haven’t been changed by running this SQL query:

SELECT * FROM `wp1_usermeta` WHERE `meta_key` LIKE '%wp_%'