How to rename your WordPress database tables prefix after the installation

It’s really easy. You just need a plugin: Change DB Prefix

  • Make a backup of your database (and maybe your wp-config.php)
  • Make sure the webserver owns the whole WordPress directory (i.e. if you’re using Apache Web Server and your WordPress files resides inside /var/www/webdomain.com/public_html/, just make sure to sudo chown -R www-data:www-data /var/www/webdomain.com/public_html/
  • Also issue a sudo chmod -R 755 /var/www/webdomain.com/public_html/ to give the webserver the ability to write to files but only read/execute to others.
  • Go to the plugin screen inside your WordPress admin panel, set the new prefix and run it.
  • Done.