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 tosudo 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.
