DB Prefix change crashes admin panel

  • So I wanted to add some additional security by changing my WordPress database prefix. I used phpMyAdmin, selected all tables beginning with ‘wp_’, change it to “XXXXX_” (5 letters – mixed uppercase and lowercase – no numbers – no special characters). I edited the wp-config.php file for the $table_prefix to be ‘XXXXX_’.

    The front page loads just fine with the new prefix.

    However, if I try to go to the https://WEBSITE.EXT/wp-admin/index.php page, I get a “Sorry, you are not allowed to access this page”.

    As I use Chrome, I just to ensure it wasn’t any type of caching issue, I loaded up the https://WEBSITE.EXT/wp-admin/index.php page in both Edge and Firefox with the same results. Yet the front page loads fine on those browser too.

    If I change the prefix back to ‘wp_’ in the DB and wp-config.php, the admin panel loads immediately.

    I am frankly confused why this happens.

    Any ideas?

Viewing 2 replies - 1 through 2 (of 2 total)

  • To make it easier, find a plugin that allows you to change the database prefix and it should work as expected, e.g. All in one security has an option.

    Thread Starter LukeDouglas

    (@lukedouglas)

    jameszen,

    All in one security accomplished the prefix renaming successfully for both front page and admin panel.

    I’m still confused why manually doing it didn’t work for the admin panel but the front page. ??

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘DB Prefix change crashes admin panel’ is closed to new replies.