After changed database tableprefix You do not have sufficient permissions error.

Hello all!

Today I changed my one of the WP blog database table prefix using phpMyAdmin command. Now table prefix looks like this “xx88_xxx44x_user”. I used following command line.

RENAME tablexx_xxx_userTOxx88_xxx44x_user;

After that I run following SQL command through phpMyAdmin.

UPDATExx88_xxx44x_usermetaSETmeta_key= replace(meta_key`, ‘xx_xxx_’, ‘xx88_xxx44x_’);

UPDATE xx88_xxx44x_options SET option_name = replace(option_name, ‘xx_xxx_’, ‘xx88_xxx44x_’);`

Now my all the tables prefix are changed to new name including usermeta table contain capabilities. Also I added new table prefix to WP-config.php file.

Now when I try to login as a admin, it shows following error (after logged in).

You do not have sufficient permissions to access this page.

My capabilities meta value is “a:1:{s:13:”administrator”;b:1;}” now I changed it to a:1:{s:13:”administrator”;s:1:”1″;} but no luck. Its user_level already set 10.

Then I disabled all the plugins (deleted plugin folder) but no success. I have already enable debugging, but can’t see any error or warning.

Could you please tell me how do I fix this issue?

Thanks!