So I’ve moved a WordPress site from one hosting provider to the next, and I didn’t like the naming of the database tables.\u00a0 So I renamed the tables to something more preferred but then I received the below error message after successfully logging into the admin area.<\/p>\n
The website itself works perfectly right, it’s just the admin section.\u00a0 Now the whole reason for me posting this is there is heaps and heaps of information about how to solve this problem but because WordPress is written for anybody to easily use, the answer was hidden by lots of people saying the same thing, that and, mentioning database upgrades that had gone wrong.\u00a0 But in this case that wasn’t the problem.<\/p>\n
The resolution, there are some table fields that make reference to the table names some how so when changing the database tables you need to change the below entries too.<\/p>\n
You will need to use phpMyAdmin, it’s normally installed with cpanel, but if its not its really easy to install, just make sure you secure it as many people attempt to hack it.\u00a0 Hopefully with out getting to technical, we will imagine our orginal tables had a prefix of wp_ and we’ve change them to wp_blog.\u00a0 Add your names as such below.<\/p>\n
table<\/strong> , wp_options which would now be<\/em> wp_blogoptions Now you’ll need to make these usermeta changes for every user on your site, hopefully you don’t have too many.<\/p>\n I hope this is a help as it too me a couple of night to fully understand what was going on.\u00a0 Happy blogging \ud83d\ude42<\/p>\n","protected":false},"excerpt":{"rendered":" So I’ve moved a WordPress site from one hosting provider to the next, and I didn’t like the naming of the database tables.\u00a0 So I renamed the tables to something more preferred but then I received the below error message after successfully logging into the admin area. You do not have sufficient permissions to access … <\/p>\n
\n– option_name<\/strong> , wp_user_roles change to<\/em> wp_bloguser_roles
\ntable<\/strong> , wp_user_meta which would now be<\/em> wp_bloguser_meta
\n– meta_key<\/strong> , wp_capabilities change to<\/em> wp_blogcapabilities
\n– meta_key<\/strong> , wp_user_level change to<\/em> wp_bloguser_level
\n– meta_key<\/strong> , wp_dashboard_quick_press_last_post_id change to<\/em> wp_blogdashboard_quick_press_last_post_id
\n– meta_key<\/strong> , wp_user-settings change to<\/em> wp_bloguser-settings
\n– meta_key<\/strong> , wp_user-settings-time change to<\/em> wp_bloguser-settings-time<\/p>\n