Wordpress转移数据表后出现"You do not have sufficient permissions to access this page"的解决方法...

根据自己的新的表前缀, 执行如下两条SQL

UPDATE `wpen_usermeta` SET `meta_key` = REPLACE(`meta_key`, 'wp_', 'wpen_');
UPDATE `wpen_options` SET `option_name` = 'wpen_user_roles' WHERE `option_name` = 'wp_user_roles' AND `blog_id` = 0;

Execute the below queries. Modify the table prefix in the SQL according to your installation before run it.

UPDATE `wpen_usermeta` SET `meta_key` = REPLACE(`meta_key`, 'wp_', 'wpen_');
UPDATE `wpen_options` SET `option_name` = 'wpen_user_roles' WHERE `option_name` = 'wp_user_roles' AND `blog_id` = 0;