Monthly Archives: September 2019

Change table prefix on WordPress installation

If you already have a WordPress installation and you want to change the table prefix, you have to set it into wp-config.php

You have also to dump your db, replace all wp_ with newprefix_ in the sql file, remove all the tables and restore the sql file.

Now check inside newprefix_usermeta and newprefix_options tables if there are ^wp_ values and change wp_ with _newprefix

SELECT * FROM newprefix_options WHERE option_name LIKE ‘wp_%’

SELECT * FROM newprefix_usermeta WHERE meta_key LIKE ‘wp_%’

https://www.wpwhitesecurity.com/you-do-not-have-sufficient-permissions-to-access-this-page-fix/